[firebird-support] Re: Deadlock exception occurs but it shouldn't?

2014-12-26 Thread brucedickin...@wp.pl [firebird-support]
No need to apologize Walter. Thanks for trying to help me out! :) Regards.

Re: [firebird-support] Deadlock exception occurs but it shouldn't?

2014-12-26 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Dec 24, 2014, at 3:22 AM, brucedickin...@wp.pl [firebird-support] firebird-support@yahoogroups.com wrote: I have two threads which constantly and at the same time are writing to this table: UPDATE OR INSERT INTO PARAMS (NAME) VALUES(:P_NAME) MATCHING (NAME) RETURNING ID;

Re: [firebird-support] Deadlock exception occurs but it shouldn't?

2014-12-26 Thread 'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
Hello Ann Maybe I am not understanding correctly, but: *Case 1:* - Transaction T1 starts with settings: READ WRITE WAIT READ COMMITTED - Transaction T1 updates a record which ID is 23 - Transaction T2 starts with settings: READ WRITE WAIT READ COMMITTED - Transaction T2 updates the