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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
