[osmosis-dev] APIDB replication stalled

[Paul Norman]

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?

Error log

pnorman at merry:~/.osmosis-apidb$ ./update.sh
21-Jul-2012 12:14:09 PM org.openstreetmap.osmosis.core.Osmosis run
INFO: Osmosis Version 0.40.1
21-Jul-2012 12:14:09 PM org.openstreetmap.osmosis.core.Osmosis run
INFO: Preparing pipeline.
21-Jul-2012 12:14:09 PM org.openstreetmap.osmosis.core.Osmosis run
INFO: Launching pipeline execution.
21-Jul-2012 12:14:09 PM org.openstreetmap.osmosis.core.Osmosis run
INFO: Pipeline executing, waiting for completion.
21-Jul-2012 12:14:12 PM
org.openstreetmap.osmosis.core.pipeline.common.ActiveTaskManager
waitForCompletion
SEVERE: Thread for task 1-rri failed
org.openstreetmap.osmosis.core.OsmosisRuntimeException: Unable to insert
user with id 712141 into the database.
        at
org.openstreetmap.osmosis.apidb.v0_6.impl.UserManager.insertUser(UserManager
.java:143)
        at
org.openstreetmap.osmosis.apidb.v0_6.impl.UserManager.addOrUpdateUser(UserMa
nager.java:191)
        at
org.openstreetmap.osmosis.apidb.v0_6.impl.ChangeWriter.write(ChangeWriter.ja
va:330)
        at
org.openstreetmap.osmosis.apidb.v0_6.impl.ActionChangeWriter.process(ActionC
hangeWriter.java:48)
        at
org.openstreetmap.osmosis.core.container.v0_6.NodeContainer.process(NodeCont
ainer.java:58)
        at
org.openstreetmap.osmosis.apidb.v0_6.ApidbChangeWriter.process(ApidbChangeWr
iter.java:67)
        at
org.openstreetmap.osmosis.core.sort.v0_6.ChangeSorter.complete(ChangeSorter.
java:64)
        at
org.openstreetmap.osmosis.core.sort.v0_6.ChangeSorter.complete(ChangeSorter.
java:67)
        at
org.openstreetmap.osmosis.replication.v0_6.ReplicationDownloader.processComp
lete(ReplicationDownloader.java:93)
        at
org.openstreetmap.osmosis.replication.v0_6.BaseReplicationDownloader.runImpl
(BaseReplicationDownloader.java:288)
        at
org.openstreetmap.osmosis.replication.v0_6.BaseReplicationDownloader.run(Bas
eReplicationDownloader.java:349)
        at java.lang.Thread.run(Thread.java:679)
Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value
violates unique constraint "users_display_name_idx"
  Detail: Key (display_name)=(lucabon) already exists.
        at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorI
mpl.java:2102)
        at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.ja
va:1835)
        at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
        at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.j
ava:500)
        at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2St
atement.java:388)
        at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2State
ment.java:334)
        at
org.openstreetmap.osmosis.apidb.v0_6.impl.UserManager.insertUser(UserManager
.java:140)
        ... 11 more
21-Jul-2012 12:14:12 PM org.openstreetmap.osmosis.core.Osmosis main
SEVERE: Execution aborted.
org.openstreetmap.osmosis.core.OsmosisRuntimeException: One or more tasks
failed.
        at
org.openstreetmap.osmosis.core.pipeline.common.Pipeline.waitForCompletion(Pi
peline.java:146)
        at org.openstreetmap.osmosis.core.Osmosis.run(Osmosis.java:92)
        at org.openstreetmap.osmosis.core.Osmosis.main(Osmosis.java:37)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57
)
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:43)
        at java.lang.reflect.Method.invoke(Method.java:616)
        at
org.codehaus.plexus.classworlds.launcher.Launcher.launchStandard(Launcher.ja
va:329)
        at
org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:239)
        at
org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.
java:409)
        at
org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:352)
        at org.codehaus.classworlds.Launcher.main(Launcher.java:47)