[osmosis-dev] APIDB replication stalled

[Paul Norman]

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>