Opened 5 years ago

Closed 5 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 robe, 5 years ago

Not to be a nitpick, but, for completeness what does

SELECT version(); 

comment:2 by komzpa, 5 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 komzpa, 5 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 robe, 5 years ago

Milestone: PostGIS 2.5.2PostGIS 2.5.3

comment:5 by komzpa, 5 years ago

Resolution: worksforme
Status: assignedclosed
Note: See TracTickets for help on using tickets.