Thanks – working now. Few days to catch up on, I might catch up just in time to reload with ODbL data
From: Brett Henderson [mailto:[email protected]] Sent: Tuesday, July 24, 2012 9:19 AM To: Paul Norman Cc: [email protected] Subject: Re: [osmosis-dev] APIDB replication stalled Hi Paul, On 22 July 2012 05:18, Paul Norman <[email protected]> wrote: My apidb replication appears to of stalled. The error given is org.openstreetmap.osmosis.core.OsmosisRuntimeException: Unable to insert user with id 712141 into the database. The relevant line from the full error log (below) seems to be Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "users_display_name_idx" Detail: Key (display_name)=(lucabon) already exists. How would I go about fixing this? A workaround would be to search for the existing "lucabon" user in the user table and rename it. Something like should do it: UPDATE users SET display_name = 'lucabon_old' WHERE display_name = 'lucabon'; Brett
_______________________________________________ osmosis-dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/osmosis-dev
