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

Assertion `page_is_leaf(block->frame)' in lock_rec_print

    XMLWordPrintable

    Details

      Description

      Problem hit during RQG testing on 10.6.
      mysqld: /data/Server/10.6alpha/storage/innobase/lock/lock0lock.cc:3985: void lock_rec_print(FILE*, const ib_lock_t*, mtr_t&): Assertion `page_is_leaf(block->frame)' failed.
       
      Query (0x62b0002a7238): DELETE FROM t7 WHERE col_int = 4 OR col_int IS NULL
      Status: NOT_KILLED
       
      (rr) bt
      #0  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
      #1  0x00007fffd6cdf859 in __GI_abort () at abort.c:79
      #2  0x00007fffd6cdf729 in __assert_fail_base (fmt=0x7fffd6e75588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x55a78b92b040 "page_is_leaf(block->frame)", file=0x55a78b9250c0 "/data/Server/10.6alpha/storage/innobase/lock/lock0lock.cc", 
          line=3985, function=<optimized out>) at assert.c:92
      #3  0x00007fffd6cf0f36 in __GI___assert_fail (assertion=0x55a78b92b040 "page_is_leaf(block->frame)", file=0x55a78b9250c0 "/data/Server/10.6alpha/storage/innobase/lock/lock0lock.cc", line=3985, 
          function=0x55a78b92ae20 "void lock_rec_print(FILE*, const ib_lock_t*, mtr_t&)") at assert.c:101
      #4  0x000055a78a42777f in lock_rec_print (file=0x615000002880, lock=0x6cdb7c397ef0, mtr=...) at /data/Server/10.6alpha/storage/innobase/lock/lock0lock.cc:3985
      #5  0x000055a78a434380 in Deadlock::print (lock=...) at /data/Server/10.6alpha/storage/innobase/lock/lock0lock.cc:5746
      #6  0x000055a78a434ede in Deadlock::report (trx=0x6cdb7c3a14c0, current_trx=true) at /data/Server/10.6alpha/storage/innobase/lock/lock0lock.cc:5866
      #7  0x000055a78a435a0e in Deadlock::check_and_resolve (trx=0x6cdb7c3a14c0) at /data/Server/10.6alpha/storage/innobase/lock/lock0lock.cc:5943
      #8  0x000055a78a41651d in lock_wait (thr=0x62100026f6c8) at /data/Server/10.6alpha/storage/innobase/lock/lock0lock.cc:1766
      #9  0x000055a78a612fd3 in row_mysql_handle_errors (new_err=0x47010f93d240, trx=0x6cdb7c3a14c0, thr=0x62100026f6c8, savept=0x0) at /data/Server/10.6alpha/storage/innobase/row/row0mysql.cc:745
      #10 0x000055a78a6a868b in row_search_mvcc (buf=0x61a0002034b8 "\350'", mode=PAGE_CUR_G, prebuilt=0x62100026e988, match_mode=0, direction=1) at /data/Server/10.6alpha/storage/innobase/row/row0sel.cc:5758
      #11 0x000055a78a2b1e01 in ha_innobase::general_fetch (this=0x61d000a8b6b8, buf=0x61a0002034b8 "\350'", direction=1, match_mode=0) at /data/Server/10.6alpha/storage/innobase/handler/ha_innodb.cc:8875
      #12 0x000055a78a2b2877 in ha_innobase::rnd_next (this=0x61d000a8b6b8, buf=0x61a0002034b8 "\350'") at /data/Server/10.6alpha/storage/innobase/handler/ha_innodb.cc:9079
      #13 0x000055a78999515a in handler::ha_rnd_next (this=0x61d000a8b6b8, buf=0x61a0002034b8 "\350'") at /data/Server/10.6alpha/sql/handler.cc:3068
      #14 0x000055a789da536f in rr_sequential (info=0x47010f93e750) at /data/Server/10.6alpha/sql/records.cc:519
      #15 0x000055a78907bd7e in READ_RECORD::read_record (this=0x47010f93e750) at /data/Server/10.6alpha/sql/records.h:81
      #16 0x000055a789df22aa in mysql_delete (thd=0x62b0002a0218, table_list=0x62b0002a73c0, conds=0x62b0002a8138, order_list=0x62b0002a4e30, limit=18446744073709551614, options=0, result=0x0) at /data/Server/10.6alpha/sql/sql_delete.cc:782
      #17 0x000055a789210b42 in mysql_execute_command (thd=0x62b0002a0218) at /data/Server/10.6alpha/sql/sql_parse.cc:4801
      #18 0x000055a789225738 in mysql_parse (thd=0x62b0002a0218, rawbuf=0x62b0002a7238 "DELETE FROM t7 WHERE col_int = 4 OR col_int IS NULL  /* E_R Thread27 QNO 111 CON_ID 42 */", length=89, parser_state=0x47010f93fb20)
          at /data/Server/10.6alpha/sql/sql_parse.cc:8018
      #19 0x000055a7891fe022 in dispatch_command (command=COM_QUERY, thd=0x62b0002a0218, packet=0x629000e7e219 " DELETE FROM t7 WHERE col_int = 4 OR col_int IS NULL  /* E_R Thread27 QNO 111 CON_ID 42 */ ", packet_length=91, blocking=true)
          at /data/Server/10.6alpha/sql/sql_parse.cc:1897
      #20 0x000055a7891fb3f7 in do_command (thd=0x62b0002a0218, blocking=true) at /data/Server/10.6alpha/sql/sql_parse.cc:1406
      #21 0x000055a7895dfb70 in do_handle_one_connection (connect=0x608000003bb8, put_in_cache=true) at /data/Server/10.6alpha/sql/sql_connect.cc:1410
      #22 0x000055a7895df4d2 in handle_one_connection (arg=0x608000003bb8) at /data/Server/10.6alpha/sql/sql_connect.cc:1312
      #23 0x00007fffd781d609 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #24 0x00007fffd6ddc293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      (rr)
       
      sdp:/data/Results/1619433372/TBR-1034/dev/shm/vardir/1619433372/88/1/rr
      _RR_TRACE_DIR="." rr replay --mark-stdio
       
      10.6 1a647b700f6b72dc97211510a5d0c647d5d3d911 2021-04-23T10:07:08+03:00
       
      RQG
      -------
      git clone https://github.com/mleich1/rqg --branch experimental RQG
       
      perl rqg.pl \
      --grammar=conf/mariadb/table_stress_innodb_nocopy1.yy \
      --gendata=conf/mariadb/table_stress.zz \
      --gendata_sql=conf/mariadb/table_stress.sql \
      --redefine=conf/mariadb/xa.yy \
      --mysqld=--loose-innodb_lock_schedule_algorithm=fcfs \
      --mysqld=--loose-idle_write_transaction_timeout=0 \
      --mysqld=--loose-idle_transaction_timeout=0 \
      --mysqld=--loose-idle_readonly_transaction_timeout=0 \
      --mysqld=--connect_timeout=60 \
      --mysqld=--interactive_timeout=28800 \
      --mysqld=--slave_net_timeout=60 \
      --mysqld=--net_read_timeout=30 \
      --mysqld=--net_write_timeout=60 \
      --mysqld=--loose-table_lock_wait_timeout=50 \
      --mysqld=--wait_timeout=28800 \
      --mysqld=--lock-wait-timeout=86400 \
      --mysqld=--innodb-lock-wait-timeout=50 \
      --no-mask \
      --queries=10000000 \
      --seed=random \
      --reporters=Backtrace \
      --reporters=ErrorLog \
      --reporters=Deadlock1 \
      --validators=None \
      --mysqld=--log_output=none \
      --mysqld=--log-bin \
      --mysqld=--log_bin_trust_function_creators=1 \
      --mysqld=--loose-debug_assert_on_not_freed_memory=0 \
      --engine=InnoDB \
      --restart_timeout=240 \
      --mysqld=--plugin-load-add=file_key_management.so \
      --mysqld=--loose-file-key-management-filename=$RQG_HOME/home/mleich/RQG_O/conf/mariadb/encryption_keys.txt \
      --duration=300 \
      --mysqld=--loose-innodb_fatal_semaphore_wait_threshold=300 \
      --mysqld=--innodb_stats_persistent=on \
      --mysqld=--innodb_adaptive_hash_index=on \
      --mysqld=--loose-innodb_evict_tables_on_commit_debug=off \
      --mysqld=--loose-max-statement-time=30 \
      --threads=33 \
      --mysqld=--innodb-use-native-aio=0 \
      --rr=Extended \
      --rr_options="--chaos --wait" \
      --mysqld=--innodb_page_size=32K \
      --mysqld=--innodb-buffer-pool-size=24M \
      --duration=300 \
      --no_mask \
      --workdir=<local settings> \
      --vardir=<local settings> \
      --mtr-build-thread=<local settings> \
      --basedir1=<local settings> \
      --script_debug=_nix_
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              marko Marko Mäkelä
              Reporter:
              mleich Matthias Leich
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration