InnoDB: Table test/t4 contains 4 indexes inside InnoDB, which is different from the number of indexes 3 defined in the MariaDB

Workflow:

1. Start the server and create some initial data

2. Nine sessions run some concurrent DDL/DML mix

3. During 2. one session harvests for CHECK TABLE t4

    Warning InnoDB: Table test/t4 contains 4 indexes inside InnoDB, which is different

    from the number of indexes 3 defined in the MariaDB.

    Initiated by that the RQG runner "reacts" by sending SIGABRT to the DB server process.

The table t4 is most probably with InnoDB Page_format = redundant.

But its not known if that property is important at all.

origin/bb-10.3-MDEV-23072 36f5ea8b1092099e7ad96251bdefd43142bbe6c3 2020-10-19T22:18:29+05:30 compiled with debug+ASAN+Og

RQG

====

git clone https://github.com/mleich1/rqg --branch experimental RQG

perl rqg.pl \ 

--grammar=conf/mariadb/table_stress_innodb.yy \

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

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

--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=120 \

--duration=400 \

--mysqld=--loose-innodb_fatal_semaphore_wait_threshold=400 \

--mysqld=--innodb_stats_persistent=off \

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

--threads=9 \

--mysqld=--innodb_page_size=32K \

--mysqld=--innodb-buffer-pool-size=24M \

--duration=400 \

--no_mask \

--workdir=<local settings> \

--vardir=<local settings> \

--mtr-build-thread=<local settings> \

--basedir1=<local settings> \

--script_debug=_nix_ \

--rr=Server \

--rr_options=--chaos