[rr 643603 30431]mariadbd: /data/Server/10.11-MDEV-29445F/storage/innobase/handler/handler0alter.cc:401: void dict_table_t::prepare_instant(const[rr 643603 30434] dict_table_t&, const ulint*, unsigned int&): Assertion `n_fields - (i - j) == index.n_fields' failed.

(rr) bt

#0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>) at ./nptl/pthread_kill.c:44

#1  __pthread_kill_internal (signo=6, threadid=<optimized out>) at ./nptl/pthread_kill.c:78

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

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

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

#5  0x000033b20b72181b in __assert_fail_base (fmt=0x33b20b8c91e8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x651a33dd8980 "n_fields - (i - j) == index.n_fields", 

    file=file@entry=0x651a33dce9b0 "/data/Server/10.11-MDEV-29445F/storage/innobase/handler/handler0alter.cc", line=line@entry=401, 

    function=function@entry=0x651a33dd8650 "void dict_table_t::prepare_instant(const dict_table_t&, const ulint*, unsigned int&)") at ./assert/assert.c:94

#6  0x000033b20b734507 in __assert_fail (assertion=0x651a33dd8980 "n_fields - (i - j) == index.n_fields", file=0x651a33dce9b0 "/data/Server/10.11-MDEV-29445F/storage/innobase/handler/handler0alter.cc", line=401, 

    function=0x651a33dd8650 "void dict_table_t::prepare_instant(const dict_table_t&, const ulint*, unsigned int&)") at ./assert/assert.c:103

#7  0x0000651a33960886 in dict_table_t::prepare_instant (this=0x204f14036de0, old=..., col_map=<optimized out>, first_alter_pos=@0x204f14014fb8: 2)

    at /data/Server/10.11-MDEV-29445F/storage/innobase/handler/handler0alter.cc:401

#8  0x0000651a33960e87 in ha_innobase_inplace_ctx::prepare_instant (this=this@entry=0x204f14014e58) at /data/Server/10.11-MDEV-29445F/storage/innobase/handler/handler0alter.cc:1218

#9  0x0000651a3394756f in prepare_inplace_alter_table_dict (ha_alter_info=ha_alter_info@entry=0x64fe140e3120, altered_table=altered_table@entry=0x64fe140e31e0, old_table=<optimized out>, 

    table_name=<optimized out>, flags=<optimized out>, flags2=<optimized out>, fts_doc_id_col=<optimized out>, add_fts_doc_id=<optimized out>, add_fts_doc_id_idx=<optimized out>)

    at /data/Server/10.11-MDEV-29445F/storage/innobase/handler/handler0alter.cc:7129

#10 0x0000651a3394c5ff in ha_innobase::prepare_inplace_alter_table (this=0x204f140320a8, altered_table=<optimized out>, ha_alter_info=<optimized out>)

    at /data/Server/10.11-MDEV-29445F/storage/innobase/handler/handler0alter.cc:8764

#11 0x0000651a336f2af3 in handler::ha_prepare_inplace_alter_table (this=0x204f140320a8, altered_table=altered_table@entry=0x64fe140e31e0, ha_alter_info=ha_alter_info@entry=0x64fe140e3120)

    at /data/Server/10.11-MDEV-29445F/sql/handler.cc:5368

#12 0x0000651a33533388 in mysql_inplace_alter_table (thd=thd@entry=0x204f14000d58, table_list=0x204f140137b0, table=table@entry=0x204f14030048, altered_table=altered_table@entry=0x64fe140e31e0, 

    ha_alter_info=ha_alter_info@entry=0x64fe140e3120, target_mdl_request=target_mdl_request@entry=0x64fe140e3a40, ddl_log_state=0x64fe140e30e0, trigger_param=0x64fe140e35e0, alter_ctx=0x64fe140e4610, 

    partial_alter=@0x64fe140e307f: false, start_alter_id=@0x64fe140e3088: 0, if_exists=false) at /data/Server/10.11-MDEV-29445F/sql/sql_table.cc:8012

#13 0x0000651a335448db in mysql_alter_table (thd=thd@entry=0x204f14000d58, new_db=new_db@entry=0x204f140058e8, new_name=<optimized out>, create_info=create_info@entry=0x64fe140e54b0, table_list=<optimized out>, 

    table_list@entry=0x204f140137b0, recreate_info=recreate_info@entry=0x64fe140e5300, alter_info=<optimized out>, order_num=<optimized out>, order=<optimized out>, ignore=<optimized out>, 

    if_exists=<optimized out>) at /data/Server/10.11-MDEV-29445F/sql/sql_table.cc:11348

#14 0x0000651a335b2c85 in Sql_cmd_alter_table::execute (this=<optimized out>, thd=0x204f14000d58) at /data/Server/10.11-MDEV-29445F/sql/sql_alter.cc:688

#15 0x0000651a334865a3 in mysql_execute_command (thd=thd@entry=0x204f14000d58, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /data/Server/10.11-MDEV-29445F/sql/sql_parse.cc:6167

#16 0x0000651a33487131 in mysql_parse (thd=thd@entry=0x204f14000d58, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x64fe140e6400)

    at /data/Server/10.11-MDEV-29445F/sql/sql_parse.cc:8188

#17 0x0000651a3348879d in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x204f14000d58, 

    packet=packet@entry=0x204f1400b0c9 " ALTER TABLE t7 DROP COLUMN col_string /* E_R Thread2 QNO 30 CON_ID 16 */ ", packet_length=packet_length@entry=74, blocking=blocking@entry=true)

    at /data/Server/10.11-MDEV-29445F/sql/sql_parse.cc:1905

#18 0x0000651a33489c3b in do_command (thd=thd@entry=0x204f14000d58, blocking=blocking@entry=true) at /data/Server/10.11-MDEV-29445F/sql/sql_parse.cc:1418

#19 0x0000651a335ab9af in do_handle_one_connection (connect=<optimized out>, connect@entry=0x651a36582fb8, put_in_cache=put_in_cache@entry=true) at /data/Server/10.11-MDEV-29445F/sql/sql_connect.cc:1386

#20 0x0000651a335abbc0 in handle_one_connection (arg=0x651a36582fb8) at /data/Server/10.11-MDEV-29445F/sql/sql_connect.cc:1298

#21 0x000033b20b795a94 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:447

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

(rr)

sdp:/data/results/1741269400/TBR-1983--TBR-1788$ _RR_TRACE_DIR=./1/rr rr replay --mark-stdio

RQG

====

# git clone https://github.com/mleich1/rqg  RQG

#

# GIT_SHOW: HEAD -> master, origin/master, origin/HEAD be3b5d9200c1ee3980b5deecb9856b078ba7ed00 2025-02-28T21:46:24+01:00

# rqg.pl  : Version 4.5.0 (2023-12)

#

# $RQG_HOME/rqg.pl \

# --duration=300 \

# --queries=10000000 \

# --no_mask \

# --seed=random \

# --vardir_type=fast \

# --rpl_mode=none \

# --engine=InnoDB \

# --max_gd_duration=1200 \

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

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

# --mysqld=--loose-idle_readonly_transaction_timeout=0 \

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

# --mysqld=--loose-table_lock_wait_timeout=50 \

# --mysqld=--net_read_timeout=30 \

# --mysqld=--log-output=none \

# --mysqld=--log_bin_trust_function_creators=1 \

# --mysqld=--slave_net_timeout=60 \

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

# --mysqld=--innodb_page_size=64K \

# --mysqld=--interactive_timeout=28800 \

# --mysqld=--log-bin \

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

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

# --mysqld=--loose-debug_assert_on_not_freed_memory=0 \

# --mysqld=--wait_timeout=28800 \

# --mysqld=--file-key-management-filename=$RQG_HOME/conf/mariadb/encryption_keys.txt \

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

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

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

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

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

# --mysqld=--net_write_timeout=60 \

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

# --mysqld=--connect_timeout=60 \

# --mysqld=--loose_innodb_lock_schedule_algorithm=fcfs \

# --mysqld=--loose-idle_transaction_timeout=0 \

# --mysqld=--sql_mode=STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION \

# --mysqld=--loose-idle_write_transaction_timeout=0 \

# --reporters=Deadlock,None \

# --validators=None \

# --grammar=TBR-1983--TBR-1788.yy \

# --threads=2 \

# <local settings>

How to replay the problem faster?

./REPLAY_SIMP.sh TBR-1983--TBR-1788.cfg <path to MariaDB install>