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

perfschema.show_aggregate fails in buildbot with variety of wrong results

    XMLWordPrintable

    Details

      Description

      http://buildbot.askmonty.org/buildbot/builders/bld-p9-rhel7/builds/4392

      10.5 e341fb0dae1008b98d6fc96f8847e6f1

      perfschema.show_aggregate 'innodb,pot'   w58 [ fail ]
              Test ended at 2020-06-19 16:09:14
       
      CURRENT_TEST: perfschema.show_aggregate
      --- /opt/buildbot-slave/bld-p9-rhel7/build/mysql-test/suite/perfschema/r/show_aggregate.result	2020-06-18 01:58:32.718011905 +0300
      +++ /opt/buildbot-slave/bld-p9-rhel7/build/mysql-test/suite/perfschema/r/show_aggregate.reject	2020-06-19 16:09:14.630545946 +0300
      @@ -203,12 +203,6 @@
       USE performance_schema;
       SELECT * FROM status_by_thread WHERE thread_id IN (@con1_id, @con2_id, @con3_id) AND variable_name IN ('handler_delete', 'handler_rollback') ORDER BY thread_id;
       THREAD_ID	VARIABLE_NAME	VARIABLE_VALUE
      -thread_id	Handler_delete	1
      -thread_id	Handler_rollback	1
      -thread_id	Handler_delete	2
      -thread_id	Handler_rollback	2
      -thread_id	Handler_delete	3
      -thread_id	Handler_rollback	3
       #
       # Verify expected counts for 'handler_delete' per thread
       # 
       
      mysqltest: Result length mismatch
      

      10.5 4243785f288149fc1571b168cda1c921

      perfschema.show_aggregate '1tpc,innodb'  w2 [ fail ]
              Test ended at 2020-06-19 12:34:54
       
      CURRENT_TEST: perfschema.show_aggregate
      --- /usr/share/mysql-test/suite/perfschema/r/show_aggregate.result	2020-06-19 09:07:03.000000000 +0000
      +++ /dev/shm/var/2/log/show_aggregate.reject	2020-06-19 12:34:54.397024241 +0000
      @@ -505,17 +505,17 @@
       SELECT * FROM status_by_account WHERE user IN ('user1', 'user2', 'user3') AND variable_name IN ('handler_delete');
       USER	HOST	VARIABLE_NAME	VARIABLE_VALUE
       user1	localhost	Handler_delete	0
      -user2	localhost	Handler_delete	0
      +user2	localhost	Handler_delete	2
       user3	localhost	Handler_delete	0
       #
       SELECT * FROM status_by_host WHERE host IN ('localhost') AND variable_name IN ('handler_delete');
       HOST	VARIABLE_NAME	VARIABLE_VALUE
      -localhost	Handler_delete	0
      +localhost	Handler_delete	2
       #
       SELECT * FROM status_by_user WHERE user IN ('user1', 'user2', 'user3') AND variable_name IN ('handler_delete');
       USER	VARIABLE_NAME	VARIABLE_VALUE
       user1	Handler_delete	0
      -user2	Handler_delete	0
      +user2	Handler_delete	2
       user3	Handler_delete	0
       # ================================================================================
       # CLEANUP
       
      mysqltest: Result content mismatch
      

      10.5 bd62a636a42f1486437cbed21198315f

      perfschema.show_aggregate 'innodb,pot'   w2 [ fail ]
              Test ended at 2020-06-16 23:14:13
       
      CURRENT_TEST: perfschema.show_aggregate
      --- /mnt/buildbot/build/mariadb-10.5.4/mysql-test/suite/perfschema/r/show_aggregate.result	2020-06-16 22:04:48.000000000 -0400
      +++ /mnt/buildbot/build/mariadb-10.5.4/mysql-test/suite/perfschema/r/show_aggregate.reject	2020-06-16 23:14:13.568358785 -0400
      @@ -494,7 +494,7 @@
       FROM test.status_results
       ORDER BY variable_name;
       variable_name	h1	h2	h3	delta	host	Expected
      -Handler_delete	6	0	0	6	6	OK
      +Handler_delete	4	0	0	6	4	ERROR
       Handler_rollback	6	0	0	6	6	OK
       # ================================================================================
       # TEST 8: FLUSH STATUS should clear account, host and user status
       
      mysqltest: Result length mismatch
      

      etc.

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated: