Skip Menu |

This queue is for tickets about the DBD-mysql CPAN distribution.

Report information
The Basics
Id: 75353
Status: resolved
Priority: 0/
Queue: DBD-mysql

People
Owner: Nobody in particular
Requestors: FBRIERE [...] cpan.org
xcermak.martin [...] gmail.com
Cc: pali [...] cpan.org
AdminCc:

Bug Information
Severity: Normal
Broken in: (no value)
Fixed in: 4.033_03



Subject: select* methods output misleading error messages on InnoDB lock timeout
(Also filed on mysql.com as bug #64475.) The various select* methods (such as selectrow_hashref or selectcol_arrayref) output misleading error messages when a timeout occurs while waiting for an InnoDB lock. (For example, selectrow_hashref outputs "fetch() without execute()", and selectcol_arrayref outputs "Statement has no result columns to bind".) From the look of it, the methods appear to not notice that execute() has failed, and proceed to call fetch() nonetheless. The resulting error message thus reflects the failure from wrongly calling fetch(), instead of the original timeout error (which is found to be accurately reported by the MySQL server with DBI_TRACE).
Subject: rt.cpan.org #75353
Date: Tue, 14 Jan 2014 16:25:10 +0100
To: bug-DBD-mysql [...] rt.cpan.org
From: Martin Cermak <xcermak.martin [...] gmail.com>
Hi all, Is there any news for this bug? Do anyone know how to fix it or avoid the mentioned behavior? Thank you. Martin
I prepared patch for this bug: https://github.com/perl5-dbi/DBD-mysql/pull/50
Thanks Pali for the patch, it's in https://metacpan.org/pod/release/MICHIELB/DBD-mysql-4.033_03/lib/DBD/mysql.pm I'll create a full (non-dev) 4.034 release later this week if there are no strange CPAN Testers results. -- Michiel