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