[Tile-serving] [osm2pgsql] Hang on unsimplified diffs (#112)

[Paul Norman]

On the same DB, refeeding the first diff is giving me what **appears** to be the same state with 100% CPU. Makes debugging easier, I hope.

> Can you do a strace on the process which is consuming the CPU, "strace -p ", and get a few hundred lines to see what is going on? And better yet a stack trace ("gdb -p ", then "bt" at the debugger prompt)?

```sh
pnorman at osm2pgsqlbench:~/osm$ sudo strace -p 9310
Process 9310 attached - interrupt to quit

```
No strace output

gdb was more useful.
```
(gdb) bt
#0  0x00007f615aa9f5d0 in gserialized_gist_picksplit_2d () from /usr/lib/postgresql/9.3/lib/postgis-2.1.so
#1  0x00007f61a3e30ec2 in FunctionCall2Coll ()
#2  0x00007f61a3b69c0b in gistSplitByKey ()
#3  0x00007f61a3b623b8 in gistSplit ()
#4  0x00007f61a3b62979 in gistplacetopage ()
#5  0x00007f61a3b630b1 in ?? ()
#6  0x00007f61a3b63593 in gistdoinsert ()
#7  0x00007f61a3b63e3e in gistinsert ()
#8  0x00007f61a3e31266 in FunctionCall6Coll ()
#9  0x00007f61a3b7faaf in index_insert ()
#10 0x00007f61a3c83b79 in ExecInsertIndexTuples ()
#11 0x00007f61a3c24b00 in ?? ()
#12 0x00007f61a3c29d2a in DoCopy ()
#13 0x00007f61a3d5b070 in standard_ProcessUtility ()
#14 0x00007f61a3d57e43 in ?? ()
#15 0x00007f61a3d58ab8 in ?? ()
#16 0x00007f61a3d596e3 in PortalRun ()
#17 0x00007f61a3d55960 in PostgresMain ()
#18 0x00007f61a3d12765 in PostmasterMain ()
#19 0x00007f61a3b4eea2 in main ()
```

I have postgresql-9.3-postgis-2.1 from apt.postgresql.org,



---
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/112#issuecomment-31204268
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20131225/e5c1c49f/attachment.html>