Hi,
Plz. help with a soultion for the below said problem.A deadlock found in a multi-transaction scenario (minimum 10 processes(JVM) executed concurrently)when same operation each using different transaction is executed on the different processes (JVM) at same time,resulted in a deadlock. The operation uses the same relation(table) to record history for each process.fatal error occurred during an insert, Find below traces:Sep 2, 2004 6:43:50 PM org.exolab.castor.jdo.engine.SQLEngine create
SEVERE: A fatal error occurred while creating com.stortek.indigo.scheduler.domainObjects.ActivityHis
tory using SQL: INSERT INTO ACTIVITY_HISTORY (ACTIVITY_ID,ACTIVITY_HISTORY_OLD_STATE_ID,ACTIVITY_HISTORY_NEW_STATE_ID,ACTIVITY_HISTORY_DATETIME,ACTIVITY_HISTORY_COMMENT,ACTIVITY_HISTORY_ACTOR) VALUES (?,?,?,?,?,?)Sep 2, 2004 6:43:50 PM com.stortek.indigo.scheduler.domainObjects.Activity retrieve
INFO: number of activities histories retrieved --->[106, 106]
Sep 2, 2004 6:43:50 PM com.stortek.indigo.scheduler.domainObjects.Activity retrieve
INFO: filtered activities::[106]
Sep 2, 2004 6:43:50 PM com.stortek.indigo.scheduler.domainObjects.Activity retrieve
INFO: Activity ID : 106 :: State : Suspended
Sep 2, 2004 6:43:50 PM com.stortek.indigo.scheduler.SchedulerController completeActivity
WARNING: EXCEPTION: com.stortek.indigo.exceptions.infrastructure.persistence.DbPersistenceException:
com.stortek.indigo.exceptions.infrastructure.persistence...DbPersistenceException(org.exolab.castor.jdo.PersistenceException: Nested error: java.sql.SQLException: Deadlock found when trying to get lock; Try restarting transaction, message from server: "Deadlock found when trying to get lock; Try restarting transaction")
at com.stortek.indigo.infrastructure.persistence.CastorDAO.daoErrorHandler(CastorDAO.java:230)
at com.stortek.indigo.infrastructure.persistence.CastorDAO.create(CastorDAO.java:101)
at com.stortek.indigo.scheduler.domainObjects.ActivityHistory.create(ActivityHistory.java:205)
at com.stortek.indigo.scheduler.domainObjects.Activity.setState(Activity.java:725)
at com.stortek.indigo.scheduler.SchedulerController.completeActivity(SchedulerController.java:946)
at com.stortek.indigo.objectStoreMetadata.domainObjects.OSActivity.complete(OSActivity.java:1476)
at com.stortek.indigo.objectStoreMetadata.OSDBIFController.completePrimaryIO(OSDBIFController.java:2085)
at com.stortek.indigo.objectStoreMetadata.kernalDBIF.OSDBIFCompletePrimaryIO..execute(OSDBIFCompletePrimaryIO.java:82)
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:324)
at com.stortek.indigo.infrastructure.rmi.IndigoHandler.run(IndigoHandler.java:130)
Sep 2, 2004 6:43:50 PM com.stortek.indigo.scheduler.domainObjects.Activity sortActivityListINFO: value of all the history records::Rgds,Banujee KrishnaMurthy
Confidentiality Notice
The information contained in this electronic message and any attachments to this message are intended
for the exclusive use of the addressee(s) and may contain confidential or privileged information. If
you are not the intended recipient, please notify the sender at Wipro or [EMAIL PROTECTED] immediately
and destroy all copies of this message and any attachments.
Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. If you are not the intended recipient, please notify the sender at Wipro or [EMAIL PROTECTED] immediately and destroy all copies of this message and any attachments. |
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-user
