Details
-
Bug
-
Status: Stalled (View Workflow)
-
Critical
-
Resolution: Unresolved
-
10.6, 10.11, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL)
Description
The test case is non-deterministic, run with --repeat=N. It fails for me (without rr) within a few attempts on various build types, but it can vary on different machines. The test is rr-able with --rr=-h, although it takes much longer, set repeat=N to a high value for rr.
--source include/have_innodb.inc
|
--source include/have_partition.inc
|
|
--connect (con1,localhost,root,,test)
|
CREATE TABLE t1 (pk INT PRIMARY KEY) ENGINE=InnoDB PARTITION BY HASH (pk) PARTITIONS 4; |
CREATE TABLE t2 (pk INT PRIMARY KEY) ENGINE=InnoDB; |
SET SESSION INNODB_LOCK_WAIT_TIMEOUT= 0; |
--send
|
DROP TABLE t1; |
--connection default
|
DROP TABLE t2; |
--error 0,ER_NO_SUCH_TABLE
|
SELECT * FROM t1 PARTITION (p3); |
|
# Cleanup
|
--connection con1
|
--reap
|
--disconnect con1 |
10.6 5e270ca2 |
mysqltest: At line 13: query 'SELECT * FROM t1 PARTITION (p3)' failed with wrong errno ER_FAILED_READ_FROM_PAR_FILE (1696): 'Failed to read from the .par file', instead of (0)... |
The failure started happening (or, if it existed before, its probability hugely increased) after this commit in 10.6.8:
commit 8840583a92243f6ac543689148ca79c85fa0a09d
|
Author: Marko Mäkelä
|
Date: Fri Mar 18 10:52:08 2022 +0200
|
|
MDEV-27909 InnoDB: Failing assertion: state == TRX_STATE_NOT_STARTED ... on DDL
|
Attachments
Issue Links
- relates to
-
MDEV-17567 Atomic DDL
- Closed
-
MDEV-27180 Fully atomic partitioning DDL operations
- Stalled
-
MDEV-27618 Atomic DDL is not very atomic on partitioned tables
- Confirmed
-
MDEV-30583 DB_DUPLICATE_KEY on CREATE OR REPLACE after ALTER TABLE change engine
- Stalled