Bug #50540 Broken zlib and missing lib/mysql LD_LIBRARY_PATH in MTR
Submitted: 22 Jan 2010 11:20 Modified: 17 Jun 2010 19:39
Reporter: Bernd Ocklin Email Updates:
Status: Closed Impact on me:
None 
Category:Tools: MTR / mysql-test-run Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: Bernd Ocklin CPU Architecture:Any

[22 Jan 2010 11:20] Bernd Ocklin
Description:
zlib path is broken in MTR. And the general lib/mysql path is missing from the LD_LIBRARY_PATH list in MTR. 

In standard builds without pkglibdir option (e.g. PB2) all libraries are installed into $basedir/lib/mysql. There they are not found as LD_LIBRARY_PATH is only set to $basedir/lib.

How to repeat:
When compiling mysql binaries for PB2 all libraries are placed in lib/mysql. This path is not the LD_LIBRARY_PATH.

The issue is not materializing with current standard mysql server tests but in new Cluster/J tests. We execute a Java program from MTR which loads the JNI library libndbjtie dynamically. While this is found the depended dynamic libraries such as libndbclient are not found. 

Suggested fix:
--- mysql-test/mysql-test-run.pl	2010-01-21 16:31:00 +0000
+++ mysql-test/mysql-test-run.pl	2010-01-22 10:56:21 +0000
@@ -1782,11 +1782,11 @@
     {
       push(@ld_library_paths, "$basedir/libmysql/.libs/",
 	   "$basedir/libmysql_r/.libs/",
-	   "$basedir/zlib.libs/");
+	   "$basedir/zlib/.libs/");
     }
     else
     {
-      push(@ld_library_paths, "$basedir/lib");
+      push(@ld_library_paths, "$basedir/lib", "$basedir/lib/mysql");
     }
   }
[22 Jan 2010 13:13] 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/97872

2883 Bernd Ocklin	2010-01-22
      fix LD_LIBRARY_PATH (bug#50540)
[25 Jan 2010 12:47] Bjørn Munch
Pushed to 5.1-mtr, trunk-mtr, next-mr-mtr, 6.0-codebase-mtr
[20 Feb 2010 9:32] Bugs System
Pushed into 6.0.14-alpha (revid:alik@sun.com-20100220092844-jh07ayojyxn8uh9p) (version source revid:bjorn.munch@sun.com-20100125123531-2dxmmczd9hfm4ye1) (merge vers: 6.0.14-alpha) (pib:16)
[20 Feb 2010 9:34] Bugs System
Pushed into 5.5.3-m2 (revid:alik@sun.com-20100220092622-wvhh1vfy5tjq4mhu) (version source revid:bjorn.munch@sun.com-20100125102422-uz803coqz5tqkhfz) (merge vers: 5.5.1-m2) (pib:16)
[20 Feb 2010 9:37] Bugs System
Pushed into mysql-next-mr (revid:alik@sun.com-20100220092730-paoo5t9gcajs5dq8) (version source revid:bjorn.munch@sun.com-20100125103031-em5g54dq400bi7sf) (pib:16)
[23 Feb 2010 2:15] Paul DuBois
Changes to test suite. No changelog entry needed.

Setting report to Need Merge pending push to 5.1.x, Celosia.
[1 Mar 2010 8:47] Bugs System
Pushed into 5.1.45 (revid:joro@sun.com-20100301083827-xnimmrjg6bh33o1o) (version source revid:azundris@mysql.com-20100222175719-viuh0f3gdsrkgv0r) (merge vers: 5.1.45) (pib:16)
[1 Mar 2010 16:31] Paul DuBois
No changelog entry needed.
[17 Jun 2010 12:21] Bugs System
Pushed into 5.1.47-ndb-7.0.16 (revid:martin.skold@mysql.com-20100617114014-bva0dy24yyd67697) (version source revid:vasil.dimov@oracle.com-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)
[17 Jun 2010 13:09] Bugs System
Pushed into 5.1.47-ndb-6.2.19 (revid:martin.skold@mysql.com-20100617115448-idrbic6gbki37h1c) (version source revid:martin.skold@mysql.com-20100609140708-52rvuyq4q500sxkq) (merge vers: 5.1.45-ndb-6.2.19) (pib:16)
[17 Jun 2010 13:49] Bugs System
Pushed into 5.1.47-ndb-6.3.35 (revid:martin.skold@mysql.com-20100617114611-61aqbb52j752y116) (version source revid:vasil.dimov@oracle.com-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)