Re: [CDBI] Prepared statement handle error under mod_perl

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

From: Ryan Tate
Subject: Re: [CDBI] Prepared statement handle error under mod_perl
Date: 17:57 on 19 Jan 2006
On 1/19/06, Perrin Harkins <perrin@xxxx.xxx> wrote:
> You can probably just kill the connection from the server side to get
> the same effect.

That would be far too intelligent ... but I tried this technique at
your insistence.

Doing so, I was able to confirm that this was an issue with
mysql_auto_reconnect. Setting it to 0 in my connection attributes
allowed my Web app to survive a stop and start of mysqld just fine.
Leaving the DBD::mysql default in place (and thus leaving
mysql_auto_reconnect at 1, since I'm running under mod_perl), the Web
app produced the aforementioned error after stopping and then starting
mysqld.

So thanks for solving this problem!

RT

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

Re: [CDBI] Prepared statement handle error under mod_perl
Ryan Tate 17:57 on 19 Jan 2006

Generated at 09:31 on 23 Jan 2006 by mariachi v0.52