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

InnoDB: Failing assertion: !other_lock || wsrep_thd_is_BF(lock->trx->mysql_thd, FALSE) || wsrep_thd_is_BF(other_lock->trx->mysql_thd, FALSE)

Details

    • 10.2.4-4

    Description

      10.2 39d2c7b18d

      		 
      2016-10-29 01:13:14 0x7fdc558c5300  InnoDB: Assertion failure in thread 140584304792320 in file lock0lock.cc line 6347
      		 
      InnoDB: Failing assertion: !other_lock || wsrep_thd_is_BF(lock->trx->mysql_thd, FALSE) || wsrep_thd_is_BF(other_lock->trx->mysql_thd, FALSE)
      		 
       
      		 
      #6  0x00007fdc54ef8ab4 in ut_dbg_assertion_failed (expr=expr@entry=0x7fdc55374cd8 "!other_lock || wsrep_thd_is_BF(lock->trx->mysql_thd, FALSE) || wsrep_thd_is_BF(other_lock->trx->mysql_thd, FALSE)", file=file@entry=0x7fdc55373bc8 "/data/src/10.2/storage/innobase/lock/lock0lock.cc", line=line@entry=6347) at /data/src/10.2/storage/innobase/ut/ut0dbg.cc:67
      		 
      #7  0x00007fdc54d52f97 in lock_rec_queue_validate (locked_lock_trx_sys=locked_lock_trx_sys@entry=0, block=block@entry=0x7fdc3dbb41a0, rec=rec@entry=0x7fdc3dec407e "", index=index@entry=0x7fdc2d55cd88, offsets=offsets@entry=0x7fdc558c0cc0) at /data/src/10.2/storage/innobase/lock/lock0lock.cc:6346
      		 
      #8  0x00007fdc54d5c5c5 in lock_clust_rec_read_check_and_lock (flags=flags@entry=0, block=block@entry=0x7fdc3dbb41a0, rec=rec@entry=0x7fdc3dec407e "", index=index@entry=0x7fdc2d55cd88, offsets=offsets@entry=0x7fdc558c0cc0, mode=mode@entry=LOCK_X, gap_mode=0, thr=0x7fdc2d69dab0) at /data/src/10.2/storage/innobase/lock/lock0lock.cc:7166
      		 
      #9  0x00007fdc54e4d785 in sel_set_rec_lock (pcur=pcur@entry=0x7fdc2d69d270, rec=rec@entry=0x7fdc3dec407e "", index=index@entry=0x7fdc2d55cd88, offsets=0x7fdc558c0cc0, mode=3, type=0, thr=0x7fdc2d69dab0, mtr=0x7fdc558c1300) at /data/src/10.2/storage/innobase/row/row0sel.cc:1255
      		 
      #10 0x00007fdc54e52b4a in row_search_mvcc (buf=buf@entry=0x7fdc2d41c188 "\377", mode=mode@entry=PAGE_CUR_G, prebuilt=0x7fdc2d69d088, match_mode=match_mode@entry=0, direction=direction@entry=0) at /data/src/10.2/storage/innobase/row/row0sel.cc:5358
      		 
      #11 0x00007fdc54cf79bb in ha_innobase::index_read (this=0x7fdc2d4b5888, buf=0x7fdc2d41c188 "\377", key_ptr=0x0, key_len=<optimized out>, find_flag=<optimized out>) at /data/src/10.2/storage/innobase/handler/ha_innodb.cc:10431
      		 
      #12 0x00007fdc54ce32a4 in ha_innobase::index_first (this=0x7fdc2d4b5888, buf=0x7fdc2d41c188 "\377") at /data/src/10.2/storage/innobase/handler/ha_innodb.cc:10878
      		 
      #13 0x00007fdc54cf8189 in ha_innobase::rnd_next (this=0x7fdc2d4b5888, buf=0x7fdc2d41c188 "\377") at /data/src/10.2/storage/innobase/handler/ha_innodb.cc:10979
      		 
      #14 0x00007fdc54b05155 in handler::ha_rnd_next (this=0x7fdc2d4b5888, buf=0x7fdc2d41c188 "\377") at /data/src/10.2/sql/handler.cc:2577
      		 
      #15 0x00007fdc54c36ea7 in rr_sequential (info=0x7fdc558c1b70) at /data/src/10.2/sql/records.cc:474
      		 
      #16 0x00007fdc549d58d2 in mysql_update (thd=thd@entry=0x7fdc2d816070, table_list=0x7fdc2d864160, fields=..., values=..., conds=0x0, order_num=<optimized out>, order=<optimized out>, limit=18446744073709551615, handle_duplicates=DUP_ERROR, ignore=false, found_return=0x7fdc558c20e0, updated_return=0x7fdc558c2190) at /data/src/10.2/sql/sql_update.cc:737
      		 
      #17 0x00007fdc54920ae4 in mysql_execute_command (thd=thd@entry=0x7fdc2d816070) at /data/src/10.2/sql/sql_parse.cc:4176
      		 
      #18 0x00007fdc549276cb in mysql_parse (thd=thd@entry=0x7fdc2d816070, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7fdc558c38e0, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/10.2/sql/sql_parse.cc:7796
      		 
      #19 0x00007fdc5492999b in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7fdc2d816070, packet=packet@entry=0x7fdc2d858071 "UPDATE t1 SET i1 = 1", packet_length=packet_length@entry=20, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/10.2/sql/sql_parse.cc:1806
      		 
      #20 0x00007fdc5492c4cd in do_command (thd=0x7fdc2d816070) at /data/src/10.2/sql/sql_parse.cc:1366
      		 
      #21 0x00007fdc54a190f0 in do_handle_one_connection (connect=connect@entry=0x7fdc51c71870) at /data/src/10.2/sql/sql_connect.cc:1354
      		 
      #22 0x00007fdc54a192d9 in handle_one_connection (arg=arg@entry=0x7fdc51c71870) at /data/src/10.2/sql/sql_connect.cc:1260
      		 
      #23 0x00007fdc54cbe699 in pfs_spawn_thread (arg=0x7fdc393eb9f0) at /data/src/10.2/storage/perfschema/pfs.cc:1862
      		 
      #24 0x00007fdc540390a4 in start_thread (arg=0x7fdc558c5300) at pthread_create.c:309
      		 
      #25 0x00007fdc5285987d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111


      --source include/have_innodb.inc
      		 
       
      		 
      CREATE TABLE t1 (i1 INT) ENGINE=InnoDB;
      		 
      INSERT INTO t1 VALUES (1),(2);
      		 
       
      		 
      CREATE TABLE t2 (i2 int) ENGINE=MyISAM;
      		 
      BEGIN;
      		 
      DELETE FROM t1;
      		 
       
      		 
      --connect (con1,localhost,root,,test)
      		 
      BEGIN;
      		 
      INSERT INTO t2 VALUES (1),(2);
      		 
      UPDATE t1 SET i1 = 1;

      Attachments

        Issue Links

          is caused by

          Task - A task that needs to be done. MDEV-11039 Add new scheduling algorithm for reducing tail latencies

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            elenst Elena Stepanova created issue -
            elenst Elena Stepanova made changes -
            Field Original Value New Value
            Component/s Locking [ 10900 ]
            Component/s Storage Engine - InnoDB [ 10129 ]
            Component/s wsrep [ 11500 ]
            Fix Version/s 10.2 [ 14601 ]
            Assignee Elena Stepanova [ elenst ] Nirbhay Choubey [ nirbhay_c ]
            Description http://buildbot.askmonty.org/buildbot/builders/kvm-qa-linux/builds/800/steps/shell_5/logs/stdio
            {noformat}
            2016-10-27 20:56:13 0x7f404eb32300 InnoDB: Assertion failure in thread 139914174997248 in file lock0lock.cc line 6347
            InnoDB: Failing assertion: !other_lock || wsrep_thd_is_BF(lock->trx->mysql_thd, FALSE) || wsrep_thd_is_BF(other_lock->trx->mysql_thd, FALSE)
            InnoDB: We intentionally generate a memory trap.
            InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
            InnoDB: If you get repeated assertion failures or crashes, even
            InnoDB: immediately after the mysqld startup, there may be
            InnoDB: corruption in the InnoDB tablespace. Please refer to
            InnoDB: http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html
            InnoDB: about forcing recovery.
            161027 20:56:13 [ERROR] mysqld got signal 6 ;
            This could be because you hit a bug. It is also possible that this binary
            or one of the libraries it was linked against is corrupt, improperly built,
            or misconfigured. This error can also be caused by malfunctioning hardware.

            To report this bug, see https://mariadb.com/kb/en/reporting-bugs

            We will try our best to scrape up some info that will hopefully help
            diagnose the problem, but since we have already crashed,
            something is definitely wrong and this may fail.

            Server version: 10.2.3-MariaDB-debug-log
            key_buffer_size=134217728
            read_buffer_size=131072
            max_used_connections=11
            max_threads=1001
            thread_count=11
            It is possible that mysqld could use up to
            key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 2312531 K bytes of memory
            Hope that's ok; if not, decrease some variables in the equation.

            Thread pointer: 0x0x7f400c7f0070
            Attempting backtrace. You can use the following information to find out
            where mysqld died. If you see no messages after this, something went
            terribly wrong...
            stack_bottom = 0x7f404eb31908 thread_stack 0x48c00
            /home/buildbot/build/sql/mysqld(my_print_stacktrace+0x38)[0x7f404fbb8a7a]
            /home/buildbot/build/sql/mysqld(handle_fatal_signal+0x3a8)[0x7f404f435b6b]
            /lib/x86_64-linux-gnu/libpthread.so.0(+0xf8d0)[0x7f404e8288d0]
            /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x37)[0x7f404c926067]
            /lib/x86_64-linux-gnu/libc.so.6(abort+0x148)[0x7f404c927448]
            /home/buildbot/build/sql/mysqld(+0xbf63c2)[0x7f404f84f3c2]
            /home/buildbot/build/sql/mysqld(+0xa4e2b4)[0x7f404f6a72b4]
            /home/buildbot/build/sql/mysqld(+0xa50aeb)[0x7f404f6a9aeb]
            /home/buildbot/build/sql/mysqld(+0xb535ab)[0x7f404f7ac5ab]
            /home/buildbot/build/sql/mysqld(+0xb5813e)[0x7f404f7b113e]
            /home/buildbot/build/sql/mysqld(+0x9ce966)[0x7f404f627966]
            /home/buildbot/build/sql/mysqld(+0x7ed2aa)[0x7f404f4462aa]
            /home/buildbot/build/sql/mysqld(_ZN7handler17ha_index_read_mapEPhPKhm16ha_rkey_function+0x1fc)[0x7f404f43c986]
            /home/buildbot/build/sql/mysqld(_ZN7handler16read_range_firstEPK12st_key_rangeS2_bb+0xfa)[0x7f404f4430a4]
            /home/buildbot/build/sql/mysqld(+0xf2a0e2)[0x7f404fb830e2]
            /home/buildbot/build/sql/mysqld(+0xf28bfa)[0x7f404fb81bfa]
            /home/buildbot/build/sql/mysqld(+0xf2946c)[0x7f404fb8246c]
            /home/buildbot/build/sql/mysqld(_ZN7handler21multi_range_read_nextEPPv+0x134)[0x7f404f35d004]
            /home/buildbot/build/sql/mysqld(_ZN18QUICK_RANGE_SELECT8get_nextEv+0x6a)[0x7f404f58cab6]
            /home/buildbot/build/sql/mysqld(+0x944872)[0x7f404f59d872]
            /home/buildbot/build/sql/mysqld(_Z12mysql_deleteP3THDP10TABLE_LISTP4ItemP10SQL_I_ListI8st_orderEyyP13select_result+0x16f5)[0x7f404f5c6825]
            /home/buildbot/build/sql/mysqld(_Z21mysql_execute_commandP3THD+0x4dd0)[0x7f404f1d3dd0]
            /home/buildbot/build/sql/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x29a)[0x7f404f1de6f6]
            /home/buildbot/build/sql/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0xf2e)[0x7f404f1cc464]
            /home/buildbot/build/sql/mysqld(_Z10do_commandP3THD+0x763)[0x7f404f1cae3e]
            /home/buildbot/build/sql/mysqld(+0x71cf89)[0x7f404f375f89]
            /home/buildbot/build/sql/mysqld(_Z11tp_callbackP13TP_connection+0xdc)[0x7f404f375bad]
            /home/buildbot/build/sql/mysqld(+0x79e1e9)[0x7f404f3f71e9]
            /home/buildbot/build/sql/mysqld(+0xdca75c)[0x7f404fa2375c]
            /lib/x86_64-linux-gnu/libpthread.so.0(+0x80a4)[0x7f404e8210a4]
            /lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7f404c9d987d]

            Trying to get some variables.
            Some pointers may be invalid and cause the dump to abort.
            Query (0x7f400c697088): DELETE FROM `table100_innodb_key_pk_parts_2_int_autoinc` WHERE `col_decimal_unsigned_key_default_null` > 'got' LIMIT 1 /* QNO 1188 CON_ID 13 */
            Connection ID (thread ID): 13
            Status: NOT_KILLED
            {noformat}
            {noformat}
            # 2016-10-27T20:52:46 [1519] Final command line:
            # 2016-10-27T20:52:46 [1519] perl /home/buildbot/rqg/runall-new.pl --no-mask --seed=1477615966 --threads=8 --duration=300 --queries=100M --reporters=QueryTimeout,Backtrace,ErrorLog,Deadlock --validators=QueryProperties --redefine=conf/mariadb/general-workarounds.yy --redefine=conf/mariadb/redefine_multiple_triggers.yy --mysqld=--log_output=FILE --mysqld=--log_bin_trust_function_creators=1 --use-gtid=current_pos --mysqld=--slave_parallel_threads=8 --mysqld=--performance_schema=1 --mysqld=--log_bin --mysqld=--binlog_format=MIXED --mysqld=--thread_handling=pool-of-threads --views --grammar=conf/replication/replication.yy --gendata=conf/replication/replication-5.1.zz --mtr-build-thread=300 --basedir1=/home/buildbot/build --vardir1=/home/buildbot/10.2-features/current1_1
            {noformat}
            		{noformat:title=10.2 39d2c7b18d}
            2016-10-29 01:13:14 0x7fdc558c5300 InnoDB: Assertion failure in thread 140584304792320 in file lock0lock.cc line 6347
            InnoDB: Failing assertion: !other_lock || wsrep_thd_is_BF(lock->trx->mysql_thd, FALSE) || wsrep_thd_is_BF(other_lock->trx->mysql_thd, FALSE)

            #6 0x00007fdc54ef8ab4 in ut_dbg_assertion_failed (expr=expr@entry=0x7fdc55374cd8 "!other_lock || wsrep_thd_is_BF(lock->trx->mysql_thd, FALSE) || wsrep_thd_is_BF(other_lock->trx->mysql_thd, FALSE)", file=file@entry=0x7fdc55373bc8 "/data/src/10.2/storage/innobase/lock/lock0lock.cc", line=line@entry=6347) at /data/src/10.2/storage/innobase/ut/ut0dbg.cc:67
            #7 0x00007fdc54d52f97 in lock_rec_queue_validate (locked_lock_trx_sys=locked_lock_trx_sys@entry=0, block=block@entry=0x7fdc3dbb41a0, rec=rec@entry=0x7fdc3dec407e "", index=index@entry=0x7fdc2d55cd88, offsets=offsets@entry=0x7fdc558c0cc0) at /data/src/10.2/storage/innobase/lock/lock0lock.cc:6346
            #8 0x00007fdc54d5c5c5 in lock_clust_rec_read_check_and_lock (flags=flags@entry=0, block=block@entry=0x7fdc3dbb41a0, rec=rec@entry=0x7fdc3dec407e "", index=index@entry=0x7fdc2d55cd88, offsets=offsets@entry=0x7fdc558c0cc0, mode=mode@entry=LOCK_X, gap_mode=0, thr=0x7fdc2d69dab0) at /data/src/10.2/storage/innobase/lock/lock0lock.cc:7166
            #9 0x00007fdc54e4d785 in sel_set_rec_lock (pcur=pcur@entry=0x7fdc2d69d270, rec=rec@entry=0x7fdc3dec407e "", index=index@entry=0x7fdc2d55cd88, offsets=0x7fdc558c0cc0, mode=3, type=0, thr=0x7fdc2d69dab0, mtr=0x7fdc558c1300) at /data/src/10.2/storage/innobase/row/row0sel.cc:1255
            #10 0x00007fdc54e52b4a in row_search_mvcc (buf=buf@entry=0x7fdc2d41c188 "\377", mode=mode@entry=PAGE_CUR_G, prebuilt=0x7fdc2d69d088, match_mode=match_mode@entry=0, direction=direction@entry=0) at /data/src/10.2/storage/innobase/row/row0sel.cc:5358
            #11 0x00007fdc54cf79bb in ha_innobase::index_read (this=0x7fdc2d4b5888, buf=0x7fdc2d41c188 "\377", key_ptr=0x0, key_len=<optimized out>, find_flag=<optimized out>) at /data/src/10.2/storage/innobase/handler/ha_innodb.cc:10431
            #12 0x00007fdc54ce32a4 in ha_innobase::index_first (this=0x7fdc2d4b5888, buf=0x7fdc2d41c188 "\377") at /data/src/10.2/storage/innobase/handler/ha_innodb.cc:10878
            #13 0x00007fdc54cf8189 in ha_innobase::rnd_next (this=0x7fdc2d4b5888, buf=0x7fdc2d41c188 "\377") at /data/src/10.2/storage/innobase/handler/ha_innodb.cc:10979
            #14 0x00007fdc54b05155 in handler::ha_rnd_next (this=0x7fdc2d4b5888, buf=0x7fdc2d41c188 "\377") at /data/src/10.2/sql/handler.cc:2577
            #15 0x00007fdc54c36ea7 in rr_sequential (info=0x7fdc558c1b70) at /data/src/10.2/sql/records.cc:474
            #16 0x00007fdc549d58d2 in mysql_update (thd=thd@entry=0x7fdc2d816070, table_list=0x7fdc2d864160, fields=..., values=..., conds=0x0, order_num=<optimized out>, order=<optimized out>, limit=18446744073709551615, handle_duplicates=DUP_ERROR, ignore=false, found_return=0x7fdc558c20e0, updated_return=0x7fdc558c2190) at /data/src/10.2/sql/sql_update.cc:737
            #17 0x00007fdc54920ae4 in mysql_execute_command (thd=thd@entry=0x7fdc2d816070) at /data/src/10.2/sql/sql_parse.cc:4176
            #18 0x00007fdc549276cb in mysql_parse (thd=thd@entry=0x7fdc2d816070, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7fdc558c38e0, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/10.2/sql/sql_parse.cc:7796
            #19 0x00007fdc5492999b in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7fdc2d816070, packet=packet@entry=0x7fdc2d858071 "UPDATE t1 SET i1 = 1", packet_length=packet_length@entry=20, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/10.2/sql/sql_parse.cc:1806
            #20 0x00007fdc5492c4cd in do_command (thd=0x7fdc2d816070) at /data/src/10.2/sql/sql_parse.cc:1366
            #21 0x00007fdc54a190f0 in do_handle_one_connection (connect=connect@entry=0x7fdc51c71870) at /data/src/10.2/sql/sql_connect.cc:1354
            #22 0x00007fdc54a192d9 in handle_one_connection (arg=arg@entry=0x7fdc51c71870) at /data/src/10.2/sql/sql_connect.cc:1260
            #23 0x00007fdc54cbe699 in pfs_spawn_thread (arg=0x7fdc393eb9f0) at /data/src/10.2/storage/perfschema/pfs.cc:1862
            #24 0x00007fdc540390a4 in start_thread (arg=0x7fdc558c5300) at pthread_create.c:309
            #25 0x00007fdc5285987d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
            {noformat}

            {code:sql}
            --source include/have_innodb.inc

            CREATE TABLE t1 (i1 INT) ENGINE=InnoDB;
            INSERT INTO t1 VALUES (1),(2);

            CREATE TABLE t2 (i2 int) ENGINE=MyISAM;
            BEGIN;
            DELETE FROM t1;

            --connect (con1,localhost,root,,test)
            BEGIN;
            INSERT INTO t2 VALUES (1),(2);
            UPDATE t1 SET i1 = 1;
            {code}
            Summary [Draft] InnoDB: Failing assertion: !other_lock || wsrep_thd_is_BF(lock->trx->mysql_thd, FALSE) || wsrep_thd_is_BF(other_lock->trx->mysql_thd, FALSE) InnoDB: Failing assertion: !other_lock || wsrep_thd_is_BF(lock->trx->mysql_thd, FALSE) || wsrep_thd_is_BF(other_lock->trx->mysql_thd, FALSE)
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.4-3 [ 115 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked lower
            nirbhay_c Nirbhay Choubey (Inactive) made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.4-3 [ 115 ] 10.2.4-4 [ 117 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked higher
            nirbhay_c Nirbhay Choubey (Inactive) made changes -
            Assignee Nirbhay Choubey [ nirbhay_c ] Jan Lindström [ jplindst ]
            jplindst Jan Lindström (Inactive) made changes -
            Assignee Jan Lindström [ jplindst ] Marko Mäkelä [ marko ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            marko Marko Mäkelä made changes -
            Status In Review [ 10002 ] Stalled [ 10000 ]
            nirbhay_c Nirbhay Choubey (Inactive) made changes -
            Affects Version/s 10.1.19 [ 22111 ]
            jplindst Jan Lindström (Inactive) made changes -
            Assignee Marko Mäkelä [ marko ] Jan Lindström [ jplindst ]
            jplindst Jan Lindström (Inactive) made changes -
            Status Stalled [ 10000 ] In Progress [ 3 ]
            jplindst Jan Lindström (Inactive) made changes -
            Component/s Storage Engine - XtraDB [ 10135 ]
            Component/s wsrep [ 11500 ]
            Fix Version/s 10.1.20 [ 22112 ]
            Fix Version/s 10.2.3 [ 22115 ]
            Fix Version/s 10.2 [ 14601 ]
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Closed [ 6 ]
            marko Marko Mäkelä made changes -
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 78124 ] MariaDB v4 [ 151142 ]

            People

              jplindst Jan Lindström (Inactive)
              elenst Elena Stepanova
              Votes:
              0 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.