| Subject | Re: [firebird-support] Is it possible to avoid update deadlocks in Firebird ? |
|---|---|
| Author | Ann W. Harrison |
| Post date | 2004-05-31T19:56:25Z |
At 03:16 PM 5/31/2004, David Johnson wrote:
resource when two users hold compatible locks and both request incompatible
locks (e.g. two readers of table A both want to convert to exclusive write
access). However, that situation can also be avoided by coding conventions.
Regards,
Ann
>In any DBMS, a deadlock occurs when you have two (or more) resources and youIn systems with more than one lock level, deadlocks can occur on a single
>request locks on them in different sequences.
resource when two users hold compatible locks and both request incompatible
locks (e.g. two readers of table A both want to convert to exclusive write
access). However, that situation can also be avoided by coding conventions.
Regards,
Ann