Subject RE: [firebird-support] What to do with long-lasting deadlock?
Author Alan McDonald
> 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!

you must commit your transactions. The records you have updated... have they
been committed? What laguage/connection component suite etc are you using?