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

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

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-21471 ER_CRASHED_ON_USAGE upon UPDATE FOR PORTION on Aria table

          • Major - Major loss of function.
          • Closed

          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.