Attachment could not gone after it was DELETE'd FROM MON$ATTACHMENTS
--------------------------------------------------------------------
Key: CORE-5819
URL: http://tracker.firebirdsql.org/browse/CORE-5819
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0.3, 4.0 Alpha 1, 3.0.2, 3.0.1, 3.0.0, 4.0 Initial
Environment: Attachment run some EXECUTE STATEMENT when it was
asynchronously dropped (using DELETE FROM MON$ATTACHMENTS).
Reporter: Vlad Khorsun
It was reproduced using OLTP-EMUL test with 10 active connections.
Separate isql session issue DELETE FROM MON$ATTACHMENTS statement and not all
attachments was finally detached, one was freeze at detach stage.
Stack traces
1. First thread run regular detach, hold blockingMutex and wait for zero at
att_purge_tid :
engine12.dll!purge_attachment(0x0000000010bc14a0, 0x00000000154ef958,
3) Line 6904 C++
engine12.dll!Jrd::JAttachment::freeEngineData(0x000007fee784ca32, 88)
Line 2935 C++
engine12.dll!Firebird::IAttachmentBaseImpl<Jrd::JAttachment,Firebird::CheckStatusWrapper,Firebird::IReferenceCountedImpl<Jrd::JAttachment,Firebird::CheckStatusWrapper,Firebird::Inherit<Firebird::IVersionedImpl<Jrd::JAttachment,Firebird::CheckStatusWrapper,Firebird::Inherit<Firebird::IAttachment>
> > > >::cloopdetachDispatcher(0x000000000863adc8, 0x00000000154ef958) Line
8898 C++
fbclient.dll!Why::YAttachment::detach(0x00000000154ef958) Line 5460
C++
fbclient.dll!Firebird::IAttachmentBaseImpl<Why::YAttachment,Firebird::CheckStatusWrapper,Firebird::IReferenceCountedImpl<Why::YAttachment,Firebird::CheckStatusWrapper,Firebird::Inherit<Firebird::IVersionedImpl<Why::YAttachment,Firebird::CheckStatusWrapper,Firebird::Inherit<Firebird::IAttachment>
> > > >::cloopdetachDispatcher(0x000000000e1c3640, 0x000000000de76cc0) Line
8898 C++
firebird.exe!rem_port::disconnect(0x000000000de76cc0,
0x000000000de76cc0) Line 2866 C++
firebird.exe!process_packet(0x000000000dd8f5c0, 0x000000000dd8f5c0,
0x0000000000000000, 0x0000000000000001) Line 4568 C++
firebird.exe!loopThread(0x000000000000007a) Line 5973 C++
firebird.exe!threadStart(0x0000000000000000) Line 93 C++
2. Second thread run asyncronous detach, set set att_purge_tid, cleanup
assotiated EDS::InternalConnection and wait for blockingMutex:
ntdll.dll!NtWaitForSingleObject() Unknown
ntdll.dll!RtlpWaitOnCriticalSection() Unknown
ntdll.dll!RtlEnterCriticalSection() Unknown
engine12.dll!`anonymous
namespace'::AttachmentHolder::AttachmentHolder(0x000007fee5503288,
0x000000000c96f100, 0, 0x000007fee5503288) Line 675 C++
engine12.dll!`anonymous
namespace'::EngineContextHolder::EngineContextHolder<Jrd::JStatement>(0x000000001564ecc0,
0x0000000000000000, 0x000000000002c78e, 0) Line 753 C++
engine12.dll!Jrd::JStatement::freeEngineData(0x000000000b498b08) Line
4943 C++
engine12.dll!EDS::InternalStatement::doClose(0x0000000000000000, 208)
Line 604 C++
engine12.dll!EDS::Statement::deallocate(0x000000000c96fcf0) Line 1026
C++
engine12.dll!EDS::Statement::deleteStatement(0x0000000015643f98,
0x0000000000000000) Line 845 C++
engine12.dll!EDS::Connection::clearStatements(0x0000000015648398) Line
492 C++
engine12.dll!EDS::Connection::detach(0x0000000015648398) Line 510
C++
engine12.dll!EDS::Connection::deleteConnection(0x0000000015648398,
0x0000000000000001) Line 310 C++
engine12.dll!EDS::Provider::releaseConnection(0x0000000000000000,
{...}, 240) Line 250 C++
engine12.dll!EDS::Connection::deleteTransaction(0x000000000c96fcf0,
0x0000000000000000) Line 401 C++
engine12.dll!EDS::Transaction::rollback(0x000007fefc6811ac, 88) Line
707 C++
engine12.dll!EDS::Transaction::jrdTransactionEnd(0x000000000c96fcf0,
0x0000000015642768, false, false, false) Line 788 C++
engine12.dll!TRA_rollback(0x000000000c96fcf0, 0x0000000021d43ff0,
false, 208) Line 1319 C++
engine12.dll!purge_transactions(0x000000001039b140, 0x000000000b498ae0,
false) Line 6850 C++
engine12.dll!purge_attachment(0x0000000011c23b40, 0x0000000011c23b40,
1) Line 7024 C++
engine12.dll!`anonymous
namespace'::shutdownAttachments(0x0000000011c23b40, 224) Line 7379 C++
engine12.dll!`anonymous
namespace'::attachmentShutdownThread(0x0000000011c23b40) Line 7408 C++
engine12.dll!threadStart(0x0000000000000000) Line 93 C++
--
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
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
