[postgis-tickets] [PostGIS] #4285: PostGIS 2.5.1 segfaulted on osm2pgsql planet import

PostGIS trac at osgeo.org
Tue Jan 8 07:01:25 PST 2019


#4285: PostGIS 2.5.1 segfaulted on osm2pgsql planet import
----------------------+---------------------------
  Reporter:  komzpa   |      Owner:  Komzpa
      Type:  defect   |     Status:  assigned
  Priority:  medium   |  Milestone:  PostGIS 2.5.2
 Component:  postgis  |    Version:  2.4.x
Resolution:           |   Keywords:
----------------------+---------------------------

Comment (by komzpa):

 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
 }}}

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4285#comment:3>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.


More information about the postgis-tickets mailing list