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

[Draft] Assertion `lock_get_wait(other_lock)' failed in lock_rec_queue_validate

    XMLWordPrintable

Details

    Description

      10.3 c2352c45fbd670f50b73415eeeb676aa67fb4a29

      mysqld: /data/src/10.3/storage/innobase/lock/lock0lock.cc:4985: bool lock_rec_queue_validate(bool, const buf_block_t*, const rec_t*, const dict_index_t*, const ulint*): Assertion `lock_get_wait(other_lock)' failed.
      180517 14:00:38 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007f8036f78312 in __GI___assert_fail (assertion=0x7f803a42a30f "lock_get_wait(other_lock)", file=0x7f803a4283d8 "/data/src/10.3/storage/innobase/lock/lock0lock.cc", line=4985, function=0x7f803a42f440 <lock_rec_queue_validate(bool, buf_block_t const*, unsigned char const*, dict_index_t const*, unsigned long const*)::__PRETTY_FUNCTION__> "bool lock_rec_queue_validate(bool, const buf_block_t*, const rec_t*, const dict_index_t*, const ulint*)") at assert.c:101
      #8  0x00007f8039c9a8bc in lock_rec_queue_validate (locked_lock_trx_sys=false, block=0x7f8021425d00, rec=0x7f8025318158 "\200", index=0x7f7fb40e12c8, offsets=0x7f80346871d0) at /data/src/10.3/storage/innobase/lock/lock0lock.cc:4985
      #9  0x00007f8039c9d813 in lock_clust_rec_read_check_and_lock (flags=0, block=0x7f8021425d00, rec=0x7f8025318158 "\200", index=0x7f7fb40e12c8, offsets=0x7f80346871d0, mode=LOCK_X, gap_mode=0, thr=0x7f7fb0031a20) at /data/src/10.3/storage/innobase/lock/lock0lock.cc:5862
      #10 0x00007f8039d9b278 in sel_set_rec_lock (pcur=0x7f7fb0031458, rec=0x7f8025318158 "\200", index=0x7f7fb40e12c8, offsets=0x7f80346871d0, mode=3, type=0, thr=0x7f7fb0031a20, mtr=0x7f80346874f0) at /data/src/10.3/storage/innobase/row/row0sel.cc:1249
      #11 0x00007f8039da4439 in row_search_mvcc (buf=0x7f7fb00bd5f8 "\370\001 \250'\023\270\177\177", mode=PAGE_CUR_G, prebuilt=0x7f7fb0031288, match_mode=0, direction=1) at /data/src/10.3/storage/innobase/row/row0sel.cc:5023
      #12 0x00007f8039c153e3 in ha_innobase::general_fetch (this=0x7f7fb00b9378, buf=0x7f7fb00bd5f8 "\370\001 \250'\023\270\177\177", direction=1, match_mode=0) at /data/src/10.3/storage/innobase/handler/ha_innodb.cc:9642
      #13 0x00007f8039c15964 in ha_innobase::rnd_next (this=0x7f7fb00b9378, buf=0x7f7fb00bd5f8 "\370\001 \250'\023\270\177\177") at /data/src/10.3/storage/innobase/handler/ha_innodb.cc:9851
      #14 0x00007f80399bd763 in handler::ha_rnd_next (this=0x7f7fb00b9378, buf=0x7f7fb00bd5f8 "\370\001 \250'\023\270\177\177") at /data/src/10.3/sql/handler.cc:2764
      #15 0x00007f8039b3e6a1 in rr_sequential (info=0x7f8034687d80) at /data/src/10.3/sql/records.cc:481
      #16 0x00007f80396344f5 in READ_RECORD::read_record (this=0x7f8034687d80) at /data/src/10.3/sql/records.h:73
      #17 0x00007f8039b5c1b9 in mysql_delete (thd=0x7f7fb8000b00, table_list=0x7f7fb80139f8, conds=0x7f7fb8014540, order_list=0x7f7fb8005370, limit=18446744073709551615, options=549755813888, result=0x0) at /data/src/10.3/sql/sql_delete.cc:729
      #18 0x00007f80396cfee5 in mysql_execute_command (thd=0x7f7fb8000b00) at /data/src/10.3/sql/sql_parse.cc:4923
      #19 0x00007f80396d9cd1 in mysql_parse (thd=0x7f7fb8000b00, rawbuf=0x7f7fb80138b8 "DELETE FROM t1 WHERE col3 = 3 OR col3 IS NULL  /* QNO 45913 CON_ID 17 */", length=72, parser_state=0x7f8034689630, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:8019
      #20 0x00007f80396c7113 in dispatch_command (command=COM_QUERY, thd=0x7f7fb8000b00, packet=0x7f7fb800b0f1 "DELETE FROM t1 WHERE col3 = 3 OR col3 IS NULL  /* QNO 45913 CON_ID 17 */ ", packet_length=73, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1846
      #21 0x00007f80396c5b37 in do_command (thd=0x7f7fb8000b00) at /data/src/10.3/sql/sql_parse.cc:1391
      #22 0x00007f803982aebb in do_handle_one_connection (connect=0x7f803c7b1090) at /data/src/10.3/sql/sql_connect.cc:1402
      #23 0x00007f803982ac3f in handle_one_connection (arg=0x7f803c7b1090) at /data/src/10.3/sql/sql_connect.cc:1308
      #24 0x00007f8038bdf064 in start_thread (arg=0x7f803468a700) at pthread_create.c:309
      #25 0x00007f803703262d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
      

      experimenal 6c40fc679d99de2a34ba7e3b6ac807b84be5942a

      perl ./runall-trials.pl --trials=50 --duration=400 --threads=6 --seed=1526336244 --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --transformers=ConvertSubqueriesToViews,ConvertTablesToDerived,Count,DisableOptimizations,Distinct,EnableOptimizations,ExecuteAsCTE,ExecuteAsDeleteReturning,ExecuteAsDerived,ExecuteAsExcept,ExecuteAsExecuteImmediate,ExecuteAsInsertSelect,ExecuteAsIntersect,ExecuteAsSelectItem,ExecuteAsUnion,ExecuteAsUpdateDelete,ExecuteAsView,ExecuteAsWhereSubquery,Having,InlineSubqueries,OrderBy,StraightJoin,ExecuteAsPreparedTwice,ExecuteAsTrigger,ExecuteAsSPTwice,ExecuteAsFunctionTwice --redefine=conf/mariadb/general-workarounds.yy --mysqld=--log_output=FILE  --mysqld=--max-statement-time=3 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --views --redefine=conf/mariadb/sequences.yy --basedir=/data/bld/10.3 --grammar=conf/runtime/alter_online.yy --gendata=conf/runtime/alter_online.zz --engine=MyISAM --mysqld=--default-storage-engine=MyISAM --vardir=/dev/shm/vardir2 --mysqld=--lock-wait-timeout=5 --mysqld=--innodb-lock-wait-timeout=4
      

      Happened on the 2nd trial.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              elenst Elena Stepanova
              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.