Don't close attach while deleting record from MON$ATTACHMENTS using ORDER BY
clause
-----------------------------------------------------------------------------------
Key: CORE-6266
URL: http://tracker.firebirdsql.org/browse/CORE-6266
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0.5, 2.5.9, 4.0 Beta 1
Reporter: Andrey Kravchenko
Priority: Minor
Start the server.
In 1st terminal - create new database and type:
SQL> commit; select mon$attachment_id, mon$user, mon$timestamp from
mon$attachments order by mon$timestamp;
Output will be 3 attachments in order: SYSDBA, Cache Writer, Garbage Collector
After connect from 2nd terminal and type in 1st terminal:
SQL> commit; select mon$attachment_id, mon$user, mon$timestamp from
mon$attachments order by mon$timestamp;
Output will be 4 attachments in order:
3 SYSDBA
1 Cache Writer
2 Garbage Collector
4 SYSDBA
After type:
SQL> commit; delete from mon$attachments order by mon$timestamp;
Output no errors, but if typing:
SQL> commit; select mon$attachment_id, mon$user, mon$timestamp from
mon$attachments order by mon$timestamp;
Output will be same 4 attachments, but one attachment should be closed (in the
2nd terminal).
If set breakpoint in function VirtualTable::erase (src/jrd/VirtualTable.cpp) id
from all 4 times is same (the first one in the select and equal of current
attachment in 1st terminal)
--
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
