Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Won't Fix
-
10.0(EOL), 10.1(EOL), 10.2(EOL)
-
None
Description
http://buildbot.askmonty.org/buildbot/builders/bld-dan-debug/builds/3571
perfschema.socket_summary_by_event_name_func w1 [ fail ]
|
Test ended at 2016-08-17 12:56:11
|
|
CURRENT_TEST: perfschema.socket_summary_by_event_name_func
|
--- /opt/buildbot-slave/mariadb/dan_demeter1/build/mysql-test/suite/perfschema/r/socket_summary_by_event_name_func.result 2016-08-17 07:38:03.569162445 +0300
|
+++ /opt/buildbot-slave/mariadb/dan_demeter1/build/mysql-test/suite/perfschema/r/socket_summary_by_event_name_func.reject 2016-08-17 12:56:11.033154139 +0300
|
@@ -106,16 +106,25 @@
|
# 4.1 Verify that the totals in socket_summary_by_event_name are
|
consistent with totals in socket_summary_by_instance
|
|
-#==============================================================================
|
-# 5.0 Clean up
|
-#==============================================================================
|
|
-# 5.1 Disconnect con1
|
+# ERROR: Socket summary tables do not match
|
+# Column comparison results:
|
|
+EVENT_NAME CNT_STAR SUM_WAIT MAX_WAIT CNT_READ SUM_READ MAX_READ BYTES_READ CNT_WRITE SUM_WRITE MAX_WRITE BYTES_WRITE CNT_MISC SUM_MISC
|
+wait/io/socket/sql/client_connection 1 1 1 1 1 1 1 1 1 1 1 1 1
|
|
-# 5.2 Disconnect con2
|
+SELECT * FROM performance_schema.socket_summary_by_instance ORDER BY EVENT_NAME;
|
+EVENT_NAME OBJECT_INSTANCE_BEGIN COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT COUNT_READ SUM_TIMER_READ MIN_TIMER_READ AVG_TIMER_READ MAX_TIMER_READ SUM_NUMBER_OF_BYTES_READ COUNT_WRITE SUM_TIMER_WRITE MIN_TIMER_WRITE AVG_TIMER_WRITE MAX_TIMER_WRITE SUM_NUMBER_OF_BYTES_WRITE COUNT_MISC SUM_TIMER_MISC MIN_TIMER_MISC AVG_TIMER_MISC MAX_TIMER_MISC
|
+wait/io/socket/sql/client_connection 139732220171584 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
|
+wait/io/socket/sql/client_connection 139732220172224 6 66546398 1354985 11090851 21237573 3 4957404 1354985 1652468 1920235 99 3 61588994 19277286 20529557 21237573 72 0 0 0 0 0
|
+wait/io/socket/sql/client_connection 139732220172544 7 2941236385 7031387 420176488 2747755186 3 25198199 7865696 8399292 9224234 99 4 2916038186 7031387 729009385 2747755186 83 0 0 0 0 0
|
+wait/io/socket/sql/server_tcpip_socket 139732220026944 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
|
+wait/io/socket/sql/server_unix_socket 139732220027264 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
|
+
|
+SELECT * FROM performance_schema.socket_summary_by_event_name ORDER BY EVENT_NAME;
|
+EVENT_NAME COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT COUNT_READ SUM_TIMER_READ MIN_TIMER_READ AVG_TIMER_READ MAX_TIMER_READ SUM_NUMBER_OF_BYTES_READ COUNT_WRITE SUM_TIMER_WRITE MIN_TIMER_WRITE AVG_TIMER_WRITE MAX_TIMER_WRITE SUM_NUMBER_OF_BYTES_WRITE COUNT_MISC SUM_TIMER_MISC MIN_TIMER_MISC AVG_TIMER_MISC MAX_TIMER_MISC
|
+wait/io/socket/sql/client_connection 13 3007782783 1354985 231367807 2747755186 6 30155603 1354985 5025880 9224234 198 7 2977627180 7031387 425375173 2747755186 155 0 0 0 0 0
|
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
|
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
|
|
-
|
-# 5.3 Drop mysqltest
|
-
|
-DROP DATABASE mysqltest;
|
+# Abort
|
|
mysqltest: Result length mismatch
|
http://askmonty.org/buildbot/builders/kvm-deb-jessie-x86/builds/1013
Attachments
Issue Links
- relates to
-
MDEV-7069 Fix buildbot failures in main server trees
-
- Closed
-
10.1, sporadic, http://buildbot.askmonty.org/buildbot/builders/kvm-bintar-trusty-amd64/builds/3753/steps/test/logs/stdio
perfschema.socket_summary_by_event_name_func w4 [ fail ]
Test ended at 2017-12-03 15:10:12
CURRENT_TEST: perfschema.socket_summary_by_event_name_func
--- /usr/local/mariadb-10.1.30-linux-x86_64/mysql-test/suite/perfschema/r/socket_summary_by_event_name_func.result 2017-12-03 13:27:31.000000000 +0000
+++ /usr/local/mariadb-10.1.30-linux-x86_64/mysql-test/suite/perfschema/r/socket_summary_by_event_name_func.reject 2017-12-03 15:10:12.284501688 +0000
@@ -106,16 +106,25 @@
# 4.1 Verify that the totals in socket_summary_by_event_name are
consistent with totals in socket_summary_by_instance
-#==============================================================================
-# 5.0 Clean up
-#==============================================================================
-# 5.1 Disconnect con1
+# ERROR: Socket summary tables do not match
+# Column comparison results:
+EVENT_NAME CNT_STAR SUM_WAIT MAX_WAIT CNT_READ SUM_READ MAX_READ BYTES_READ CNT_WRITE SUM_WRITE MAX_WRITE BYTES_WRITE CNT_MISC SUM_MISC
+wait/io/socket/sql/client_connection 1 1 1 1 1 1 1 1 1 1 1 1 1
-# 5.2 Disconnect con2
+SELECT * FROM performance_schema.socket_summary_by_instance ORDER BY EVENT_NAME;
+EVENT_NAME OBJECT_INSTANCE_BEGIN COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT COUNT_READ SUM_TIMER_READ MIN_TIMER_READ AVG_TIMER_READ MAX_TIMER_READ SUM_NUMBER_OF_BYTES_READ COUNT_WRITE SUM_TIMER_WRITE MIN_TIMER_WRITE AVG_TIMER_WRITE MAX_TIMER_WRITE SUM_NUMBER_OF_BYTES_WRITE COUNT_MISC SUM_TIMER_MISC MIN_TIMER_MISC AVG_TIMER_MISC MAX_TIMER_MISC
+wait/io/socket/sql/client_connection 140657141120576 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
+wait/io/socket/sql/client_connection 140657141121216 6 40607052 1366728 6767508 13588623 3 4534551 1366728 1511517 1693380 99 3 36072501 10388235 12024000 13588623 72 0 0 0 0 0
+wait/io/socket/sql/client_connection 140657141121536 7 2157996378 5868714 308284839 1274853117 3 20412744 5868714 6804081 7913295 99 4 2137583634 25881660 534395658 1274853117 83 0 0 0 0 0
+wait/io/socket/sql/server_tcpip_socket 140657140924416 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
+wait/io/socket/sql/server_unix_socket 140657140924736 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
+
+SELECT * FROM performance_schema.socket_summary_by_event_name ORDER BY EVENT_NAME;
+EVENT_NAME COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT COUNT_READ SUM_TIMER_READ MIN_TIMER_READ AVG_TIMER_READ MAX_TIMER_READ SUM_NUMBER_OF_BYTES_READ COUNT_WRITE SUM_TIMER_WRITE MIN_TIMER_WRITE AVG_TIMER_WRITE MAX_TIMER_WRITE SUM_NUMBER_OF_BYTES_WRITE COUNT_MISC SUM_TIMER_MISC MIN_TIMER_MISC AVG_TIMER_MISC MAX_TIMER_MISC
+wait/io/socket/sql/client_connection 13 2198603430 1366728 169123071 1274853117 6 24947295 1366728 4157799 7913295 198 7 2173656135 10388235 310522305 1274853117 155 0 0 0 0 0
+wait/io/socket/sql/server_tcpip_socket 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
+wait/io/socket/sql/server_unix_socket 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
-
-# 5.3 Drop mysqltest
-
-DROP DATABASE mysqltest;
+# Abort
mysqltest: Result length mismatch