Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-17841 S3 Storage engine
  3. MDEV-19464

Altering partitioned table into S3 causes an obscure error

Details

    Description

      a9499a38

      MariaDB [elenst]> create table t1 (a int) partition by hash(a);
      Query OK, 0 rows affected (0.477 sec)
       
      MariaDB [elenst]> alter table t1 engine=S3;
      ERROR 155 (HY000): Table elenst.#sql-45b7_a#P#p0 doesn't exist in s3
      MariaDB [elenst]> show warnings;                   
      +-------+------+--------------------------------------------------------------------------------------------------------------------------+
      | Level | Code | Message                                                                                                                  |
      +-------+------+--------------------------------------------------------------------------------------------------------------------------+
      | Error |  155 | Table elenst.#sql-45b7_a#P#p0 doesn't exist in s3                                                                        |
      | Error | 1025 | Error on rename of './elenst/#sql-45b7_a' to './elenst/t1' (errno: 155 "The table does not exist in the storage engine") |
      +-------+------+--------------------------------------------------------------------------------------------------------------------------+
      2 rows in set (0.000 sec)
      

      Maybe partitioning is not supported for S3, but then it could produce a better message.

      Attachments

        Issue Links

          Activity

            elenst Elena Stepanova created issue -
            elenst Elena Stepanova made changes -
            Field Original Value New Value
            Status Open [ 1 ] Confirmed [ 10101 ]
            elenst Elena Stepanova made changes -
            Status Confirmed [ 10101 ] Open [ 1 ]
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            Component/s Storage Engine - S3 [ 15100 ]
            vlad.lesin Vladislav Lesin made changes -
            Status Open [ 1 ] Confirmed [ 10101 ]
            vlad.lesin Vladislav Lesin made changes -
            Assignee Michael Widenius [ monty ] Vladislav Lesin [ vlad.lesin ]
            vlad.lesin Vladislav Lesin made changes -
            Status Confirmed [ 10101 ] In Progress [ 3 ]
            vlad.lesin Vladislav Lesin added a comment - - edited The fix for 10.5: https://github.com/vlad-lesin/mariadb-server/tree/bb-10.5-MDEV-19464-s3-parts Testing: https://buildbot.askmonty.org/buildbot/grid?category=main&branch=bb-10.5-MDEV-19464-s3-parts
            vlad.lesin Vladislav Lesin made changes -

            Merged to 10.5, commit 878ad986.

            vlad.lesin Vladislav Lesin added a comment - Merged to 10.5, commit 878ad986.
            vlad.lesin Vladislav Lesin made changes -
            Fix Version/s 10.5.0 [ 23709 ]
            Fix Version/s N/A [ 14700 ]
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 96712 ] MariaDB v4 [ 156183 ]

            People

              vlad.lesin Vladislav Lesin
              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.