Subject | RE: [firebird-support] Removing deadlocks via Backup/Restore. Any other way? |
---|---|
Author | Alan McDonald |
Post date | 2009-05-04T10:50:24Z |
> Hi!deadlocks are not a phenomenon which is corrected only via B/R cycle. You
>
> I realize that I should fix my applications so that deadlocks don't
> occur at all. Unfortunately, the occurence of deadlocks is so extremely
> rare that I really have no hope of finding the cause. So instead I am
> looking for a way to fix the effects. I know that a Backup/Restore
> cycle
> removes my deadlocks. But - is there an alternative way that would not
> require an exclusive access to the database?
>
> Thanks, Pepak
only have to commit the transaction.
If you read up a little on transaction isolation you may quickly twig to
what your issue is. You could change your isolation e.g. ...
deadlocks are your friend not your enemy - learn to detect them and use
them, don't avoid them
Alan