httpd-modules-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Danie Qian" <dan...@bestningning.com>
Subject Re: mod_authn_dbd - internal server error after certain idle time
Date Sat, 07 Jul 2007 15:38:39 GMT

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



Mime
View raw message