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

Concurrent DDL on InnoDB table and REPAIR on InnoDB stats table leads to "table not found" error

    XMLWordPrintable

Details

    Description

      Before MDEV-33449, REPAIR on InnoDB stat tables wasn't supported. Now it is, and in some circumstances it leads to concurrency errors like the one here

      [ERROR] InnoDB: Table mysql.innodb_table_stats not found
      

      or lock wait timeouts.

      The use case as such (REPAIR on a stat table and concurrent ALTER) may be not that important, but I'm not at all sure it's limited to ALTER, and in general, when a part of operations in question involve activities happening under the hood, which a user has no control of (here it is doing something with the statistical table upon ALTER), it's potentially problematic.

      The test case is for reproducing purposes only, don't put it into the regression suite!

      --source include/have_innodb.inc
       
      CREATE TABLE t1 (a int) STATS_PERSISTENT=1 ENGINE=InnoDB;
      INSERT INTO t1 VALUES (1),(2);
       
      --connect (con1,localhost,root,,)
      --let $con1= `select connection_id()`
      --delimiter $
      --send
        loop
          ALTER TABLE t1 COMMENT 'comment', ALGORITHM=COPY;
        end loop $
      --delimiter ;
       
      --connection default
      --let SEARCH_FILE= $MYSQLTEST_VARDIR/log/mysqld.1.err
      --let SEARCH_PATTERN= Table .* not found
      --let $run= 100
      SET lock_wait_timeout= 1, innodb_lock_wait_timeout= 1;
      while ($run)
      {
        REPAIR TABLE mysql.innodb_table_stats;
        if ($mysql_errno) {
          --echo # Got error $mysql_errno upon ALTER
        }
        --source include/search_pattern_in_file.inc
          if ($SEARCH_RESULT) {
            die # FOUND the error line in the log;
        }
        --dec $run
      }
      --eval KILL $con1
       
      # Cleanup
      DROP TABLE t1;
      

      When it hits the problem, which happens always for me, it says

      mysqltest: At line 31: # FOUND the error line in the log
      

      and the error log contains the error line

      2024-04-20  1:36:57 5 [ERROR] InnoDB: Table mysql.innodb_table_stats not found.
      

      Additionally, lock wait timeouts can be seen in the test output:

      REPAIR TABLE mysql.innodb_table_stats;
      Table	Op	Msg_type	Msg_text
      mysql.innodb_table_stats	repair	Error	Lock wait timeout exceeded; try restarting transaction
      mysql.innodb_table_stats	repair	status	Table is already up to date
      

      Attachments

        Issue Links

          Activity

            People

              monty Michael Widenius
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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