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

Galera node with role master crashes in lock_rec_has_to_wait_in_queue()

    XMLWordPrintable

Details

    Description

      We got another master crash today. Stacktrace follows. We have corefile for it.

      #0  0x00007fe21ae699d1 in __pthread_kill (threadid=<optimized out>, signo=11) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:59
      #1  0x00005613b1ef8ffe in handle_fatal_signal (sig=11) at /usr/src/debug/MariaDB-10.4.13/src_0/sql/signal_handler.cc:343
      #2  <signal handler called>
      #3  lock_rec_get_n_bits (lock=0x0) at /usr/src/debug/MariaDB-10.4.13/src_0/storage/innobase/include/lock0priv.ic:79
      #4  lock_rec_has_to_wait_in_queue (wait_lock=wait_lock@entry=0x7fdf1f86e210) at /usr/src/debug/MariaDB-10.4.13/src_0/storage/innobase/lock/lock0lock.cc:2050
      #5  0x00005613b20e7128 in lock_rec_dequeue_from_page (in_lock=<optimized out>) at /usr/src/debug/MariaDB-10.4.13/src_0/storage/innobase/lock/lock0lock.cc:2256
      #6  0x00005613b20e7315 in lock_release (trx=trx@entry=0x7fc558728718) at /usr/src/debug/MariaDB-10.4.13/src_0/storage/innobase/lock/lock0lock.cc:4288
      #7  0x00005613b21dcf96 in release_locks (this=0x7fc558728718) at /usr/src/debug/MariaDB-10.4.13/src_0/storage/innobase/trx/trx0trx.cc:501
      #8  commit_in_memory (mtr=0x7fc3fa5a9f20, this=0x7fc558728718) at /usr/src/debug/MariaDB-10.4.13/src_0/storage/innobase/trx/trx0trx.cc:1387
      #9  trx_t::commit_low (this=this@entry=0x7fc558728718, mtr=0x7fc3fa5a9f20) at /usr/src/debug/MariaDB-10.4.13/src_0/storage/innobase/trx/trx0trx.cc:1577
      #10 0x00005613b21dd342 in trx_t::commit (this=this@entry=0x7fc558728718) at /usr/src/debug/MariaDB-10.4.13/src_0/storage/innobase/trx/trx0trx.cc:1591
      #11 0x00005613b21dd659 in trx_commit_for_mysql (trx=0x7fc558728718) at /usr/src/debug/MariaDB-10.4.13/src_0/storage/innobase/trx/trx0trx.cc:1723
      #12 0x00005613b2099c88 in innobase_commit_ordered_2 (trx=0x7fc558728718, thd=<optimized out>) at /usr/src/debug/MariaDB-10.4.13/src_0/storage/innobase/handler/ha_innodb.cc:4375
      #13 0x00005613b2099fa6 in innobase_commit_ordered (hton=<optimized out>, thd=0x7fc89c5d9d38, all=<optimized out>)
          at /usr/src/debug/MariaDB-10.4.13/src_0/storage/innobase/handler/ha_innodb.cc:4564
      #14 0x00005613b1fe191d in TC_LOG::run_commit_ordered (this=this@entry=0x5613b2ee9cb0 <mysql_bin_log>, thd=0x7fc89c5d9d38, all=true)
          at /usr/src/debug/MariaDB-10.4.13/src_0/sql/log.cc:8945
      #15 0x00005613b1fe651a in MYSQL_BIN_LOG::trx_group_commit_leader (this=this@entry=0x5613b2ee9cb0 <mysql_bin_log>, leader=leader@entry=0x7fc3fa5aa650)
          at /usr/src/debug/MariaDB-10.4.13/src_0/sql/log.cc:8179
      #16 0x00005613b1fe6924 in MYSQL_BIN_LOG::write_transaction_to_binlog_events (this=this@entry=0x5613b2ee9cb0 <mysql_bin_log>, entry=entry@entry=0x7fc3fa5aa650)
          at /usr/src/debug/MariaDB-10.4.13/src_0/sql/log.cc:7768
      #17 0x00005613b1fe6d60 in MYSQL_BIN_LOG::write_transaction_to_binlog (this=this@entry=0x5613b2ee9cb0 <mysql_bin_log>, thd=thd@entry=0x7fc89c5d9d38, 
          cache_mngr=cache_mngr@entry=0x7fc89c5637e8, end_ev=end_ev@entry=0x7fc3fa5aa7b0, all=<optimized out>, using_stmt_cache=using_stmt_cache@entry=true, 
          using_trx_cache=using_trx_cache@entry=true) at /usr/src/debug/MariaDB-10.4.13/src_0/sql/log.cc:7416
      #18 0x00005613b1fe6f0d in binlog_flush_cache (thd=thd@entry=0x7fc89c5d9d38, cache_mngr=cache_mngr@entry=0x7fc89c5637e8, end_ev=end_ev@entry=0x7fc3fa5aa7b0, all=all@entry=true, 
          using_stmt=using_stmt@entry=true, using_trx=using_trx@entry=true) at /usr/src/debug/MariaDB-10.4.13/src_0/sql/log.cc:1788
      #19 0x00005613b1fe7a94 in binlog_commit_flush_xid_caches (thd=thd@entry=0x7fc89c5d9d38, cache_mngr=cache_mngr@entry=0x7fc89c5637e8, all=all@entry=true, xid=xid@entry=2315302525)
          at /usr/src/debug/MariaDB-10.4.13/src_0/sql/log.cc:1894
      #20 0x00005613b1fe7c54 in MYSQL_BIN_LOG::log_and_order (this=<optimized out>, thd=0x7fc89c5d9d38, xid=2315302525, all=<optimized out>, need_prepare_ordered=<optimized out>, 
          need_commit_ordered=<optimized out>) at /usr/src/debug/MariaDB-10.4.13/src_0/sql/log.cc:9728
      #21 0x00005613b1f0725b in ha_commit_trans (thd=thd@entry=0x7fc89c5d9d38, all=all@entry=true) at /usr/src/debug/MariaDB-10.4.13/src_0/sql/handler.cc:1625
      #22 0x00005613b1de9fc7 in trans_commit (thd=thd@entry=0x7fc89c5d9d38) at /usr/src/debug/MariaDB-10.4.13/src_0/sql/transaction.cc:236
      #23 0x00005613b1cf40c8 in mysql_execute_command (thd=thd@entry=0x7fc89c5d9d38) at /usr/src/debug/MariaDB-10.4.13/src_0/sql/sql_parse.cc:5620
      #24 0x00005613b1cfa8ab in mysql_parse (thd=thd@entry=0x7fc89c5d9d38, rawbuf=rawbuf@entry=0x7fc89c716010 "COMMIT", length=length@entry=6, 
          parser_state=parser_state@entry=0x7fc3fa5ad350, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false)
          at /usr/src/debug/MariaDB-10.4.13/src_0/sql/sql_parse.cc:7900
      #25 0x00005613b1be9090 in wsrep_mysql_parse (thd=thd@entry=0x7fc89c5d9d38, rawbuf=0x7fc89c716010 "COMMIT", length=6, parser_state=parser_state@entry=0x7fc3fa5ad350, 
          is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /usr/src/debug/MariaDB-10.4.13/src_0/sql/sql_parse.cc:7704
      #26 0x00005613b1cfd9d8 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7fc89c5d9d38, packet=packet@entry=0x7fc89d049619 "COMMIT", 
          packet_length=packet_length@entry=6, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false)
          at /usr/src/debug/MariaDB-10.4.13/src_0/sql/sql_parse.cc:1827
      #27 0x00005613b1cfe049 in do_command (thd=0x7fc89c5d9d38) at /usr/src/debug/MariaDB-10.4.13/src_0/sql/sql_parse.cc:1360
      #28 0x00005613b1ddbbfa in do_handle_one_connection (connect=connect@entry=0x56141db6ab88) at /usr/src/debug/MariaDB-10.4.13/src_0/sql/sql_connect.cc:1412
      #29 0x00005613b1ddbcdd in handle_one_connection (arg=arg@entry=0x56141db6ab88) at /usr/src/debug/MariaDB-10.4.13/src_0/sql/sql_connect.cc:1316
      #30 0x00005613b241478d in pfs_spawn_thread (arg=0x56141e30e5b8) at /usr/src/debug/MariaDB-10.4.13/src_0/storage/perfschema/pfs.cc:1869
      #31 0x00007fe21ae64dd5 in start_thread (arg=0x7fc3fa5ae700) at pthread_create.c:307
      #32 0x00007fe219206ead in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
      

      Attachments

        Issue Links

          Activity

            People

              jplindst Jan Lindström (Inactive)
              rpizzi Rick Pizzi (Inactive)
              Votes:
              1 Vote for this issue
              Watchers:
              4 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.