#
|
# MDEV-25200 Index count mismatch due to aborted FULLTEXT INDEX
|
#
|
CREATE TABLE t1(a INT, b TEXT, c TEXT, FULLTEXT INDEX(b)) ENGINE=InnoDB;
|
connect con1,localhost,root,,test;
|
SET DEBUG_DBUG="+d,innodb_OOM_inplace_alter";
|
SET DEBUG_SYNC='innodb_commit_inplace_alter_table_enter SIGNAL s2 WAIT_FOR g2';
|
ALTER TABLE t1 ADD FULLTEXT(c);
|
connection default;
|
SET DEBUG_SYNC='now WAIT_FOR s2';
|
START TRANSACTION;
|
SELECT * FROM t1;
|
a b c
|
SET DEBUG_SYNC='now SIGNAL g2';
|
connection con1;
|
ERROR HY000: Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space
|
disconnect con1;
|
connection default;
|
SET DEBUG_SYNC=RESET;
|
ALTER TABLE t1 ADD bl INT AS (LENGTH(b)) VIRTUAL;
|
Warnings:
|
Warning 1082 InnoDB: Table test/t1 contains 2 indexes inside InnoDB, which is different from the number of indexes 1 defined in the MariaDB
|
CHECK TABLE t1;
|
Table Op Msg_type Msg_text
|
test.t1 check status OK
|
DROP TABLE t1;
|
innodb_fts.f3 'innodb' [ fail ] Found warnings/errors in server log file!
|
Test ended at 2021-06-17 15:26:28
|
line
|
2021-06-17 15:26:28 139763778254592 [ERROR] InnoDB: Table test/t1 contains 2 indexes inside InnoDB, which is different from the number of indexes 1 defined in the MariaDB Have you mixed up .frm files from different installations? See https://mariadb.com/kb/en/innodb-troubleshooting/
|
^ Found warnings in /home/thiru/mariarepo/10.2/10.2-sample/bld_sample-debug/mysql-test/var/log/mysqld.1.err
|
|