History | Log In     View a printable version of the current page.  
   HOME       BROWSE PROJECT       FIND ISSUES   
    QUICK SEARCH:  
Issue Details (XML | Word | Printable)

Key: QB-614
Type: Bug Bug
Status: Resolved Resolved
Resolution: Fixed
Priority: Major Major
Assignee: Robin Shen
Reporter: Moshe shalev
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
QuickBuild

Backup throwing exeption: no row with the given identifier exists

Created: 13/Sep/10 04:04 PM   Updated: 28/Sep/10 02:41 PM
Component/s: None
Affects Version/s: None
Fix Version/s: None

Original Estimate: Unknown Remaining Estimate: Unknown Time Spent: Unknown
File Attachments: 1. Text File console.log (118 kb)
Environment: quickbuild-2.1.46-windows-x86-64


 Description  « Hide
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)

 All   Comments   Work Log   Change History      Sort Order:
[ Permlink | « Hide ]
Moshe shalev [13/Sep/10 04:04 PM]
attaching console.log

Change by Moshe shalev [13/Sep/10 04:04 PM]
Field Original Value New Value
Attachment console.log [ 10210 ]

[ Permlink | « Hide ]
Robin Shen [14/Sep/10 12:07 AM]
On which type of database are you running QB?

[ Permlink | « Hide ]
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.

[ Permlink | « Hide ]
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.

[ Permlink | « Hide ]
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?

[ Permlink | « Hide ]
Robin Shen [16/Sep/10 11:55 PM]
I've sent you a separate mail regarding the ftp sever account.

[ Permlink | « Hide ]
Moshe shalev [17/Sep/10 05:23 AM]
The zip file is on the ftp site

[ Permlink | « Hide ]
Robin Shen [17/Sep/10 08:33 AM]
I've got the db file. Please also tell which QuickBuild version you are using.

[ Permlink | « Hide ]
Moshe shalev [17/Sep/10 12:57 PM]
quickbuild-2.1.46-windows-x86-64

[ Permlink | « Hide ]
Robin Shen [18/Sep/10 01:00 AM]
The database is fixed, and I will send you a separate mail including the fixed db.

Change by Robin Shen [18/Sep/10 01:00 AM]
Status Open [ 1 ] Resolved [ 5 ]
Resolution Fixed [ 1 ]

[ Permlink | « Hide ]
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.


Powered by Atlassian JIRA™ the Professional Issue Tracker. (Standard Edition, Version: 3.7.4-#189) - Bug/feature request - Contact Administrators