Bug #114888 Test innodb.parallel_read_kill always fails

• Submitted: 5 May 10:11
• Modified: 17 Oct 13:23
• Reporter: Laurynas Biveinis (OCA)
• Status: Verified
• Category: MySQL Server: Tests
• Severity: S7 (Test Cases)
• Version: 8.0.38
• OS: MacOS (14.5)
• CPU Architecture: ARM

[5 May 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 6:24] MySQL Verification Team

Hello Laurynas,

Thank you for the report and feedback!

regards,
Umesh

[24 Jun 12:23] Laurynas Biveinis

Bug 115416

[2 Jul 4:31] Laurynas Biveinis

Same on 8.0.38

[8 Jul 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 13:23] Laurynas Biveinis

Indeed no longer reproducing with 8.0.40 / 8.4.3 / 9.1.0