[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 |