[MDEV-23733] s3.partition - alter table fail - 29: Expected object didn'texist Created: 2020-09-14  Updated: 2020-10-13

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

Type: Bug Priority: Major
Reporter: Daniel Black Assignee: Michael Widenius
Resolution: Unresolved Votes: 0
Labels: None
Environment:

minio setup per MDEV-2364
fc32


Attachments: Text File s3-server-logs.txt    

 Description   

bb-10.5-monty (6844212f01c65a8d78ff218d4f2a731a62e096f8)

s3.partition                             [ fail ]
        Test ended at 2020-09-14 17:14:54
 
CURRENT_TEST: s3.partition
mysqltest: At line 26: query 'ALTER TABLE t1 ADD COLUMN c INT' failed: 29: Expected object 's3_test_fd0016f1f65911eaa4becabbbeb0fc5c/t1#P#p0/data/000001' didn't exist
 
The result from queries just before the failure was:
< snip >
INSERT INTO t1 VALUE (1), (2), (101), (102), (201), (202);
ALTER TABLE t1 ENGINE=S3;
SELECT count(*) FROM t1;
count(*)
6
SHOW TABLES;
Tables_in_s3
t1
ALTER TABLE t1 COALESCE PARTITION 2;
ERROR 42000: Table 't1' uses an extension that doesn't exist in this MariaDB version
SHOW WARNINGS;
Level	Code	Message
Error	1112	Table 't1' uses an extension that doesn't exist in this MariaDB version
Error	6	Error on delete of './s3/t1#P#p0#TMP#.MAI' (Errcode: 2 "No such file or directory")
Error	6	Error on delete of './s3/t1#P#p0#TMP#.MAD' (Errcode: 2 "No such file or directory")
ALTER TABLE t1 ADD PARTITION PARTITIONS 6;
SELECT count(*) FROM t1;
count(*)
6
ALTER TABLE t1 ADD COLUMN c INT;
 
More results from queries before failure can be found in /home/dan/repos/build-mariadb-server-10.5/mysql-test/var/log/partition.log

Interesting enough the object mentions has no failure in the server log. Its removed, its put back, but no failures.


Generated at Thu Feb 08 09:24:38 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.