Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.3.7, 10.4.0, 10.3.20, 10.5.0
-
CentOS 7.7.1908 - kernel 3.10.0-1062.7.1.el7.x86_64
Description
While issuing ALTER on a InnoDB table with FTS MariaDB breaks with a segmentation fault:
kernel: mysqld[812]: segfault at 0 ip 00005649f0b31ac8 sp 00007febffffd0b0 error 6 in mysqld[5649efe3e000+12c9000]
MariaDB [test]> optimize table t;
-----------------------------------------------------------------------------------------+
Table | Op | Msg_type | Msg_text |
-----------------------------------------------------------------------------------------+
test.t | optimize | note | Table does not support optimize, doing recreate + analyze instead |
test.t | optimize | status | OK |
-----------------------------------------------------------------------------------------+
2 rows in set (10.312 sec)
MariaDB [test]> optimize table t;
-----------------------------------------------------------------------------------------+
Table | Op | Msg_type | Msg_text |
-----------------------------------------------------------------------------------------+
test.t | optimize | note | Table does not support optimize, doing recreate + analyze instead |
test.t | optimize | status | OK |
-----------------------------------------------------------------------------------------+
2 rows in set (6.379 sec)
MariaDB [test]> optimize table t;
ERROR 2013 (HY000): Lost connection to MySQL server during query
MariaDB [test]> optimize table t;
ERROR 2013 (HY000): Lost connection to MySQL server during query
MariaDB [test]> optimize table t;
ERROR 2013 (HY000): Lost connection to MySQL server during query
We managed to replicate this after around 3 consecutive calls of ALTER TABLE t ENGINE=InnoDB; after the initial data import.
If we remove the FTS index there are no more issues.
It seems the issue appears on FTS index merge, recreate.
I've attached to this ticket the backtrace, MariaDB log, configuration and sample data used to replicate the issue.
If you require any additional info, just let me know.
Attachments
Issue Links
- relates to
-
MDEV-21907 Enable -Wconversion for InnoDB and Mariabackup
- Closed