incubator-olio-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Harold Lim <rold...@yahoo.com>
Subject Re: Problem loading data using ./dbloader
Date Sat, 14 Nov 2009 19:15:44 GMT
Hi Kim,

I rebuilt the OlioDriver and deployed it to Faban and recreated bpwebapp and reloaded the
new schema.sql but I'm still getting the same error:

Any idea how to fix this?

./dbloader.sh xxxx 50


Nov 14, 2009 2:09:17 PM org.apache.olio.workload.loader.LoadController main
INFO: Done clearing database tables.
Nov 14, 2009 2:09:22 PM org.apache.olio.workload.loader.framework.ThreadConnection processBatch
WARNING: org.apache.olio.workload.loader.SocialEvent: Retry loading.
java.sql.BatchUpdateException: Field 'SOCIALEVENTID' doesn't have a default value
at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2007)
at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1443)
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:441)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
Nov 14, 2009 2:09:22 PM org.apache.olio.workload.loader.framework.ThreadConnection processBatch
WARNING: org.apache.olio.workload.loader.SocialEvent: Failed to update.
java.sql.BatchUpdateException: Field 'SOCIALEVENTID' doesn't have a default value
at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2007)
at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1443)
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:441)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
Error count exceeded threshold of 50! Exiting.
Nov 14, 2009 2:09:22 PM org.apache.olio.workload.loader.framework.ThreadConnection processBatch
WARNING: org.apache.olio.workload.loader.Tag: Retry loading.
java.sql.BatchUpdateException: Field 'SOCIALEVENTTAGID' doesn't have a default value
at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2007)
at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1443)
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:441)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
Nov 14, 2009 2:09:22 PM org.apache.olio.workload.loader.framework.ThreadConnection processBatch
WARNING: org.apache.olio.workload.loader.Tag: Failed to update.
java.sql.BatchUpdateException: Field 'SOCIALEVENTTAGID' doesn't have a default value
at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2007)
at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1443)
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:441)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
Error count exceeded threshold of 50! Exiting.
ERROR: Database loader exited with code 2.

--- On Thu, 11/12/09, Kim LiChong <Kim.Lichong@Sun.COM> wrote:

> From: Kim LiChong <Kim.Lichong@Sun.COM>
> Subject: Re: Problem loading data using ./dbloader
> To: olio-user@incubator.apache.org
> Date: Thursday, November 12, 2009, 1:27 AM
> Hi Harold,
> 
> Can you refresh your workspace?  There has been some
> changes to the 
> schema.  You will have to drop and recreate your
> database with the new 
> schema, and then rerun dbloader.
> 
> I just tried this on my updated workspace (I had to drop
> and recreate as 
> well since I was using an older schema) and it went
> through.
> 
> kim
> $ ./dbloader.sh localhost 25
> Nov 11, 2009 10:18:29 PM
> org.apache.olio.workload.loader.LoadController main
> INFO: Done clearing database tables.
> Nov 11, 2009 10:18:33 PM
> org.apache.olio.workload.loader.LoadController main
> INFO: Done data creation.
> Nov 11, 2009 10:19:53 PM
> org.apache.olio.workload.loader.LoadController main
> INFO: Done data loading.
> Nov 11, 2009 10:19:53 PM
> org.apache.olio.workload.loader.LoadController main
> INFO: Done post-load.
> Database Load Successful
> 
> > Hi All,
> >
> >
> > When I try to run dbloader, I'm getting the following
> error:
> > java.sql.BatchUpdateException: Field 'ADDRESSID'
> doesn't have a default value
> >     at
> com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2007)
> >     at
> com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1443)
> >     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:441)
> >     at
> java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
> >     at
> java.util.concurrent.FutureTask.run(FutureTask.java:138)
> >     at
> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
> >     at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
> >     at
> java.lang.Thread.run(Thread.java:619)
> >
> >
> > Any idea how to fix this problem?
> >
> > Thanks,
> > Harold
> >
> >
> >       
> >   
> 
> 


      

Mime
View raw message