----- Original Message -----
From: "Nick Kew" <nick@webthing.com>
To: <modules-dev@httpd.apache.org>
Sent: Saturday, July 07, 2007 4:38 AM
Subject: Re: mod_authn_dbd - internal server error after certain idle time
> On Fri, 06 Jul 2007 18:37:07 -0700
> Matthew Kent <matt@bravenet.com> wrote:
>
>> After some testing I think I better understand the issue, updated it
>> here
>>
>> http://issues.apache.org/bugzilla/show_bug.cgi?id=39329#c11
>
> Thanks. I saw that already (notification email reached me ahead of
> this one).
>
>> think its the mysql_ping reconnection clobbering the prepared
>> statement
>> used in mod_authn_dbd.
>
> Buggrit. I can't see a satisfactory workaround for that.
> I guess the kludge suggested by Tom Donovan in this thread
> could be the best practical solution.
>
It is working a little better now after I set both DBDKeep and DBDMin to
zero. But I am still getting the internal server error from time to time.
Users usually can get pass the error by reloading the same page. Here is the
error messages in the log:
[Sat Jul 07 02:56:44 2007] [error] (20014)Internal error: DBD [mysql] Error:
Lost connection to MySQL server during query
[Sat Jul 07 02:56:44 2007] [error] [client 75.87.112.250] authn_dbd_acquire:
Error looking up josiahhansen in database
|