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

Can't selectively restore sequences using innodb tables from backup

Details

    Description

      When wanting to do a selective restore of a backup taken with mariabackup DISCARD TABLESPACE / IMPORT TABLESPACE is used after preparing the backup with mariabackup --prepare --export

      When having a SEQUENCE backed by an InnoDB table the related .ibd tablespace file can't be discarded though:

      MariaDB [test]> alter table test_sequence discard tablespace;
      ERROR 1031 (HY000): Storage engine SEQUENCE of the table `test`.`test_sequence` doesn't have this option
      

      So there does not seem to be a way to restore such a sequence from a physical backup like mariabackup.

      IMHO the SEQUENCE engine here should not just outright refuse such ALTER attempts, but pass them through to the underlying engine actually used for sequence storage.

      Attachments

        Issue Links

          Activity

            Transition Time In Source Status Execution Times
            Marko Mäkelä made transition -
            Open Confirmed
            2d 46m 1
            Michael Widenius made transition -
            Confirmed In Progress
            262d 3h 46m 1
            JiraAutomate made transition -
            In Progress Stalled
            62d 3h 28m 1
            Michael Widenius made transition -
            Stalled In Progress
            43d 19h 10m 1
            Michael Widenius made transition -
            In Progress In Testing
            1d 2h 57m 1
            Elena Stepanova made transition -
            In Testing Stalled
            4d 20h 51m 1
            Michael Widenius made transition -
            Stalled Closed
            2d 3h 4m 1

            People

              monty Michael Widenius
              hholzgra Hartmut Holzgraefe
              Votes:
              0 Vote for this issue
              Watchers:
              6 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.