[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