[Tile-serving] [osm2pgsql] expire output broken (#219)

Stefan de Konink notifications at github.com
Sun Nov 23 16:42:02 UTC 2014


It seems that the expire output broke for polygon bounded imports where nodes are present which are currently not part of the database contents. This is unrelated to the flat-nodes table or planet_osm_nodes table. It might also be that this applies to any node, currently not being rendered as node conforming the stylesheets, nodes part of a way for example.

```
LOG:  database system is ready to accept connections
ERROR:  COPY from stdin failed: COPY terminated by new PQexec
CONTEXT:  COPY planet_osm_point, line 1
STATEMENT:  COPY planet_osm_point (osm_id,"access","addr:housename","addr:housenumber","addr:interpolation","admin_level","aerialway","aeroway","amenity","area","barrier","bicycle","brand","bridge","boundary","building","capital","construction","covered","cutting","denomination","disused","ele","embankment","foot","generator:source","highway","historic","horse","junction","landuse","layer","leisure","lock","man_made","military","motorcar","name","natural","oneway","operator","poi","power","power_source","place","railway","ref","religion","route","service","shop","sport","surface","toll","tourism","tower:type","tunnel","water","waterway","wetland","width","wood","z_order","population","name:carnaval","source","source:date","lcn_ref","rcn_ref","ncn_ref","lwn_ref","rwn_ref","nwn_ref",tags,way) FROM STDIN
ERROR:  current transaction is aborted, commands ignored until end of transaction block
STATEMENT:  PREPARE get_wkt (int8) AS SELECT ST_AsText(way) FROM planet_osm_point WHERE osm_id = $1
ERROR:  unexpected message type 0x58 during COPY from stdin
```

The problem can be reproduced by loading a small city scale extract, and start to apply changesets.

---
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/219
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20141123/75de0b9c/attachment.html>


More information about the Tile-serving mailing list