Bug #45605 ps_not_windows.test fails: The plugin feature is disabled, you need HAVE_DLOPEN
Submitted: 19 Jun 2009 10:06 Modified: 18 Dec 2009 11:45
Reporter: Sergey Petrunya Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Compiling Severity:S3 (Non-critical)
Version:5.1 OS:Linux (Ubuntu 9.01 amd64)
Assigned to: Davi Arnaut CPU Architecture:Any

[19 Jun 2009 10:06] Sergey Petrunya
Description:
ps_not_windows.test fails when one runs the test suite:

main.ps_not_windows                      [ fail ]
        Test ended at 2009-06-19 04:33:36

CURRENT_TEST: main.ps_not_windows
mysqltest: At line 13: query 'call proc_1()' failed with wrong errno 1289: 'The 'plugin' feature is disabled; you need MySQL built with 'HAVE_DLOPEN' to have it working', instead of 1124...

The result from queries just before the failure was:
create procedure proc_1() install plugin my_plug soname '/root/some_plugin.so';

 - saving '/var/lib/buildbot/maria-slave/psergey-pylon-amd64/build/mysql-test/var/log/main.ps_not_windows/' to '/var/lib/buildbot/maria-slave/psergey-pylon-amd64/build/mysql-test/var/log/main.ps_not_windows/'

Retrying test, attempt(2/3)...

main.ps_not_windows                      [ retry-fail ]
        Test ended at 2009-06-19 04:33:36

CURRENT_TEST: main.ps_not_windows
mysqltest: At line 13: query 'call proc_1()' failed with wrong errno 1289: 'The 'plugin' feature is disabled; you need MySQL built with 'HAVE_DLOPEN' to have it working', instead of 1124...

The result from queries just before the failure was:
create procedure proc_1() install plugin my_plug soname '/root/some_plugin.so';

 - saving '/var/lib/buildbot/maria-slave/psergey-pylon-amd64/build/mysql-test/var/log/main.ps_not_windows/' to '/var/lib/buildbot/maria-slave/psergey-pylon-amd64/build/mysql-test/var/log/main.ps_not_windows/'

Test has failed 2 times, no more retries!

main.query_cache                         [ pass ]   7072

How to repeat:
* Get latest 5.1 source from launchpad
* Compile with BUILD/compile-pentium64-max
  http://askmonty.org/buildbot/builders/jaunty-amd64-rel/builds/45/steps/compile/logs/stdio

* Run "make test-force":
http://askmonty.org/buildbot/builders/jaunty-amd64-rel/builds/45/steps/test/logs/stdio

* Observe the failure

Suggested fix:
I suspect there are two problems here:
- Why does the compilation process not recognize that Ubuntu default install supports HAVE_DLOPEN ? 
- If ps_not_windows.test does require plugin loading support then it should be skipped when support isn't compiled in.
[22 Jun 2009 23:10] Davi Arnaut
- Why does the compilation process not recognize that Ubuntu default install supports HAVE_DLOPEN ?

Server was built with --with-mysqld-ldflags=-all-static

- If ps_not_windows.test does require plugin loading support then it should be skipped when support isn't compiled in.

A matter of making a simple have_dynamic_loading variant to skip.
[2 Jul 2009 23:31] MySQL Verification Team
Thank you for the bug report.
[4 Sep 2009 19:54] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/82506

3112 Davi Arnaut	2009-09-04
      Bug#45605: ps_not_windows.test fails:
                 The plugin feature is disabled, you need HAVE_DLOPEN
      
      Selectively skip tests that require dynamic loading (ie: static builds).
     @ mysql-test/include/have_dynamic_loading.inc
        Add require file.
     @ mysql-test/t/ps_not_windows.test
        Test requires dynamic loading support.
[4 Sep 2009 20:03] Davi Arnaut
Queued to 5.1-bugteam
[14 Sep 2009 16:04] Bugs System
Pushed into 5.4.4-alpha (revid:alik@sun.com-20090914155317-m1g9wodmndzdj4l1) (version source revid:alik@sun.com-20090914155317-m1g9wodmndzdj4l1) (merge vers: 5.4.4-alpha) (pib:11)
[19 Sep 2009 16:54] Paul DuBois
Test case changes. No changelog entry needed.

Setting report to NDI pending push into 5.1.x.
[6 Oct 2009 9:00] Bugs System
Pushed into 5.1.40 (revid:joro@sun.com-20091006073316-lea2cpijh9r6on7c) (version source revid:mikael@mysql.com-20090907102257-fflwgm6rp5m5kmfw) (merge vers: 5.1.39) (pib:11)
[13 Oct 2009 9:33] MC Brown
Internal test change; no documentation needed
[18 Dec 2009 10:33] Bugs System
Pushed into 5.1.41-ndb-7.1.0 (revid:jonas@mysql.com-20091218102229-64tk47xonu3dv6r6) (version source revid:jonas@mysql.com-20091218095730-26gwjidfsdw45dto) (merge vers: 5.1.41-ndb-7.1.0) (pib:15)
[18 Dec 2009 10:49] Bugs System
Pushed into 5.1.41-ndb-6.2.19 (revid:jonas@mysql.com-20091218100224-vtzr0fahhsuhjsmt) (version source revid:jonas@mysql.com-20091217101452-qwzyaig50w74xmye) (merge vers: 5.1.41-ndb-6.2.19) (pib:15)
[18 Dec 2009 10:51] MC Brown
No changelog entry needed
[18 Dec 2009 11:04] Bugs System
Pushed into 5.1.41-ndb-6.3.31 (revid:jonas@mysql.com-20091218100616-75d9tek96o6ob6k0) (version source revid:jonas@mysql.com-20091217154335-290no45qdins5bwo) (merge vers: 5.1.41-ndb-6.3.31) (pib:15)
[18 Dec 2009 11:18] Bugs System
Pushed into 5.1.41-ndb-7.0.11 (revid:jonas@mysql.com-20091218101303-ga32mrnr15jsa606) (version source revid:jonas@mysql.com-20091218064304-ezreonykd9f4kelk) (merge vers: 5.1.41-ndb-7.0.11) (pib:15)
[18 Dec 2009 11:45] MC Brown
Already documented in 5.1.41