Weird DBI/DBD-mysql problem

Hey all,

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/devcentr al-2534631/pe=
rl/lib/perl-std-5.6.1/Amazon/ContactUs/ReportDB.pm:391):
391: my $sth =3D $this->{DB}->prepare("select type_name from =
faq_type;");

DB<2> n
Amazon::ContactUs::ReportDB::get_types(/apollo/_env/devcentr al-2534631/pe=
rl/lib/perl-std-5.6.1/Amazon/ContactUs/ReportDB.pm:392):
392: $sth->execute();

DB<2> n
Amazon::ContactUs::ReportDB::get_types(/apollo/_env/devcentr al-2534631/pe=
rl/lib/perl-std-5.6.1/Amazon/ContactUs/ReportDB.pm:394):
394: while ( my $ref =3D $sth->fetchrow_hashref() )
395: {

DB<2> use Data::Dumper

DB<3> p Dumper $sth->fetchrow_hashref()
$VAR1 =3D {
'@' =3D> 'Build/Compile/Link Errors'
};

I am running MySQL 4.1.9 server, MySQL 4.1.8 client libraries, DBI 1.46, =
and DBD-mysql-2.9004.

Any help would be appreciated.

--Tim

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=3Dgcdmp-msql-mysql-modules @m.gmane.org

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/devcentr al-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/devcentr al-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/devcentr al-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/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

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=3D6511

Looks remarkably like what we've been seeing.=20

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

--Tim


-----Original Message-----
From: Rudy Lippan [mailto:rlippan@remotelinux.com]=20
Sent: Thursday, February 17, 2005 5:31 PM
To: Sehn, Timothy
Cc: msql-mysql-modules@lists.mysql.com; 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:
>=20
> =
Amazon::ContactUs::ReportDB::get_types(/apollo/_env/devcentr al-2534631/pe=
rl/lib/perl-std-5.6.1/Amazon/ContactUs/ReportDB.pm:391):
> 391: my $sth =3D $this->{DB}->prepare("select type_name from =
faq_type;");
>=20
> DB<2> n
> =
Amazon::ContactUs::ReportDB::get_types(/apollo/_env/devcentr al-2534631/pe=
rl/lib/perl-std-5.6.1/Amazon/ContactUs/ReportDB.pm:392):
> 392: $sth->execute();
>=20
> DB<2> n
> =
Amazon::ContactUs::ReportDB::get_types(/apollo/_env/devcentr al-2534631/pe=
rl/lib/perl-std-5.6.1/Amazon/ContactUs/ReportDB.pm:394):
> 394: while ( my $ref =3D $sth->fetchrow_hashref() )
> 395: {
>=20
> DB<2> use Data::Dumper
>=20
> DB<3> p Dumper $sth->fetchrow_hashref()
> $VAR1 =3D {
> '@' =3D> 'Build/Compile/Link Errors'
> };

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

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

Rudy


--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=3Dgcdmp-msql-mysql-modules @m.gmane.org