Bug #80874 test_service_sql_api.test_sql_errors cannot run with mtr --repeat=2 (or more)

• Submitted: 29 Mar 2016 2:49
• Modified: 31 Mar 2016 13:13
• Reporter: Daniel Black
• Status: Closed
• Category: Tests
• Severity: S3 (Non-critical)
• Version: 5.7.11,5.7.9
• OS: Any
• CPU Architecture: Any

[29 Mar 2016 2:49] Daniel Black

Description:
running (cd mysql-test; ./mtr test_service_sql_api.test_sql_errors --repeat=2 ) fails on second run

How to repeat:
~/build_mysql-5.7$ (cd mysql-test; ./mtr test_service_sql_api.test_sql_errors --repeat=2 )

test_service_sql_api.test_sql_errors     [ pass ]     55
test_service_sql_api.test_sql_errors     [ fail ]
        Test ended at 2016-03-29 13:46:10

CURRENT_TEST: test_service_sql_api.test_sql_errors
--- /home/danielgb/mysql-5.7/mysql-test/suite/test_service_sql_api/r/test_sql_errors.result     2016-03-22 01:00:02.107505127 +0300
+++ /home/danielgb/build_mysql-5.7/mysql-test/var/log/test_sql_errors.reject    2016-03-29 05:46:09.852258134 +0300
@@ -80,6 +80,11 @@
 INSTALL PLUGIN test_sql_errors SONAME 'TEST_SQL_ERRORS';
 /*first*/SELECT * FROM information_schema.processlist ORDER BY id;
 ID     USER    HOST    DB      COMMAND TIME    STATE   INFO
+<ID>   unauthenticated user    <HOST_NAME>     NULL    Sleep   <TIME>  login   PLUGIN
+<ID>   unauthenticated user    <HOST_NAME>     NULL    Sleep   <TIME>  login   PLUGIN
+<ID>   unauthenticated user    <HOST_NAME>     NULL    Sleep   <TIME>  login   PLUGIN
+<ID>   unauthenticated user    <HOST_NAME>     NULL    Sleep   <TIME>  login   PLUGIN
+<ID>   unauthenticated user    <HOST_NAME>     NULL    Sleep   <TIME>  login   PLUGIN
 <ID>   root    <HOST_NAME>     test    Query   <TIME>  executing       /*first*/SELECT * FROM information_schema.processlist ORDER BY id
 <ID>   unauthenticated user    <HOST_NAME>     NULL    Sleep   <TIME>  login   PLUGIN
 <ID>   unauthenticated user    <HOST_NAME>     NULL    Sleep   <TIME>  login   PLUGIN
@@ -92,6 +97,11 @@
 UNINSTALL PLUGIN test_sql_errors;
 /*first*/SELECT * FROM information_schema.processlist ORDER BY id;
 ID     USER    HOST    DB      COMMAND TIME    STATE   INFO
+<ID>   unauthenticated user    <HOST_NAME>     NULL    Sleep   <TIME>  login   PLUGIN
+<ID>   unauthenticated user    <HOST_NAME>     NULL    Sleep   <TIME>  login   PLUGIN
+<ID>   unauthenticated user    <HOST_NAME>     NULL    Sleep   <TIME>  login   PLUGIN
+<ID>   unauthenticated user    <HOST_NAME>     NULL    Sleep   <TIME>  login   PLUGIN
+<ID>   unauthenticated user    <HOST_NAME>     NULL    Sleep   <TIME>  login   PLUGIN
 <ID>   root    <HOST_NAME>     test    Query   <TIME>  executing       /*first*/SELECT * FROM information_schema.processlist ORDER BY id
 <ID>   unauthenticated user    <HOST_NAME>     NULL    Sleep   <TIME>  login   PLUGIN
 <ID>   unauthenticated user    <HOST_NAME>     NULL    Sleep   <TIME>  login   PLUGIN

mysqltest: Result content mismatch

safe_process[37013]: Child process: 37014, exit: 1

 - the logfile can be found in '/home/danielgb/build_mysql-5.7/mysql-test/var/log/test_service_sql_api.test_sql_errors/test_sql_errors.log'
--------------------------------------------------------------------------
The servers were restarted 0 times
Spent 0.055 of 4 seconds executing testcases

Completed: Failed 1/2 tests, 50.00% were successful.

Failing test(s): test_service_sql_api.test_sql_errors

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

mysql-test-run: *** ERROR: there were failing test cases

[29 Mar 2016 4:07] MySQL Verification Team

Hello Daniel,

Thank you for the report.

Thanks,
Umesh

[29 Mar 2016 6:27] Daniel Black

test perfschema.start_server_low_table_lock also fails in a similar way. Like test_service_sql_api.test_sql_errors the differences in the information_schema need to be resolved on the second run.

[31 Mar 2016 13:13] Paul DuBois

Posted by developer:
 
Fixed in 5.8.0.

Changes for test suite. No changelog entry needed.