Subject | RE: [firebird-support] What to do with long-lasting deadlock? |
---|---|
Author | Alan McDonald |
Post date | 2006-08-22T21:44:38Z |
> So - there are made some updates on records from other app - and now -you must commit your transactions. The records you have updated... have they
> 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!
been committed? What laguage/connection component suite etc are you using?
Alan