[OSM-dev] duplicate uid?

[Brett Henderson]

Tom Hughes wrote:
> On 06/08/09 17:51, Jeffrey Warren wrote:
>
>   
>> I checked the .osc diff file (20090719-20090720.osc) and found a lot by
>> Rick Rupp:
>>
>> <way id="37813450" version="1" timestamp="2009-07-19T00:57:38Z"
>> uid="114479" user="Rick Rupp" changeset="1868550">
>>
>> But that conflicts with my entry for user with id 114479:
>>
>> "osmosis_user_114479 at example.com
>> <mailto:osmosis_user_114479 at example.com>";114479;1;"00000000000000000000000000000000";"2009-06-05
>> 15:04:06.462206";"PalouseGeo";t;"PalouseGeo";0;0;3;50;"00000000";"";f;f;"";t;""
>>     
>  >
>   
>> whereas Rick Rupp is #119700:
>>
>> "osmosis_user_119700 at example.com
>> <mailto:osmosis_user_119700 at example.com>";119700;1;"00000000000000000000000000000000";"2009-06-05
>> 15:04:06.462206";"Rick Rupp";t;"Rick
>> Rupp";0;0;3;50;"00000000";"";f;f;"";t;""
>>
>> (apologies to Rick Rupp for spreading his name across this list)
>>     
>
> I can't really say too much, but having looked at those two records in 
> the database I don't believe there is any problem here.
>   
It's possible that one Rick Rupp was renamed in the main database to 
something else but then no records modified using it.  In that case 
osmosis will never know that the name of the user has changed because 
all replication is driven from node/relation/way updates which user 
details are attached to.  Then a new Rick Rupp is created which won't 
conflict in the main database because the original Rick Rupp now has a 
different name.  Then when edits are performed using the new Rick Rupp 
osmosis will see it and try to create/modify a record in the replica 
database but an error occurs because the original Rick Rupp still exists 
there.

That was badly worded, hope it makes sense :-)

The simple fix should be to modify the original Rick Rupp user name in 
the replica database to something else (eg. Rick Rupp Duplicate).

Brett

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20090807/4159f133/attachment.html>