Hi Bruno,
Thanks for using Olio. I'll have a look at this issue tomorrow. Is there any
chance that you could post your MySQL config file?
Thanks
Amanda
---------------------------- included message ----------------------------
Hi everyone,
I'm using Debian Squeeze, Olio 0.2 (rails version) and Mysql 5.1.45-1.
After running "*rake db:create*" and "*rake db:migrate*", *dbloader.sh* is
executed and:
# ./dbloader.sh 192.168.0.12 50
19/05/2010 00:41:34 org.apache.olio.workload.loader.LoadController main
INFO: Done clearing database tables.
19/05/2010 00:41:41
org.apache.olio.workload.loader.framework.ThreadConnection processBatch
WARNING: org.apache.olio.workload.loader.Address: Retry loading.
java.sql.BatchUpdateException: Incorrect decimal value: '-27,905504' for
column 'latitude' at row 1
at
com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1269)
at
com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:955)
at
org.apache.olio.workload.loader.framework.ThreadConnection.flush(ThreadConnection.java:235)
at
org.apache.olio.workload.loader.framework.ThreadConnection.processBatch(ThreadConnection.java:180)
at
org.apache.olio.workload.loader.framework.Loader$4.run(Loader.java:276)
at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at
java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
at java.util.concurrent.FutureTask.run(FutureTask.java:166)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:636)
19/05/2010 00:41:41
org.apache.olio.workload.loader.framework.ThreadConnection processBatch
WARNING: org.apache.olio.workload.loader.Address: Failed to update.
java.sql.BatchUpdateException: Incorrect decimal value: '-33,127308' for
column 'latitude' at row 1
at
com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1269)
at
com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:955)
at
org.apache.olio.workload.loader.framework.ThreadConnection.flush(ThreadConnection.java:235)
at
org.apache.olio.workload.loader.framework.ThreadConnection.processBatch(ThreadConnection.java:180)
at
org.apache.olio.workload.loader.framework.Loader$4.run(Loader.java:276)
at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at
java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
at java.util.concurrent.FutureTask.run(FutureTask.java:166)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:636)
Error count exceeded threshold of 50! Exiting.
ERROR: Database loader exited with code 2.
I tried the same thing with mysql server 5.0.51 and the same problem
happened
What can be happening? Is it something about geocoder?
