Bug #72334 Testcase multi_plugin_load broken

• Submitted: 14 Apr 2014 5:51
• Modified: 29 Apr 2014 23:42
• Reporter: Laurynas Biveinis (OCA)
• Status: Closed
• Category: Tests: Server
• Severity: S3 (Non-critical)
• Version: 5.6,5.7
• OS: Any
• 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.