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

mysql-test: perfschema test failures with --ssl

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Not a Bug
    • Affects Version/s: 10.0.20
    • Fix Version/s: N/A
    • 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

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              serg Sergei Golubchik
              Reporter:
              nirbhay_c Nirbhay Choubey (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.