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

Corruption errors upon CHECK on temporary InnoDB table

    XMLWordPrintable

Details

    Description

      --source include/have_innodb.inc
       
      CREATE TEMPORARY TABLE t (f INT, UNIQUE(f)) ENGINE=InnoDB;
      INSERT INTO t (f) VALUES (1),(2);
      CHECK TABLE t;
       
      # Cleanup
      DROP TABLE t;
      

      10.6 c4ce012e

      CHECK TABLE t;
      Table	Op	Msg_type	Msg_text
      test.t	check	Warning	InnoDB: Invalid PAGE_MAX_TRX_ID=0 in index 'f'
      test.t	check	Warning	InnoDB: Invalid PAGE_MAX_TRX_ID=0 in index 'f'
      test.t	check	Warning	InnoDB: The B-tree of index f is corrupted.
      test.t	check	Warning	InnoDB: Index 'f' contains 0 entries, should be 2.
      test.t	check	error	Corrupt
      DROP TABLE t;
      bug.15453 'innodb'                       [ fail ]  Found warnings/errors in server log file!
              Test ended at 2022-11-08 16:59:22
      line
      2022-11-08 16:59:21 4 [ERROR] InnoDB: Unable to flag corruption of `f` in table `mysqld.1`.`#sql-temptable-2a260c-4-f` in CHECK TABLE-check index
      

      The errors started showing up after

      commit ab0190101b0587e0e03b2d75a967050b9a85fd1b
      Author: Marko Mäkelä
      Date:   Fri Oct 21 10:02:54 2022 +0300
       
          MDEV-24402: InnoDB CHECK TABLE ... EXTENDED
      

      Attachments

        Issue Links

          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.