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

Assertion `0' failed in btr_search_hash_table_validate

    XMLWordPrintable

    Details

      Description

      origin/10.6, 10.6 68b2819342a00bf18ee98f1e8d5db4b6db78b146 2021-01-27T18:41:58+02:00
       
      2021-01-28  5:09:50 33 [ERROR] InnoDB: Error in an adaptive hash index pointer to page [page id: space=5, page number=3], ptr mem address 0x56723beed201, index id 23, node fold 1270551399198, rec fold 1270308129438
      InnoDB: Record [rr 1097029 2023276]PHYSICAL RECORD: n_fields 1; compact format; info bits 0
      [rr 1097029 2023278] 0:[rr 1097029 2023280] len 4; hex [rr 1097029 2023282]00[rr 1097029 2023284]00[rr 1097029 2023286]00[rr 1097029 2023288]00[rr 1097029 2023290]; asc [rr 1097029 2023292] [rr 1097029 2023294] [rr 1097029 2023296] [rr 1097029 2023298] [rr 1097029 2023300];[rr 1097029 2023302];[rr 1097029 2023304]
      [rr 1097029 2023306]
      InnoDB: on that page. Page mem address 0x56723bee8000, is hashed 0x61600079f620, n fields 0
      InnoDB: side 0
      [rr 1097029 2023308]mysqld: /Server/10.6B/storage/innobase/btr/btr0sea.cc:2226: ulint btr_search_hash_table_validate(ulint): Assertion `0' failed.
       
      Query (0x62b0001d5238): ALTER TABLE r CHECK PARTITION p2,p3
      Status: KILL_TIMEOUT
       
      (rr) bt
      #0  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
      #1  0x00004c8c136cb859 in __GI_abort () at abort.c:79
      #2  0x00004c8c136cb729 in __assert_fail_base (fmt=0x4c8c13861588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x55ce9389a160 "0", file=0x55ce9389a360 "/Server/10.6B/storage/innobase/btr/btr0sea.cc", line=2226, function=<optimized out>)
          at assert.c:92
      #3  0x00004c8c136dcf36 in __GI___assert_fail (assertion=0x55ce9389a160 "0", file=0x55ce9389a360 "/Server/10.6B/storage/innobase/btr/btr0sea.cc", line=2226, function=0x55ce9389c980 "ulint btr_search_hash_table_validate(ulint)") at assert.c:101
      #4  0x000055ce922776ac in btr_search_hash_table_validate (hash_table_id=5) at /Server/10.6B/storage/innobase/btr/btr0sea.cc:2226
      #5  0x000055ce92277b28 in btr_search_validate () at /Server/10.6B/storage/innobase/btr/btr0sea.cc:2285
      #6  0x000055ce91ce304c in ha_innobase::check (this=0x61d0001568b8, thd=0x62b0001ce218, check_opt=0x62b0001d3670) at /Server/10.6B/storage/innobase/handler/ha_innodb.cc:14654
      #7  0x000055ce911a8f91 in handler::ha_check (this=0x61d0001568b8, thd=0x62b0001ce218, check_opt=0x62b0001d3670) at /Server/10.6B/sql/handler.cc:4586
      #8  0x000055ce91a59271 in ha_partition::handle_opt_part (this=0x61d0001536b8, thd=0x62b0001ce218, check_opt=0x62b0001d3670, part_id=2, flag=3) at /Server/10.6B/sql/ha_partition.cc:1320
      #9  0x000055ce91a5a410 in ha_partition::handle_opt_partitions (this=0x61d0001536b8, thd=0x62b0001ce218, check_opt=0x62b0001d3670, flag=3) at /Server/10.6B/sql/ha_partition.cc:1496
      #10 0x000055ce91a58a30 in ha_partition::check (this=0x61d0001536b8, thd=0x62b0001ce218, check_opt=0x62b0001d3670) at /Server/10.6B/sql/ha_partition.cc:1228
      #11 0x000055ce911a8f91 in handler::ha_check (this=0x61d0001536b8, thd=0x62b0001ce218, check_opt=0x62b0001d3670) at /Server/10.6B/sql/handler.cc:4586
      #12 0x000055ce90df2184 in mysql_admin_table (thd=0x62b0001ce218, tables=0x62b0001d5398, check_opt=0x62b0001d3670, operator_name=0x55ce92d834e0 "check", lock_type=TL_READ_NO_INSERT, org_open_for_modify=false, repair_table_use_frm=false, 
          extra_open_options=32, prepare_func=0x0, operator_func=(int (handler::*)(class handler * const, class THD *, HA_CHECK_OPT *)) 0x55ce911a8b08 <handler::ha_check(THD*, st_ha_check_opt*)>, view_operator_func=
          0x55ce90caebac <view_check(THD*, TABLE_LIST*, st_ha_check_opt*)>) at /Server/10.6B/sql/sql_admin.cc:853
      #13 0x000055ce90df6df4 in Sql_cmd_check_table::execute (this=0x62b0001d5ad0, thd=0x62b0001ce218) at /Server/10.6B/sql/sql_admin.cc:1423
      #14 0x000055ce90dc042e in Sql_cmd_alter_table_check_partition::execute (this=0x62b0001d5ad0, thd=0x62b0001ce218) at /Server/10.6B/sql/sql_partition_admin.cc:741
      #15 0x000055ce9099569f in mysql_execute_command (thd=0x62b0001ce218) at /Server/10.6B/sql/sql_parse.cc:5880
      #16 0x000055ce909a309f in mysql_parse (thd=0x62b0001ce218, rawbuf=0x62b0001d5238 "ALTER TABLE r CHECK PARTITION p2,p3 /* E_R Thread18 QNO 27 CON_ID 33 */", length=71, parser_state=0x4eef806a97c0) at /Server/10.6B/sql/sql_parse.cc:7906
      #17 0x000055ce90979c99 in dispatch_command (command=COM_QUERY, thd=0x62b0001ce218, packet=0x62d0000fa419 "", packet_length=72) at /Server/10.6B/sql/sql_parse.cc:1833
      #18 0x000055ce90976b5f in do_command (thd=0x62b0001ce218) at /Server/10.6B/sql/sql_parse.cc:1365
      #19 0x000055ce90db8665 in do_handle_one_connection (connect=0x608000003838, put_in_cache=true) at /Server/10.6B/sql/sql_connect.cc:1410
      #20 0x000055ce90db7fce in handle_one_connection (arg=0x608000003838) at /Server/10.6B/sql/sql_connect.cc:1312
      #21 0x000055ce91abb913 in pfs_spawn_thread (arg=0x61500000dc98) at /Server/10.6B/storage/perfschema/pfs.cc:2201
      #22 0x00007ff26b550609 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #23 0x00004c8c137c8293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      (rr) quit
       
      sdp:/home/mleich/RQG_O/storage/1611834303/AHI/dev/shm/vardir/1611834303/22/1/rr
      _RR_TRACE_DIR="." rr replay --mark-stdio
       
      RQG
      ====
      git clone https://github.com/mleich1/rqg --branch experimental RQG
       
      perl rqg.pl \
      --views \
      --grammar=conf/mariadb/partitions_innodb.yy \
      --redefine=conf/mariadb/alter_table.yy \
      --redefine=conf/mariadb/instant_add.yy \
      --redefine=conf/mariadb/modules/alter_table_columns.yy \
      --redefine=conf/mariadb/sp.yy \
      --redefine=conf/mariadb/bulk_insert.yy \
      --redefine=conf/mariadb/modules/userstat.yy \
      --redefine=conf/mariadb/modules/foreign_keys.yy \
      --redefine=conf/mariadb/modules/locks.yy \
      --redefine=conf/mariadb/modules/sql_mode.yy \
      --redefine=conf/mariadb/versioning.yy \
      --redefine=conf/mariadb/sequences.yy \
      --redefine=conf/mariadb/modules/locks-10.4-extra.yy \
      --mysqld=--innodb_use_native_aio=1 \
      --mysqld=--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/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-max-statement-time=30 \
      --threads=33 \
      --mysqld=--innodb_page_size=32K \
      --mysqld=--innodb-buffer-pool-size=256M \
      --duration=300 \
      --no_mask \
      --workdir=<local settings> \
      --vardir=<local settings> \
      --mtr-build-thread=<local settings> \
      --basedir1=<local settings> \
      --script_debug=_nix_ \
      --rr=Extended \
      --rr_options=--chaos
      
      

        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: