deadlock

Jimmy Stiefel <[email protected]> Mon, 17 Jan 2005 15:32:57 -0800
Newsgroups gmane.comp.java.ozone.user
Message-ID <1106004777.10274.58.camel@crystal>
My database server is hitting a deadlock condition it can't seem to
resolve.  It's just keeps hopelessly looping (see log below).  This
server is running on dual-processor system.  When I copy the database &
run it on another machine (single processor), I'm not able to duplicate
the problem.
  
Anyone have any idea what's going on here and how to correct it?

Jan-17 14:45 WARN   [Thread-13] TransactionManager -
ta[id=77137465,blocker=null] sleeping 927 milliseconds...
Jan-17 14:45 WARN   [Thread-13] TransactionManager -
ta[id=77137465,blocker=null] re-run...
Jan-17 14:45 DEBUG  [Thread-2] EdgeChasing - *** sendLockMessage():
ta[id=77137465,blocker=250045],
visitingLockers=[ta[id=77137465,blocker=250045]].
Jan-17 14:45 DEBUG  [Thread-2] EdgeChasing - *** sendLockMessage():
ta[id=77137463,blocker=166700],
visitingLockers=[ta[id=77137463,blocker=166700],
ta[id=77137465,blocker=250045]].
Jan-17 14:45 WARN   [Thread-2] TransactionManager - *** *** DEADLOCK
DETECTED: ta=ta[id=77137465,blocker=250045]
Jan-17 14:45 WARN   [Thread-13] TransactionManager -
ta[id=77137465,blocker=250045] aborting... (DEADLOCK)
Jan-17 14:45 WARN   [Thread-13] TransactionManager -
ta[id=77137465,blocker=null] sleeping 1111 milliseconds...
Jan-17 14:45 WARN   [Thread-13] TransactionManager -
ta[id=77137465,blocker=null] re-run...
Jan-17 14:45 DEBUG  [Thread-2] EdgeChasing - *** sendLockMessage():
ta[id=77137465,blocker=35644],
visitingLockers=[ta[id=77137465,blocker=35644]].
Jan-17 14:45 DEBUG  [Thread-2] EdgeChasing - *** sendLockMessage():
ta[id=77137463,blocker=19774210],
visitingLockers=[ta[id=77137463,blocker=19774210],
ta[id=77137465,blocker=35644]].
Jan-17 14:45 DEBUG  [Thread-2] EdgeChasing - *** sendLockMessage():
ta[id=77137546,blocker=19774210],
visitingLockers=[ta[id=77137546,blocker=19774210],
ta[id=77137463,blocker=19774210], ta[id=77137465,blocker=35644]].
Jan-17 14:45 WARN   [Thread-2] TransactionManager - *** *** DEADLOCK
DETECTED: ta=ta[id=77137465,blocker=35644]
Jan-17 14:45 WARN   [Thread-12] TransactionManager -
ta[id=77137463,blocker=19774210] aborting... (DEADLOCK)
Jan-17 14:45 DEBUG  [Thread-12] ClusterStore - abortCluster(): Unloading
pinned cluster 210151. Should we really do that?
Jan-17 14:45 DEBUG  [Thread-12] ClusterStore - abortCluster(): Unloading
pinned cluster 360480. Should we really do that?
Jan-17 14:45 DEBUG  [Thread-12] ClusterStore - abortCluster(): Unloading
pinned cluster 10573460. Should we really do that?
Jan-17 14:45 DEBUG  [Thread-12] ClusterStore - abortCluster(): Unloading
pinned cluster 30113. Should we really do that?
Jan-17 14:45 DEBUG  [Thread-12] ClusterStore - abortCluster(): Unloading
pinned cluster 4519219. Should we really do that?
Jan-17 14:45 DEBUG  [Thread-12] ClusterStore - abortCluster(): Unloading
pinned cluster 5648136. Should we really do that?
Jan-17 14:45 DEBUG  [Thread-12] ClusterStore - abortCluster(): Unloading
pinned cluster 3619203. Should we really do that?
Jan-17 14:45 DEBUG  [Thread-12] ClusterStore - abortCluster(): Unloading
pinned cluster 40798379. Should we really do that?
Jan-17 14:45 DEBUG  [Thread-12] ClusterStore - abortCluster(): Unloading
pinned cluster 46987519. Should we really do that?
Jan-17 14:45 DEBUG  [Thread-2] EdgeChasing - *** sendLockMessage():
ta[id=77137465,blocker=35644],
visitingLockers=[ta[id=77137465,blocker=35644]].
Jan-17 14:45 WARN   [Thread-12] TransactionManager -
ta[id=77137463,blocker=null] sleeping 1505 milliseconds...
Jan-17 14:45 DEBUG  [Thread-2] EdgeChasing - *** sendLockMessage():
ta[id=77137463,blocker=null],
visitingLockers=[ta[id=77137463,blocker=null]].
Jan-17 14:45 DEBUG  [Thread-2] EdgeChasing - *** sendLockMessage():
ta[id=77137546,blocker=null],
visitingLockers=[ta[id=77137546,blocker=null]].
Jan-17 14:45 WARN   [Thread-12] TransactionManager -
ta[id=77137463,blocker=null] re-run...
Jan-17 14:45 DEBUG  [Thread-2] EdgeChasing - *** sendLockMessage():
ta[id=77137465,blocker=166700],
visitingLockers=[ta[id=77137465,blocker=166700]].
Jan-17 14:45 DEBUG  [Thread-2] EdgeChasing - *** sendLockMessage():
ta[id=77137463,blocker=250045],
visitingLockers=[ta[id=77137463,blocker=250045],
ta[id=77137465,blocker=166700]].
Jan-17 14:45 WARN   [Thread-2] TransactionManager - *** *** DEADLOCK
DETECTED: ta=ta[id=77137465,blocker=166700]
Jan-17 14:45 WARN   [Thread-13] TransactionManager -
ta[id=77137465,blocker=166700] aborting... (DEADLOCK)
Jan-17 14:45 DEBUG  [Thread-13] ClusterStore - abortCluster(): Unloading
pinned cluster 210151. Should we really do that?
Jan-17 14:45 DEBUG  [Thread-13] ClusterStore - abortCluster(): Unloading
pinned cluster 10573460. Should we really do that?
Jan-17 14:45 DEBUG  [Thread-13] ClusterStore - abortCluster(): Unloading
pinned cluster 4519219. Should we really do that?
Jan-17 14:45 DEBUG  [Thread-13] ClusterStore - abortCluster(): Unloading
pinned cluster 5648136. Should we really do that?
Jan-17 14:45 DEBUG  [Thread-13] ClusterStore - abortCluster(): Unloading
pinned cluster 3619203. Should we really do that?
Jan-17 14:45 DEBUG  [Thread-13] ClusterStore - abortCluster(): Unloading
pinned cluster 40798379. Should we really do that?
Jan-17 14:45 DEBUG  [Thread-13] ClusterStore - abortCluster(): Unloading
pinned cluster 46987519. Should we really do that?
Jan-17 14:45 WARN   [Thread-13] TransactionManager -
ta[id=77137465,blocker=null] sleeping 3323 milliseconds...
Jan-17 14:45 WARN   [Thread-13] TransactionManager -
ta[id=77137465,blocker=null] re-run...
Jan-17 14:45 DEBUG  [Thread-2] EdgeChasing - *** sendLockMessage():
ta[id=77137465,blocker=250045],
visitingLockers=[ta[id=77137465,blocker=250045]].
Jan-17 14:45 DEBUG  [Thread-2] EdgeChasing - *** sendLockMessage():
ta[id=77137463,blocker=166700],
visitingLockers=[ta[id=77137463,blocker=166700],
ta[id=77137465,blocker=250045]].
Jan-17 14:45 WARN   [Thread-2] TransactionManager - *** *** DEADLOCK
DETECTED: ta=ta[id=77137465,blocker=250045]
Jan-17 14:45 WARN   [Thread-13] TransactionManager -
ta[id=77137465,blocker=250045] aborting... (DEADLOCK)
Jan-17 14:45 WARN   [Thread-13] TransactionManager -
ta[id=77137465,blocker=null] sleeping 2161 milliseconds...
Jan-17 14:45 WARN   [Thread-13] TransactionManager -
ta[id=77137465,blocker=null] re-run...



thanks,
 Jimmy
(unnamed) (message/delivery-status, 298 B) - not displayed