[osmosis-dev] APIDB replication stalled
Paul Norman
penorman at mac.com
Wed Jul 25 07:13:22 BST 2012
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:brett at bretth.com]
Sent: Tuesday, July 24, 2012 9:19 AM
To: Paul Norman
Cc: osmosis-dev at openstreetmap.org
Subject: Re: [osmosis-dev] APIDB replication stalled
Hi Paul,
On 22 July 2012 05:18, Paul Norman <penorman at mac.com> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/osmosis-dev/attachments/20120724/28b2ae5b/attachment.html>
More information about the osmosis-dev
mailing list