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:

                Git Integration

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