Opened 6 years ago
Closed 6 years ago
#4285 closed defect (worksforme)
PostGIS 2.5.1 segfaulted on osm2pgsql planet import
Reported by: | komzpa | Owned by: | Komzpa |
---|---|---|---|
Priority: | medium | Milestone: | PostGIS 2.5.3 |
Component: | postgis | Version: | 2.4.x |
Keywords: | Cc: |
Description
POSTGIS="2.5.1 r17027" [EXTENSION] PGSQL="110" GEOS="3.6.2-CAPI-1.10.2 4d2925d6" PROJ="Rel. 4.9.3, 15 August 2016" GDAL="GDAL 2.2.3, released 2017/11/20" LIBXML="2.9.4" LIBJSON="0.12.1" LIBPROTOBUF="1.2.1" RASTER
2019-01-03 21:38:47.511 +03 [20096] LOG: background worker "parallel worker" (PID 22709) exited with exit code 1 2019-01-03 21:38:47.511 +03 [20096] LOG: background worker "parallel worker" (PID 22714) exited with exit code 1 2019-01-03 21:38:47.533 +03 [20096] LOG: background worker "parallel worker" (PID 22711) exited with exit code 1 2019-01-03 21:38:47.533 +03 [20096] LOG: background worker "parallel worker" (PID 22712) exited with exit code 1 2019-01-03 21:38:47.534 +03 [20096] LOG: background worker "parallel worker" (PID 22713) exited with exit code 1 2019-01-03 21:38:47.534 +03 [20096] LOG: background worker "parallel worker" (PID 22715) exited with exit code 1 2019-01-03 22:03:01.949 +03 [20096] LOG: background worker "parallel worker" (PID 22710) was terminated by signal 11: Segmentation fault 2019-01-03 22:03:01.949 +03 [20096] DETAIL: Failed process was running: CREATE TABLE planet_osm_polygon_tmp AS SELECT * FROM planet_osm_polygon WHERE ST_IsValid(way) ORDER BY ST_GeoHash(ST_Transform(ST_Envelope(way),4326),10) COLLATE "C" 2019-01-03 22:03:01.950 +03 [20096] LOG: terminating any other active server processes 2019-01-03 22:03:01.950 +03 [22563] gis@gis WARNING: terminating connection because of crash of another server process 2019-01-03 22:03:01.950 +03 [22563] gis@gis DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. 2019-01-03 22:03:01.950 +03 [22563] gis@gis HINT: In a moment you should be able to reconnect to the database and repeat your command. 2019-01-03 22:03:01.950 +03 [22561] gis@gis WARNING: terminating connection because of crash of another server process
Change History (5)
comment:1 by , 6 years ago
comment:2 by , 6 years ago
gis=# select version(); version ---------------------------------------------------------------------------------------------------------------------------------- PostgreSQL 11.1 (Ubuntu 11.1-1.pgdg18.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 7.3.0-27ubuntu1~18.04) 7.3.0, 64-bit
comment:3 by , 6 years ago
upon other retry machine died with no ssh connection. investingating hardware, will post coredump if there's one.
WARNING: there is no transaction in progress Sorting data and creating indexes for planet_osm_point Sorting data and creating indexes for planet_osm_line Sorting data and creating indexes for planet_osm_roads Sorting data and creating indexes for planet_osm_polygon node cache: stored: 3514201463(71.37%), storage efficiency: 89.37% (dense blocks: 444940, sparse nodes: 143606228), hit rate: 70.37% Stopping table: planet_osm_ways Stopping table: planet_osm_nodes Stopping table: planet_osm_rels Building index on table: planet_osm_ways Stopped table: planet_osm_nodes in 0s Building index on table: planet_osm_rels Stopped table: planet_osm_rels in 2331s Copying planet_osm_roads to cluster by geometry finished Creating geometry index on planet_osm_roads WARNING: terminating connection because of crash of another server process DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. HINT: In a moment you should be able to reconnect to the database and repeat your command. WARNING: terminating connection because of crash of another server process DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. HINT: In a moment you should be able to reconnect to the database and repeat your command. WARNING: terminating connection because of crash of another server process DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. HINT: In a moment you should be able to reconnect to the database and repeat your command. WARNING: terminating connection because of crash of another server process DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. HINT: In a moment you should be able to reconnect to the database and repeat your command. WARNING: terminating connection because of crash of another server process DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. HINT: In a moment you should be able to reconnect to the database and repeat your command. Osm2pgsql took 103732s overall
comment:4 by , 6 years ago
Milestone: | PostGIS 2.5.2 → PostGIS 2.5.3 |
---|
comment:5 by , 6 years ago
Resolution: | → worksforme |
---|---|
Status: | assigned → closed |
Note:
See TracTickets
for help on using tickets.
Not to be a nitpick, but, for completeness what does