[MDEV-8446] mysql-test: perfschema test failures with --ssl Created: 2015-07-10  Updated: 2017-01-04  Resolved: 2017-01-04

Status: Closed
Project: MariaDB Server
Component/s: SSL, Tests
Affects Version/s: 10.0.20
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Nirbhay Choubey (Inactive) Assignee: Sergei Golubchik
Resolution: Not a Bug Votes: 0
Labels: SUSE

Issue Links:
Relates
relates to MDEV-7760 Some MTR tests fail when run with --s... Closed
relates to MDEV-8404 Some main.ssl_xxx tests fails with --ssl Closed

 Description    

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
 
 

https://bugzilla.suse.com/show_bug.cgi?id=920246
https://bugzilla.suse.com/show_bug.cgi?id=937836

 Comments   
Comment by Nirbhay Choubey (Inactive) [ 2015-07-10 ]

perfschema.nesting test fails as well.

nirbhay@nirbhay-VirtualBox-1:~/project/git-repo/maria/10.0/install/mysql-test$ perl mtr --ssl --retry-failure=0 perfschema.nesting
 
Logging: mtr  --ssl --retry-failure=0 perfschema.nesting
 
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
 
perfschema.nesting                       [ fail ]
 
        Test ended at 2015-07-10 13:21:54
 
 
 
CURRENT_TEST: perfschema.nesting
 
--- /home/nirbhay/project/git-repo/maria/10.0/install/mysql-test/suite/perfschema/r/nesting.result	2015-03-19 18:08:00.000000000 -0400
 
+++ /home/nirbhay/project/git-repo/maria/10.0/install/mysql-test/suite/perfschema/r/nesting.reject	2015-07-10 13:21:54.382371734 -0400
 
@@ -107,142 +107,130 @@
 
 ) all_events
 
 order by relative_event_id asc;
 
 relative_event_id	relative_end_event_id	event_name	comment	nesting_event_type	relative_nesting_event_id
 
-0	19	statement/sql/select	select "MARKER_BEGIN" as marker	NULL	NULL
 
..

Comment by Sergei Golubchik [ 2017-01-04 ]

Not a bug. There was no promise that the full test suite will work for any combination of mysqld command-line options. This test is supposed to be run without ssl and it fails with, not surprisingly.

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