| << Back to previous view |
|
[QB-614] Backup throwing exeption: no row with the given identifier exists
|
|
| Status: | Resolved |
| Project: | QuickBuild |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Major |
| Reporter: | Moshe shalev | Assigned To: | Robin Shen |
| Resolution: | Fixed | Votes: | 0 |
| Remaining Estimate: | Unknown | Time Spent: | Unknown |
| Original Estimate: | Unknown | ||
| Environment: | quickbuild-2.1.46-windows-x86-64 | ||
| File Attachments: |
console.log
|
| Description |
|
The scheduled backup was working fine but has been failing for the last few days with the same error:
jvm 1 | 2010-09-13 04:00:06,729 ERROR - Job default.com.pmease.quickbuild.taskschedule.DefaultTaskScheduler$HelperTask threw an unhandled Exception: jvm 1 | org.hibernate.ObjectNotFoundException: No row with the given identifier exists: [com.pmease.quickbuild.model.Configuration#908] jvm 1 | at org.hibernate.impl.SessionFactoryImpl$1.handleEntityNotFound(SessionFactoryImpl.java:377) jvm 1 | at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:145) jvm 1 | at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:195) jvm 1 | at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:103) jvm 1 | at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:878) jvm 1 | at org.hibernate.impl.SessionImpl.internalLoad(SessionImpl.java:846) jvm 1 | at org.hibernate.type.EntityType.resolveIdentifier(EntityType.java:557) jvm 1 | at org.hibernate.type.EntityType.resolve(EntityType.java:379) jvm 1 | at org.hibernate.engine.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:116) jvm 1 | at org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:854) jvm 1 | at org.hibernate.loader.Loader.doQuery(Loader.java:729) jvm 1 | at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236) jvm 1 | at org.hibernate.loader.Loader.doList(Loader.java:2220) jvm 1 | at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104) jvm 1 | at org.hibernate.loader.Loader.list(Loader.java:2099) jvm 1 | at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378) jvm 1 | at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338) jvm 1 | at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172) jvm 1 | at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121) jvm 1 | at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79) jvm 1 | at com.pmease.quickbuild.entitymanager.impl.DefaultDataManager.exportEntity(DefaultDataManager.java:457) jvm 1 | at com.pmease.quickbuild.entitymanager.impl.DefaultDataManager.exportData(DefaultDataManager.java:435) jvm 1 | at com.pmease.quickbuild.entitymanager.impl.DefaultDataManager$$EnhancerByGuice$$11fec743.CGLIB$exportData$7(<generated>) jvm 1 | at com.pmease.quickbuild.entitymanager.impl.DefaultDataManager$$EnhancerByGuice$$11fec743$$FastClassByGuice$$fe11fbff.invoke(<generated>) jvm 1 | at com.google.inject.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:187) jvm 1 | at com.google.inject.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:66) jvm 1 | at com.pmease.quickbuild.persistence.TransactionInterceptor.invoke(TransactionInterceptor.java:49) 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$$11fec743.exportData(<generated>) jvm 1 | at com.pmease.quickbuild.AutoBackupScheduler$1.execute(AutoBackupScheduler.java:38) jvm 1 | at com.pmease.quickbuild.taskschedule.DefaultTaskScheduler$HelperTask.execute(DefaultTaskScheduler.java:89) jvm 1 | at org.quartz.core.JobRunShell.run(JobRunShell.java:202) jvm 1 | at java.lang.Thread.run(Unknown Source) jvm 1 | 2010-09-13 04:00:06,729 ERROR - Job (default.com.pmease.quickbuild.taskschedule.DefaultTaskScheduler$HelperTask threw an exception. jvm 1 | org.quartz.SchedulerException: Job threw an unhandled exception. [See nested exception: org.hibernate.ObjectNotFoundException: No row with the given identifier exists: [com.pmease.quickbuild.model.Configuration#908]] jvm 1 | at org.quartz.core.JobRunShell.run(JobRunShell.java:213) jvm 1 | at java.lang.Thread.run(Unknown Source) jvm 1 | Caused by: org.hibernate.ObjectNotFoundException: No row with the given identifier exists: [com.pmease.quickbuild.model.Configuration#908] jvm 1 | at org.hibernate.impl.SessionFactoryImpl$1.handleEntityNotFound(SessionFactoryImpl.java:377) jvm 1 | at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:145) jvm 1 | at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:195) jvm 1 | at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:103) jvm 1 | at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:878) jvm 1 | at org.hibernate.impl.SessionImpl.internalLoad(SessionImpl.java:846) jvm 1 | at org.hibernate.type.EntityType.resolveIdentifier(EntityType.java:557) jvm 1 | at org.hibernate.type.EntityType.resolve(EntityType.java:379) jvm 1 | at org.hibernate.engine.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:116) jvm 1 | at org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:854) jvm 1 | at org.hibernate.loader.Loader.doQuery(Loader.java:729) jvm 1 | at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236) jvm 1 | at org.hibernate.loader.Loader.doList(Loader.java:2220) jvm 1 | at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104) jvm 1 | at org.hibernate.loader.Loader.list(Loader.java:2099) jvm 1 | at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378) jvm 1 | at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338) jvm 1 | at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172) jvm 1 | at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121) jvm 1 | at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79) jvm 1 | at com.pmease.quickbuild.entitymanager.impl.DefaultDataManager.exportEntity(DefaultDataManager.java:457) jvm 1 | at com.pmease.quickbuild.entitymanager.impl.DefaultDataManager.exportData(DefaultDataManager.java:435) jvm 1 | at com.pmease.quickbuild.entitymanager.impl.DefaultDataManager$$EnhancerByGuice$$11fec743.CGLIB$exportData$7(<generated>) jvm 1 | at com.pmease.quickbuild.entitymanager.impl.DefaultDataManager$$EnhancerByGuice$$11fec743$$FastClassByGuice$$fe11fbff.invoke(<generated>) jvm 1 | at com.google.inject.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:187) jvm 1 | at com.google.inject.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:66) jvm 1 | at com.pmease.quickbuild.persistence.TransactionInterceptor.invoke(TransactionInterceptor.java:49) 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$$11fec743.exportData(<generated>) jvm 1 | at com.pmease.quickbuild.AutoBackupScheduler$1.execute(AutoBackupScheduler.java:38) jvm 1 | at com.pmease.quickbuild.taskschedule.DefaultTaskScheduler$HelperTask.execute(DefaultTaskScheduler.java:89) jvm 1 | at org.quartz.core.JobRunShell.run(JobRunShell.java:202) |
| Comments |
| Comment by Moshe shalev [ 13/Sep/10 04:04 PM ] |
| attaching console.log |
| Comment by Robin Shen [ 14/Sep/10 12:07 AM ] |
| On which type of database are you running QB? |
| Comment by Moshe shalev [ 14/Sep/10 02:03 PM ] |
| We are still on the embedded h2 db but want to take a current backup to restore on sql server. |
| Comment by Robin Shen [ 14/Sep/10 11:03 PM ] |
| The embedded database is not reliable and it seems that the database is now corrupted. You may zip all files under <QB install dir>/sampledb and send to [support AT pmease DOT com]. We will try to fix it for you. |
| Comment by Moshe shalev [ 16/Sep/10 08:26 PM ] |
| The zip file size exceeds the email limit. Is there an FTP site where I can put it or any alternative way to send you the file? |
| Comment by Robin Shen [ 16/Sep/10 11:55 PM ] |
| I've sent you a separate mail regarding the ftp sever account. |
| Comment by Moshe shalev [ 17/Sep/10 05:23 AM ] |
| The zip file is on the ftp site |
| Comment by Robin Shen [ 17/Sep/10 08:33 AM ] |
| I've got the db file. Please also tell which QuickBuild version you are using. |
| Comment by Moshe shalev [ 17/Sep/10 12:57 PM ] |
| quickbuild-2.1.46-windows-x86-64 |
| Comment by Robin Shen [ 18/Sep/10 01:00 AM ] |
| The database is fixed, and I will send you a separate mail including the fixed db. |
| Comment by Moshe shalev [ 28/Sep/10 02:41 PM ] |
| The database has been restore on SQL Server and is working fine now. Thanks for the help, this issue can be closed. |