[OSM-dev] Daily diff's retry

[Jon Bright]

Hi Brett,

Brett Henderson wrote:
> 
> If 1, then the answer to your question is yes, begin applying daily 
> diffs beginning with the first diff.

I figured I'd give it a try, but I'm seeing an error:

java -jar osmosis.jar --read-xml-change-0.5 
file="2007-10-10--10-10-09:57:01.osc" --write-mysql-change-0.5 host=...

(correct host/db/user/pass values follow).  I see the following output:

12-Oct-2007 16:12:26 com.bretth.osmosis.core.Osmosis main
INFO: Pipeline executing, waiting for completion.
Exception in thread "Thread-1-read-xml-change-0.5" 
com.bretth.osmosis.core.OsmosisRuntimeException: Unable to insert 
history node with id=26374933.
         at 
com.bretth.osmosis.core.mysql.v0_5.impl.ChangeWriter.write(ChangeWriter.java:244)
         at 
com.bretth.osmosis.core.mysql.v0_5.impl.ActionChangeWriter.process(ActionChangeWriter.java:38)
         at 
com.bretth.osmosis.core.container.v0_5.NodeContainer.process(NodeContainer.java:34)
         at 
com.bretth.osmosis.core.mysql.v0_5.MysqlChangeWriter.process(MysqlChangeWriter.java:72)
         at 
com.bretth.osmosis.core.xml.v0_5.impl.ChangeSourceElementProcessor$ChangeSinkAdapter.process(ChangeSourceElementProcessor.java:129)
         at 
com.bretth.osmosis.core.xml.v0_5.impl.NodeElementProcessor.end(NodeElementProcessor.java:99)
         at 
com.bretth.osmosis.core.xml.v0_5.impl.OsmChangeHandler.endElement(OsmChangeHandler.java:95)
....xerces stuff here...
Caused by: java.sql.SQLException: Parameter index out of bounds. 8 is 
not between valid values of 1 and 7
         at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
         at 
com.mysql.jdbc.ServerPreparedStatement.getBinding(ServerPreparedStatement.java:768)
         at 
com.mysql.jdbc.ServerPreparedStatement.setLong(ServerPreparedStatement.java:1793)
         at 
com.bretth.osmosis.core.mysql.v0_5.impl.ChangeWriter.write(ChangeWriter.java:239)
         ... 20 more

This seems more like an error in the SQL than in the diff, so I 
deliberately haven't tried the other file yet (not wanting to corrupt my 
DB).

rake db:migrate makes no changes to the DB using the latest 
rails_0.5_port from svn.  osmosis is freshly updated and rebuilt from 
clean from svn.

The planet import worked fine (though that was a slightly older osmosis, 
I think).

-- 
Jon Bright
Silicon Circus Ltd.
http://www.siliconcircus.com