Skip to content

Instantly share code, notes, and snippets.

@apetresc

apetresc/gist:3208043

Created July 30, 2012 16:04
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save apetresc/3208043 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save apetresc/3208043 to your computer and use it in GitHub Desktop.
Download ZIP
Nominatim warnings
Raw
gistfile1.txt
WARNING: 136227003
NOTICE: IllegalArgumentException: Points of LinearRing do not form a closed linestring
CONTEXT: PL/pgSQL function "placex_update" line 86 at assignment
index_placex: UPDATE failed: ERROR: POSTGIS2GEOS conversion failed
CONTEXT: PL/pgSQL function "placex_update" line 86 at assignment
WARNING: 136227003
NOTICE: IllegalArgumentException: Points of LinearRing do not form a closed linestring
CONTEXT: PL/pgSQL function "placex_update" line 86 at assignment
index_placex: UPDATE failed: ERROR: POSTGIS2GEOS conversion failed
CONTEXT: PL/pgSQL function "placex_update" line 86 at assignment
WARNING: 136227003
NOTICE: IllegalArgumentException: Points of LinearRing do not form a closed linestring
CONTEXT: PL/pgSQL function "placex_update" line 86 at assignment
index_placex: UPDATE failed: ERROR: POSTGIS2GEOS conversion failed
CONTEXT: PL/pgSQL function "placex_update" line 86 at assignment
WARNING: 136227003
NOTICE: IllegalArgumentException: Points of LinearRing do not form a closed linestring
CONTEXT: PL/pgSQL function "placex_update" line 86 at assignment
index_placex: UPDATE failed: ERROR: POSTGIS2GEOS conversion failed
CONTEXT: PL/pgSQL function "placex_update" line 86 at assignment
WARNING: 136227003
NOTICE: IllegalArgumentException: Points of LinearRing do not form a closed linestring
CONTEXT: PL/pgSQL function "placex_update" line 86 at assignment
index_placex: UPDATE failed: ERROR: POSTGIS2GEOS conversion failed
CONTEXT: PL/pgSQL function "placex_update" line 86 at assignment
WARNING: 136227003
NOTICE: IllegalArgumentException: Points of LinearRing do not form a closed linestring
CONTEXT: PL/pgSQL function "placex_update" line 86 at assignment
index_placex: UPDATE failed: ERROR: POSTGIS2GEOS conversion failed
CONTEXT: PL/pgSQL function "placex_update" line 86 at assignment
@apetresc
Copy link
Copy Markdown
Author

apetresc commented Jul 30, 2012 

place_id  | partition | osm_type |  osm_id   |  class  |  type   | name | admin_level | housenumber | street | isin | postcode | country_code | extratags |                                                                                                                              geometry                                                                                                                              | parent_place_id | linked_place_id | rank_address | rank_search | importance | indexed_status | indexed_date | wikipedia | geometry_sector | calculated_country_code | centroid |                                                                                 astext                                                                                 
-----------+-----------+----------+-----------+---------+---------+------+-------------+-------------+--------+------+----------+--------------+-----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------+-----------------+--------------+-------------+------------+----------------+--------------+-----------+-----------------+-------------------------+----------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 136227003 |        28 | W        | 156242571 | amenity | parking |      |          15 |             |        |      |          |              |           | 0103000020E6100000010000000700000001704793E64226408D0354DD88004740060DA25AE94226403FA253A1CB004740660AE764F34226408BC3995FCD0047407E834078FE42264021E5CC1BCC004740FC349314FD42264016CDB9CAC90047404DD64DCEF542264010B45DFCC800474001704793E64226408D0354DDC8004740 |                 |                 |           30 |          30 |            |              1 |              |           |        28489454 | it                      |          | POLYGON((11.1306654 46.004176775,11.1306866 46.0062143,11.1307632 46.0062675,11.1308477 46.0062289,11.1308371 46.0061582,11.1307816 46.0061336,11.1306654 46.0061299))
(1 row)

@apetresc
Copy link
Copy Markdown
Author

apetresc commented Jul 30, 2012 

#------------------------------------------------------------------------------# WRITE AHEAD LOG#------------------------------------------------------------------------------# - Settings -#wal_level = minimal                    # minimal, archive, or hot_standby                                        # (change requires restart)fsync = on                              # turns forced synchronization on or offsynchronous_commit = off                # synchronization level; on, off, or local#wal_sync_method = fsync                # the default is the first option                                        # supported by the operating system:
                                        #   open_datasync
                                        #   fdatasync (default on Linux)
                                        #   fsync
                                        #   fsync_writethrough
                                        #   open_sync
full_page_writes = on                   # recover from partial page writes
#wal_buffers = -1                       # min 32kB, -1 sets based on shared_buffers
                                        # (change requires restart)
#wal_writer_delay = 200ms               # 1-10000 milliseconds

#commit_delay = 0                       # range 0-100000, in microseconds
#commit_siblings = 5                    # range 1-1000

# - Checkpoints -

checkpoint_segments = 100               # in logfile segments, min 1, 16MB each
checkpoint_timeout = 10min              # range 30s-1h
checkpoint_completion_target = 0.9      # checkpoint target duration, 0.0 - 1.0
#checkpoint_warning = 30s               # 0 disables

# - Archiving -

#archive_mode = off             # allows archiving to be done
                                # (change requires restart)
#archive_command = ''           # command to use to archive a logfile segment
#archive_timeout = 0            # force a logfile segment switch after this
                                # number of seconds; 0 disables

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment