S3 Storage engine (MDEV-17841)

[MDEV-19463] Altering sequence to S3 leaves unremovable garbage behind Created: 2019-05-13  Updated: 2019-05-22  Resolved: 2019-05-22

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

Type: Technical task Priority: Major
Reporter: Elena Stepanova Assignee: Michael Widenius
Resolution: Fixed Votes: 0
Labels: None

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

 Description   

maria-s3 a9499a38

MariaDB [test]> create sequence s1;
Query OK, 0 rows affected (0.495 sec)
 
MariaDB [test]> alter table s1 engine=S3;
ERROR 1025 (HY000): Error on rename of './test/#sql-6beb_a' to './test/s1' (errno: 1 "Operation not permitted")
MariaDB [test]> show warnings;
+-------+------+---------------------------------------------------------------------------------------------+
| Level | Code | Message                                                                                     |
+-------+------+---------------------------------------------------------------------------------------------+
| Error | 1025 | Error on rename of './test/#sql-6beb_a' to './test/s1' (errno: 1 "Operation not permitted") |
+-------+------+---------------------------------------------------------------------------------------------+
1 row in set (0.000 sec)

MariaDB [test]> show tables;
+----------------+
| Tables_in_test |
+----------------+
| #sql2_3d73_4   |
| s1             |
+----------------+

#sql2_3d73_4 is quite persistent, it survives drop database:

MariaDB [test]> drop database test;
Query OK, 1 row affected, 1 warning (0.298 sec)
 
MariaDB [(none)]> show warnings;
+-------+------+-------------------------------------------------+
| Level | Code | Message                                         |
+-------+------+-------------------------------------------------+
| Error |  155 | Table test.@0023sql2_3d73_4 doesn't exist in s3 |
+-------+------+-------------------------------------------------+
1 row in set (0.000 sec)
 
MariaDB [(none)]> create database test;
Query OK, 1 row affected (0.000 sec)
 
MariaDB [(none)]> show tables in test;
+----------------+
| Tables_in_test |
+----------------+
| #sql2_3d73_4   |
+----------------+
1 row in set (0.116 sec)



 Comments   
Comment by Michael Widenius [ 2019-05-22 ]

Fixed in main s3 tree and test case added

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