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 Sun, 15 Nov 2009 05:58:05 GMT
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