Details
-
Bug
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Fixed
-
10.4.10
-
debian buster amd64
Description
Hi,
I've just switch from mysql5.7 to mariadb10.4.10
I got many mysql crash when FTS is used.
I made a simple query:
select * from qz_forum_topic where id_forum = '1284' AND status = '1' AND MATCH (sujet) AGAINST ('bad gate' IN BOOLEAN MODE) ORDER BY sujet
-> mysql crash immediatly
table desc:
qz_forum_topic | CREATE TABLE `qz_forum_topic` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_forum` mediumint(9) NOT NULL DEFAULT 0,
`sujet` varchar(255) NOT NULL DEFAULT '',
`resume` varchar(255) NOT NULL,
`date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`login` varchar(30) NOT NULL DEFAULT '',
`dernier_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`dernier_login` varchar(30) NOT NULL DEFAULT '',
`nb_reponses` int(11) NOT NULL DEFAULT 0,
`intervenant` varchar(30) NOT NULL DEFAULT '',
`date_intervention` datetime NOT NULL,
`date_suppression_groupe` date NOT NULL,
`blocked` tinyint(1) NOT NULL DEFAULT 0,
`post_it` tinyint(4) NOT NULL DEFAULT 0,
`public` enum('','admins','adjoints') NOT NULL,
`status` tinyint(1) NOT NULL DEFAULT 1,
PRIMARY KEY (`id`),
KEY `id_forum` (`id_forum`),
KEY `post_it` (`post_it`),
KEY `status` (`status`),
KEY `dernier_date` (`dernier_date`),
KEY `sujet` (`sujet`),
KEY `login` (`login`),
FULLTEXT KEY `search_nom` (`sujet`)
) ENGINE=InnoDB AUTO_INCREMENT=114559 DEFAULT CHARSET=latin1
debug symbols:
(gdb) list *0xb0cc14
0xb0cc14 is in row_sel_field_store_in_mysql_format_func(unsigned char*, mysql_row_templ_t const*, unsigned char const*, unsigned long) (./storage/innobase/row/row0sel.cc:2864).
2859 in ./storage/innobase/row/row0sel.cc
(gdb) list *0xb0cda9
0xb0cda9 is in row_sel_store_mysql_field(byte*, row_prebuilt_t*, rec_t const*, dict_index_t const*, ulint const*, ulint, mysql_row_templ_t const*) (./storage/innobase/row/row0sel.cc:3011).
3006 in ./storage/innobase/row/row0sel.cc
(gdb) list *0xb0d4e4
0xb0d4e4 is in row_search_idx_cond_check(byte*, row_prebuilt_t*, rec_t const*, ulint const*) (./storage/innobase/row/row0sel.cc:3921).
3916 in ./storage/innobase/row/row0sel.cc
(gdb) list *0xb0ff75
0xb0ff75 is in row_search_mvcc(unsigned char*, page_cur_mode_t, row_prebuilt_t*, unsigned long, unsigned long) (./storage/innobase/row/row0sel.cc:5257).
5252 in ./storage/innobase/row/row0sel.cc
(gdb) list *0xa3d11d
0xa3d11d is in ha_innobase::ft_read(unsigned char*) (./storage/innobase/include/row0sel.ic:137).
132 ./storage/innobase/include/row0sel.ic: No such file or directory.
I think this is similar with MDEV-21047 but without 100% confidence with that
Attachments
Issue Links
- relates to
-
MDEV-21040 InnoDB: fulltext search with ` in(...)` crashed on specific combination
- Closed
-
MDEV-21047 Crash on UTF-8 Full text search
- Closed
-
MDEV-20407 mysqld got signal 11; rowid filter
- Closed