Bug 91085

Summary:	dev-perl/DBD-mysql-2.9003 error executing queries
Product:	Gentoo Linux	Reporter:	Georges Toth <sim0n>
Component:	[OLD] Server	Assignee:	Gentoo Perl team <perl>
Status:	RESOLVED INVALID
Severity:	major
Priority:	High
Version:	unspecified
Hardware:	x86
OS:	Linux
Whiteboard:
Package list:		Runtime testing required:	---

Description Georges Toth 2005-05-01 15:03:04 UTC

After upgrading to v2.9003, all my perl scripts were broken.
None were able to make a DB conenction...they all died with the following error:

DBD::mysql::st execute failed
Error: MySQL server has gone away

Changing some values on the my.cnf didn't help. Turning on query-log, or stracing it, didn't help neither.

Downgrading to dev-perl/DBD-mysql-2.1027, fixed the problem.
So I guess this is really a bug in the perl-module.

Reproducible: Always
Steps to Reproduce:
1.emerge dev-perl/DBD-mysql-2.9003
2.make a DB connection
3.do a query

Actual Results:  
Unsuccessful DB query 

Expected Results:  
Successful DB query

Comment 1 Michael Cummings (RETIRED) gentoo-dev

2005-05-02 01:34:58 UTC

Can we get some (simple) sample code for this? Will at least help us isolate the problem and send upstream if needed. Thanks!

Comment 2 Georges Toth 2005-05-02 04:18:43 UTC

After looking more into this problem, I just found that in some scripts i did a DB-disconnect, too early.
Changing that fixed those scripts.

But that means that the disconnect didn't work correctly in earlier versions ?? weird...

Also, I have a binary script, where the same problem occured, and without changing anything (well, I can't), the problem went away too.

Sorry for posting this... I should have checked it more in detail before posting.

Comment 3 Michael Cummings (RETIRED) gentoo-dev

2005-05-02 04:37:13 UTC

Not a problem. You had me all excited though - the chance to have found a bug instead of hearing about them for a change :)