Bug #103306 for DBD-mysql: fetchrow_hashref and fetchall_hashref generates errors #2000 when in async mode

Sat Apr 04 10:14:21 2015 anotheroneackap [...] gmail.com - Ticket created

Subject:	fetchrow_hashref and fetchall_hashref generates errors #2000 when in async mode
Date:	Sat, 4 Apr 2015 17:14:09 +0300
To:	bug-DBD-mysql [...] rt.cpan.org
From:	Ackap AnotherOne <anotheroneackap [...] gmail.com>

I had it on DBD::mysql v.4.021 and perl v5.14.2) built for x86_64-linux-gnu-thread-multi, uname -a is Linux anotheroneackap 2.6.32-042stab094.7 #1 SMP Wed Oct 22 12:43:21 MSK 2014 x86_64 GNU/Linux See discussion in https://github.com/jhthorsen/mojo-mysql/issues/1 Briefly: The call to fetchrow_hashref activates error 2000. This is becase DBD::mysql calls *mysql_async_ready* and *mysql_async_result* for each call to *fetchrow_hashref* and *fetchall_hashref*. It does not do the same check for *fetchrow_arrayref* and *fetchall_arrayref*. This issue is not directed to the correct project. If you need a fix comment out lines 854-881 in lib/DBD/mysql.pm of the latest 4.031 version of DBD::mysql.

Tue Apr 07 14:59:21 2015 MICHIELB [...] cpan.org - Correspondence added

Hi, thanks for your report. Please see my comment at https://github.com/jhthorsen/mojo-mysql/issues/1#issuecomment-90697780 -- I have a hard time creating a test for the issue. -- Michiel

Tue Apr 07 14:59:21 2015 The RT System itself - Status changed from 'new' to 'open'

Wed May 17 12:56:22 2017 pali [...] cpan.org - Cc PALI added

Wed May 17 12:56:36 2017 pali [...] cpan.org - Correspondence added

On Sob Apr 04 10:14:21 2015, anotheroneackap@gmail.com wrote: Show quoted text

> I had it on DBD::mysql v.4.021 and perl v5.14.2) built for > x86_64-linux-gnu-thread-multi, uname -a is > Linux anotheroneackap 2.6.32-042stab094.7 #1 SMP Wed Oct 22 12:43:21 MSK > 2014 x86_64 GNU/Linux > > See discussion in https://github.com/jhthorsen/mojo-mysql/issues/1 > > Briefly: > > The call to fetchrow_hashref activates error 2000. > This is becase DBD::mysql calls *mysql_async_ready* and > *mysql_async_result* for > each call to > *fetchrow_hashref* and *fetchall_hashref*. > It does not do the same check for *fetchrow_arrayref* and > *fetchall_arrayref*. > > This issue is not directed to the correct project. > If you need a fix comment out lines 854-881 in lib/DBD/mysql.pm of the > latest 4.031 version of DBD::mysql.

Fix is in this pull request: https://github.com/perl5-dbi/DBD-mysql/pull/124

Wed Nov 15 02:53:43 2017 MICHIELB [...] cpan.org - Correspondence added

Ticket migrated to github as https://github.com/perl5-dbi/DBD-mysql/issues/201

Wed Nov 15 02:53:46 2017 MICHIELB [...] cpan.org - Status changed from 'open' to 'resolved'