New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Deadlock with TIP page lock and monitoring lock [CORE4627] #4942
Comments
Commented by: @hvlad 1. Locks, involved into deadlock LOCK BLOCK 635472 LOCK BLOCK 557236 LOCK BLOCK 635472 - this is a monitoring lock Owner 18744 hold lock 635472 (monitoring lock) and acquires lock 557236 (page lock). Memory dump helps to see what lock owners doing: OWNER BLOCK 262568 06 fb_inet_server!enqueue+0x51 OWNER BLOCK 18744 02 fb_inet_server!Jrd::LockManager::LocalCheckout::~LocalCheckout+0x53 Owner 18744 is attached to the database. It is already initialized its monitoring lock, and run some system queries to complete attachment initialization. dbb_ast_flags 0x204 // DBB_monitor_off | DBB_assert_locks It is in a wrong state - DBB_monitor_off should be set only if monitoring lock is released ! |
Modified by: @hvladassignee: Vlad Khorsun [ hvlad ] |
Modified by: @hvladFix Version: 2.5.4 [ 10585 ] Component: Engine [ 10000 ] description: firebird.log contains messages like page NNN, page type 3 lock denied (216) environment: Classic Server or Super Classic |
Commented by: @hvlad Note, database contains ON CONNECT and ON TRANSACTION COMMIT triggers both accessed monitoring tables. |
Commented by: @hvlad Changed ticket owner by user who supplied lock table and memory dumps. |
Modified by: @hvladreporter: Vlad Khorsun [ hvlad ] => Yurij [ yurij ] |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Resolved [ 5 ] QA Status: Deferred Test Details: Have no idea how to encounter new lines in firebird.log. |
Modified by: @pcisarstatus: Resolved [ 5 ] => Closed [ 6 ] |
Submitted by: Yurij (yurij)
firebird.log contains messages like
page NNN, page type 3 lock denied (216)
Commits: 13a364c FirebirdSQL/fbt-repository@8ad859f
====== Test Details ======
Have no idea how to encounter new lines in firebird.log.
Perhaps, by launch of 'fbsvcmgr action_get_fb_log' and finding results with timestamp >= test beginning ?..
The text was updated successfully, but these errors were encountered: