Subject | Re: [firebird-support] SELECT WITH LOCK, WAIT transaction, deadlock |
---|---|
Author | Gabor Boros |
Post date | 2016-04-28T13:19:18Z |
2016. 04. 28. 14:55 keltezéssel, Dimitry Sibiryakov sd@...
[firebird-support] írta:
In the language reference for "isc_tpb_read_committed + isc_tpb_wait" I
see this: "Update conflict exceptions can never be raised by an explicit
lock statement in this TPB mode."
http://www.firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-dml-select.html#fblangref25-dml-with-lock
Gabor
[firebird-support] írta:
> 28.04.2016 13:41, Gabor Boros gaborboros@... [firebird-support] wrote:Are you sure?
>> The message is:
>> deadlock
>> update conflicts with concurrent update
>> concurrent transaction number is ...
>
> That's an expected behavior.
In the language reference for "isc_tpb_read_committed + isc_tpb_wait" I
see this: "Update conflict exceptions can never be raised by an explicit
lock statement in this TPB mode."
http://www.firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-dml-select.html#fblangref25-dml-with-lock
Gabor