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

SIGSEGV in thd_storage_lock_wait

    XMLWordPrintable

Details

    • Can result in hang or crash

    Description

      SigSegv found on debug build while testing MDEV-28730

      origin/main-MDEV-28730 1ee1317ddd1103587eb9625729b0fb425da1bb50

      Thread 3 received signal SIGSEGV, Segmentation fault.
      [Switching to Thread 2739561.2742763]
      thd_storage_lock_wait (thd=0x0, value=0) at /data/Server/MDEV-28730/sql/sql_class.cc:450
      450       thd->utime_after_lock+= value;
      (rr) bt
      #0  thd_storage_lock_wait (thd=0x0, value=0) at /data/Server/MDEV-28730/sql/sql_class.cc:450
      #1  0x00006503c6d92153 in lock_sys_t::wait_resume (this=this@entry=0x6503c8543d00 <lock_sys>, thd=0x0, start=start@entry=..., now=...) at /data/Server/MDEV-28730/storage/innobase/lock/lock0lock.cc:2119
      #2  0x00006503c6d904a0 in lock_wait (thr=<optimized out>) at /data/Server/MDEV-28730/storage/innobase/lock/lock0lock.cc:2421
      #3  0x00006503c6fdf0c0 in QueryExecutor::handle_wait (this=this@entry=0x3f3470074e30, err=err@entry=DB_LOCK_WAIT, table_lock=table_lock@entry=false) at /data/Server/MDEV-28730/storage/innobase/row/row0query.cc:74
      #4  0x00006503c6fdf3ce in QueryExecutor::delete_record (this=0x3f3470074e30, table=table@entry=0x3c3e7430b148, tuple=tuple@entry=0x7ce47783ed50) at /data/Server/MDEV-28730/storage/innobase/row/row0query.cc:130
      #5  0x00006503c6fb1879 in FTSQueryExecutor::delete_aux_record (this=this@entry=0x7ce47783ee30, aux_index=aux_index@entry=0 '\000', aux_data=aux_data@entry=0x7ce47783edb0) at /data/Server/MDEV-28730/storage/innobase/fts/fts0exec.cc:371
      #6  0x00006503c6fb431b in fts_optimize_write_word (trx=trx@entry=0x9d44deaf580, index=index@entry=0x3c3e74301b28, word=word@entry=0x3f3470067648, nodes=0x3f34700765e8) at /data/Server/MDEV-28730/storage/innobase/fts/fts0opt.cc:1095
      #7  0x00006503c6fb4bc0 in fts_optimize_compact (optim=optim@entry=0x3f3470021c48, index=index@entry=0x3c3e74301b28, start_time=start_time@entry=1764049458) at /data/Server/MDEV-28730/storage/innobase/fts/fts0opt.cc:1175
      #8  0x00006503c6fb6d0a in fts_optimize_words (optim=optim@entry=0x3f3470021c48, index=index@entry=0x3c3e74301b28, word=word@entry=0x7ce47783f100) at /data/Server/MDEV-28730/storage/innobase/fts/fts0opt.cc:1406
      #9  0x00006503c6fb7018 in fts_optimize_index (optim=optim@entry=0x3f3470021c48, index=0x3c3e74301b28) at /data/Server/MDEV-28730/storage/innobase/fts/fts0opt.cc:1569
      #10 0x00006503c6fb717b in fts_optimize_indexes (optim=optim@entry=0x3f3470021c48) at /data/Server/MDEV-28730/storage/innobase/fts/fts0opt.cc:1772
      #11 0x00006503c6fb7325 in fts_optimize_table (table=0x3c3e7417c3e8) at /data/Server/MDEV-28730/storage/innobase/fts/fts0opt.cc:1952
      #12 0x00006503c6d0b568 in ha_innobase::optimize (this=0x3f347005cb60, thd=<optimized out>) at /data/Server/MDEV-28730/storage/innobase/handler/ha_innodb.cc:15168
      #13 0x00006503c6abbcc0 in handler::ha_optimize (this=0x3f347005cb60, thd=thd@entry=0x3f3470000d58, check_opt=check_opt@entry=0x3f3470006500) at /data/Server/MDEV-28730/sql/handler.cc:5626
      #14 0x00006503c6951ea8 in mysql_admin_table (thd=thd@entry=0x3f3470000d58, tables=tables@entry=0x3f3470015ca0, check_opt=check_opt@entry=0x3f3470006500, operator_name=operator_name@entry=0x6503c7a46760 <msg_optimize>, 
          lock_type=lock_type@entry=TL_WRITE, org_open_for_modify=org_open_for_modify@entry=true, no_errors_from_open=false, extra_open_options=0, prepare_func=0x0, operator_func=<optimized out>, view_operator_func=0x0, is_cmd_replicated=true)
          at /data/Server/MDEV-28730/sql/sql_admin.cc:949
      #15 0x00006503c6953b2e in Sql_cmd_optimize_table::execute (this=<optimized out>, thd=0x3f3470000d58) at /data/Server/MDEV-28730/sql/sql_admin.cc:1707
      #16 0x00006503c6809c5f in mysql_execute_command (thd=thd@entry=0x3f3470000d58, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /data/Server/MDEV-28730/sql/sql_parse.cc:5861
      #17 0x00006503c680a80b in mysql_parse (thd=thd@entry=0x3f3470000d58, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7ce4778403d0) at /data/Server/MDEV-28730/sql/sql_parse.cc:7888
      #18 0x00006503c680bded in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x3f3470000d58, packet=packet@entry=0x3f347000b3b9 "", packet_length=packet_length@entry=79, blocking=blocking@entry=true)
          at /data/Server/MDEV-28730/sql/sql_parse.cc:1878
      #19 0x00006503c680d343 in do_command (thd=thd@entry=0x3f3470000d58, blocking=blocking@entry=true) at /data/Server/MDEV-28730/sql/sql_parse.cc:1417
      #20 0x00006503c6941c0f in do_handle_one_connection (connect=<optimized out>, connect@entry=0x6503c9b8f568, put_in_cache=put_in_cache@entry=true) at /data/Server/MDEV-28730/sql/sql_connect.cc:1503
      #21 0x00006503c6941e2c in handle_one_connection (arg=0x6503c9b8f568) at /data/Server/MDEV-28730/sql/sql_connect.cc:1415
      #22 0x000078b57e90ea94 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:447
      #23 0x000078b57e99ba34 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:100
      

      RR trace is present on SDP:-
      /data/results/1764049434/TBR-2261

      Attachments

        Issue Links

          Activity

            People

              thiru Thirunarayanan Balathandayuthapani
              saahil Saahil Alam
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.