Test main.mysql_client_test fails testcase check intermittently

Bug #1622456 reported by Laurynas Biveinis
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Status tracked in 5.7
5.5
New
Low
Unassigned
5.6
Fix Released
Low
Laurynas Biveinis
5.7
Fix Released
Low
Laurynas Biveinis

Bug Description

On PS 5.6 trunk:

main.mysql_client_test w2 [ pass ] 5039

MTR's internal check of the test case 'main.mysql_client_test' failed.
This means that the test case does not preserve the state that existed
before the test case was executed. Most likely the test case did not
do a proper clean-up. It could also be caused by the previous test run
by this thread, if the server wasn't restarted.
This is the diff of the states of the servers before and after the
test case was executed:
mysqltest: Logging to '/mnt/workspace/percona-server-5.6-trunk/BUILD_TYPE/release/Host/ubuntu-precise-32bit/build/mysql-test/var/2/tmp/check-mysqld_1.log'.
mysqltest: Results saved in '/mnt/workspace/percona-server-5.6-trunk/BUILD_TYPE/release/Host/ubuntu-precise-32bit/build/mysql-test/var/2/tmp/check-mysqld_1.result'.
mysqltest: Connecting to server localhost:13001 (socket /tmp/bOLt5tAR3b/2/mysqld.1.sock) as 'root', connection 'default', attempt 0 ...
mysqltest: ... Connected.
mysqltest: Start processing test commands from './include/check-testcase.test' ...
mysqltest: ... Done processing test commands.
--- /mnt/workspace/percona-server-5.6-trunk/BUILD_TYPE/release/Host/ubuntu-precise-32bit/build/mysql-test/var/2/tmp/check-mysqld_1.result 2016-08-30 15:42:21.758564000 +0300
+++ /mnt/workspace/percona-server-5.6-trunk/BUILD_TYPE/release/Host/ubuntu-precise-32bit/build/mysql-test/var/2/tmp/check-mysqld_1.reject 2016-08-30 15:42:27.114564000 +0300
@@ -1,4 +1,5 @@
 ID USER HOST DB COMMAND TIME STATE INFO TIME_MS ROWS_SENT ROWS_EXAMINED TID
+<Id> root localhost test Query <Time> <State> SELECT SLEEP(100) <Time_ms> X X <Tid>
 <Id> root localhost NULL Query <Time> <State> SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST
 WHERE COMMAND != 'Binlog Dump' AND COMMAND != 'Binlog Dump GTID' <Time_ms> X X <Tid>
 Slave_IO_State

mysqltest: Result content mismatch

Tags: ci
Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote :

For 5.7, already fixed under bug 1612063.

tags: added: ci
Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote :
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-2198

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.