Subject | What to do with long-lasting deadlock? |
---|---|
Author | vincent_kwinsey |
Post date | 2006-08-22T14:31:42Z |
So - there are made some updates on records from other app - and now -
after hours/days there is deadlock when another application is trying
to updates this record. How to remove this deadlock? Does gfix -commit
all can help, or the only solution is the full B/R of database. There
is not problem about 2-phase commit because only one DB is involved.
I am asking how to resolve simptoms on already running production
system, not - how to make deadlock-free programs (this is completely
another issue).
Thanks for any suggestion in advance!
after hours/days there is deadlock when another application is trying
to updates this record. How to remove this deadlock? Does gfix -commit
all can help, or the only solution is the full B/R of database. There
is not problem about 2-phase commit because only one DB is involved.
I am asking how to resolve simptoms on already running production
system, not - how to make deadlock-free programs (this is completely
another issue).
Thanks for any suggestion in advance!