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

Connect: "table is marked as crashed and should be repaired" upon DELETE inside trx

    XMLWordPrintable

Details

    • Can result in data loss

    Description

      # mysqld options required for replay:  --log-bin
      INSTALL SONAME 'ha_connect';
      CREATE TABLE t1 (c INT) ENGINE=InnoDB;
      CREATE TABLE t2 (c BINARY, d DATE) ENGINE=Connect PARTITION BY RANGE COLUMNS (c) (PARTITION p VALUES LESS THAN (x'FF'));
      INSERT INTO t2 VALUES (0,0);
      BEGIN;   # or: XA START 'a';
      INSERT INTO t1 VALUES (1);
      DELETE FROM t2;
      

      Leads to:

      CS 12.2.0 fd15fd2765b53d0c070dd01d86fb231024b8f284 (Debug, Clang 21.1.3-20250923) Build 10/11/2025

      12.2.0-dbg>DELETE FROM t2;
      ERROR 1194 (HY000): Table 't2' is marked as crashed and should be repaired
      

      CS 12.2.0 fd15fd2765b53d0c070dd01d86fb231024b8f284 (Debug, Clang 21.1.3-20250923) Build 10/11/2025

      THIS TESTCASE DID NOT CRASH 12.2.0 (the version of the basedir in which you started this script), SO NO BACKTRACE IS SHOWN HERE. YOU CAN RE-EXECUTE THIS SCRIPT FROM ONE OF THE 'Bug confirmed present in' DIRECTORIES BELOW TO OBTAIN ONE, OR EXECUTE ./all_no_cl; ./test; ./stack FROM WITHIN THAT DIRECTORY TO GET A BACKTRACE ETC. MANUALLY!
      

      Bug Detection Matrix

          Rel    o/d  Build   Commit                                    UniqueID observed             
      CS  10.6   dbg  101125  759e3523e3d832b174cf0a612704da38b2557b40  MARIADBD_ERROR|mariadbd: Table table is marked as crashed and should be repaired
      CS  10.6   opt  101125  759e3523e3d832b174cf0a612704da38b2557b40  MARIADBD_ERROR|mariadbd: Table table is marked as crashed and should be repaired
      CS  10.11  dbg  101125  536cd151f0370216d9ba4c15f40c7037060972a5  MARIADBD_ERROR|mariadbd: Table table is marked as crashed and should be repaired
      CS  10.11  opt  101125  536cd151f0370216d9ba4c15f40c7037060972a5  MARIADBD_ERROR|mariadbd: Table table is marked as crashed and should be repaired
      CS  11.4   dbg  101125  a1bb5c94fda453baa99e57e3927eaa7cd3c8bafe  MARIADBD_ERROR|mariadbd: Table table is marked as crashed and should be repaired
      CS  11.4   opt  101125  a1bb5c94fda453baa99e57e3927eaa7cd3c8bafe  MARIADBD_ERROR|mariadbd: Table table is marked as crashed and should be repaired
      CS  11.8   dbg  101125  e0428264d0095472c015eb58c46be68ca1a320ee  MARIADBD_ERROR|mariadbd: Table table is marked as crashed and should be repaired
      CS  11.8   opt  101125  e0428264d0095472c015eb58c46be68ca1a320ee  MARIADBD_ERROR|mariadbd: Table table is marked as crashed and should be repaired
      CS  12.1   dbg  101125  ba00960fdaee67a4efff6866e31f446bf486a1c2  MARIADBD_ERROR|mariadbd: Table table is marked as crashed and should be repaired
      CS  12.1   opt  101125  ba00960fdaee67a4efff6866e31f446bf486a1c2  MARIADBD_ERROR|mariadbd: Table table is marked as crashed and should be repaired
      CS  12.2   dbg  101125  fd15fd2765b53d0c070dd01d86fb231024b8f284  MARIADBD_ERROR|mariadbd: Table table is marked as crashed and should be repaired
      CS  12.2   opt  101125  fd15fd2765b53d0c070dd01d86fb231024b8f284  MARIADBD_ERROR|mariadbd: Table table is marked as crashed and should be repaired
      ES  10.6   dbg  101125  f0d4d34fb0314b03fddb71fb9dbde372744a8c13  MARIADBD_ERROR|mariadbd: Table table is marked as crashed and should be repaired
      ES  10.6   opt  101125  f0d4d34fb0314b03fddb71fb9dbde372744a8c13  MARIADBD_ERROR|mariadbd: Table table is marked as crashed and should be repaired
      ES  11.4   dbg  101125  b81ec4b57a5ddce88b8e2b2d16b64625ffdaa0e6  MARIADBD_ERROR|mariadbd: Table table is marked as crashed and should be repaired
      ES  11.4   opt  101125  b81ec4b57a5ddce88b8e2b2d16b64625ffdaa0e6  MARIADBD_ERROR|mariadbd: Table table is marked as crashed and should be repaired
      ES  11.8   dbg  101125  db36e8fb3bcdae26dd0acdcb2b52f7f4eb014df6  MARIADBD_ERROR|mariadbd: Table table is marked as crashed and should be repaired
      ES  11.8   opt  101125  db36e8fb3bcdae26dd0acdcb2b52f7f4eb014df6  MARIADBD_ERROR|mariadbd: Table table is marked as crashed and should be repaired
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            Roel Roel Van de Paar
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.