Re: Can anyone help with this error?

Wed, 22 Feb 2006 01:23:08 -0800

Hmm, that's weird. We have some problems with jdo/jpox and in your case, i don't know if it's a pb with jdo/jpox or with derby. 

What is your OS?

I think will use something else in 1.1

Emmanuel

Punkin Head a écrit :

Sorry for the length it took to reply to this, I was out for a couple of
days.

Yes, the application.xml has that in it though.

On 2/18/06, Emmanuel Venisse <[EMAIL PROTECTED]> wrote:


Do you have the following part in your application.xml :

          <property>
            <name>org.jpox.transactionIsolation</name>
            <value>READ_UNCOMMITTED</value>
          </property>
          <property>
            <name>org.jpox.poid.transactionIsolation</name>
            <value>READ_UNCOMMITTED</value>
          </property>


Emmanuel

Punkin Head a écrit :


1.0.2 also using with Maven 2.0

On 2/17/06, Emmanuel Venisse <[EMAIL PROTECTED]> wrote:



What is your continuum version?

Emmanuel

Punkin Head a écrit :



The parent of our application will get an error at the scheduled time


of


build (not on every scheduled build but about 4 or 5 times a day), even


when



no changes have been done to it.  When I go to force the build, it


builds



successfully. Here is the error:

javax.jdo.JDODataStoreException: Insert request failed: INSERT INTO
PROJECTDEPENDENCY (PROJECTDEPENDENCY_ID,VERSION,ARTIFACT_ID,GROUP_ID)
VALUES (?,?,?,?)
    at org.jpox.store.rdbms.request.InsertRequest.execute(


InsertRequest.java:329)



    at org.jpox.store.rdbms.table.ClassTable.insert(ClassTable.java


:1774)



    at org.jpox.store.StoreManager.insert(StoreManager.java:721)
    at org.jpox.state.StateManagerImpl.internalMakePersistent(


StateManagerImpl.java:3066)



    at org.jpox.state.StateManagerImpl.makePersistent(


StateManagerImpl.java:3039)



    at org.jpox.state.StateManagerImpl.attachCopy(


StateManagerImpl.java:3452)



    at org.jpox.AbstractPersistenceManager.attachCopy(


AbstractPersistenceManager.java:1644)



    at org.jpox.sco.List.attachCopy(List.java:326)
    at org.jpox.state.AttachFieldManager.storeObjectField(


AttachFieldManager.java:107)



    at org.jpox.state.StateManagerImpl.providedObjectField(


StateManagerImpl.java:2394)



    at


org.apache.maven.continuum.model.project.Project.jdoProvideField(
Project.java)



    at


org.apache.maven.continuum.model.project.Project.jdoProvideFields(
Project.java)



    at org.jpox.state.StateManagerImpl.provideFields(


StateManagerImpl.java:2732)



    at org.jpox.state.StateManagerImpl.internalAttachCopy(


StateManagerImpl.java:3518)



    at org.jpox.state.StateManagerImpl.attachCopy(


StateManagerImpl.java:3446)



    at org.jpox.AbstractPersistenceManager.attachCopy(


AbstractPersistenceManager.java:1644)



    at org.jpox.AbstractPersistenceManager.attachCopy(


AbstractPersistenceManager.java:1660)



    at


org.apache.maven.continuum.store.JdoContinuumStore.updateObject


(JdoContinuumStore.java:679)



    at


org.apache.maven.continuum.store.JdoContinuumStore.updateProject(
JdoContinuumStore.java:841)



    at




org.apache.maven.continuum.core.action.ExecuteBuilderContinuumAction.execute


(ExecuteBuilderContinuumAction.java:94)



    at


org.apache.maven.continuum.buildcontroller.DefaultBuildController.build(
DefaultBuildController.java:171)



    at




org.apache.maven.continuum.buildcontroller.BuildProjectTaskExecutor.executeTask


(BuildProjectTaskExecutor.java:53)



    at




org.codehaus.plexus.taskqueue.execution.ThreadedTaskQueueExecutor$ExecutorRunnable.run


(ThreadedTaskQueueExecutor.java:103)



    at java.lang.Thread.run(Thread.java:595)
NestedThrowablesStackTrace:
ERROR 40001: A lock could not be obtained due to a deadlock, cycle of
locks and waiters is:
Lock : ROW, PROJECTDEPENDENCY, (4271,6)
Waiting XID : {30604833, X} , SA, INSERT INTO PROJECTDEPENDENCY
(PROJECTDEPENDENCY_ID,VERSION,ARTIFACT_ID,GROUP_ID) VALUES (?,?,?,?)
Granted XID : {30604480, X}
Lock : ROW, PROJECT, (3,96)
Waiting XID : {30604480, S} , SA, UPDATE PROJECTDEPENDENCY SET
DEPENDENCIES_ID_OWN = ?,DEPENDENCIESINTEGER_IDX = ? WHERE
PROJECTDEPENDENCY_ID = ?
Granted XID : {30604833, X}
. The selected victim is XID : 30604833.
    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.lockNonScanRowOnPage


(Unknown



Source)
    at org.apache.derby.impl.store.access.btree.BTreeController.doIns


(Unknown



Source)
    at


org.apache.derby.impl.store.access.btree.BTreeController.insert


(Unknown



Source)
    at


org.apache.derby.impl.store.access.btree.index.B2IController.insert
(Unknown



Source)
    at


org.apache.derby.impl.sql.execute.IndexChanger.insertAndCheckDups


(Unknown


Source)
    at org.apache.derby.impl.sql.execute.IndexChanger.doInsert


(Unknown


Source)



    at org.apache.derby.impl.sql.execute.IndexChanger.insert(Unknown


Source)



    at org.apache.derby.impl.sql.execute.IndexSetChanger.insert


(Unknown


Source)



    at org.apache.derby.impl.sql.execute.RowChangerImpl.insertRow


(Unknown


Source)



    at


org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore


(Unknown


Source)
    at org.apache.derby.impl.sql.execute.InsertResultSet.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.executeUpdate


(Unknown



Source)
    at org.jpox.store.rdbms.request.Request.executeUpdate(


Request.java


:69)



    at org.jpox.store.rdbms.request.InsertRequest.execute(


InsertRequest.java:268)



    at org.jpox.store.rdbms.table.ClassTable.insert(ClassTable.java


:1774)



    at org.jpox.store.StoreManager.insert(StoreManager.java:721)
    at org.jpox.state.StateManagerImpl.internalMakePersistent(


StateManagerImpl.java:3066)



    at org.jpox.state.StateManagerImpl.makePersistent(


StateManagerImpl.java:3039)



    at org.jpox.state.StateManagerImpl.attachCopy(


StateManagerImpl.java:3452)



    at org.jpox.AbstractPersistenceManager.attachCopy(


AbstractPersistenceManager.java:1644)



    at org.jpox.sco.List.attachCopy(List.java:326)
    at org.jpox.state.AttachFieldManager.storeObjectField(


AttachFieldManager.java:107)



    at org.jpox.state.StateManagerImpl.providedObjectField(


StateManagerImpl.java:2394)



    at


org.apache.maven.continuum.model.project.Project.jdoProvideField(
Project.java)



    at


org.apache.maven.continuum.model.project.Project.jdoProvideFields(
Project.java)



    at org.jpox.state.StateManagerImpl.provideFields(


StateManagerImpl.java:2732)



    at org.jpox.state.StateManagerImpl.internalAttachCopy(


StateManagerImpl.java:3518)



    at org.jpox.state.StateManagerImpl.attachCopy(


StateManagerImpl.java:3446)



    at org.jpox.AbstractPersistenceManager.attachCopy(


AbstractPersistenceManager.java:1644)



    at org.jpox.AbstractPersistenceManager.attachCopy(


AbstractPersistenceManager.java:1660)



    at


org.apache.maven.continuum.store.JdoContinuumStore.updateObject


(JdoContinuumStore.java:679)



    at


org.apache.maven.continuum.store.JdoContinuumStore.updateProject(
JdoContinuumStore.java:841)



    at




org.apache.maven.continuum.core.action.ExecuteBuilderContinuumAction.execute


(ExecuteBuilderContinuumAction.java:94)



    at


org.apache.maven.continuum.buildcontroller.DefaultBuildController.build(
DefaultBuildController.java:171)



    at




org.apache.maven.continuum.buildcontroller.BuildProjectTaskExecutor.executeTask


(BuildProjectTaskExecutor.java:53)



    at




org.codehaus.plexus.taskqueue.execution.ThreadedTaskQueueExecutor$ExecutorRunnable.run


(ThreadedTaskQueueExecutor.java:103)



    at java.lang.Thread.run(Thread.java:595)




Thanks,

Adam






--
www.punkinshred.net  // punkin'head official homepage

www.myspace.com/punkinhead <-- for true shred







--
www.punkinshred.net  // punkin'head official homepage

www.myspace.com/punkinhead <-- for true shred

Reply via email to