fetchrow_array() failed: fetch() without execute() ..., with intermittant syntax error

We have a web system (Perl) that is intermittantly giving this error:

DBD::mysql::st fetchrow_array() failed: fetch() without
execute() at ... webmin

Sometimes it also gives this error

DBD::mysql::st execute failed: You have an error in your
SQL syntax near ') GROUP BY

and so forth.

We've dumped the statement that is being executed and run it from the
command line without errors, but since these errors are intermittant,
that is not surprising.

System information:
Solaris 2.8 -- sparc
perl 5.6.1
MySQL 3.23.45
Apache 1.3.27
Mod-ssl 2.8.11
OpenSSL 0.9.6i

These errors started showing up after upgrading apache and installing
mod-ssl, and after raising the log level on apache. We are not,
therefore sure if they were there before the upgrade.

Does this ring a bell with anyone? I've checked the archives and found
some mention of possible deadlock related problems,

http://marc.theaimsgroup.com/?l=msql-mysql-modules&m=1020265 13407236&w=2

and we're looking into that and other things we have thought of, but we
would appreciate any leads we can get.

--
Joel Rees
http://www.alpsgiken.co.jp


--
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