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

ER_CRASHED_ON_USAGE (Table is marked as crashed and should be repaired) upon update on versioned Aria table

    XMLWordPrintable

Details

    Description

      CREATE TABLE t1 (a VARCHAR(8), s TIMESTAMP(6) AS ROW START, e TIMESTAMP(6) AS ROW END, PERIOD FOR SYSTEM_TIME (s,e)) ENGINE=Aria ROW_FORMAT=Fixed WITH SYSTEM VERSIONING;
      INSERT INTO t1 (a) VALUES ('foo');
      UPDATE t1 SET a = 'bar';
       
      # Cleanup
      DROP TABLE t1;
      

      10.3 b96e4424

      mysqltest: At line 3: query 'UPDATE t1 SET a = 'bar'' failed: 1194: Table 't1' is marked as crashed and should be repaired
      

      Reproducible on earlier versions as well.
      Couldn't reproduce without ROW_FORMAT=Fixed.
      Possibly unrelated to versioning, but I couldn't make a test case without it.

      Attachments

        Issue Links

          Activity

            People

              midenok Aleksey Midenkov
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

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

                  Git Integration

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