5.5.13 perfschema.relaylog fails when using pool of threads

Bug #781092 reported by Valentine Gostev on 2011-05-11
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
percona-projects-qa
Low
Laurynas Biveinis

Bug Description

CURRENT_TEST: perfschema.relaylog
--- /root/HEAP/mysql-test/suite/perfschema/r/relaylog.result 2011-05-06 18:25:36.760325000 +0300
+++ /root/HEAP/mysql-test/suite/perfschema/r/relaylog.reject 2011-05-11 14:50:52.319107378 +0300
@@ -19,7 +19,7 @@
 from performance_schema.file_summary_by_instance
 where file_name like "%master-%" order by file_name;
 FILE_NAME EVENT_NAME COUNT_READ COUNT_WRITE SUM_NUMBER_OF_BYTES_READ SUM_NUMBER_OF_BYTES_WRITE
-master-bin.000001 wait/io/file/sql/binlog MANY MANY MANY MANY
+master-bin.000001 wait/io/file/sql/binlog NONE MANY NONE MANY
 master-bin.index wait/io/file/sql/binlog_index NONE MANY NONE MANY
 select * from performance_schema.file_summary_by_instance
 where file_name like "%slave-%" order by file_name;
@@ -35,7 +35,7 @@
 from performance_schema.file_summary_by_instance
 where event_name like "%binlog%" order by file_name;
 FILE_NAME EVENT_NAME COUNT_READ COUNT_WRITE SUM_NUMBER_OF_BYTES_READ SUM_NUMBER_OF_BYTES_WRITE
-master-bin.000001 wait/io/file/sql/binlog MANY MANY MANY MANY
+master-bin.000001 wait/io/file/sql/binlog NONE MANY NONE MANY
 master-bin.index wait/io/file/sql/binlog_index NONE MANY NONE MANY
 select
 EVENT_NAME,
@@ -46,7 +46,7 @@
 from performance_schema.file_summary_by_event_name
 where event_name like "%binlog%" order by event_name;
 EVENT_NAME COUNT_READ COUNT_WRITE SUM_NUMBER_OF_BYTES_READ SUM_NUMBER_OF_BYTES_WRITE
-wait/io/file/sql/binlog MANY MANY MANY MANY
+wait/io/file/sql/binlog NONE MANY NONE MANY
 wait/io/file/sql/binlog_index NONE MANY NONE MANY
 select
 EVENT_NAME,
@@ -55,7 +55,7 @@
 where event_name like "%MYSQL_BIN_LOG%" order by event_name;
 EVENT_NAME COUNT_STAR
 wait/synch/cond/sql/MYSQL_BIN_LOG::COND_prep_xids NONE
-wait/synch/cond/sql/MYSQL_BIN_LOG::update_cond MANY
+wait/synch/cond/sql/MYSQL_BIN_LOG::update_cond NONE
 wait/synch/mutex/sql/MYSQL_BIN_LOG::LOCK_index MANY
 wait/synch/mutex/sql/MYSQL_BIN_LOG::LOCK_prep_xids NONE
 "Expect no slave relay log"
@@ -90,9 +90,9 @@
        or file_name like "%slave-relay-bin.000002")
 order by file_name;
 FILE_NAME EVENT_NAME COUNT_READ COUNT_WRITE SUM_NUMBER_OF_BYTES_READ SUM_NUMBER_OF_BYTES_WRITE
-slave-bin.000001 wait/io/file/sql/binlog MANY MANY MANY MANY
+slave-bin.000001 wait/io/file/sql/binlog NONE MANY NONE MANY
 slave-bin.index wait/io/file/sql/binlog_index NONE MANY NONE MANY
-slave-relay-bin.000001 wait/io/file/sql/relaylog MANY MANY MANY MANY
+slave-relay-bin.000001 wait/io/file/sql/binlog MANY NONE MANY NONE
 slave-relay-bin.000002 wait/io/file/sql/relaylog MANY MANY MANY MANY
 slave-relay-bin.index wait/io/file/sql/relaylog_index MANY MANY MANY MANY
 "Expect a slave binlog + binlog_index"
@@ -106,8 +106,9 @@
 from performance_schema.file_summary_by_instance
 where event_name like "%binlog%" order by file_name;
 FILE_NAME EVENT_NAME COUNT_READ COUNT_WRITE SUM_NUMBER_OF_BYTES_READ SUM_NUMBER_OF_BYTES_WRITE
-slave-bin.000001 wait/io/file/sql/binlog MANY MANY MANY MANY
+slave-bin.000001 wait/io/file/sql/binlog NONE MANY NONE MANY
 slave-bin.index wait/io/file/sql/binlog_index NONE MANY NONE MANY
+slave-relay-bin.000001 wait/io/file/sql/binlog MANY NONE MANY NONE
 select
 EVENT_NAME,
 if (count_read > 0, "MANY", "NONE") as COUNT_READ,
@@ -144,7 +145,6 @@
        or file_name like "%slave-relay-bin.000002")
 order by file_name;
 FILE_NAME EVENT_NAME COUNT_READ COUNT_WRITE SUM_NUMBER_OF_BYTES_READ SUM_NUMBER_OF_BYTES_WRITE
-slave-relay-bin.000001 wait/io/file/sql/relaylog MANY MANY MANY MANY
 slave-relay-bin.000002 wait/io/file/sql/relaylog MANY MANY MANY MANY
 slave-relay-bin.index wait/io/file/sql/relaylog_index MANY MANY MANY MANY
 select

mysqltest: Result content mismatch

Changed in percona-projects-qa:
assignee: nobody → Laurynas Biveinis (laurynas-biveinis)
milestone: none → 5.5.13-eb

Perfschema bugs will be fixed later if at all.

Changed in percona-projects-qa:
status: New → Triaged
importance: Undecided → Low
Changed in percona-projects-qa:
status: Triaged → Fix Committed
Changed in percona-projects-qa:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers