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

Versioned temporary table is marked as crashed and should be repaired

    XMLWordPrintable

Details

    Description

      Note: The problem is likely to go away after MDEV-14769 is fixed, so it will stay draft for now.

      CREATE TEMPORARY TABLE table11_aria ( `col_int_key` INT) ENGINE=Aria;
      INSERT INTO table11_aria VALUES (1),(2);
      SET STATEMENT system_versioning_alter_history=KEEP FOR ALTER TABLE `table11_aria` ADD SYSTEM VERSIONING, ROW_FORMAT=DYNAMIC;
      UPDATE table11_aria SET `col_int_key` = 3;
      SET STATEMENT system_versioning_alter_history=KEEP FOR ALTER TABLE `table11_aria` ADD COLUMN IF NOT EXISTS `vers_end` BIGINT UNSIGNED GENERATED ALWAYS AS ROW END;
      DELETE HISTORY FROM `table11_aria`;
      OPTIMIZE TABLE `table11_aria`;
      UPDATE table11_aria SET `col_int_key` = 2;
      

      bb-10.3-temporal ea49441c41

      mysqltest: At line 8: query 'UPDATE table11_aria SET `col_int_key` = 2' failed: 1194: Table 'table11_aria' is marked as crashed and should be repaired
      

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.