Note: I tried latest DBI and DBD::mysql, and the same DBI, DBD::mysql as
the old server. the result is the same.
and I don't have Apache::DBI enabled.
Thanks
On 2011/1/13 16:40, Fayland Lam wrote:
Hi,
here is the background:
1. we have everything fine on Perl v5.8.5 CentOS release 4.3 (Final)
2. the code is from a big Catalyst framework run under mod_perl 2.0.2
(we have DBIx::Class code but all errors are from plain DBI usage now)
we upgraded our OS to CentOS release 5.3 (Final) and we have some
encoding issue with our Catalyst application.
then we upgraded the Perl to 5.10.1 and re-build the mod_perl 2.0.4
but in the new server, we keeping getting
DBD::mysql::st fetchrow_array failed: fetch() without execute()
or
DBD::mysql::db selectrow_array failed: fetch() without execute()
we have several MySQL servers and all the errors happens with
5.1.39-community-log MySQL Community Server (GPL)
fine with Server version: 5.0.77-log Source distribution
I posted the DBI->trace(6) info in pastebin:
Correct: http://pastebin.com/XjFfmJYJ
FAIL: http://pastebin.com/iTPCMusG
1 <- prepare= DBI::st=HASH(0x2acbe173f728) at Report.pm line 963 via
at Report.pm line 763
-> dbd_st_execute for 2acbf5c22de0
<- dbd_st_execute 1 rows
-> dbd_st_fetch for 2acbf5c22de0, chopblanks 0
fetch() without execute() error 19 recorded: fetch() without execute()
!! ERROR: 19 'fetch() without execute()' (err#0)
other notes I tried:
1. if I change fetchrow_array on SQL "SELECT 1" to $sth->rows > 1,
nothing will be wrong.
2. if I change selectrow_array to prepare + execute + fetchrow_array,
fails (SQL is SELECT COUNT(*) so I can't really do $sth->rows I think)
3. the issue is not happening at the beginning when we restart the
Apache. but after few minutes, it happens. keeping having this issues.
never gone.
my OS is 64bit and Perl 5.10 is built with
-des -A ccflags=-fPIC -Dinstallprefix=/usr -Dprefix=/usr -Duseshrplib
-Dusethreads -Duseithreads -Duselargefiles -Dinstallusrbinperl
so the DBI is ithreads one. (Note old one is ithreads too)
DBD::mysql is not from yum install but I did it manually (with yum
install mysql-devel then cpanm it)
Do anyone here have the same issue before? and share me some thoughts?
if you need any more info or anything you want me to try, just let me
know.
Thanks
--
Fayland Lam // http://www.fayland.org/
