NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum

   /app/nominatim/build/osm2pgsql/osm2pgsql -klas --number-processes 1 -C 2000 -O gazetteer -d nominatim.nominatim -P 5432 -U n_user -H nominatim-pgpool-service.nominatim  /app/diff_53820819.osc

I got pgpool and 3 psql nodes. Periodically cron spawning a script to download changes from osm and upload them to nominatim.

During upload process I there is error:

osm2pgsql version 0.96.0 (64 bit id space)

Using projection SRS 4326 (Latlong)
Allocating memory for dense node cache
Allocating dense node cache in one big chunk
Allocating memory for sparse node cache
Sharing dense sparse
Node-cache: cache=2000MB, maxblocks=32000*65536, allocation method=11
Mid: pgsql, cache=2000
Setting up table: planet_osm_nodes
Setting up table: planet_osm_ways
Setting up table: planet_osm_rels

Reading in file: /app/diff_53820819.osc
Using XML parser.
node cache: stored: 0(-nan%), storage efficiency: -nan% (dense blocks: 0, sparse nodes: 0), hit rate: -nan%
Osm2pgsql failed due to ERROR: delete_rel failed: server closed the connection unexpectedly
    This probably means the server terminated abnormally
    before or while processing the request.
(7)
Arguments were: 80305167,
ERROR: Error from osm2pgsql, 1

In pg-pool logs:

2018-10-09 10:57:41 ERROR: pid 58: Bind: cannot get parse message "delete_rel"
2018-10-09 10:57:41 LOG:   pid 58: do_child: exits with status 1 due to error

2018-10-09 10:57:41 LOG:   pid 89: ProcessFrontendResponse: failed to read kind from frontend. frontend abnormally exited
2018-10-09 10:57:41 LOG:   pid 103: ProcessFrontendResponse: failed to read kind from frontend. frontend abnormally exited
2018-10-09 10:57:41 LOG:   pid 95: ProcessFrontendResponse: failed to read kind from frontend. frontend abnormally exited

As I understand "delete_rel" is a prepared statement which was not created. But when I tried to do the same operation locally it's working even without that prepared statement.

Any suggestions how to resolve this?

asked 09 Oct '18, 12:09

awerger's gravatar image

awerger
11112
accept rate: 0%

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×710
×689
×263

question asked: 09 Oct '18, 12:09

question was seen: 1,032 times

last updated: 09 Oct '18, 12:09

NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum