main.partition_explicit_prune            w14 [ fail ]

        Test ended at 2025-03-21 04:35:53

CURRENT_TEST: main.partition_explicit_prune

mysqltest: At line 557: query 'TRUNCATE TABLE t2' failed: ER_LOCK_WAIT_TIMEOUT (1205): Lock wait timeout exceeded; try restarting transaction

The result from queries just before the failure was:

< snip >

HANDLER_ROLLBACK	1

HANDLER_TMP_WRITE	24

HANDLER_WRITE	1

# 16 locks (2 tables, 1 + 5 subpartitions lock/unlock)

FLUSH STATUS;

INSERT IGNORE INTO t2 PARTITION (subp3) SELECT * FROM t1 PARTITION (subp3, `p10-99`, `p100-99999`);

Warnings:

Warning	1748	Found a row not matching the given partition set

Warning	1748	Found a row not matching the given partition set

Warning	1748	Found a row not matching the given partition set

SELECT * FROM INFORMATION_SCHEMA.SESSION_STATUS

WHERE VARIABLE_NAME LIKE 'HANDLER_%' AND VARIABLE_VALUE > 0;

VARIABLE_NAME	VARIABLE_VALUE

HANDLER_COMMIT	1

HANDLER_READ_FIRST	5

HANDLER_READ_NEXT	5

HANDLER_TMP_WRITE	24

HANDLER_WRITE	7

# 16 locks (2 tables, 1 + 5 subpartitions lock/unlock)

TRUNCATE TABLE t2;

More results from queries before failure can be found in /<<PKGBUILDDIR>>/builddir/mysql-test/var/14/log/partition_explicit_prune.log

main.partition_explicit_prune            w14 [ retry-pass ]  21544