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

InnoDB: Assertion failure in file lock0lock.cc (lock != ctx->wait_lock)

    Details

      Description

      InnoDB: Assertion failure in thread 140492273628928 in file lock0lock.cc line 4033
      InnoDB: Failing assertion: lock != ctx->wait_lock

      Found using rqg with following command line (does not repeat every time):

      perl ./runall-new.pl --grammar=conf/engines/engine_stress.yy --gendata=conf/engi
      nes/engine_stress.zz --duration=2000 --queries=100M --threads=8 --galera=mmm --b
      asedir=/home/jan/mysql/10.0-galera --vardir=/home/jan/mysql/galera-test "--mysql
      d=--wsrep-provider=/usr/lib/libgalera_smm.so" "--mysqld=--wsrep_sst_method=rsync"

      ddd stack trace:

      (gdb) where
      #0  0x00007fc6e8fd6621 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
      #1  0x0000000000ea285b in my_write_core (sig=6) at /home/jan/mysql/10.0-galera/mysys/stacktrace.c:457
      #2  0x00000000008979f6 in handle_fatal_signal (sig=6) at /home/jan/mysql/10.0-galera/sql/signal_handler.cc:262
      #3  <signal handler called>
      #4  0x00007fc6e842bbb9 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56
      #5  0x00007fc6e842efc8 in __GI_abort () at abort.c:89
      #6  0x0000000000c27ce8 in lock_get_first_lock (ctx=0x7fc6e80ff300, heap_no=0x7fc6e80ff2a8) at /home/jan/mysql/10.0-galera/storage/xtradb/lock/lock0lock.cc:4033
      #7  0x0000000000c28742 in lock_deadlock_search (ctx=0x7fc6e80ff300, waitee_ptr=0x0) at /home/jan/mysql/10.0-galera/storage/xtradb/lock/lock0lock.cc:4303
      #8  0x0000000000c28c92 in lock_deadlock_check_and_resolve (lock=0x7fc6ac46f738, trx=0x7fc6ac47e678) at /home/jan/mysql/10.0-galera/storage/xtradb/lock/lock0lock.cc:4467
      #9  0x0000000000c243ff in lock_rec_enqueue_waiting (c_lock=0x7fc6ac071120, type_mode=1027, block=0x7fc6befca1d0, heap_no=71, index=0x7fc6d91b4ff8, thr=0x7fc6ad597780) at /home/jan/mysql/10.0-galera/storage/xtradb/lock/lock0lock.cc:2259
      #10 0x0000000000c25000 in lock_rec_lock_slow (impl=0, mode=1027, block=0x7fc6befca1d0, heap_no=71, index=0x7fc6d91b4ff8, thr=0x7fc6ad597780) at /home/jan/mysql/10.0-galera/storage/xtradb/lock/lock0lock.cc:2602
      #11 0x0000000000c252af in lock_rec_lock (impl=0, mode=1027, block=0x7fc6befca1d0, heap_no=71, index=0x7fc6d91b4ff8, thr=0x7fc6ad597780) at /home/jan/mysql/10.0-galera/storage/xtradb/lock/lock0lock.cc:2670
      #12 0x0000000000c2f32f in lock_clust_rec_read_check_and_lock (flags=0, block=0x7fc6befca1d0, rec=0x7fc6c6b28dc9 "\200", index=0x7fc6d91b4ff8, offsets=0x7fc6e80ff880, mode=LOCK_X, gap_mode=1024, thr=0x7fc6ad597780) at /home/jan/mysql/10.0-galera/storage/xtradb/lock/lock0lock.cc:7028
      #13 0x0000000000cf4d27 in sel_set_rec_lock (block=0x7fc6befca1d0, rec=0x7fc6c6b28dc9 "\200", index=0x7fc6d91b4ff8, offsets=0x7fc6e80ff880, mode=3, type=1024, thr=0x7fc6ad597780) at /home/jan/mysql/10.0-galera/storage/xtradb/row/row0sel.cc:1011
      #14 0x0000000000cfb432 in row_search_for_mysql (buf=0x7fc6ad44d3a0 "\377", ' ' <repeats 12 times>, mode=1, prebuilt=0x7fc6ad597078, match_mode=0, direction=1) at /home/jan/mysql/10.0-galera/storage/xtradb/row/row0sel.cc:4513
      #15 0x0000000000bd286c in ha_innobase::general_fetch (this=0x7fc6ad55e088, buf=0x7fc6ad44d3a0 "\377", ' ' <repeats 12 times>, direction=1, match_mode=0) at /home/jan/mysql/10.0-galera/storage/xtradb/handler/ha_innodb.cc:9515
      #16 0x0000000000bd2dc2 in ha_innobase::rnd_next (this=0x7fc6ad55e088, buf=0x7fc6ad44d3a0 "\377", ' ' <repeats 12 times>) at /home/jan/mysql/10.0-galera/storage/xtradb/handler/ha_innodb.cc:9732
      #17 0x000000000089db32 in handler::ha_rnd_next (this=0x7fc6ad55e088, buf=0x7fc6ad44d3a0 "\377", ' ' <repeats 12 times>) at /home/jan/mysql/10.0-galera/sql/handler.cc:2617
      #18 0x0000000000e6b464 in ha_partition::rnd_next (this=0x7fc6ad4ee888, buf=0x7fc6ad44d3a0 "\377", ' ' <repeats 12 times>) at /home/jan/mysql/10.0-galera/sql/ha_partition.cc:4910
      #19 0x000000000089db32 in handler::ha_rnd_next (this=0x7fc6ad4ee888, buf=0x7fc6ad44d3a0 "\377", ' ' <repeats 12 times>) at /home/jan/mysql/10.0-galera/sql/handler.cc:2617
      #20 0x00000000008935ca in find_all_keys (param=0x7fc6e81005b0, select=0x7fc6ac423b00, fs_info=0x7fc6e8100540, buffpek_pointers=0x7fc6e81007d0, tempfile=0x7fc6e8100630, pq=0x0, found_rows=0x7fc6e8100a80) at /home/jan/mysql/10.0-galera/sql/filesort.cc:757
      #21 0x0000000000891fff in filesort (thd=0x7fc6bd633070, table=0x7fc6ad4d0470, sortorder=0x7fc6ac4a1088, s_length=5, select=0x7fc6ac423b00, max_rows=18446744073709551615, sort_positions=true, examined_rows=0x7fc6e8100a60, found_rows=0x7fc6e8100a80) at /home/jan/mysql/10.0-galera/sql/filesort.cc:299
      #22 0x00000000009facb3 in mysql_delete (thd=0x7fc6bd633070, table_list=0x7fc6ac422370, conds=0x7fc6ac422e00, order_list=0x7fc6bd637900, limit=3, options=0, result=0x7fc6ac423748) at /home/jan/mysql/10.0-galera/sql/sql_delete.cc:484
      #23 0x00000000006833ed in mysql_execute_command (thd=0x7fc6bd633070) at /home/jan/mysql/10.0-galera/sql/sql_parse.cc:3931
      #24 0x000000000068c909 in mysql_parse (thd=0x7fc6bd633070, rawbuf=0x7fc6ac422088 "DELETE LOW_PRIORITY  IGNORE FROM `table100_key_pk_parts_2_int_autoinc` WHERE `col_int_key` IN ( 28 , 155 , 4 , 9 , 'f' ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3", length=198, parser_state=0x7fc6e8102220) at /home/jan/mysql/10.0-galera/sql/sql_parse.cc:7010
      #25 0x000000000068c07a in wsrep_mysql_parse (thd=0x7fc6bd633070, rawbuf=0x7fc6ac422088 "DELETE LOW_PRIORITY  IGNORE FROM `table100_key_pk_parts_2_int_autoinc` WHERE `col_int_key` IN ( 28 , 155 , 4 , 9 , 'f' ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3", length=198, parser_state=0x7fc6e8102220) at /home/jan/mysql/10.0-galera/sql/sql_parse.cc:6832
      #26 0x000000000067d0b4 in dispatch_command (command=COM_QUERY, thd=0x7fc6bd633070, packet=0x7fc6bd639071 "DELETE LOW_PRIORITY  IGNORE FROM `table100_key_pk_parts_2_int_autoinc` WHERE `col_int_key` IN ( 28 , 155 , 4 , 9 , 'f' ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3", packet_length=198) at /home/jan/mysql/10.0-galera/sql/sql_parse.cc:1485
      #27 0x000000000067bda8 in do_command (thd=0x7fc6bd633070) at /home/jan/mysql/10.0-galera/sql/sql_parse.cc:1087
      #28 0x00000000007a6f4c in do_handle_one_connection (thd_arg=0x7fc6bd633070) at /home/jan/mysql/10.0-galera/sql/sql_connect.cc:1396
      #29 0x00000000007a6ca4 in handle_one_connection (arg=0x7fc6bd633070) at /home/jan/mysql/10.0-galera/sql/sql_connect.cc:1307
      #30 0x00007fc6e8fd1182 in start_thread (arg=0x7fc6e8103700) at pthread_create.c:312
      #31 0x00007fc6e84effbd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                nirbhay_c Nirbhay Choubey (Inactive)
                Reporter:
                jplindst Jan Lindström
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: