[OSM-dev] Mapnik import of planet delayed due to Postgres problem
Jon Burgess
jburgess777 at googlemail.com
Thu Nov 8 09:04:32 GMT 2007
I've tried to run the osm2pgsql import for the latest planet dump twice
and both times Postgres has returned a deadlock error near the end of
the processing:-
failed: ERROR: deadlock detected
DETAIL: Process 10255 waits for AccessExclusiveLock on relation 1151780 of database 18309; blocked by process 12547.
Process 12547 waits for ShareLock on transaction 572767014; blocked by process 10255.
I'll investigate further and see whether an update to the server or some
tweaks to the SQL commands can fix it. One suggestion I've found on the
net is that the auto-vacuum is interfering with things.
Jon
More information about the dev
mailing list