[MDEV-33130] Dump restore S3 partition table --no-data lead to unusable tables Created: 2023-12-27  Updated: 2023-12-28

Status: Open
Project: MariaDB Server
Component/s: Storage Engine - S3
Affects Version/s: 10.11
Fix Version/s: None

Type: Bug Priority: Major
Reporter: VAROQUI Stephane Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None


 Description   

mysqldump the structure of s3 partition tables give illegal mixed storage table as the main table is aria and partitions are S3

Following such dump and restore probably break .par and .frm filles that make auto table discovered failure

Note on minio the full dataset is still available in S3 while drop table should have destroyed the data

Need to rm -rf all S3 buckets to recover a fully working database

Flush tables did not help to recover the S3 tables when all data was still in S3 after restore of table definition


Generated at Thu Feb 08 10:36:37 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.