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

Server crashes in fts_is_sync_needed upon timed out FLUSH TABLES after unsuccessful ADD FOREIGN KEY

    XMLWordPrintable

Details

    Description

      Note: I can't say whether the problem is new, because until recently the test case failed with MDEV-17432 (and it still does on 10.3+).

      Run the test case with --repeat=N. It usually fails for me on the 2nd attempt. Possibly when the reason is known, it can be converted into a deterministic test case. It would also be good to get rid of the long lock_wait_timeout.

      --source include/have_innodb.inc
       
      CREATE TABLE t1 ( 
        pk INT AUTO_INCREMENT,
        c CHAR(105) NOT NULL DEFAULT '',
        PRIMARY KEY(pk),
        FULLTEXT KEY(c)
      ) ENGINE=InnoDB;
       
      --error ER_CANT_CREATE_TABLE
      ALTER TABLE t1 ADD FOREIGN KEY (c) REFERENCES x(x);
      LOCK TABLE t1 READ;
       
      --connect (con1,localhost,root,,test)
       
      SET lock_wait_timeout= 10;
      --error ER_LOCK_WAIT_TIMEOUT
      FLUSH TABLES;
       
      # Cleanup
      --disconnect con1
      --connection default
      UNLOCK TABLES;
      DROP TABLE t1;
      

      10.2 5ec9b88e1

      #3  <signal handler called>
      #4  0x000055bb3f86e67b in fts_is_sync_needed (tables=0x55bb424f0508) at /data/src/10.2-bug/storage/innobase/fts/fts0opt.cc:2805
      #5  0x000055bb3f86e9cc in fts_optimize_thread (arg=0x55bb424f02a0) at /data/src/10.2-bug/storage/innobase/fts/fts0opt.cc:2901
      #6  0x00007f7d723be494 in start_thread (arg=0x7f7d577fe700) at pthread_create.c:333
      #7  0x00007f7d709bf93f in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      Attachments

        Activity

          People

            marko Marko Mäkelä
            elenst Elena Stepanova
            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.