Mailing-List: contact modules-dev-help@httpd.apache.org; run by ezmlm
Precedence: bulk
Reply-To: modules-dev@httpd.apache.org
Received-SPF: pass (herse.apache.org: local policy)
Message-ID: <01a501c7c0ac$e41185d0$66d482d8@CORP.LOCAL>
Reply-To: "Danie Qian" <daniel@bestningning.com>
From: "Danie Qian" <daniel@bestningning.com>
To: <modules-dev@httpd.apache.org>
References: 
 <00b701c7c000$f2f71300$66d482d8@CORP.LOCAL><1183749481.5095.44.camel@fuego><00d501c7c007$700c0b10$66d482d8@CORP.LOCAL><1183752783.5095.56.camel@fuego><20070706230429.34edfd4a@grimnir><1183772227.5095.70.camel@fuego>
 <20070707093828.618637f7@grimnir>
Subject: Re: mod_authn_dbd - internal server error after certain idle time
Date: Sat, 7 Jul 2007 11:38:39 -0400
MIME-Version: 1.0
Content-Type: text/plain;
	format=flowed;
	charset="gb2312";
	reply-type=original
Content-Transfer-Encoding: 7bit


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