[ 
http://jira.codehaus.org/browse/CONTINUUM-721?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Emmanuel Venisse closed CONTINUUM-721.
--------------------------------------

         Assignee: Emmanuel Venisse
       Resolution: Won't Fix
    Fix Version/s:     (was: Future)

out of date

> JDO Deadlock stack whilst removing a POM
> ----------------------------------------
>
>                 Key: CONTINUUM-721
>                 URL: http://jira.codehaus.org/browse/CONTINUUM-721
>             Project: Continuum
>          Issue Type: Bug
>          Components: Core system, Database
>    Affects Versions: 1.0.3
>         Environment: linux amd64
>            Reporter: Andy Brook
>            Assignee: Emmanuel Venisse
>
> ognl.MethodFailedException: Method "removeProject" failed for object [EMAIL 
> PROTECTED] [javax.jdo.JDODataStoreException: Update request failed: UPDATE 
> PROJECT SET CHECKOUT_RESULT_SCMRESULT_ID_OID=? WHERE ID=?
> NestedThrowables:
> SQL Exception: A lock could not be obtained due to a deadlock, cycle of locks 
> and waiters is:
> Lock : ROW, PROJECT, (3,17)
>   Waiting XID : {64696941, X} , SA, UPDATE PROJECT SET 
> CHECKOUT_RESULT_SCMRESULT_ID_OID=? WHERE ID=?
>   Granted XID : {64696933, X} 
> Lock : ROW, BUILDDEFINITION, (3,28)
>   Waiting XID : {64696933, X} , SA, INSERT INTO BUILDDEFINITION 
> (SCHEDULE_ID_OID,LATEST_BUILD_ID,MODEL_ENCODING,BUILD_FILE,GOALS,DEFAULT_FOR_PROJECT,PROFILE_ID_OID,ARGUMENTS,ID)
>  VALUES (?,?,?,?,?,?,?,?,?)
>   Granted XID : {64696941, X} 
> . The selected victim is XID : 64696941.]
>       at ognl.OgnlRuntime.callAppropriateMethod(OgnlRuntime.java:796)
>       at ognl.ObjectMethodAccessor.callMethod(ObjectMethodAccessor.java:61)
>       at ognl.OgnlRuntime.callMethod(OgnlRuntime.java:819)
>       at ognl.ASTMethod.getValueBody(ASTMethod.java:75)
>       at ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:170)
>       at ognl.SimpleNode.getValue(SimpleNode.java:210)
>       at ognl.Ognl.getValue(Ognl.java:333)
>       at ognl.Ognl.getValue(Ognl.java:378)
>       at ognl.Ognl.getValue(Ognl.java:357)
>       at 
> org.codehaus.plexus.formica.action.DeleteEntity.uponSuccessfulValidation(DeleteEntity.java:57)
>       at 
> org.codehaus.plexus.formica.action.DeleteEntity.execute(DeleteEntity.java:47)
>       at 
> org.codehaus.plexus.summit.pipeline.valve.ActionValve.invoke(ActionValve.java:68)
>       at 
> org.codehaus.plexus.summit.pipeline.AbstractPipeline.invoke(AbstractPipeline.java:70)
>       at org.codehaus.plexus.summit.Summit.doGet(Summit.java:54)
>       at org.codehaus.plexus.summit.Summit.doPost(Summit.java:108)
>       at javax.servlet.http.HttpServlet.service(HttpServlet.java:615)
>       at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
>       at 
> org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:358)
>       at 
> org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:294)
>       at 
> org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:567)
>       at org.mortbay.http.HttpContext.handle(HttpContext.java:1807)
>       at 
> org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:525)
>       at org.mortbay.http.HttpContext.handle(HttpContext.java:1757)
>       at org.mortbay.http.HttpServer.service(HttpServer.java:879)
>       at org.mortbay.http.HttpConnection.service(HttpConnection.java:789)
>       at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:960)
>       at org.mortbay.http.HttpConnection.handle(HttpConnection.java:806)
>       at 
> org.mortbay.http.SocketListener.handleConnection(SocketListener.java:218)
>       at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:331)
>       at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:520)
> /-- Encapsulated exception ------------\
> javax.jdo.JDODataStoreException: Update request failed: UPDATE PROJECT SET 
> CHECKOUT_RESULT_SCMRESULT_ID_OID=? WHERE ID=?
>       at 
> org.jpox.store.rdbms.request.UpdateRequest.execute(UpdateRequest.java:267)
>       at org.jpox.store.rdbms.table.ClassTable.update(ClassTable.java:2200)
>       at org.jpox.store.StoreManager.update(StoreManager.java:786)
>       at org.jpox.state.StateManagerImpl.flush(StateManagerImpl.java:4596)
>       at 
> org.jpox.AbstractPersistenceManager.flush(AbstractPersistenceManager.java:3167)
>       at 
> org.jpox.NonmanagedTransaction.getConnection(NonmanagedTransaction.java:235)
>       at 
> org.jpox.NonmanagedTransaction.getConnection(NonmanagedTransaction.java:204)
>       at 
> org.jpox.AbstractPersistenceManager.getConnection(AbstractPersistenceManager.java:370)
>       at 
> org.jpox.store.rdbms.scostore.InverseListStore.clear(InverseListStore.java:986)
>       at 
> org.jpox.store.mapping.CollectionMapping.preDelete(CollectionMapping.java:304)
>       at 
> org.jpox.store.mapping.CollectionMapping.deleteDependent(CollectionMapping.java:332)
>       at 
> org.jpox.store.rdbms.table.ClassTable.deleteDependent(ClassTable.java:2280)
>       at org.jpox.store.StoreManager.deleteDependent(StoreManager.java:838)
>       at 
> org.jpox.state.StateManagerImpl.deletePersistent(StateManagerImpl.java:4049)
>       at 
> org.jpox.AbstractPersistenceManager.internalDeletePersistent(AbstractPersistenceManager.java:1391)
>       at 
> org.jpox.AbstractPersistenceManager.deletePersistent(AbstractPersistenceManager.java:1402)
>       at 
> org.jpox.store.rdbms.table.ClassTable.deleteDependent(ClassTable.java:2324)
>       at org.jpox.store.StoreManager.deleteDependent(StoreManager.java:838)
>       at 
> org.jpox.state.StateManagerImpl.deletePersistent(StateManagerImpl.java:4049)
>       at 
> org.jpox.AbstractPersistenceManager.internalDeletePersistent(AbstractPersistenceManager.java:1391)
>       at 
> org.jpox.AbstractPersistenceManager.deletePersistent(AbstractPersistenceManager.java:1402)
>       at 
> org.codehaus.plexus.jdo.PlexusJdoUtils.removeObject(PlexusJdoUtils.java:53)
>       at 
> org.apache.maven.continuum.store.JdoContinuumStore.removeObject(JdoContinuumStore.java:969)
>       at 
> org.apache.maven.continuum.store.JdoContinuumStore.removeProject(JdoContinuumStore.java:901)
>       at 
> org.apache.maven.continuum.DefaultContinuum.removeProject(DefaultContinuum.java:328)
>       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>       at 
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>       at 
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>       at java.lang.reflect.Method.invoke(Method.java:585)
>       at ognl.OgnlRuntime.invokeMethod(OgnlRuntime.java:491)
>       at ognl.OgnlRuntime.callAppropriateMethod(OgnlRuntime.java:785)
>       at ognl.ObjectMethodAccessor.callMethod(ObjectMethodAccessor.java:61)
>       at ognl.OgnlRuntime.callMethod(OgnlRuntime.java:819)
>       at ognl.ASTMethod.getValueBody(ASTMethod.java:75)
>       at ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:170)
>       at ognl.SimpleNode.getValue(SimpleNode.java:210)
>       at ognl.Ognl.getValue(Ognl.java:333)
>       at ognl.Ognl.getValue(Ognl.java:378)
>       at ognl.Ognl.getValue(Ognl.java:357)
>       at 
> org.codehaus.plexus.formica.action.DeleteEntity.uponSuccessfulValidation(DeleteEntity.java:57)
>       at 
> org.codehaus.plexus.formica.action.DeleteEntity.execute(DeleteEntity.java:47)
>       at 
> org.codehaus.plexus.summit.pipeline.valve.ActionValve.invoke(ActionValve.java:68)
>       at 
> org.codehaus.plexus.summit.pipeline.AbstractPipeline.invoke(AbstractPipeline.java:70)
>       at org.codehaus.plexus.summit.Summit.doGet(Summit.java:54)
>       at org.codehaus.plexus.summit.Summit.doPost(Summit.java:108)
>       at javax.servlet.http.HttpServlet.service(HttpServlet.java:615)
>       at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
>       at 
> org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:358)
>       at 
> org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:294)
>       at 
> org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:567)
>       at org.mortbay.http.HttpContext.handle(HttpContext.java:1807)
>       at 
> org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:525)
>       at org.mortbay.http.HttpContext.handle(HttpContext.java:1757)
>       at org.mortbay.http.HttpServer.service(HttpServer.java:879)
>       at org.mortbay.http.HttpConnection.service(HttpConnection.java:789)
>       at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:960)
>       at org.mortbay.http.HttpConnection.handle(HttpConnection.java:806)
>       at 
> org.mortbay.http.SocketListener.handleConnection(SocketListener.java:218)
>       at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:331)
>       at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:520)
> NestedThrowablesStackTrace:
> ERROR 40001: A lock could not be obtained due to a deadlock, cycle of locks 
> and waiters is:
> Lock : ROW, PROJECT, (3,17)
>   Waiting XID : {64696941, X} , SA, UPDATE PROJECT SET 
> CHECKOUT_RESULT_SCMRESULT_ID_OID=? WHERE ID=?
>   Granted XID : {64696933, X} 
> Lock : ROW, BUILDDEFINITION, (3,28)
>   Waiting XID : {64696933, X} , SA, INSERT INTO BUILDDEFINITION 
> (SCHEDULE_ID_OID,LATEST_BUILD_ID,MODEL_ENCODING,BUILD_FILE,GOALS,DEFAULT_FOR_PROJECT,PROFILE_ID_OID,ARGUMENTS,ID)
>  VALUES (?,?,?,?,?,?,?,?,?)
>   Granted XID : {64696941, X} 
> . The selected victim is XID : 64696941.
>       at org.apache.derby.iapi.error.StandardException.newException(Unknown 
> Source)
>       at org.apache.derby.impl.services.locks.Deadlock.buildException(Unknown 
> Source)
>       at org.apache.derby.impl.services.locks.LockSet.lockObject(Unknown 
> Source)
>       at org.apache.derby.impl.services.locks.SinglePool.lockAnObject(Unknown 
> Source)
>       at org.apache.derby.impl.services.locks.SinglePool.lockObject(Unknown 
> Source)
>       at 
> org.apache.derby.impl.store.raw.xact.RowLocking3.lockRecordForWrite(Unknown 
> Source)
>       at 
> org.apache.derby.impl.store.access.heap.HeapController.lockRow(Unknown Source)
>       at 
> org.apache.derby.impl.store.access.heap.HeapController.lockRow(Unknown Source)
>       at 
> org.apache.derby.impl.store.access.btree.index.B2IRowLocking3.lockRowOnPage(Unknown
>  Source)
>       at 
> org.apache.derby.impl.store.access.btree.index.B2IRowLocking3._lockScanRow(Unknown
>  Source)
>       at 
> org.apache.derby.impl.store.access.btree.index.B2IRowLocking1.lockScanRow(Unknown
>  Source)
>       at 
> org.apache.derby.impl.store.access.btree.BTreeForwardScan.fetchRows(Unknown 
> Source)
>       at org.apache.derby.impl.store.access.btree.BTreeScan.fetchNext(Unknown 
> Source)
>       at 
> org.apache.derby.impl.sql.execute.TableScanResultSet.getNextRowCore(Unknown 
> Source)
>       at 
> org.apache.derby.impl.sql.execute.IndexRowToBaseRowResultSet.getNextRowCore(Unknown
>  Source)
>       at 
> org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.getNextRowCore(Unknown
>  Source)
>       at 
> org.apache.derby.impl.sql.execute.NormalizeResultSet.getNextRowCore(Unknown 
> Source)
>       at 
> org.apache.derby.impl.sql.execute.DMLWriteResultSet.getNextRowCore(Unknown 
> Source)
>       at 
> org.apache.derby.impl.sql.execute.UpdateResultSet.collectAffectedRows(Unknown 
> Source)
>       at org.apache.derby.impl.sql.execute.UpdateResultSet.open(Unknown 
> Source)
>       at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown 
> Source)
>       at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown 
> Source)
>       at 
> org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown 
> Source)
>       at org.apache.derby.impl.jdbc.EmbedPreparedStatement.execute(Unknown 
> Source)
>       at org.jpox.store.rdbms.request.Request.executeUpdate(Request.java:78)
>       at 
> org.jpox.store.rdbms.request.UpdateRequest.execute(UpdateRequest.java:253)
>       at org.jpox.store.rdbms.table.ClassTable.update(ClassTable.java:2200)
>       at org.jpox.store.StoreManager.update(StoreManager.java:786)
>       at org.jpox.state.StateManagerImpl.flush(StateManagerImpl.java:4596)
>       at 
> org.jpox.AbstractPersistenceManager.flush(AbstractPersistenceManager.java:3167)
>       at 
> org.jpox.NonmanagedTransaction.getConnection(NonmanagedTransaction.java:235)
>       at 
> org.jpox.NonmanagedTransaction.getConnection(NonmanagedTransaction.java:204)
>       at 
> org.jpox.AbstractPersistenceManager.getConnection(AbstractPersistenceManager.java:370)
>       at 
> org.jpox.store.rdbms.scostore.InverseListStore.clear(InverseListStore.java:986)
>       at 
> org.jpox.store.mapping.CollectionMapping.preDelete(CollectionMapping.java:304)
>       at 
> org.jpox.store.mapping.CollectionMapping.deleteDependent(CollectionMapping.java:332)
>       at 
> org.jpox.store.rdbms.table.ClassTable.deleteDependent(ClassTable.java:2280)
>       at org.jpox.store.StoreManager.deleteDependent(StoreManager.java:838)
>       at 
> org.jpox.state.StateManagerImpl.deletePersistent(StateManagerImpl.java:4049)
>       at 
> org.jpox.AbstractPersistenceManager.internalDeletePersistent(AbstractPersistenceManager.java:1391)
>       at 
> org.jpox.AbstractPersistenceManager.deletePersistent(AbstractPersistenceManager.java:1402)
>       at 
> org.jpox.store.rdbms.table.ClassTable.deleteDependent(ClassTable.java:2324)
>       at org.jpox.store.StoreManager.deleteDependent(StoreManager.java:838)
>       at 
> org.jpox.state.StateManagerImpl.deletePersistent(StateManagerImpl.java:4049)
>       at 
> org.jpox.AbstractPersistenceManager.internalDeletePersistent(AbstractPersistenceManager.java:1391)
>       at 
> org.jpox.AbstractPersistenceManager.deletePersistent(AbstractPersistenceManager.java:1402)
>       at 
> org.codehaus.plexus.jdo.PlexusJdoUtils.removeObject(PlexusJdoUtils.java:53)
>       at 
> org.apache.maven.continuum.store.JdoContinuumStore.removeObject(JdoContinuumStore.java:969)
>       at 
> org.apache.maven.continuum.store.JdoContinuumStore.removeProject(JdoContinuumStore.java:901)
>       at 
> org.apache.maven.continuum.DefaultContinuum.removeProject(DefaultContinuum.java:328)
>       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>       at 
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>       at 
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>       at java.lang.reflect.Method.invoke(Method.java:585)
>       at ognl.OgnlRuntime.invokeMethod(OgnlRuntime.java:491)
>       at ognl.OgnlRuntime.callAppropriateMethod(OgnlRuntime.java:785)
>       at ognl.ObjectMethodAccessor.callMethod(ObjectMethodAccessor.java:61)
>       at ognl.OgnlRuntime.callMethod(OgnlRuntime.java:819)
>       at ognl.ASTMethod.getValueBody(ASTMethod.java:75)
>       at ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:170)
>       at ognl.SimpleNode.getValue(SimpleNode.java:210)
>       at ognl.Ognl.getValue(Ognl.java:333)
>       at ognl.Ognl.getValue(Ognl.java:378)
>       at ognl.Ognl.getValue(Ognl.java:357)
>       at 
> org.codehaus.plexus.formica.action.DeleteEntity.uponSuccessfulValidation(DeleteEntity.java:57)
>       at 
> org.codehaus.plexus.formica.action.DeleteEntity.execute(DeleteEntity.java:47)
>       at 
> org.codehaus.plexus.summit.pipeline.valve.ActionValve.invoke(ActionValve.java:68)
>       at 
> org.codehaus.plexus.summit.pipeline.AbstractPipeline.invoke(AbstractPipeline.java:70)
>       at org.codehaus.plexus.summit.Summit.doGet(Summit.java:54)
>       at org.codehaus.plexus.summit.Summit.doPost(Summit.java:108)
>       at javax.servlet.http.HttpServlet.service(HttpServlet.java:615)
>       at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
>       at 
> org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:358)
>       at 
> org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:294)
>       at 
> org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:567)
>       at org.mortbay.http.HttpContext.handle(HttpContext.java:1807)
>       at 
> org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:525)
>       at org.mortbay.http.HttpContext.handle(HttpContext.java:1757)
>       at org.mortbay.http.HttpServer.service(HttpServer.java:879)
>       at org.mortbay.http.HttpConnection.service(HttpConnection.java:789)
>       at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:960)
>       at org.mortbay.http.HttpConnection.handle(HttpConnection.java:806)
>       at 
> org.mortbay.http.SocketListener.handleConnection(SocketListener.java:218)
>       at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:331)
>       at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:520)
> \--------------------------------------/

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Reply via email to