Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.5
-
None
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
Issue Links
- relates to
-
MDEV-26207 perfschema.show_aggregate,innodb,pot fails upon --repeat with wrong result
- Open