Re: [CDBI] Prepared statement handle error under mod_perl

[prev] [thread] [next] [Date index for 2006/01/18]

On Wed, 2006-01-18 at 15:35 -0800, Ryan Tate wrote:
> Since the DBD::mysql upgrade to true prepared statements, when I
> switch one of my CDBI Web apps from CGI mode to mod_perl (persistent),
> I will get the following sort of error whenever the app has been out
> of use for several hours (just me using it at moment):
> 
> DBD::mysql::st execute failed: Unknown prepared statement handler (11)
> given to mysql_stmt_execute [for Statement "(SQL cut here)"] at
> /usr/local/share/perl/5.8.4/DBIx/ContextualFetch. pm line 51.

I wonder if the auto-reconnect feature in MySQL is doing a reconnect
without the knowledge of the perl code.  That could cause something like
this.  Try disabling MySQL's auto-reconnect feature.

- Perrin


_______________________________________________
ClassDBI mailing list
ClassDBI@xxxxx.xxxxxxxxxxxxxxxx.xxx
http://lists.digitalcraftsmen.net/mailman/listinfo/classdbi