/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, 12:09

awerger's gravatar image

awerger
111
accept rate: 0%

Be the first one to answer this question!
toggle preview

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:

×508
×487
×176

question asked: 09 Oct, 12:09

question was seen: 42 times

last updated: 09 Oct, 12:09

powered by OSQA