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: | |
| Category: | MySQL Server: Tests | Severity: | S7 (Test Cases) |
| Version: | 8.0.38 | OS: | MacOS (14.5) |
| Assigned to: | CPU Architecture: | ARM |
[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
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.059 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.
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/