InnoDB: Failing assertion: heap_no < n_heap in page0zip.cc

origin/11.2, 11.2 b8c039fad16adf9cbc6dac2e34cdeb772b9065a0 2023-07-07T09:05:33+10:00

[rr 111813 377572]2023-07-13 12:11:00 0x7fd92f432640[rr 111813 377575]  InnoDB: Assertion failure in file /data/Server/11.2/storage/innobase/page/page0zip.cc line 696

[rr 111813 377577]InnoDB: Failing assertion: heap_no < n_heap

(rr) bt

#0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=140570777560640) at ./nptl/pthread_kill.c:44

#1  __pthread_kill_internal (signo=6, threadid=140570777560640) at ./nptl/pthread_kill.c:78

#2  __GI___pthread_kill (threadid=140570777560640, signo=signo@entry=6) at ./nptl/pthread_kill.c:89

#3  0x000055d17c71f476 in __GI_raise (sig=sig@entry=6) at ../sysdeps/posix/raise.c:26

#4  0x000055d17c7057f3 in __GI_abort () at ./stdlib/abort.c:79

#5  0x00005611ac8b6e97 in ut_dbg_assertion_failed (expr=expr@entry=0x5611ad395cc8 "heap_no < n_heap", file=file@entry=0x5611ad395d28 "/data/Server/11.2/storage/innobase/page/page0zip.cc", line=line@entry=696)

    at /data/Server/11.2/storage/innobase/ut/ut0dbg.cc:60

#6  0x00005611ac8a5c51 in page_zip_dir_encode (recs=0x1918645404d8, buf=<optimized out>, page=0x44c33ce3c000 "") at /data/Server/11.2/storage/innobase/page/page0zip.cc:696

#7  page_zip_compress (block=0x44c33cb22640, index=0x32a354036e48, level=<optimized out>, mtr=mtr@entry=0x7fd92f42ff20) at /data/Server/11.2/storage/innobase/page/page0zip.cc:1427

#8  0x00005611acf9856c in PageBulk::compress (this=0x7fd92f42ff10) at /data/Server/11.2/storage/innobase/btr/btr0bulk.cc:576

#9  BtrBulk::pageCommit (this=0x7fd92f430390, page_bulk=0x7fd92f42ff10, next_page_bulk=0x0, insert_father=<optimized out>) at /data/Server/11.2/storage/innobase/btr/btr0bulk.cc:945

#10 0x00005611acf98f9d in BtrBulk::finish (this=this@entry=0x7fd92f430390, err=DB_SUCCESS) at /data/Server/11.2/storage/innobase/btr/btr0bulk.cc:1220

#11 0x00005611acf42c02 in row_merge_bulk_t::write_to_index (this=0x191864080e50, index_no=<optimized out>, trx=0x7fd9252fe780) at /data/Server/11.2/storage/innobase/row/row0merge.cc:5339

#12 0x00005611acf42e52 in row_merge_bulk_t::write_to_table (trx=0x7fd9252fe780, table=<optimized out>, this=0x191864080e50) at /data/Server/11.2/storage/innobase/row/row0merge.cc:5352

#13 trx_mod_table_time_t::write_bulk (trx=0x7fd9252fe780, table=<optimized out>, this=0x5fac3b1c11e8) at /data/Server/11.2/storage/innobase/row/row0merge.cc:5365

#14 trx_t::bulk_insert_apply_low (this=this@entry=0x7fd9252fe780) at /data/Server/11.2/storage/innobase/row/row0merge.cc:5379

#15 0x00005611acf82610 in trx_t::bulk_insert_apply (this=0x7fd9252fe780) at /data/Server/11.2/storage/innobase/include/trx0trx.h:1174

#16 trx_mark_sql_stat_end (trx=trx@entry=0x7fd9252fe780) at /data/Server/11.2/storage/innobase/trx/trx0trx.cc:1647

#17 0x00005611aceaad1d in end_of_statement (trx=0x7fd9252fe780) at /data/Server/11.2/storage/innobase/handler/ha_innodb.cc:4431

#18 innobase_xa_prepare (hton=<optimized out>, thd=0x191864001618, prepare_trx=<optimized out>) at /data/Server/11.2/storage/innobase/handler/ha_innodb.cc:16964

#19 0x00005611acc50c76 in prepare_or_error (ht=ht@entry=0x3e552e6a21d8, thd=thd@entry=0x191864001618, all=all@entry=false) at /data/Server/11.2/sql/handler.cc:1485

#20 0x00005611acc5313b in ha_commit_trans (thd=thd@entry=0x191864001618, all=all@entry=false) at /data/Server/11.2/sql/handler.cc:1911

#21 0x00005611acb36389 in trans_commit_stmt (thd=thd@entry=0x191864001618) at /data/Server/11.2/sql/transaction.cc:472

#22 0x00005611aca0e39c in mysql_execute_command (thd=0x191864001618, is_called_from_prepared_stmt=<optimized out>) at /data/Server/11.2/sql/sql_parse.cc:5826

#23 0x00005611aca12564 in mysql_parse (thd=0x191864001618, rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>) at /data/Server/11.2/sql/sql_parse.cc:7774

#24 0x00005611aca143a2 in dispatch_command (command=COM_QUERY, thd=0x191864001618, packet=<optimized out>, packet_length=<optimized out>, blocking=<optimized out>) at /data/Server/11.2/sql/sql_parse.cc:1989

#25 0x00005611aca15831 in do_command (thd=0x191864001618, blocking=blocking@entry=true) at /data/Server/11.2/sql/sql_parse.cc:1405

#26 0x00005611acb2796f in do_handle_one_connection (connect=<optimized out>, connect@entry=0xb4655f2e858, put_in_cache=put_in_cache@entry=true) at /data/Server/11.2/sql/sql_connect.cc:1416

#27 0x00005611acb27c6d in handle_one_connection (arg=0xb4655f2e858) at /data/Server/11.2/sql/sql_connect.cc:1318

#28 0x000055d17c771b43 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442

#29 0x000055d17c802bb4 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:100

(rr)

sdp:/data1/results/1689268656/TBR-2005$ _RR_TRACE_DIR=./1/rr rr replay --mark-stdio

RQG

===

# git clone https://github.com/mleich1/rqg --branch <pick the right branch> RQG

#

# GIT_SHOW: HEAD -> master, origin/master, origin/HEAD 504f2ca3e04ae0f91ca921a18964feeccdb3d297 2023-07-13T10:28:28+02:00

# rqg.pl  : Version 4.3.0 (2023-06)

#

# $RQG_HOME/rqg.pl \

# --grammar=conf/mariadb/table_stress_innodb_dml2.yy \

# --gendata=conf/mariadb/table_stress.zz \

# --gendata_sql=conf/mariadb/table_stress.sql \

# --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 \

# --no_mask \

# --queries=10000000 \

# --seed=random \

# --reporters=None \

# --reporters=ErrorLog \

# --reporters=Deadlock \

# --validators=None \

# --mysqld=--log_output=none \

# --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 \

# --mysqld=--plugin-load-add=provider_lzo.so \

# --mysqld=--plugin-load-add=provider_bzip2.so \

# --mysqld=--plugin-load-add=provider_lzma.so \

# --mysqld=--plugin-load-add=provider_snappy.so \

# --mysqld=--plugin-load-add=provider_lz4.so \

# --mysqld=--loose-innodb_compression_level=1 \

# --duration=300 \

# --mysqld=--loose-innodb_fatal_semaphore_wait_threshold=300 \

# --mysqld=--lock-wait-timeout=86400 \

# --mysqld=--innodb-lock-wait-timeout=50 \

# --mysqld=--loose-innodb_read_only_compressed=OFF \

# --mysqld=--loose-innodb-sync-debug \

# --mysqld=--innodb_stats_persistent=off \

# --mysqld=--innodb_adaptive_hash_index=on \

# --mysqld=--innodb_random_read_ahead=ON \

# --redefine=conf/mariadb/redefine_checks_off.yy \

# --mysqld=--log-bin \

# --mysqld=--sync-binlog=1 \

# --mysqld=--loose-innodb_evict_tables_on_commit_debug=on \

# --mysqld=--loose-max-statement-time=30 \

# --threads=9 \

# --mysqld=--innodb-use-native-aio=0 \

# --mysqld=--loose-gdb \

# --mysqld=--loose-debug-gdb \

# --rr=Extended \

# --rr_options=--chaos --wait \

# --mysqld=--innodb_undo_log_truncate=OFF \

# --mysqld=--loose_innodb_change_buffering=changes \

# --mysqld=--innodb_undo_tablespaces=16 \

# --mysqld=--innodb_rollback_on_timeout=OFF \

# --mysqld=--innodb_page_size=8K \

# --mysqld=--innodb_undo_tablespaces=16 \

# --mysqld=--innodb_rollback_on_timeout=OFF \

# --mysqld=--innodb_page_size=8K \

# --mysqld=--innodb-buffer-pool-size=256M \

# <local settings>