[OSM-dev] Osmosis error "duplicate entry for key 1"

Maarten Deen mdeen at xs4all.nl
Sat Feb 28 12:15:55 GMT 2009


I have this (for me) unexplainable error "duplicate entry ... for key 1" when 
trying to load some data into a database with Osmosis (latest, 0.30).

The data is:
<?xml version='1.0' standalone='no'?>
<osm version='0.5' generator='osmxapi: OSM Extended API' 
xmlns:osmxapi='http://www.informationfreeway.org/osmxapi/0.5' 
osmxapi:uri='/api/0.5/node[amenity=atm][bbox=3.4,50.7,7.2,53.6]' 
osmxapi:planetDate='200902281146' osmxapi:copyright='2008 OpenStreetMap 
contributors' osmxapi:instance='zappyHyper'>
   <node id='27432409' lat='51.4461182' lon='7.0541461' user='SlowRider' 
osmxapi:users='SlowRider' timestamp='2007-04-17T20:19:14Z'>
     <tag k='amenity' v='atm'/>
   </node>
</osm>

and

<?xml version='1.0' standalone='no'?>
<osm version='0.5' generator='osmxapi: OSM Extended API' 
xmlns:osmxapi='http://www.informationfreeway.org/osmxapi/0.5' 
osmxapi:uri='/api/0.5/node[amenity=bank][bbox=3.4,50.7,7.2,53.6]' 
osmxapi:planetDate='200902281144' osmxapi:copyright='2008 OpenStreetMap 
contributors' osmxapi:instance='zappyHyper'>
   <node id='27432408' lat='51.4459649' lon='7.0533624' user='DocGo' 
osmxapi:users='DocGo' timestamp='2007-10-16T16:09:19Z'>
     <tag k='amenity' v='bank'/>
     <tag k='name' v='Sparkasse'/>
   </node>
</osm>


If I put these in different files, then the second always fails to load with 
error "Duplicate entry '27432409' for key 1" when the first file is loaded first 
or "Duplicate entry '27432408' for key 1" when the second is loaded first.
If I put the two nodes in one file than all is well.

I've noticed that after loading, both nodes are in the 'nodes' table, but not in 
the 'current_nodes' table, making me think that the error occurs there.
But I can't figure out why.

Regards,
Maarten




More information about the dev mailing list