Your browser was unable to load all of the resources. They may have been blocked by your firewall, proxy or browser configuration.
Press Ctrl+F5 or Ctrl+Shift+R to have your browser try again.

QuickBuild

db rebuild script? #1006

#1
DL1030 ·
It appears that the DB has got out of whack. Is there a restore/rebuild script somewhere?

We dont have much for data (so no backups have been taken at this point either), if we had to start over it wouldnt be ideal but we could deal.

I am not the end user so I am not sure what happened, just told to fix it. 

Running QuickBuild Server...
wrapper  | --> Wrapper Started as Console
wrapper  | Java Service Wrapper Standard Edition 32-bit 3.3.5
wrapper  |   Copyright (C) 1999-2009 Tanuki Software, Ltd.  All Rights Reserved.
wrapper  |     http://wrapper.tanukisoftware.org
wrapper  |   Licensed to PMEase Inc. for QuickBuild
wrapper  |
wrapper  | Launching a JVM...
jvm 1    | WrapperManager: Initializing...
jvm 1    | 2010-06-21 08:47:54,191 INFO  - Booting application from '/opt/quickbuild/quickbuild-2.0.6'...
jvm 1    | 2010-06-21 08:47:54,267 INFO  - Starting framework...
jvm 1    | 2010-06-21 08:47:55,617 INFO  - Starting QuickBuild server...
jvm 1    | 2010-06-21 08:47:55,617 INFO  - Starting IOC container...
jvm 1    | 2010-06-21 08:47:55,910 INFO  - Cleaning temp directory...
jvm 1    | 2010-06-21 08:47:55,970 INFO  - Checking data version...
jvm 1    | 2010-06-21 08:47:56,803 INFO  - Checking data...
jvm 1    | 2010-06-21 08:47:59,650 ERROR - Exception executing batch:
jvm 1    | org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1
jvm 1    |      at org.hibernate.jdbc.Expectations$BasicExpectation.checkBatched(Expectations.java:61)
jvm 1    |      at org.hibernate.jdbc.Expectations$BasicExpectation.verifyOutcome(Expectations.java:46)
jvm 1    |      at org.hibernate.jdbc.BatchingBatcher.checkRowCounts(BatchingBatcher.java:68)
jvm 1    |      at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
jvm 1    |      at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
jvm 1    |      at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:237)
jvm 1    |      at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:142)
jvm 1    |      at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
jvm 1    |      at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
jvm 1    |      at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
jvm 1    |      at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
jvm 1    |      at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
jvm 1    |      at com.pmease.quickbuild.persistence.TransactionInterceptor.invoke(TransactionInterceptor.java:56)
jvm 1    |      at com.google.inject.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:66)
jvm 1    |      at com.google.inject.InterceptorStackCallback.intercept(InterceptorStackCallback.java:45)
jvm 1    |      at com.pmease.quickbuild.entitymanager.impl.DefaultDataManager$$EnhancerByGuice$$eff7f312.initialize(<generated>)
jvm 1    |      at com.pmease.quickbuild.Quickbuild.startServer(Quickbuild.java:273)
jvm 1    |      at com.pmease.quickbuild.Quickbuild.access$3(Quickbuild.java:233)
jvm 1    |      at com.pmease.quickbuild.Quickbuild$2.run(Quickbuild.java:155)
jvm 1    |      at java.lang.Thread.run(Thread.java:595)
jvm 1    | 2010-06-21 08:47:59,655 ERROR - Could not synchronize database state with session
jvm 1    | org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1
jvm 1    |      at org.hibernate.jdbc.Expectations$BasicExpectation.checkBatched(Expectations.java:61)
jvm 1    |      at org.hibernate.jdbc.Expectations$BasicExpectation.verifyOutcome(Expectations.java:46)
jvm 1    |      at org.hibernate.jdbc.BatchingBatcher.checkRowCounts(BatchingBatcher.java:68)
jvm 1    |      at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
jvm 1    |      at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
jvm 1    |      at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:237)
jvm 1    |      at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:142)
jvm 1    |      at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
jvm 1    |      at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
jvm 1    |      at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
jvm 1    |      at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
jvm 1    |      at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
jvm 1    |      at com.pmease.quickbuild.persistence.TransactionInterceptor.invoke(TransactionInterceptor.java:56)
jvm 1    |      at com.google.inject.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:66)
jvm 1    |      at com.google.inject.InterceptorStackCallback.intercept(InterceptorStackCallback.java:45)
jvm 1    |      at com.pmease.quickbuild.entitymanager.impl.DefaultDataManager$$EnhancerByGuice$$eff7f312.initialize(<generated>)
jvm 1    |      at com.pmease.quickbuild.Quickbuild.startServer(Quickbuild.java:273)
jvm 1    |      at com.pmease.quickbuild.Quickbuild.access$3(Quickbuild.java:233)
jvm 1    |      at com.pmease.quickbuild.Quickbuild$2.run(Quickbuild.java:155)
jvm 1    |      at java.lang.Thread.run(Thread.java:595)
jvm 1    | 2010-06-21 08:47:59,657 ERROR - Error starting QuickBuild.
jvm 1    | org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1
jvm 1    |      at org.hibernate.jdbc.Expectations$BasicExpectation.checkBatched(Expectations.java:61)
jvm 1    |      at org.hibernate.jdbc.Expectations$BasicExpectation.verifyOutcome(Expectations.java:46)
jvm 1    |      at org.hibernate.jdbc.BatchingBatcher.checkRowCounts(BatchingBatcher.java:68)
jvm 1    |      at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
jvm 1    |      at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
jvm 1    |      at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:237)
jvm 1    |      at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:142)
jvm 1    |      at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
jvm 1    |      at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
jvm 1    |      at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
jvm 1    |      at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
jvm 1    |      at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
jvm 1    |      at com.pmease.quickbuild.persistence.TransactionInterceptor.invoke(TransactionInterceptor.java:56)
jvm 1    |      at com.google.inject.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:66)
jvm 1    |      at com.google.inject.InterceptorStackCallback.intercept(InterceptorStackCallback.java:45)
jvm 1    |      at com.pmease.quickbuild.entitymanager.impl.DefaultDataManager$$EnhancerByGuice$$eff7f312.initialize(<generated>)
jvm 1    |      at com.pmease.quickbuild.Quickbuild.startServer(Quickbuild.java:273)
jvm 1    |      at com.pmease.quickbuild.Quickbuild.access$3(Quickbuild.java:233)
jvm 1    |      at com.pmease.quickbuild.Quickbuild$2.run(Quickbuild.java:155)
jvm 1    |      at java.lang.Thread.run(Thread.java:595)
jvm 1    | 2010-06-21 08:47:59,658 INFO  - Stopping QuickBuild server...
jvm 1    | 2010-06-21 08:47:59,658 INFO  - Stopping task scheduler...
jvm 1    | 2010-06-21 08:47:59,660 INFO  - Closing session factory...
jvm 1    | 2010-06-21 08:47:59,661 INFO  - Cleaning up temp files...
jvm 1    | 2010-06-21 08:47:59,722 INFO  - QuickBuild server stopped.
wrapper  | <-- Wrapper Stopped
  • replies 1
  • views 1151
  • stars 0
#2
robinshen ADMIN ·
Seems that you are running against the embedded H2 database which is not reliable and only for demonstration purpose. If this is true, please switch to external database following instructions below to avoid further damage:
http://wiki.pmease.com/display/QB21/Data+Management
Commercial user may submit a support request in this case, and we can try to fix the database.
Log in to reply