Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
None
-
None
-
None
Description
When executing a DML workload, Aria 5.2 deadlocked with one thread with the following backtrace:
#2 0x08747ec2 in safe_cond_wait (cond=0x9278954, mp=0x92788f4, file=0x88d5d60 "ma_loghandler.c", line=7689) at thr_mutex.c:496
#3 0x0851b058 in translog_flush_wait_for_end (lsn=4303371829) at ma_loghandler.c:7688
#4 0x0851bb43 in translog_flush (lsn=4303371829) at ma_loghandler.c:7967
#5 0x0856d7b2 in flush_log_for_bitmap (page=0xb6079008 "\002", page_no=0, data_ptr=0xb39e708 "\376\376\t\003\f") at ma_bitmap.c:2558
#6 0x0851dd94 in pagecache_fwrite (pagecache=0x9281fa0, filedesc=0xb5f03684, buffer=0xb6079008 "\002", pageno=0, type=PAGECACHE_PLAIN_PAGE, flags=36)
at ma_pagecache.c:618
#7 0x0852695f in flush_cached_blocks (pagecache=0x9281fa0, file=0xb39ece8, cache=0xab790b70, end=0xab790b78, type=FLUSH_RELEASE, first_errno=0xab790b5c)
at ma_pagecache.c:4240
#8 0x085271b9 in flush_pagecache_blocks_int (pagecache=0x9281fa0, file=0xb39ece8, type=FLUSH_RELEASE, filter=0, filter_arg=0x0) at ma_pagecache.c:4530
--Type <return> to continue, or q <return> to quit--
#9 0x08527560 in flush_pagecache_blocks_with_filter (pagecache=0x9281fa0, file=0xb39ece8, type=FLUSH_RELEASE, filter=0, filter_arg=0x0)
at ma_pagecache.c:4652
#10 0x085583db in _ma_once_end_block_record (share=0xb39e708) at ma_blockrec.c:432
#11 0x0857b96f in maria_close (info=0xab55978) at ma_close.c:79
#12 0x0852acc8 in ha_maria::close (this=0xab731e0) at ha_maria.cc:1051
#13 0x082df4e8 in closefrm (table=0xb2aab48, free_share=true) at table.cc:2451
#14 0x082c6d9a in intern_close_table (table=0xb2aab48) at sql_base.cc:786
#15 0x082c6e3b in free_cache_entry (table=0xb2aab48) at sql_base.cc:808
#16 0x0872a39c in my_hash_delete (hash=0x8a6e7a0, record=0xb2aab48 "\310ܺ\n\340\061\267\n\220\221\325\n8k\203\n") at hash.c:562
#17 0x082c7aa8 in close_open_tables (thd=0xb140730) at sql_base.cc:1208
#18 0x082c7e04 in close_thread_tables (thd=0xb140730) at sql_base.cc:1361
#19 0x0827faff in dispatch_command (command=COM_QUERY, thd=0xb140730, packet=0xb142739 "", packet_length=100) at sql_parse.cc:1636
#20 0x0827dee7 in do_command (thd=0xb140730) at sql_parse.cc:898
#21 0x0827aea8 in handle_one_connection (arg=0xb140730) at sql_connect.cc:1154
#22 0x00a08919 in start_thread () from /lib/libpthread.so.0
#23 0x001ede5e in clone () from /lib/libc.so.6
and several threads with:
#2 0x08747ec2 in safe_cond_wait (cond=0x9278954, mp=0x92788f4, file=0x88d5d60 "ma_loghandler.c", line=7689) at thr_mutex.c:496
#3 0x0851b058 in translog_flush_wait_for_end (lsn=4303370971) at ma_loghandler.c:7688
#4 0x0851bb43 in translog_flush (lsn=4303370971) at ma_loghandler.c:7967
#5 0x085b5247 in ma_commit (trn=0xae140c0) at ma_commit.c:61
#6 0x0852f62f in ha_maria::implicit_commit (thd=0xb13e330, new_trn=false) at ha_maria.cc:2647
#7 0x0827fab4 in dispatch_command (command=COM_QUERY, thd=0xb13e330,
packet=0xb0e0789 "REPLACE INTO smf_log_boards (`id_msg`,`id_member`,`id_board`) VALUES (209,4,147)", packet_length=80) at sql_parse.cc:1625
#8 0x0827dee7 in do_command (thd=0xb13e330) at sql_parse.cc:898
#9 0x0827aea8 in handle_one_connection (arg=0xb13e330) at sql_connect.cc:1154
#10 0x00a08919 in start_thread () from /lib/libpthread.so.0
#11 0x001ede5e in clone () from /lib/libc.so.6
Attachments
Issue Links
- is duplicated by
-
MDEV-13635 MariaDB Server 10.2.6 hangs up during shutdown
- Open
- relates to
-
MDEV-13736 MariaDB Server 5.5.54 hangs up during shutdown
- Stalled