[MDEV-11083] performance schema test fail with threadpool Created: 2016-10-18  Updated: 2016-10-19  Resolved: 2016-10-19

Status: Closed
Project: MariaDB Server
Component/s: OTHER
Affects Version/s: 10.0, 10.1, 10.2
Fix Version/s: 10.0.28

Type: Bug Priority: Major
Reporter: Vladislav Vaintroub Assignee: Vladislav Vaintroub
Resolution: Fixed Votes: 0
Labels: None


 Description   

CURRENT_TEST: perfschema.event_aggregate_no_a_no_u_no_h
--- C:/work/10.0/mysql-test/suite/perfschema/r/event_aggregate_no_a_no_u_no_h.result    2016-10-18 16:02:22.979825600 +0200
+++ C:\work\10.0\mysql-test\suite\perfschema\r\event_aggregate_no_a_no_u_no_h.reject    2016-10-18 16:20:26.839561400 +0200
@@ -127,6 +127,11 @@
 1
 insert into test.t1 values ("marker");
 "================== con1 marker =================="
+Timeout in wait_condition.inc for select count(*) = 1 from performance_schema.events_waits_current
+where EVENT_NAME= 'idle'
+Id     User    Host    db      Command Time    State   Info    Progress
+3      root    localhost:51100 test    Query   0       init    show full processlist   0.000
+4      user1   localhost:51101 test    Sleep   31              NULL    0.000
 "================== Step 3 =================="
 call dump_thread();
 username       event_name      count_star
@@ -277,6 +282,12 @@
 1
 insert into test.t1 values ("marker");
 "================== con2 marker =================="
+Timeout in wait_condition.inc for select count(*) = 2 from performance_schema.events_waits_current
+where EVENT_NAME= 'idle'
+Id     User    Host    db      Command Time    State   Info    Progress
+3      root    localhost:51100 test    Query   0       init    show full processlist   0.000
+4      user1   localhost:51101 test    Sleep   63              NULL    0.000
+5      user2   localhost:51103 test    Sleep   31              NULL    0.000
 "================== Step 5 =================="
 call dump_thread();
 username       event_name      count_star
@@ -433,6 +444,13 @@
 1
 insert into test.t1 values ("marker");
 "================== con3 marker =================="
+Timeout in wait_condition.inc for select count(*) = 3 from performance_schema.events_waits_current
+where EVENT_NAME= 'idle'
+Id     User    Host    db      Command Time    State   Info    Progress
+3      root    localhost:51100 test    Query   0       init    show full processlist   0.000
+4      user1   localhost:51101 test    Sleep   94              NULL    0.000
+5      user2   localhost:51103 test    Sleep   62              NULL    0.000
+6      user3   localhost:51104 test    Sleep   31              NULL    0.000
 "================== Step 7 =================="
 call dump_thread();
 username       event_name      count_star
@@ -595,6 +613,14 @@
 1
 insert into test.t1 values ("marker");
 "================== con4 marker =================="
+Timeout in wait_condition.inc for select count(*) = 4 from performance_schema.events_waits_current
+where EVENT_NAME= 'idle'
+Id     User    Host    db      Command Time    State   Info    Progress
+3      root    localhost:51100 test    Query   0       init    show full processlist   0.000
+4      user1   localhost:51101 test    Sleep   125             NULL    0.000
+5      user2   localhost:51103 test    Sleep   93              NULL    0.000
+6      user3   localhost:51104 test    Sleep   62              NULL    0.000
+7      user4   localhost:51114 test    Sleep   31              NULL    0.000
 "================== Step 9 =================="
 call dump_thread();
 username       event_name      count_star
 
mysqltest: Result length mismatch
 
 - saving 'C:/work/10.0/xxx/mysql-test/var/log/perfschema.event_aggregate_no_a_no_u_no_h/' to 'C:/work/10.0/xxx/mysql-test/var/log/perfschema.event_aggregate_no_a_no_u_no_h/'
 
Only  39  of 326 completed.
--------------------------------------------------------------------------
The servers were restarted 7 times
Spent 3.173 of 147 seconds executing testcases
 
Failure: Failed 1/21 tests, 95.24% were successful.
 
Failing test(s): perfschema.event_aggregate_no_a_no_u_no_h


Generated at Thu Feb 08 07:47:11 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.