Bug #72334 Testcase multi_plugin_load broken
Submitted: 14 Apr 2014 5:51 Modified: 29 Apr 2014 23:42
Reporter: Laurynas Biveinis (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:Tests: Server Severity:S3 (Non-critical)
Version:5.6,5.7 OS:Any
Assigned to: CPU Architecture:Any
Tags: mtr, plugin

[14 Apr 2014 5:51] Laurynas Biveinis
Description:
Testcase multi_plugin_load is always skipped due to the way it's written:

the master options file:

$PLUGIN_AUTH_OPT
$PLUGIN_AUTH_LOAD
$PLUGIN_AUTH_INTERFACE_LOAD_ADD
$PLUGIN_AUTH_SERVER_LOAD

the testcase:
--source include/have_plugin_auth.inc
[...]

The options file results in PLUGIN_AUTH_LOAD being overridden with PLUGIN_AUTH_SERVER_LOAD, which is tested in the testcase itself later. But have_plugin_auth.inc expects the former plugin to be present.

How to repeat:
./mysql-test-run multi_plugin_load
...
main.multi_plugin_load                   [ skipped ]  Need the plugin test_plugin_server

Suggested fix:
Replace the have_plugin_auth.inc with a snippet or include that checks for the presence of qa_auth_server instead.
[14 Apr 2014 6:02] Umesh Shastry
Hello Laurynas,

Thank you for the report.
Verified as described.

Thanks,
Umesh
[14 Apr 2014 6:03] Umesh Shastry
// 5.7.5

 ./mysql-test-run multi_plugin_load
Logging: ./mysql-test-run  multi_plugin_load
MySQL Version 5.7.5
Checking supported features...
 - SSL connections supported
Collecting tests...
Checking leftover processes...
Removing old var directory...
Creating var directory '/data/ushastry/server/mysql-5.7.5/mysql-test/var'...
Installing system database...

==============================================================================

TEST                                      RESULT   TIME (ms) or COMMENT
--------------------------------------------------------------------------

worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009
main.multi_plugin_load                   [ skipped ]  Need the plugin test_plugin_server
--------------------------------------------------------------------------
The servers were restarted 0 times
Spent 0.000 of 17 seconds executing testcases

Completed: All 0 tests were successful.

1 tests were skipped, 1 by the test itself.

// 5.6.18

MySQL Version 5.6.18
Checking supported features...
 - SSL connections supported
Collecting tests...
Checking leftover processes...
Removing old var directory...
Creating var directory '/data/ushastry/server/mysql-5.6.18/mysql-test/var'...
Installing system database...

==============================================================================

TEST                                      RESULT   TIME (ms) or COMMENT
--------------------------------------------------------------------------

worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009
main.multi_plugin_load                   [ skipped ]  Need the plugin test_plugin_server
--------------------------------------------------------------------------
The servers were restarted 0 times
Spent 0.000 of 16 seconds executing testcases

Completed: All 0 tests were successful.

1 tests were skipped, 1 by the test itself.
[29 Apr 2014 23:42] Paul Dubois
Fixed in 5.7.5.

Changes for test suite. No changelog entry needed.