httpd-modules-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Matthew Kent <m...@bravenet.com>
Subject Re: mod_authn_dbd - internal server error after certain idle time
Date Fri, 06 Jul 2007 19:18:01 GMT
On Fri, 2007-06-07 at 15:07 -0400, Danie Qian wrote:
> I am using mod_authn_dbd and mod_dbd to do authentication again a mysql 
> database. Basically it works but after sometime I will get a internal server 
> error. I checked the log this happens at apr_dbd_pvselect() line in 
> mod_authn_dbd.c. So this looks like to me that apr_dbd_pvselect() is trying 
> to re-use a connection that is closed by the mysql server side whose 
> wait-timeout is set to 1200 seconds. my mod_dbd setting is this
> DBDMin  1
> DBDKeep 2
> DBDMax  50
> DBDExptime 60
> My question is why the keepalive setting for 60sec doesnt work for me? How 
> do I fix this without changing the timeout setting on the mysql server?
> 
> 

I've haven't used mod_authn_dbd yet but this sounds similar to issues I
was having

http://issues.apache.org/bugzilla/show_bug.cgi?id=39329

patch hasn't made its way into apr_dbd_mysql.c yet. Please add a note if
the it fixes your issue.

> Thanks,
> Daniel 
> 
-- 
Matthew Kent \ SA \ bravenet.com


Mime
View raw message