On 24 Aug 2009, at 07:49, Brett Henderson wrote:
Dennie.nl wrote:Brett, apologies for sending the email direct to you! Hello Brett, The ruby problems are solved, I mentioned them for future reference (if somebody searches the archives). Next time I will run it on an virtual appliance, thanks for the tip. Answers on your questions:3. Using version 0.31.2: <osmosis_home>bin\osmosis --read-xml"path_to\planet-benelux-090817.osm" --write-apidb host="localhost" user="openstreetmap" password="openstreetmap" dbType="mysql"4. I don't have the compleet stacktrace anymore and I can't use mylocal pc right now to bulk read the entire database but basicly the mysql jdbc driver throws an exception with the message: Duplicate entry '37847304-2-court' for key 'PRIMARY' and this leads to Osmosisthrowing an exception with the message: Unable to bulk insert way tagsinto the database. After restarting the tool it tries to populate the OSM database instead of the openstreetmap database.Have you run osmosis against a database that isn't empty? If you've imported some data then attempt to import it again you'll get primary key violations. You can clear a database using the --truncate-apidb task(http://wiki.openstreetmap.org/wiki/Osmosis/DetailedUsage#--truncate-apidb_.28--td.29 ).If this doesn't explain the problem you'll need to dig deeper. It is failing trying to write a way tag. The key being violated is'37847304-2-court'. I haven't checked the database, but it sounds like a way tag with way id 378...., version 2, and key "court" already exists in the database. Perhaps the way has two tags with the same name? Theerror is coming from MySQL itself, not Osmosis so by looking at theinput XML and the database you should be able to identify the source of the problem. Either the duplicate entry already exists in the database,or it is being written twice due to duplicate data in the XML.
There is currently an issue whereby Postgres will allow two tag keys that have the different capitalisation. Whilst MySQL thinks that they are the same. This is the case:
http://www.openstreetmap.org/browse/way/37847304 Shaun
I'm confused by your command "after restarting the tool it tries to populate the OSM database" though. Why would it suddenly switch to another database instance? It should only connect to the database you specify.That is true. MySQL doesn't receive much (if any) testing. Although I2. I am a java programmer and have some understanding of exception concepts. My quess is that the database structure of mysql isn't very well tested against mysql after switching from mysql -> postgress?don't think that's the issue here. If there is a bug in Osmosis and you're familiar with Java I'd greatly appreciate some assistance in identifying the source of the problem. Hope that helps, Brett _______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/dev
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/dev
