Missing error code isc_lock_timeout in WAIT LOCK TIMEOUT transaction
--------------------------------------------------------------------
Key: CORE-6102
URL: http://tracker.firebirdsql.org/browse/CORE-6102
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0.4, 3.0.3
Reporter: prenosil
Priority: Minor
In Firebird 2.x, when I do UPDATE in
"SET TRANSACTION READ COMMITTED RECORD_VERSION WAIT LOCK TIMEOUT 10"
transaction and the record is locked, I can get two different errors depending
on situation:
1) if the time run out:
Statement failed, SQLSTATE = 40001
[335544510] lock time-out on wait transaction
[335544336] -deadlock
[335544451] -update conflicts with concurrent update
[335544878] -concurrent transaction number is 5876
2) if the concurrent transaction committed:
Statement failed, SQLSTATE = 40001
[335544336] deadlock
[335544451] -update conflicts with concurrent update
[335544878] -concurrent transaction number is 5876
which helps in deciding whether to repeat the command or not.
However in Firebird 3 (v3.0.4 or latest snapshot) I always get:
Statement failed, SQLSTATE = 40001
[335544336] deadlock
[335544451] -update conflicts with concurrent update
[335544878] -concurrent transaction number is 10338
i.e. isc_lock_timeout = "lock time-out on wait transaction" is never returned.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
