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=102026513407236&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 <joel <at> alpsgiken.gr.jp>
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 <at> m.gmane.org