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

ER_CRASHED_ON_USAGE upon DML and OPTIMIZE on temporary Aria table

    XMLWordPrintable

    Details

      Description

      Note: There was a very similar bug MDEV-19595. However the test case there was only failing on 10.2+, so the bug was fixed in 10.2+. The test case below reveals the same problem on 5.5 and 10.1. On 10.2+ it stopped failing after the fix for MDEV-19595, so it's apparently the same problem. I don't expect it to be fixed in 10.1 which is at the moment 3 major releases behind the latest one; but tests on 10.1 are still running, and the bug affects them, so I need it to be filed. It will quietly expire when 5.5 and 10.1 go EOL.

      CREATE TEMPORARY TABLE t1 (a INT) ROW_FORMAT=DYNAMIC ENGINE=Aria;
      INSERT INTO t1 VALUES (1);
      DELETE FROM t1 LIMIT 2;
      OPTIMIZE TABLE t1;
      INSERT INTO t1 VALUES (2);
      DELETE FROM t1 LIMIT 2;
      

      10.1 cb204e11

      mysqltest: At line 6: query 'DELETE FROM t1 LIMIT 2' failed: 1194: Table 't1' is marked as crashed and should be repaired
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated: