Greetings,
I've just finished installing 4.1 alpha (yes, I know, alpha) on a test setup.
Now that I'm starting to stress test it, I've run into an odd bug:
Every once in a while, (and from what I can tell, randomly) the server will
reject the attempted connection from another host on the network with an
access denied message.
Perl script used to test:
#!/usr/bin/perl
use DBI;
# Set up the DB connection
my $dsn = "dbi:mysql:host=192.168.0.201;database=test";
my $user = "user";
my $password = "password";
$goodcount = 0;
$errorcount = 0;
$bar = 0;
while ($bar < 1000) {
$dbh = DBI->connect($dsn, $user, $password, {PrintError => 1});
if ($DBI::errstr) {
$errorcount++;
print "!";
} else {
$goodcount++;
print ".";
}
$dbh->disconnect();
$bar++;
}
print "\n$goodcount / $errorcount\n";
The end result is that somewhere along the line, usually before connection
attempt #100 is reached, the following occurs:
DBI connect('host=192.168.0.201;database=test','user',...) failed: Access
denied for user: '[EMAIL PROTECTED]' (Using password: YES) at a.pl line 26
I'm also seeing the same intermittent failures in my PHP scripts.
Linux text.box.invalid 2.4.20-20.9 #1 Mon Aug 18 11:45:58 EDT 2003 i686 i686
i386 GNU/Linux
RedHat 9 based system, fully updated glibc etc. MySQL 4.1 installed from the
RPMs provided on the mysql.com site.
I can work around the issue in my PHP scripts, merely by looping the
connection attempt a set number of times if a failure is encountered. Not
the nicest of solutions though.
Is this a known problem in 4.1? Any better way I can debug it to provide
info?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
