ObjectWeb Consortium
Search ObjectWeb Mail Archive: 

Advanced Search - Powered by Google


Mail Archive Home | shark List | August 2007 Index

<--  Date Index     <--  Thread Index    

Re: [shark] error in set WfxmlInsntace SetProperties?


Hi,

it normally happens when you have two concurrent threads working on the same process. Both threads have started a new transaction and one of the threads committed transaction before another. When another thread tries to commit its transaction, our ORM tool determines that the database version of the process is changed meanwhile (by the first thread commit) and it throws an exception.

Regards,
Sasa.


Ignacio Talavera wrote:
Hi again ! I'm testing wfxmlInstancesetProperties and I get this exception
Any idea?
Update failed, but Table SHKProcesses id=1002870 does exist with version=3
at com.lutris.appserver.server.sql.CoreDO.seeWhatHappened (CoreDO.java:456) at com.lutris.appserver.server.sql.CoreDO.executeUpdate(CoreDO.java:420) at com.lutris.dods.builder.generator.dataobject.GenericDO.executeUpdate(GenericDO.java:384) at org.enhydra.shark.instancepersistence.data.ProcessDO.executeUpdate (ProcessDO.java:2546) at com.lutris.appserver.server.sql.standard.StandardDBTransaction.write(StandardDBTransaction.java:761) at org.enhydra.dods.jta.SyncDBTransactionFactory$SyncDBTransaction.write(SyncDBTransactionFactory.java :286)2007-08-30 17:03:47,750: at org.enhydra.shark.instancepersistence.data.ProcessQuery._runQuery(ProcessQuery.java:678) at org.enhydra.shark.instancepersistence.data.ProcessQuery.runQuery(ProcessQuery.java :632) at org.enhydra.shark.instancepersistence.data.ProcessQuery.getNextDO(ProcessQuery.java:1406) at org.enhydra.shark.instancepersistence.DODSPersistentManager.getPersistedProcessObject(DODSPersistentManager.java :3764) at org.enhydra.shark.instancepersistence.DODSPersistentManager.getPersistedObject(DODSPersistentManager.java:3698) at org.enhydra.shark.instancepersistence.DODSPersistentManager.persist(DODSPersistentManager.java :353)
    at org.enhydra.shark.WfProcessImpl.persist(WfProcessImpl.java:1613)
at org.enhydra.shark.WfExecutionObjectImpl.set_priority(WfExecutionObjectImpl.java:133) at org.enhydra.shark.WfProcessWrapper.set_priority (WfProcessWrapper.java:681) at org.enhydra.shark.asap.AsapInstanceBindingImpl.setProperties(AsapInstanceBindingImpl.java:116) at org.enhydra.shark.wfxml.WfXmlInstanceBindingSkeleton.setProperties(WfXmlInstanceBindingSkeleton.java :133)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397) at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java :186) at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323) at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
    at org.apache.axis.SimpleChain.doVisiting (SimpleChain.java:118)
    at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:454)
    at org.apache.axis.server.AxisServer.invoke( AxisServer.java:281)
at org.apache.axis.transport.http.SimpleAxisWorker.execute(SimpleAxisWorker.java:428) at org.apache.axis.transport.http.SimpleAxisWorker.run(SimpleAxisWorker.java:155) at org.apache.axis.transport.http.SimpleAxisServer.run (SimpleAxisServer.java:245) at org.apache.axis.transport.http.SimpleAxisServer.start(SimpleAxisServer.java:296) at org.apache.axis.transport.http.SimpleAxisServer.start(SimpleAxisServer.java:304) at org.apache.axis.transport.http.SimpleAxisServer.main (SimpleAxisServer.java:385)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke (Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
at org.enhydra.shark.wfxml.SharkServiceImpl.main(SharkServiceImpl.java:51) com.lutris.dods.builder.generator.query.DataObjectException: Couldn't write transaction: java.sql.SQLException: Update failed, but Table SHKProcesses id=1002870 does exist with version=3 at org.enhydra.shark.instancepersistence.data.ProcessQuery._runQuery(ProcessQuery.java:681) at org.enhydra.shark.instancepersistence.data.ProcessQuery.runQuery (ProcessQuery.java:632) at org.enhydra.shark.instancepersistence.data.ProcessQuery.getNextDO(ProcessQuery.java:1406) at org.enhydra.shark.instancepersistence.DODSPersistentManager.getPersistedProcessObject(DODSPersistentManager.java :3764) at org.enhydra.shark.instancepersistence.DODSPersistentManager.getPersistedObject(DODSPersistentManager.java:3698) at org.enhydra.shark.instancepersistence.DODSPersistentManager.persist(DODSPersistentManager.java :353)
    at org.enhydra.shark.WfProcessImpl.persist(WfProcessImpl.java:1613)
at org.enhydra.shark.WfExecutionObjectImpl.set_priority(WfExecutionObjectImpl.java:133) at org.enhydra.shark.WfProcessWrapper.set_priority (WfProcessWrapper.java:681) at org.enhydra.shark.asap.AsapInstanceBindingImpl.setProperties(AsapInstanceBindingImpl.java:116) at org.enhydra.shark.wfxml.WfXmlInstanceBindingSkeleton.setProperties(WfXmlInstanceBindingSkeleton.java :133)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397) at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java :186) at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323) at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
    at org.apache.axis.SimpleChain.doVisiting (SimpleChain.java:118)
    at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:454)
    at org.apache.axis.server.AxisServer.invoke( AxisServer.java:281)
at org.apache.axis.transport.http.SimpleAxisWorker.execute(SimpleAxisWorker.java:428) at org.apache.axis.transport.http.SimpleAxisWorker.run(SimpleAxisWorker.java:155) at org.apache.axis.transport.http.SimpleAxisServer.run (SimpleAxisServer.java:245) at org.apache.axis.transport.http.SimpleAxisServer.start(SimpleAxisServer.java:296) at org.apache.axis.transport.http.SimpleAxisServer.start(SimpleAxisServer.java:304) at org.apache.axis.transport.http.SimpleAxisServer.main (SimpleAxisServer.java:385)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke (Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
at org.enhydra.shark.wfxml.SharkServiceImpl.main(SharkServiceImpl.java:51) org.enhydra.shark.api.internal.instancepersistence.PersistenceException : Couldn't write transaction: java.sql.SQLException: Update failed, but Table SHKProcesses id=1002870 does exist with version=3 at org.enhydra.shark.instancepersistence.DODSPersistentManager.getPersistedProcessObject (DODSPersistentManager.java:3767) at org.enhydra.shark.instancepersistence.DODSPersistentManager.getPersistedObject(DODSPersistentManager.java:3698) at org.enhydra.shark.instancepersistence.DODSPersistentManager.persist (DODSPersistentManager.java:353)
    at org.enhydra.shark.WfProcessImpl.persist(WfProcessImpl.java:1613)
at org.enhydra.shark.WfExecutionObjectImpl.set_priority(WfExecutionObjectImpl.java:133) at org.enhydra.shark.WfProcessWrapper.set_priority (WfProcessWrapper.java:681) at org.enhydra.shark.asap.AsapInstanceBindingImpl.setProperties(AsapInstanceBindingImpl.java:116) at org.enhydra.shark.wfxml.WfXmlInstanceBindingSkeleton.setProperties(WfXmlInstanceBindingSkeleton.java :133)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397) at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java :186) at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323) at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
    at org.apache.axis.SimpleChain.doVisiting (SimpleChain.java:118)
    at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:454)
    at org.apache.axis.server.AxisServer.invoke( AxisServer.java:281)
at org.apache.axis.transport.http.SimpleAxisWorker.execute(SimpleAxisWorker.java:428) at org.apache.axis.transport.http.SimpleAxisWorker.run(SimpleAxisWorker.java:155) at org.apache.axis.transport.http.SimpleAxisServer.run (SimpleAxisServer.java:245) at org.apache.axis.transport.http.SimpleAxisServer.start(SimpleAxisServer.java:296) at org.apache.axis.transport.http.SimpleAxisServer.start(SimpleAxisServer.java:304) at org.apache.axis.transport.http.SimpleAxisServer.main (SimpleAxisServer.java:385)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke (Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
at org.enhydra.shark.wfxml.SharkServiceImpl.main(SharkServiceImpl.java:51) Caused by: com.lutris.dods.builder.generator.query.DataObjectException : Couldn't write transaction: java.sql.SQLException: Update failed, but Table SHKProcesses id=1002870 does exist with version=3 at org.enhydra.shark.instancepersistence.data.ProcessQuery._runQuery(ProcessQuery.java :681) at org.enhydra.shark.instancepersistence.data.ProcessQuery.runQuery(ProcessQuery.java:632) at org.enhydra.shark.instancepersistence.data.ProcessQuery.getNextDO(ProcessQuery.java:1406) at org.enhydra.shark.instancepersistence.DODSPersistentManager.getPersistedProcessObject (DODSPersistentManager.java:3764)
    ... 30 more
org.enhydra.shark.api.internal.instancepersistence.PersistenceException: Persisting of Process 1204_pkg_E_Local_E_Local failed at org.enhydra.shark.instancepersistence.DODSPersistentManager.persist (DODSPersistentManager.java:403)
    at org.enhydra.shark.WfProcessImpl.persist(WfProcessImpl.java:1613)
at org.enhydra.shark.WfExecutionObjectImpl.set_priority(WfExecutionObjectImpl.java:133) at org.enhydra.shark.WfProcessWrapper.set_priority (WfProcessWrapper.java:681) at org.enhydra.shark.asap.AsapInstanceBindingImpl.setProperties(AsapInstanceBindingImpl.java:116) at org.enhydra.shark.wfxml.WfXmlInstanceBindingSkeleton.setProperties(WfXmlInstanceBindingSkeleton.java :133)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397) at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java :186) at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323) at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
    at org.apache.axis.SimpleChain.doVisiting (SimpleChain.java:118)
    at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:454)
    at org.apache.axis.server.AxisServer.invoke( AxisServer.java:281)
at org.apache.axis.transport.http.SimpleAxisWorker.execute(SimpleAxisWorker.java:428) at org.apache.axis.transport.http.SimpleAxisWorker.run(SimpleAxisWorker.java:155) at org.apache.axis.transport.http.SimpleAxisServer.run (SimpleAxisServer.java:245) at org.apache.axis.transport.http.SimpleAxisServer.start(SimpleAxisServer.java:296) at org.apache.axis.transport.http.SimpleAxisServer.start(SimpleAxisServer.java:304) at org.apache.axis.transport.http.SimpleAxisServer.main (SimpleAxisServer.java:385)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke (Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
at org.enhydra.shark.wfxml.SharkServiceImpl.main(SharkServiceImpl.java:51) Caused by: org.enhydra.shark.api.internal.instancepersistence.PersistenceException : Couldn't write transaction: java.sql.SQLException: Update failed, but Table SHKProcesses id=1002870 does exist with version=3 at org.enhydra.shark.instancepersistence.DODSPersistentManager.getPersistedProcessObject (DODSPersistentManager.java:3767) at org.enhydra.shark.instancepersistence.DODSPersistentManager.getPersistedObject(DODSPersistentManager.java:3698) at org.enhydra.shark.instancepersistence.DODSPersistentManager.persist (DODSPersistentManager.java:353)
    ... 28 more
Caused by: com.lutris.dods.builder.generator.query.DataObjectException: Couldn't write transaction: java.sql.SQLException: Update failed, but Table SHKProcesses id=1002870 does exist with version=3 at org.enhydra.shark.instancepersistence.data.ProcessQuery._runQuery(ProcessQuery.java:681) at org.enhydra.shark.instancepersistence.data.ProcessQuery.runQuery(ProcessQuery.java:632) at org.enhydra.shark.instancepersistence.data.ProcessQuery.getNextDO (ProcessQuery.java:1406) at org.enhydra.shark.instancepersistence.DODSPersistentManager.getPersistedProcessObject(DODSPersistentManager.java:3764)
    ... 30 more
------------------------------------------------------------------------


--
You receive this message as a subscriber of the shark@xxxxxxxxxxxxx mailing 
list.
To unsubscribe: mailto:shark-unsubscribe@xxxxxxxxxxxxx
For general help: mailto:sympa@xxxxxxxxxxxxx?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws




<--  Date Index     <--  Thread Index    

Reply via email to:

Powered by MHonArc.

Copyright © 1999-2005, ObjectWeb Consortium | contact | webmaster.