[OSM-dev] osmosis error

[Pallinger Péter]

Tom Hughes írta:
> Use PostgreSQL not MySQL - the MySQL support is not really maintained
> anymore so it likely to be extremely fragile as you've just discovered.
Thanks for the tip, I successfully ran "rake db:migrate". However, I failed to upload
some maps.

I've tried to run:
--------
osmosis --read-xml file="hungary.osm.bz2" --write-apidb-0.6 host="localhost"
database="openstreetmap" user="openstreetmap" password="openstreetmap"
validateSchemaVersion=no
--------
however, it failed with an exception.
The root cause seems to be:
--------
org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint
"nodes_pkey"
--------

I've seen a thread on this list about a similar error here:
http://www.mail-archive.com/dev@openstreetmap.org/msg08498.html, but there was no real
solution except to try to fix the OSM file itself (which I would very much like to not
to do).

By the way, 'osmosis --read-xml file="hungary.osm.bz2" --write-xml"' succeeds.

Thank you in advance for any tips,

	PP