httpd-bugs mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 39329] - mod_dbd ap_dbd_acquire failure
Date Thu, 18 May 2006 18:16:40 GMT
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG·
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=39329>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND·
INSERTED IN THE BUG DATABASE.

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





------- Additional Comments From mkent@magoazul.com  2006-05-18 18:16 -------
(In reply to comment #6)
> Just revisiting this, I hacked (In reply to comment #0)  
> > I'm using mod_dbd with persistant mysql connections and another custom  
> module to  
> > do vhost document root lookups against a database.   
> >   
> > The problems is that my mod_dbd connections reach the MySQL daemons  
> wait_timeout  
> > of 600 seconds and are closed automatically.  
>   
> Come to think of it, I thought mysql_ping (as used in the check_conn function)  
> would reopen the connection if it had timed out.  ISTR it doing that for me  
> when I tested it.  
>   
> Adding a new patch (untested).  Not decided whether to test and commit it. 

Just tested the latest patch and it almost works but bumps into an issue I've
run into with mysql before: when a connection is closed the first mysql_ping
will always fail and the handle needs a second command to actually reopen the
connection despite what the manual says
(http://dev.mysql.com/doc/refman/5.0/en/mysql-ping.html). Made a slight change
to your patch and its working fine in testing so far.

Also, as noted in the manual page, as of 5.0.3 MYSQL_OPT_RECONNECT is not on by
default, the driver needs to set it after mysql_init like

mysql_options(&mysql, MYSQL_OPT_RECONNECT, &my_true)

-- 
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.

---------------------------------------------------------------------
To unsubscribe, e-mail: bugs-unsubscribe@httpd.apache.org
For additional commands, e-mail: bugs-help@httpd.apache.org


Mime
View raw message