MTR's internal check of the test case 'percona_bug1289599' fails
| 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 |
In Progress
|
Low
|
Yura Sorokin | |||
| 5.7 |
In Progress
|
Low
|
Yura Sorokin | |||
Bug Description
./mtr --debug-server percona_bug1289599
Although the test itself passes, it leaves some side effects in the mysql.user table.
The problem discovered during merging upstream 5.6.30 into Percona Server.
*******
worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009
main.percona_
MTR's internal check of the test case 'main.percona_
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 '/home/
mysqltest: Results saved in '/home/
mysqltest: Connecting to server localhost:13001 (socket /home/yura/
mysqltest: ... Connected.
mysqltest: Start processing test commands from './include/
mysqltest: ... Done processing test commands.
--- /home/yura/
+++ /home/yura/
@@ -928,6 +928,6 @@
mysql.
mysql.
mysql.
-mysql.user 3907072784
+mysql.user 3891088588
Warnings:
Error 1146 Table 'mysql.host' doesn't exist
mysqltest: Result content mismatch
not ok
*******
| Yura Sorokin (yura-sorokin) wrote | #1 |
| Shahriyar Rzayev (rzayev-sehriyar) wrote | #2 |
The problem seems to be with restoring original 'plugin' value in the 'mysql.user' table by executing
update mysql.user set plugin='';
This statement relies on the fact that at the beginning of the test the value of the 'plugin' field was also an empty string. This is not true, at least for 5.6.30, where this value is originally 'mysql_