Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-21125

Crash with FTS query

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Blocker
    • Resolution: Fixed
    • 10.4.10
    • 10.4.11
    • Optimizer
    • 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

          Activity

            People

              igor Igor Babaev
              yverry Yann
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.