S3 Storage engine (MDEV-17841)

[MDEV-19464] Altering partitioned table into S3 causes an obscure error Created: 2019-05-13  Updated: 2023-11-22  Resolved: 2019-08-01

Status: Closed
Project: MariaDB Server
Component/s: Data Definition - Alter Table, Partitioning, Storage Engine - S3
Affects Version/s: N/A
Fix Version/s: 10.5.0

Type: Technical task Priority: Minor
Reporter: Elena Stepanova Assignee: Vladislav Lesin
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Duplicate
Relates
relates to MDEV-19416 Test S3 Storage engine Closed

 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.



 Comments   
Comment by Vladislav Lesin [ 2019-06-11 ]

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

Comment by Vladislav Lesin [ 2019-08-01 ]

Merged to 10.5, commit 878ad986.

Generated at Thu Feb 08 08:51:54 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.