Bugcheck 291 (cannot find record back version) if GTT is modified concurrently
using at least one read-committed read-only transaction
--------------------------------------------------------------------------------------------------------------------------------------
Key: CORE-3924
URL: http://tracker.firebirdsql.org/browse/CORE-3924
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 2.5.1, 3.0 Initial, 2.5.2
Reporter: Dmitry Yemanov
It cannot be reproduced in ISQL as it requires two transactions per connection.
Obviously, only connection-level GTTs (ON COMMIT PRESERVE ROWS) are affected.
create table t (col int) on commit preserve rows;
insert into t (col) values (0);
commit;
-- txn1 (read committed, read only):
update t set col = 1;
-- no commit here
- txn2 (snapshot):
delete from t;
-- BUGCHECK 291: cannot find record back version
An update conflict error is expected instead.
--
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
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
