Bug #99063 perfschema.idx_compare_ees_by_thread_by_error is unstable

• Submitted: 25 Mar 2020 7:01
• Modified: 25 Mar 2020 8:00
• Reporter: zhijun long
• Status: Verified
• Category: MySQL Server: Performance Schema
• Severity: S7 (Test Cases)
• Version: 8.0.19
• OS: Any
• CPU Architecture: Any

[25 Mar 2020 7:01] zhijun long

Description:
./mtr  perfschema.idx_compare_ees_by_thread_by_error --parallel=24 --repeat=20 --testcase-timeout=20

[  5%] perfschema.idx_compare_ees_by_thread_by_error w14 [ fail ]
        Test ended at 2020-03-25 13:11:01

CURRENT_TEST: perfschema.idx_compare_ees_by_thread_by_error
--- /home/ci/perf/mysql-8.0.19/bin/mysql-test/suite/perfschema/r/idx_compare_ees_by_thread_by_error.result      2019-12-09 22:53:17.000000000 +0300
+++ /home/ci/perf/mysql-8.0.19/bin/mysql-test/var/14/log/idx_compare_ees_by_thread_by_error.reject      2020-03-25 08:11:00.510309355 +0300
@@ -66,7 +66,7 @@

 OK: Result set: Non-empty  Expected: Non-empty

-OK: Extra rows: 0  Missing rows: 0
+*** ERROR ***: Extra rows: 4641  Missing rows: 0
 ========
 SELECT THREAD_ID, ERROR_NUMBER FROM performance_schema.events_errors_summary_by_thread_by_error WHERE thread_id = @target_thread_id

mysqltest: Result content mismatch

How to repeat:
see Description.

./mtr  perfschema.idx_compare_ees_by_thread_by_error --parallel=24 --repeat=20 --testcase-timeout=20

Suggested fix:
none.

[25 Mar 2020 8:00] MySQL Verification Team

Hello zhijun long,

Thank you for the report and feedback.

regards,
Umesh