[#MDEV-27618] Atomic DDL is not very atomic on partitioned tables

Note: To repeat what was also said in the comments, it was already known at the time of atomic DDL development/release (~~MDEV-25180~~) that partitioned tables still have problems and aren't made atomic in the scope of the task. However, I was asked to register reproducible test cases anyway, so they could be looked at with a low priority, so that's what this report is for.

The test case is non-deterministic, run with --repeat=N. It usually fails for me within several attempts (takes longer on non-debug builds), but it can vary on different machines and builds.

--source include/have_partition.inc

--source include/have_innodb.inc

--source include/have_sequence.inc

CREATE TABLE t (pk INT PRIMARY KEY, a INT) ENGINE=InnoDB PARTITION BY HASH(pk);

INSERT INTO t SELECT seq, seq FROM seq_1_to_1000;

--connect (con1,localhost,root,,test)

--let $shutdown_timeout= 0

--send

ALTER TABLE t ADD KEY (a), ALGORITHM=INPLACE;

--connection default

--source include/restart_mysqld.inc

CHECK TABLE t;

# Cleanup

DROP TABLE t;

10.6 8171f9da
bug.t 'innodb' [ fail ] Found warnings/errors in server log file!
Test ended at 2023-06-17 22:19:56
line
2023-06-17 22:19:56 3 [ERROR] InnoDB indexes are inconsistent with what defined in .frm for table ./test/t#P#p0
2023-06-17 22:19:56 3 [ERROR] InnoDB: Table test/t#P#p0 contains 1 indexes inside InnoDB, which is different from the number of indexes 2 defined in the .frm file. See https://mariadb.com/kb/en/innodb-troubleshooting/
2023-06-17 22:19:56 3 [ERROR] InnoDB could not find key no 1 with name a from dict cache for table test/t#P#p0
2023-06-17 22:19:56 3 [ERROR] InnoDB: Table test/t#P#p0 contains 1 indexes inside InnoDB, which is different from the number of indexes 2 defined in the .frm file. See https://mariadb.com/kb/en/innodb-troubleshooting/
2023-06-17 22:19:56 3 [ERROR] InnoDB: Table test/t#P#p0 contains 1 indexes inside InnoDB, which is different from the number of indexes 2 defined in the .frm file. See https://mariadb.com/kb/en/innodb-troubleshooting/
2023-06-17 22:19:56 3 [ERROR] InnoDB could not find key no 1 with name a from dict cache for table test/t#P#p0
2023-06-17 22:19:56 3 [ERROR] InnoDB: Table test/t#P#p0 contains 1 indexes inside InnoDB, which is different from the number of indexes 2 defined in the .frm file. See https://mariadb.com/kb/en/innodb-troubleshooting/
^ Found warnings in /mnt8t/bld/10.6-asan/mysql-test/var/log/mysqld.1.err
ok

[MDEV-27618] Atomic DDL is not very atomic on partitioned tables Created: 2022-01-25 Updated: 2023-08-11
Status:	Open
Project:	MariaDB Server
Component/s:	Data Definition - Alter Table, Partitioning
Affects Version/s:	10.6, 10.9, 10.10, 10.11, 11.0, 11.1
Fix Version/s:	11.1

[MDEV-27618] Atomic DDL is not very atomic on partitioned tables Created: 2022-01-25 Updated: 2023-08-11