From fce80b6ae1e909e7ce0959650fe7b4b80a3537fd Mon Sep 17 00:00:00 2001 From: Sergei Golubchik Date: Sat, 24 Dec 2022 18:53:16 +0100 Subject: sporadic failures of perfschema.statement_program_concurrency wait until all three concurrent statements are truly completely finished before quering P_S. In particular "Logging slow query" stage happens after sending the OK packet but before the statement appears in events_statements_history --- mysql-test/suite/perfschema/t/statement_program_concurrency.test | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) (limited to 'mysql-test/suite/perfschema/t/statement_program_concurrency.test') diff --git a/mysql-test/suite/perfschema/t/statement_program_concurrency.test b/mysql-test/suite/perfschema/t/statement_program_concurrency.test index 75261254c00..8229223caec 100644 --- a/mysql-test/suite/perfschema/t/statement_program_concurrency.test +++ b/mysql-test/suite/perfschema/t/statement_program_concurrency.test @@ -91,7 +91,9 @@ connection con3; --reap; connection default; ---source include/wait_until_connected_again.inc + +--let $wait_condition=select count(*)=3 from information_schema.processlist where command='sleep'; +--source include/wait_condition.inc SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, COUNT_STAR, COUNT_STATEMENTS FROM performance_schema.events_statements_summary_by_program -- cgit v1.2.1