[osmosis-dev] APIDB replication stalled

[Brett Henderson]

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/20120725/b5d4e7a5/attachment.html>