MySQL Bugs: #23983: ps.test fails to open shared library

Bug #23983	ps.test fails to open shared library
Submitted:	5 Nov 2006 9:16	Modified:	13 Dec 2006 19:57
Reporter:	Magnus Blåudd	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Prepared statements	Severity:	S3 (Non-critical)
Version:	5.1	OS:	Windows (win2003-x86)
Assigned to:	Iggy Galarza	CPU Architecture:	Any

Description:
This looks really strange. Is there really a shared library involved in this test?

ps                             [ fail ]

Errors are (from e:/pb/mysql-5.1/1351/mysql-5.1.13-beta-pb1351/mysql-test/var-n_stm-5/log/mysqltest-time) :
mysqltest: At line 2095: query 'call proc_1()' failed with wrong errno 1126: 'Can't open shared library 'e:/pb/mysql-5.1/1351/mysql-5.1.13-beta-pb1351/mysql-test/lib///r' (errno: 2 )', instead of 1124...
(the last lines may be the most important ones)
Result from queries before failure can be found in r/ps.log

How to repeat:
Look at PushBuild testing on win2003-x86

Same effect in test builds of 5.1.12-beta,
both on win2003-x86 and win2003-amd64.

If I counted correct, the path name in the output has 64 characters, so it might be just a string length issue.

Raising priority, as it affects release build tests.

Seems to be several problems actually. One is that the buffer
holding the complete path to the plugin is limited by 64
characters. Another that running it from one environment setup
(Cygwin Perl calling Cygwin Perl and "mysql-test-run.pl" the path
doesn't get translated to use forward slashes, and displays as

  d:\mysql-5.1.12-beta-winbuild\mysql-5.1.12-beta-winx64\lib///roo

Shortening the directory path and running the test in another environment
(directly Cygwin Perl and "mysql-test-run")

  d:/mysql-5.1.12-beta-winbuild/a/mysql-test/lib///root/some_plugi

Shortening it even more, the complete path fits

  d:/a/mysql-test/lib///root/some_plugin.so

Don't know why the extra slashes shows up.

Making the path not being cut off doesn't solve the problem,
that errno is 2 instead of 1124.

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/15527

ChangeSet@1.2379, 2006-11-17 16:52:41-05:00, iggy@amd64. +6 -0
  Bug#23983 ps.test fails to open shared library.
  - When a shared library argument is supplied, it's checked for an OS
  specific directory separator.  The expected error is different
  depending on the separator used. Created OS specific versions of these
  tests.

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/15566

ChangeSet@1.2381, 2006-11-20 14:11:12-05:00, iggy@amd64. +2 -0
  Bug#23983 ps.test fails to open shared library.
  - Corrected mistake in Windows only test.

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/15572

ChangeSet@1.2368, 2006-11-20 15:18:57-05:00, iggy@amd64. +6 -0
  Bug#23983 ps.test fails to open shared library
  - When a shared library argument is supplied, it's checked for an OS
  specific directory separator. The expected error is different
  depending on the separator used. Create OS specific versions of these
  tests.

No changelog entry needed.