You are viewing a plain text version of this content. The canonical link for it is here.
Posted to olio-user@incubator.apache.org by Harold Lim <ro...@yahoo.com> on 2009/11/12 04:40:15 UTC
Problem loading data using ./dbloader
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
Re: Problem loading data using ./dbloader
Posted by Kim LiChong <Ki...@Sun.COM>.
HI Harold,
Thanks for pointing this out. I will make sure that the schema file in
the $WEBAPP/etc is updated.
Kim
> I think it works now.
>
> When I used the schema file from the $WEBAPP/etc directory it gave me an error. But when I tried loading the schema.sql from the $WORKLOAD/bin, it worked.
>
> --- On Sat, 11/14/09, Harold Lim <ro...@yahoo.com> wrote:
>
>
>> From: Harold Lim <ro...@yahoo.com>
>> Subject: Re: Problem loading data using ./dbloader
>> To: olio-user@incubator.apache.org
>> Date: Saturday, November 14, 2009, 2:15 PM
>> 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 <Ki...@Sun.COM>
>> wrote:
>>
>>
>>> From: Kim LiChong <Ki...@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
>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>
>>
>>
>
>
>
>
Re: Problem loading data using ./dbloader
Posted by Harold Lim <ro...@yahoo.com>.
I think it works now.
When I used the schema file from the $WEBAPP/etc directory it gave me an error. But when I tried loading the schema.sql from the $WORKLOAD/bin, it worked.
--- On Sat, 11/14/09, Harold Lim <ro...@yahoo.com> wrote:
> From: Harold Lim <ro...@yahoo.com>
> Subject: Re: Problem loading data using ./dbloader
> To: olio-user@incubator.apache.org
> Date: Saturday, November 14, 2009, 2:15 PM
> 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 <Ki...@Sun.COM>
> wrote:
>
> > From: Kim LiChong <Ki...@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
> > >
> > >
> > >
> > >
> >
> >
>
>
>
>
Re: Problem loading data using ./dbloader
Posted by Harold Lim <ro...@yahoo.com>.
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 <Ki...@Sun.COM> wrote:
> From: Kim LiChong <Ki...@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
> >
> >
> >
> >
>
>
Re: Problem loading data using ./dbloader
Posted by Kim LiChong <Ki...@Sun.COM>.
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
>
>
>
>