5 messages in com.mysql.lists.javaRe: autoReconnect, host ports
FromSent OnAttachments
Gorazd Golob29 Jun 2004 03:20 
Mark Matthews29 Jun 2004 07:33 
Gorazd Golob29 Jun 2004 07:54 
Gorazd Golob29 Jun 2004 09:25 
Mark Matthews29 Jun 2004 12:50 
Subject:Re: autoReconnect, host ports
From:Mark Matthews (ma@mysql.com)
Date:06/29/2004 12:50:36 PM
List:com.mysql.lists.java

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1

Gorazd Golob wrote:

Also, what state is autoCommit in when the host goes down? Re-connection won't happen until autoCommit == true.

Yes, autoCommit is true. So when we try to establish connection to host2, when host1 is down, it won't work (when autoReconnect is also true). When we disable autoReconnect, failover is working - on the begging on the session it connects to host2.

hope it helps, gorazd

Gorazd,

I went ahead and filed this as a bug (http://bugs.mysql.com/?id=4334), so it would be better traceable.

This is now fixed for 3.0.15, and it will be in tonight's nightly snapshot build after 00:00 GMT at http://downloads.mysql.com/snapshots.php

Thanks,

-Mark

- -- Mr. Mark Matthews MySQL AB, Software Development Manager, J2EE and Windows Platforms Office: +1 708 332 0507 www.mysql.com

MySQL Guide to Lower TCO http://www.mysql.com/it-resources/white-papers/tco.php -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.3 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFA4cghtvXNTca6JD8RAtaoAJwNk7khtSuq+Tcw4MkF9aPYtm/DaACgjJ2t G2Xc5etN6R4A0OpsX89fXI8= =gZ6H -----END PGP SIGNATURE-----