[Tile-serving] [openstreetmap/osm2pgsql] Planet load fails with ERROR: relation "osm_point" does not exist (#855)

[Jason Newmoyer]

I ran with postgres log_statements='all' last time, and I captured this output, leading right up to the "osm_point" does not exist error:

```
< 2018-07-04 15:33:14.727 UTC postgres osm_2018-07-03 12522 [local] geoserver 5b3ba6cb.30ea >STATEMENT:  COPY osm_point (osm_id,"access","admin_level","aerialway","aeroway","amenity","area"
,"barrier","bicycle","brand","bridge","boundary","building","capital","construction","covered","culvert","cutting","denomination","disused","ele","embankment","foot","generator:source","har
bour","highway","historic","horse","intermittent","junction","landuse","layer","leisure","lock","man_made","military","motorcar","name","name:en","natural","office","oneway","operator","pla
ce","poi","population","power","power_source","public_transport","railway","ref","religion","route","service","shop","sport","surface","toll","tourism","tower:type","tunnel","water","waterw
ay","wetland","width","wood","z_order","osm_user","osm_uid","osm_version","osm_changeset","osm_timestamp",tags,way) FROM STDIN
< 2018-07-04 15:33:14.727 UTC postgres osm_2018-07-03 12523 [local] geoserver 5b3ba6cb.30eb >LOG:  could not send data to client: Broken pipe
< 2018-07-04 15:33:14.727 UTC postgres osm_2018-07-03 12523 [local] geoserver 5b3ba6cb.30eb >STATEMENT:  COPY osm_line (osm_id,"access","admin_level","aerialway","aeroway","amenity","area",
"barrier","bicycle","brand","bridge","boundary","building","construction","covered","culvert","cutting","denomination","disused","embankment","foot","generator:source","harbour","highway","
historic","horse","intermittent","junction","landuse","layer","leisure","lock","man_made","military","motorcar","name","name:en","natural","office","oneway","operator","place","population",
"power","power_source","public_transport","railway","ref","religion","route","service","shop","sport","surface","toll","tourism","tower:type","tracktype","tunnel","water","waterway","wetlan
d","width","wood","z_order","way_area","osm_user","osm_uid","osm_version","osm_changeset","osm_timestamp",tags,way) FROM STDIN
< 2018-07-04 15:33:14.728 UTC postgres osm_2018-07-03 12524 [local] geoserver 5b3ba6cb.30ec >LOG:  could not send data to client: Broken pipe
< 2018-07-04 15:33:14.728 UTC postgres osm_2018-07-03 12524 [local] geoserver 5b3ba6cb.30ec >STATEMENT:  COPY osm_polygon (osm_id,"access","admin_level","aerialway","aeroway","amenity","are
a","barrier","bicycle","brand","bridge","boundary","building","construction","covered","culvert","cutting","denomination","disused","embankment","foot","generator:source","harbour","highway
","historic","horse","intermittent","junction","landuse","layer","leisure","lock","man_made","military","motorcar","name","name:en","natural","office","oneway","operator","place","populatio
n","power","power_source","public_transport","railway","ref","religion","route","service","shop","sport","surface","toll","tourism","tower:type","tracktype","tunnel","water","waterway","wet
land","width","wood","z_order","way_area","osm_user","osm_uid","osm_version","osm_changeset","osm_timestamp",tags,way) FROM STDIN
< 2018-07-04 15:33:14.729 UTC postgres osm_2018-07-03 12528 [local] geoserver 5b3ba6cb.30f0 >LOG:  could not send data to client: Broken pipe
< 2018-07-04 15:33:14.729 UTC postgres osm_2018-07-03 12528 [local] geoserver 5b3ba6cb.30f0 >STATEMENT:  COPY osm_rels FROM STDIN;

< 2018-07-04 15:33:14.739 UTC postgres osm_2018-07-03 12526 [local] geoserver 5b3ba6cb.30ee >FATAL:  terminating connection because protocol synchronization was lost
< 2018-07-04 15:33:14.761 UTC postgres osm_2018-07-03 12528 [local] geoserver 5b3ba6cb.30f0 >FATAL:  terminating connection because protocol synchronization was lost
< 2018-07-04 15:33:14.782 UTC postgres osm_2018-07-03 12524 [local] geoserver 5b3ba6cb.30ec >FATAL:  terminating connection because protocol synchronization was lost
< 2018-07-04 15:33:14.837 UTC postgres osm_2018-07-03 12523 [local] geoserver 5b3ba6cb.30eb >FATAL:  terminating connection because protocol synchronization was lost
< 2018-07-04 15:33:14.837 UTC [unknown] [unknown] 29444 [local] [unknown] 5b3ce8ba.7304 >LOG:  connection received: host=[local]
< 2018-07-04 15:33:14.863 UTC postgres osm_2018-07-03 29444 [local] [unknown] 5b3ce8ba.7304 >LOG:  connection authorized: user=postgres database=osm_2018-07-03
< 2018-07-04 15:33:14.899 UTC postgres osm_2018-07-03 29444 [local] geoserver 5b3ce8ba.7304 >LOG:  statement: GRANT SELECT ON osm_point TO PUBLIC;
< 2018-07-04 15:33:14.903 UTC postgres osm_2018-07-03 29444 [local] geoserver 5b3ce8ba.7304 >ERROR:  relation "osm_point" does not exist
```

-- 
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/855#issuecomment-402820516
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20180705/e0922e00/attachment.html>