Bug #27788 regression tests: grant2 failed.
Submitted: 12 Apr 2007 17:48 Modified: 24 Apr 2007 5:22
Reporter: Horst Hunger Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.36 OS:Linux (64 bit)
Assigned to: CPU Architecture:Any

[12 Apr 2007 17:48] Horst Hunger
Description:
grant2                         [ fail ]

Errors are (from /home/hhunger/mysql-enterprise-gpl-5.0.36-linux-x86_64-glibc23/mysql-test/var/log/mysqltest-time) :
mysqltest: At line 469: query 'connect  con1,localhost,mysqltest_1,password,TESTDB' failed: 1045: Access denied for user 'mysqltest_1'@'localhost' (using password: YES)
(the last lines may be the most important ones)
Result from queries before failure can be found in r/grant2.log

Stopping All Servers
Shutting-down Instance Manager
Restoring snapshot of databases
Resuming Tests

How to repeat:
run grant2 with 5.0.36
[13 Apr 2007 4:01] Valeriy Kravchuk
Thank you for a problem report. Sorry, but I was not able to repeat the behaviour described:

-bash-2.05b$ cd mysql-enterprise-gpl-5.0.36-linux-x86_64-glibc23
-bash-2.05b$ cd mysql-test/
-bash-2.05b$ ./mysql-test-run.pl grant2
Logging: ./mysql-test-run.pl grant2
MySQL Version 5.0.36
Skipping ndbcluster, mysqld not compiled with ndbcluster
Setting mysqld to support SSL connections
Using MTR_BUILD_THREAD      = 0
Using MASTER_MYPORT         = 9306
Using MASTER_MYPORT1        = 9307
Using SLAVE_MYPORT          = 9308
Using SLAVE_MYPORT1         = 9309
Using SLAVE_MYPORT2         = 9310
Using IM_PORT               = 9312
Using IM_MYSQLD1_PORT       = 9313
Using IM_MYSQLD2_PORT       = 9314
Killing Possible Leftover Processes
Removing Stale Files
Creating Directories
Installing Master Database
Installing Master Database
=======================================================
Starting Tests in the 'main' suite

TEST                           RESULT         TIME (ms)
-------------------------------------------------------

grant2                         [ pass ]            569
-------------------------------------------------------
Stopping All Servers
Warning;  Aborted waiting on pid file: '/users/vkravchuk/mysql-enterprise-gpl-5.
0.36-linux-x86_64-glibc23/mysql-test/var/run/master.pid' after 70 seconds
All 1 tests were successful.
The servers were restarted 1 times
Spent 0.569 seconds actually executing testcases

-bash-2.05b$ uname -a
Linux hammer.mysql.com 2.4.21-32.EL #1 Fri Apr 15 21:18:42 EDT 2005 x86_64 x86_6
4 x86_64 GNU/Linux

So, please, send the results of:

uname -a
env
getconf GNU_LIBPTHREAD_VERSION

from your environment.
[24 Apr 2007 5:22] Valeriy Kravchuk
So, I think, we can close this bug report as "Can't repeat" for now.