RE: Weird DBI/DBD-mysql problem

This was actually a problem with the MySQL 4.1.9 release:


http://dev.mysql.com/doc/mysql/en/news-4-1-10.html

"Column headers in query results retrieved from the query cache could be corrupted when a non-4.1 client was served a result originally generated for a 4.1 client. The query cache was not keeping track of which client/server protocol was being used. (Bug #6511)"

http://bugs.mysql.com/bug.php?id=6511

Looks remarkably like what we've been seeing. 

Thanks for your help. I upgraded to 4.1.10 and everything went away nicely.

--Tim


-----Original Message-----
From: Rudy Lippan [mailto:[email protected]] 
Sent: Thursday, February 17, 2005 5:31 PM
To: Sehn, Timothy
Cc: [email protected]; Dyer, Christopher
Subject: Re: Weird DBI/DBD-mysql problem


On Thu, 17 Feb 2005, Sehn, Timothy wrote:

> I am having a problem with these modules and I was wondering if anyone 
> has run into it before:
> 
> Amazon::ContactUs::ReportDB::get_types(/apollo/_env/devcentral-2534631/perl/lib/perl-std-5.6.1/Amazon/ContactUs/ReportDB.pm:391):
> 391:       my $sth = $this->{DB}->prepare("select type_name from faq_type;");
> 
>   DB<2> n
> Amazon::ContactUs::ReportDB::get_types(/apollo/_env/devcentral-2534631/perl/lib/perl-std-5.6.1/Amazon/ContactUs/ReportDB.pm:392):
> 392:       $sth->execute();
> 
>   DB<2> n
> Amazon::ContactUs::ReportDB::get_types(/apollo/_env/devcentral-2534631/perl/lib/perl-std-5.6.1/Amazon/ContactUs/ReportDB.pm:394):
> 394:       while ( my $ref = $sth->fetchrow_hashref() )
> 395:       {
> 
>   DB<2> use Data::Dumper
> 
>   DB<3> p Dumper $sth->fetchrow_hashref()
> $VAR1 = {
>           '@' => 'Build/Compile/Link Errors'
>         };

1. Is there a reason that you are calling fetchrow_hashref() in a loop as well 
as in the loop conditional?

2. I can't for the life of me figure out why you are getting that (But that 
might just fall out of my not being able to read right now ;) ). Could you send 
a DBI->trace(9) of that section of code and I'll see if I can make sense of 
that.

Rudy


-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/[email protected]