Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
11.8.1
-
None
-
None
-
None
Description
After uploading MariaDB 1:11.8.1-2 to Debian I saw this test crashing on arch loong64:
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
|
Later down in the log I see the 3rd restart passed:
main.partition_explicit_prune w14 [ retry-pass ] 21544
|
Full log at https://buildd.debian.org/status/fetch.php?pkg=mariadb&arch=loong64&ver=1%3A11.8.1-2&stamp=1742531991&raw=0
In the previous build of 1:11.8.1-1 the test passed right away: https://buildd.debian.org/status/fetch.php?pkg=mariadb&arch=loong64&ver=1%3A11.8.1-1&stamp=1742370987&raw=0
Hence this issue seems sporadic.
I also found MDEV-34824 with failure on same test, but it has a mismatch in value and not a crash.
Attachments
Issue Links
- relates to
-
-
- Open
-