Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-8446

mysql-test: perfschema test failures with --ssl

        Details

        • Type: Bug
        • Status: Confirmed
        • Priority: Major
        • Resolution: Unresolved
        • Affects Version/s: 10.0.20
        • Fix Version/s: 10.0
        • Component/s: SSL, Tests
        • Labels:

          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

            Gliffy Diagrams

              Attachments

                Issue Links

                relates to

                Bug - A problem which impairs or prevents the functions of the product. MDEV-8404 Some main.ssl_xxx tests fails with --ssl

                • Major - Major loss of function.
                • Confirmed

                Bug - A problem which impairs or prevents the functions of the product. MDEV-7760 Some MTR tests fail when run with --ssl option

                • Minor - Minor loss of function, or other problem where easy workaround is present.
                • Closed

                  Activity

                  Hide
                  Permalink
                  nirbhay_c Nirbhay Choubey added a comment -

                  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
..
                  Show
                  nirbhay_c Nirbhay Choubey added a comment - 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 ..

                    People

                    • Assignee:
                      Unassigned
                      Reporter:
                      nirbhay_c Nirbhay Choubey
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      2 Start watching this issue

                      Dates

                      • Created:
                        Updated: