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

INNODB_ERROR|Flagged corruption of `iv` in table X.X in CHECK TABLE; Wrong count

    XMLWordPrintable

Details

    • Can result in unexpected behaviour

    Description

        --source include/have_innodb.inc
        --source include/have_debug_sync.inc
        --echo #
        --echo # Online ADD INDEX on a virtual column which is not part of any index yet.
        --echo # A concurrent INSERT writes NULL for the virtual column into the new index.
        --echo #
        CREATE TABLE t (id INT PRIMARY KEY, k INT NOT NULL, v INT AS (k + 3) VIRTUAL) ENGINE=InnoDB;
        INSERT INTO t (id, k) VALUES (1, 1);
        --connect (con1,localhost,root,,test)
        SET DEBUG_SYNC = 'row_log_apply_before SIGNAL built WAIT_FOR go';
        --send ALTER TABLE t ADD KEY iv (v)
        --connection default
        SET DEBUG_SYNC = 'now WAIT_FOR built';
        INSERT INTO t (id, k) VALUES (2, 10);
        SET DEBUG_SYNC = 'now SIGNAL go';
        --connection con1
        --reap
        --disconnect con1
        --connection default
        SET DEBUG_SYNC = 'RESET';
        --echo # Correct result: (1,4) and (2,13)
        SELECT id, v FROM t FORCE INDEX (iv);
        CHECK TABLE t EXTENDED;
        DROP TABLE t;
      

      Leads to:

      2026-09-23  7:20:01 4 [ERROR] InnoDB: Flagged corruption of `iv` in table `test`.`t` in CHECK TABLE; Wrong count
      

      Bug Detection Matrix

          Rel    o/d  Build   Commit                                    UniqueID observed             
      CS  10.11  dbg  090926  2753b5919a10abd32ba822877c6a1cbf602d3748  No bug found                  
      CS  10.11  opt  090926  2753b5919a10abd32ba822877c6a1cbf602d3748  No bug found                  
      CS  11.4   dbg  090926  42038e1145dd43b3910055c364fb720a8a152d61  INNODB_ERROR|Flagged corruption of `iv` in table X.X in CHECK TABLE; Wrong count
      CS  11.4   opt  090926  42038e1145dd43b3910055c364fb720a8a152d61  No bug found                  
      CS  11.8   dbg  090926  e2e060ce3d8c3ce11b6c7ba28ced0f1a30c50a54  INNODB_ERROR|Flagged corruption of `iv` in table X.X in CHECK TABLE; Wrong count
      CS  11.8   opt  090926  e2e060ce3d8c3ce11b6c7ba28ced0f1a30c50a54  No bug found                  
      CS  12.3   dbg  090926  e9f84a1fdf7093191e55b55dc14b08b9d4ebaa20  INNODB_ERROR|Flagged corruption of `iv` in table X.X in CHECK TABLE; Wrong count
      CS  12.3   opt  090926  e9f84a1fdf7093191e55b55dc14b08b9d4ebaa20  No bug found                  
      CS  13.0   dbg  090926  b2c4e675049e23ce8c7346985f40840fcd4e583f  INNODB_ERROR|Flagged corruption of `iv` in table X.X in CHECK TABLE; Wrong count
      CS  13.0   opt  090926  b2c4e675049e23ce8c7346985f40840fcd4e583f  No bug found                  
      CS  13.1   dbg  090926  02c842c30dcb05a962eaac58c69920e6be3369cf  INNODB_ERROR|Flagged corruption of `iv` in table X.X in CHECK TABLE; Wrong count
      CS  13.1   opt  090926  02c842c30dcb05a962eaac58c69920e6be3369cf  No bug found                  
      ES  10.6   dbg  090926  aa3fb9800c358182ee2a1f8cca8ffbdd6d0a37eb  INNODB_ERROR|Flagged corruption of `iv` in table X.X in CHECK TABLE; Wrong count
      ES  10.6   opt  090926  aa3fb9800c358182ee2a1f8cca8ffbdd6d0a37eb  No bug found                  
      ES  11.4   dbg  090926  32807340954440071ca8ae8e2de51fb180d134c6  INNODB_ERROR|Flagged corruption of `iv` in table X.X in CHECK TABLE; Wrong count
      ES  11.4   opt  090926  32807340954440071ca8ae8e2de51fb180d134c6  No bug found                  
      ES  11.8   dbg  090926  c4af6f687a2dd983072457429aa2294f11957650  INNODB_ERROR|Flagged corruption of `iv` in table X.X in CHECK TABLE; Wrong count
      ES  11.8   opt  090926  c4af6f687a2dd983072457429aa2294f11957650  No bug found                  
      ES  12.3   dbg  090926  c3bd5108d81f19e33efb93f7b6ae971293732fd0  INNODB_ERROR|Flagged corruption of `iv` in table X.X in CHECK TABLE; Wrong count
      ES  12.3   opt  090926  c3bd5108d81f19e33efb93f7b6ae971293732fd0  No bug found                  
      

      Attachments

        Activity

          People

            thiru Thirunarayanan Balathandayuthapani
            saahil Saahil Alam
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0d
                0d
                Logged:
                Time Spent - 1h
                1h

                Git Integration

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