[MDEV-26207] perfschema.show_aggregate,innodb,pot fails upon --repeat with wrong result Created: 2021-07-21  Updated: 2021-07-21

Status: Open
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.5, 10.6
Fix Version/s: 10.5, 10.6

Type: Bug Priority: Minor
Reporter: Elena Stepanova Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-22962 perfschema.show_aggregate fails in bu... Open

 Description   

10.5 b4ec3313

$ perl ./mtr perfschema.show_aggregate,innodb,pot --repeat=2
<...>
worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019
perfschema.show_aggregate 'innodb,pot'   [ pass ]    155
perfschema.show_aggregate 'innodb,pot'   [ 2 fail ]
        Test ended at 2021-07-22 00:06:21
 
CURRENT_TEST: perfschema.show_aggregate
--- /mnt-hd8t/bld/10.5-debug-nightly/mysql-test/suite/perfschema/r/show_aggregate.result	2021-03-06 05:41:07.000000000 +0200
+++ /mnt-hd8t/bld/10.5-debug-nightly/mysql-test/suite/perfschema/r/show_aggregate.reject	2021-07-22 00:06:21.143429636 +0300
@@ -203,12 +203,6 @@
 USE performance_schema;
 SELECT * FROM status_by_thread WHERE thread_id IN (@con1_id, @con2_id, @con3_id) AND variable_name IN ('handler_delete', 'handler_rollback') ORDER BY thread_id;
 THREAD_ID	VARIABLE_NAME	VARIABLE_VALUE
-thread_id	Handler_delete	1
-thread_id	Handler_rollback	1
-thread_id	Handler_delete	2
-thread_id	Handler_rollback	2
-thread_id	Handler_delete	3
-thread_id	Handler_rollback	3
 #
 # Verify expected counts for 'handler_delete' per thread
 # 
 
mysqltest: Result length mismatch


Generated at Thu Feb 08 09:43:33 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.