Bug #114888 Test innodb.parallel_read_kill always fails
Submitted: 5 May 2024 10:11 Modified: 17 Oct 2024 13:23
Reporter: Laurynas Biveinis (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Tests Severity:S7 (Test Cases)
Version:8.0.38 OS:MacOS (14.5)
Assigned to: CPU Architecture:ARM

[5 May 2024 10:11] Laurynas Biveinis 
Description:
On a debug build of 8.0.37:
$ ./mtr innodb.parallel_read_kill
...
[ 50%] innodb.parallel_read_kill                 [ fail ]
        Test ended at 2024-05-05 12:23:32

CURRENT_TEST: innodb.parallel_read_kill
mysqltest: At line 60: Query 'reap' succeeded, should have failed with error '1317'

The result from queries just before the failure was:
SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
SET SESSION innodb_parallel_read_threads=2;
# Count committed rows
SET DEBUG_SYNC='parallel_read_wait_for_kill_query SIGNAL ready WAIT_FOR kill_query';
SELECT count(*) FROM t1;
SET DEBUG_SYNC='now WAIT_FOR ready';
Warnings:
Warning	1639	debug sync point wait timed out
SET DEBUG_SYNC='now SIGNAL kill_query';
# Killing select query
kill query @id;
# Should be 0 since the query should not be active
SELECT COUNT(*) FROM information_schema.processlist WHERE id = @id AND
INFO = 'SELECT count(*) FROM t1' AND state="executing";
COUNT(*)
0
Warnings:
Warning	1287	'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead
count(*)
0
safe_process[32340]: Child process: 32341, exit: 1

How to repeat:
See above. CMake flags I used: -DCMAKE_EXPORT_COMPILE_COMMANDS=ON -DCMAKE_BUILD_TYPE=Debug -DWITH_DEBUG=ON -DMYSQL_MAINTAINER_MODE=ON -DWITH_SYSTEM_LIBS=ON -DFORCE_COLORED_OUTPUT=ON -DDOWNLOAD_BOOST=ON -DWITH_BOOST=~/vilniusdb/mysql-boost/
[6 May 2024 6:24] MySQL Verification Team 
Hello Laurynas,

Thank you for the report and feedback!

regards,
Umesh
[24 Jun 2024 12:23] Laurynas Biveinis 
Bug 115416
[2 Jul 2024 4:31] Laurynas Biveinis 
Same on 8.0.38
[8 Jul 2024 3:33] Rahul Sisondia 
Posted by developer:
 
Thank you Laurynas for the bug report. Indeed, test is failing after Bug#35952353 was fixed.  I would like to fix this bug through Bug#115416.  Closing this as a duplicate.
[17 Oct 2024 13:23] Laurynas Biveinis 
Indeed no longer reproducing with 8.0.40 / 8.4.3 / 9.1.0