I've broken something ...

[lsces]

I've had a system running for a couple of years now which I thought was keeping up to date, but have realised that it is perhaps still a little behind on the current version of data. Probably cleaner to start again and do a complete new upload, but just trying to understand what I broke.
SUSE13.1 with osm2pgsql 0.89.0-dev loaded which was not the version that was running, so problems with 'pending' fields which I've deleted from the database, but now it goes as far as 'Using XML parser.' and seems to stall.
What is the easiest approach to debug this as I'm sure it should be able to pick up and input the changes files?

[alex85k]

The simplest way to debug this: run osm2pgsql inside gdb

 gdb -ex=r --args ./osm2pgsql  .......

press Ctrl-C when it hangs and then enter bt command. You'll get the call stack (maybe you would want to put it here) and see what function is doing wrong things.

You can also open osm2pgsql sources as a project in QtCreator (it supports cmake) and do interactive debugging (may need to copy style file, change the command line, setup PSUSER & PGPASSWORD variables etc).

[lsces]

Need to install all the debug libraries but ...

Reading in file: 896702.changes.osc.gz
Using XML parser.
[New Thread 0x7fffb562a700 (LWP 22247)]
[New Thread 0x7fffb4e29700 (LWP 22248)]
^C
Program received signal SIGINT, Interrupt.
0x00007ffff5bf306d in poll () from /lib64/libc.so.6
(gdb) bt
#0 0x00007ffff5bf306d in poll () from /lib64/libc.so.6
#1 0x00007ffff77a789e in ?? () from /usr/lib64/libpq.so.5
#2 0x00007ffff77a7920 in ?? () from /usr/lib64/libpq.so.5
#3 0x00007ffff77a5c19 in PQgetResult () from /usr/lib64/libpq.so.5
#4 0x00007ffff77a5f1e in ?? () from /usr/lib64/libpq.so.5
#5 0x00000000004e24a0 in pgsql_execPrepared(pg_conn_, char const_, int, char const* const*, ExecStatusType) ()
#6 0x00000000004b815f in middle_pgsql_t::node_changed(long) ()
#7 0x000000000047abda in osmdata_t::node_modify(long, double, double, taglist_t const&) ()
#8 0x000000000049483f in parse_osmium_t::node(osmium::Node&) ()
#9 0x0000000000495378 in parse_osmium_t::stream_file(std::string const&, std::string const&) ()
#10 0x000000000046d9a3 in main ()
(gdb)

[alex85k]

No need for debug postgresql libraries, it is hanging on executing prepared SQL statement pgsql_execPrepared (something with database itself, most likely).

You can take one of the ways:

1. See the query with the debugger (do not know exact command for gdb)
2. Add add_definintions(-DDEBUG_PGSQL) into CMakeLists.txt an rebuild osm2pgsql - it will print all queries after this.
3. Add more printf calls manually into the code.

[lsces]

OK ... getting too complicated for time available ...
http://wiki.openstreetmap.org/wiki/Osm2pgsql/schema is obviously out of date but I can't find a clean schema to check what I've now got is correct, and more important, the scripts I have will add the 'pending' fields back in which were the original crash point. So where do I find a current postgres setup cribsheet?

[pnorman]

https://github.com/openstreetmap/osm2pgsql#usage for osm2pgsql specific parts, see your OS documentation for how to install PostgreSQL.

[lsces]

My original crib sheets were getting a bit out of date and had scripts for setting some things up prior to osm2pgsql. Just reworking the bits I'd missed for SUSE installs, however still fighting a problem between 13.1 and 13.2 builds.
BUT I needed the -C xxx to import the UK subset and missed that the --slim is needed to get the --append to work as I think originally that was already configured by the scripts. Just re-running the populate so I can retest the cron task to update.