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

Shutdown hangs after altering innodb partition fts table

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

          is caused by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-25506 Atomic DDL: .frm file is removed and orphan InnoDB tablespace is left behind upon crash recovery

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            thiru Thirunarayanan Balathandayuthapani created issue -
            thiru Thirunarayanan Balathandayuthapani made changes -
            Field Original Value New Value
            thiru Thirunarayanan Balathandayuthapani made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            thiru Thirunarayanan Balathandayuthapani made changes -
            Assignee Thirunarayanan Balathandayuthapani [ thiru ] Marko Mäkelä [ marko ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            marko Marko Mäkelä added a comment -

            Thank you, the logic of the fix looks good to me. For the regression test, I hope that we can reproduce this with wait_all_purged.inc instead of requiring a server restart.

            marko Marko Mäkelä added a comment - Thank you, the logic of the fix looks good to me. For the regression test, I hope that we can reproduce this with wait_all_purged.inc instead of requiring a server restart.
            marko Marko Mäkelä made changes -
            Assignee Marko Mäkelä [ marko ] Thirunarayanan Balathandayuthapani [ thiru ]
            Status In Review [ 10002 ] Stalled [ 10000 ]
            marko Marko Mäkelä made changes -
            Fix Version/s 10.6.8 [ 27506 ]
            Fix Version/s 10.7.4 [ 27504 ]
            Fix Version/s 10.8.3 [ 27502 ]
            Fix Version/s 10.6 [ 24028 ]
            Fix Version/s 10.7 [ 24805 ]
            Fix Version/s 10.8 [ 26121 ]
            Resolution Fixed [ 1 ]
            Status Stalled [ 10000 ] Closed [ 6 ]

            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.