mysql-test: perfschema test failures with --ssl

Logging: mtr  --ssl --force --retry-failure=0 main.create perfschema.socket_summary_by_event_name_func perfschema.socket_summary_by_instance_func

vardir: /home/nirbhay/project/git-repo/maria/10.0/install/mysql-test/var

Checking leftover processes...

Removing old var directory...

Creating var directory '/home/nirbhay/project/git-repo/maria/10.0/install/mysql-test/var'...

Checking supported features...

MariaDB Version 10.0.20-MariaDB-debug

 - SSL connections supported

 - binaries are debug compiled

Collecting tests...

Installing system database...

==============================================================================

TEST                                      RESULT   TIME (ms) or COMMENT

--------------------------------------------------------------------------

worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019

main.create                              [ pass ]   5527

perfschema.socket_summary_by_event_name_func [ fail ]

        Test ended at 2015-07-10 12:24:33

CURRENT_TEST: perfschema.socket_summary_by_event_name_func

--- /home/nirbhay/project/git-repo/maria/10.0/install/mysql-test/suite/perfschema/r/socket_summary_by_event_name_func.result	2015-03-19 18:08:00.000000000 -0400

+++ /home/nirbhay/project/git-repo/maria/10.0/install/mysql-test/suite/perfschema/r/socket_summary_by_event_name_func.reject	2015-07-10 12:24:33.340002919 -0400

@@ -97,25 +97,16 @@

 # 3.6 Verify that SUM_NUMBER_OF_BYTES_WRITE increased

-# socket_summary_by_instance was updated

+# ERROR: Write count did not increaase

+#        Before = 0

+#        After  = 0

+

+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	139726777342784	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	139726777343424	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	139726777343744	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_tcpip_socket	139726777339904	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	139726777340224	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0

-#==============================================================================

-# 4.0 VERIFY RESULTS

-#==============================================================================

-

-# 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

-

-

-# 5.2 Disconnect con2

-

-

-# 5.3 Drop mysqltest

-

-DROP DATABASE mysqltest;

+# Abort

mysqltest: Result length mismatch

 - saving '/home/nirbhay/project/git-repo/maria/10.0/install/mysql-test/var/log/perfschema.socket_summary_by_event_name_func/' to '/home/nirbhay/project/git-repo/maria/10.0/install/mysql-test/var/log/perfschema.socket_summary_by_event_name_func/'

perfschema.socket_summary_by_instance_func [ fail ]

        Test ended at 2015-07-10 12:24:41

CURRENT_TEST: perfschema.socket_summary_by_instance_func

--- /home/nirbhay/project/git-repo/maria/10.0/install/mysql-test/suite/perfschema/r/socket_summary_by_instance_func.result	2015-03-19 18:08:00.000000000 -0400

+++ /home/nirbhay/project/git-repo/maria/10.0/install/mysql-test/suite/perfschema/r/socket_summary_by_instance_func.reject	2015-07-10 12:24:41.604002537 -0400

@@ -126,47 +126,647 @@

 #       SELECT col2 FROM does_not_exist

 # One statement is longer than the other.

 # Both statements fail with the same error message (table does not exist)

+# The compared statistics looks suspicious

+# We expect

+t2.COUNT_READ                - t1.COUNT_READ                = 0  AND

+t2.SUM_NUMBER_OF_BYTES_READ  - t1.SUM_NUMBER_OF_BYTES_READ  = LENGTH('SELECT col2 FROM does_not_exist WHERE col1 = 0') - LENGTH('SELECT col2 FROM does_not_exist') AND

+t2.COUNT_WRITE               - t1.COUNT_WRITE               = 0  AND

+t2.SUM_NUMBER_OF_BYTES_WRITE - t1.SUM_NUMBER_OF_BYTES_WRITE = 0  AND

+t2.COUNT_MISC                - t1.COUNT_MISC                = 0

...

+SELECT EVENT_NAME, OBJECT_INSTANCE_BEGIN,

+COUNT_READ,  SUM_NUMBER_OF_BYTES_READ,

+COUNT_WRITE, SUM_NUMBER_OF_BYTES_WRITE,

+COUNT_MISC,  statement

+FROM mysqltest.socket_summary_by_instance_detail

+WHERE EVENT_NAME LIKE '%client_connection%'

+     AND OBJECT_INSTANCE_BEGIN <> @default_object_instance_begin

+ORDER BY statement, run;

+EVENT_NAME	OBJECT_INSTANCE_BEGIN	COUNT_READ	SUM_NUMBER_OF_BYTES_READ	COUNT_WRITE	SUM_NUMBER_OF_BYTES_WRITE	COUNT_MISC	statement

+wait/io/socket/sql/client_connection	139632443270080	2	36	1	103	3	Connect (con*,127.0.0.1,root,,mysqltest,,)

+wait/io/socket/sql/client_connection	139632443270400	2	36	1	103	3	Connect (con*,127.0.0.1,root,,mysqltest,,)

+wait/io/socket/sql/client_connection	139632443270720	2	36	1	103	3	Connect (con*,127.0.0.1,root,,mysqltest,,)

+wait/io/socket/sql/client_connection	139632443271040	2	36	1	103	3	Connect (con*,127.0.0.1,root,,mysqltest,,)

...

+pk	After

 # 6. Cleanup

mysqltest: Result length mismatch

 - saving '/home/nirbhay/project/git-repo/maria/10.0/install/mysql-test/var/log/perfschema.socket_summary_by_instance_func/' to '/home/nirbhay/project/git-repo/maria/10.0/install/mysql-test/var/log/perfschema.socket_summary_by_instance_func/'

--------------------------------------------------------------------------

The servers were restarted 1 times

Spent 5.527 of 19 seconds executing testcases

Completed: Failed 2/3 tests, 33.33% were successful.

Failing test(s): perfschema.socket_summary_by_event_name_func perfschema.socket_summary_by_instance_func

The log files in var/log may give you some hint of what went wrong.

If you want to report this error, please read first the documentation

at http://dev.mysql.com/doc/mysql/en/mysql-test-suite.html