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

Drop default history partitions renders table inaccessible

    XMLWordPrintable

    Details

      Description

      Reproduce

      --source include/have_partition.inc
      --source include/have_innodb.inc
       
      create or replace table t1 (i int) with system versioning
      partition by system_time limit 1 partitions 5;
       
      alter table t1 drop partition p0, p2;
      show create table t1;
      alter table t1 add partition partitions 1;
      show create table t1;
       
      drop tables t1;
      

      Result

      mysqltest: At line 10: query 'show create table t1' failed: 1017: Can't find file: './test/t1.MYI' (errno: 2 "No such file or directory")
      

      Notes

      This is continuation of MDEV-22153 bug when contiguity of history partition is broken. ha_partition::open_read_partitions() can not handle non-contiguous list of default partitions.

      Fix

      When default partition is dropped convert list of partitions to non-default.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              midenok Aleksey Midenkov
              Reporter:
              midenok Aleksey Midenkov
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: