On Friday 07 April 2006 01:55, Frank Sweetser wrote: > On Thu, Apr 06, 2006 at 09:36:39PM +0200, Kern Sibbald wrote: > > On MySQL databases, Bacula *specifically* requests that MySQL not timeout > > the connection. > > > > If this is only a problem with MySQL 5, then most likely MySQL has > > changed something concerning timeouts, or has a bug. Bacula has not > > "officially" been tested with MySQL 5, which I still consider immature > > (unstable if you will). > > I think I found it: > > http://dev.mysql.com/doc/refman/5.0/en/mysql-real-connect.html > > last paragraph: > > ---8<--- > Note that upon connection, mysql_real_connect() sets the reconnect flag > (part of the MYSQL structure) to a value of 1 in versions of the API older > than 5.0.3, or 0 in newer versions. A value of 1 for this flag indicates > that if a statement cannot be performed because of a lost connection, to > try reconnecting to the server before giving up. As of MySQL 5.0.13, you > can use the MYSQL_OPT_RECONNECT option to mysql_options() to control > reconnection behavior. ---8<--- > > This implies to me that the disconnects have been happening all along, but > because bacula set the reconnect flag, the database connection was silently > restored. If bacula were to ever support database level transactions, it's > worth noting that using the reconnect flag will break transactions.
Bacula sets the mysql.reconnect flag to 1 prior to calling real_connect() so the above behavior in versions greater than 5.0.3 (implemented by a bunch of idiots) explains the problem. I wonder what you do in versions between 5.0.3 and 5.0.13. I also wonder if MYSQL_OPT_RECONNECT is available or at least ignored on older versions. Sorry for the nasty comments, but the MySQL programmers are really not very cleaver. I'm not intending to put a lot of MySQL version detecting code in Bacula. Bacula already has enough of that kind of idiocy with Windows. So, I would appreciate it if someone who is using one of the new broken versions of MySQL would research the issue enough to determine a reasonable way of working around this problem ... -- Best regards, Kern ("> /\ V_V ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users