Subject Re: [firebird-support] SELECT WITH LOCK, WAIT transaction, deadlock
Author Thomas Steinmaurer
> 2016. 04. 28. 14:55 keltezéssel, Dimitry Sibiryakov sd@...
> [firebird-support] írta:
>> 28.04.2016 13:41, Gabor Boros gaborboros@... [firebird-support] wrote:
>>> The message is:
>>> deadlock
>>> update conflicts with concurrent update
>>> concurrent transaction number is ...
>> That's an expected behavior.
> Are you sure?
> 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."

You have mentioned that you are using Read Committed without record
version. What happens if you are running Read Committed WITH record version?

With regards,
Thomas Steinmaurer

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.