Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-689

LP:619666 - Deadlock with Aria around translog_flush_wait_for_end()

    XMLWordPrintable

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

          Activity

            People

              Unassigned Unassigned
              philipstoev Philip Stoev (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.