[Tile-serving] [osm2pgsql] Hang on unsimplified diffs (#112)
Paul Norman
notifications at github.com
Sat Dec 21 08:49:52 UTC 2013
This is reproducible, but takes a full planet import...
1. Import a full planet with `osm2pgsql -d gis -c -S default.style --flat-nodes flat.nodes -C 20000 --slim --number-processes 4 planet-130904.osm.pbf`
2. Cluster on a geohash index (probably optional)
3. Import hourly diffs with
```sh
for n in `seq 555 568`;
do osm2pgsql -d gis -a -S default.style --flat-nodes flat.nodes -C 2000 --slim --number-processes 8 "diffs/008/$n.osc.gz"
done
```
On diff 568 osm2pgsql will hang. `pg_stat_activity` will show a COPY statement running for hours, consuming 100% CPU, no disk IO, and that process will not end if osm2pgsql is terminated or of `pg_terminate_backend(pid)` is used.
This may be because it wasn't passed through osmosis with `--simc`, but the hung process is still wrong
---
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/112
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20131221/8eda5cdd/attachment.html>
More information about the Tile-serving
mailing list