> 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."
>
> http://www.firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-dml-select.html#fblangref25-dml-with-lock

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
http://www.upscene.com/

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