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

Shutdown hangs after altering innodb partition fts table

    XMLWordPrintable

Details

    Description

      Shutdown keeps on hanging because purge threads are waiting on purge_sys.check_stop_FTS()

      --source include/have_partition.inc
      --source include/have_innodb.inc
      create table t1 (f1 int, f2 char(100))engine=innodb partition by hash(f1) partitions 2;
      ALTER TABLE t1 ADD FULLTEXT(f2);
      set global innodb_fast_shutdown=0;
      --source include/restart_mysqld.inc
      DROP TABLE t1;
      

      stop_FTS is being called for each partition, but it calls resume_FTS() only once in alter command.

      Attachments

        Issue Links

          Activity

            People

              thiru Thirunarayanan Balathandayuthapani
              thiru Thirunarayanan Balathandayuthapani
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.