That's interesting. I firebird really killing the transaction or will it
wait infinite until the client will kill the connection?

Is it possible to wait only a few seconds and catch an error then?
Is it possible to log which table is deadlocked?

Thanks for the help
Henner Kollmann

>
> Imagine the situation bellow in the exact order it is:
>
> User1:
> starts transaction
> update table1 set field2 = 'value' where id = 1;
> (locked)
>
> User2:
> starts transaction
> update table1 set field2 = 'value' where id = 500;
> (locked)
>
> User2:
> update table1 set field2 = 'other value' where id = 1; (wait
> the lock of User1)
>
> User1:
> Update table1 set field2 = 'other value' where id = 500;
> -->DEADLOCK
>
> The last update would wait for the lock of User2 because it's
> trying to update a record wich is being updated (id=500), but
> the User2 is already waiting for the record locked to User1
> (id=1), in this case the database chooses one of the
> transactions and kills it (I think the newest is killed, but
> not sure).
>
> The same situation can happen between 3 or more users in a
> circular deadlock.
>
> In the example the deadlock is in one table, it can happen
> (and occurs more frequently) between 2 tables.
>
> Mauro.
>
>
>
>
> _______________________________________________________
> Yahoo! Messenger com voz: PROMOÇÃO VOCÊ PODE LEVAR UMA VIAGEM
> NA CONVERSA. Participe! www.yahoo.com.br/messenger/promocao
>
>
> ------------------------ Yahoo! Groups Sponsor
> --------------------~-->
> Fair play? Video games influencing politics. Click and talk back!
> http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/67folB/TM
> --------------------------------------------------------------
> ------~->
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>