incubator-olio-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kim LiChong <Kim.Lich...@Sun.COM>
Subject Re: Problem loading data using ./dbloader
Date Mon, 16 Nov 2009 17:12:20 GMT
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 <rold_50@yahoo.com> wrote:
>
>   
>> From: Harold Lim <rold_50@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 <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