Bug #37179 Enable auto reconnect dont work in this version
Submitted: 4 Jun 2008 3:02 Modified: 5 Jan 17:51
Reporter: Roberto Valente
Status: Closed
Category:Connector/ODBC Severity:S2 (Serious)
Version:5.1.4, 3.51 OS:Any
Assigned to: Bugs System Target Version:
Tags: enable auto reconnect
Triage: D2 (Serious)

[4 Jun 2008 3:02] Roberto Valente 
Description:
The option Enable auto reconnect dont work in this version
I tested many applications at version 3.51 and when occurs 
connection fail, with, Enable auto reconnect, the connection
is restored.
Using connector 5.1, when connection fail, the connection can´t be
restored, and the errors are the same as if the option
was not marked.

How to repeat:
Open any application using the 5.1 connector
(with Enable auto reconnect option marked)
Connect to Mysql Database
Disable the network connection
Restore the network connection
Try to access the database (ex: a query)

An exception will occuour as if the the 
Enable auto reconnect option was not marked.
[4 Jun 2008 18:56] Valeriy Kravchuk 
Thank you for a problem report. What exact version, 5.1.x, do you use? 5.1.4 is the
latest.
[4 Jun 2008 19:04] Roberto Valente 
Hi
The ODBC version is the latest (5.1.4)

Thanks
[7 Jun 2008 0:49] Jess Balint 
Verified by killing session while Access has connection open.
[7 Jun 2008 1:01] Jess Balint 
Problem caused by adding #ifdefs in headers:

#ifdef MYSQL_OPT_RECONNECT /* disabled if not included in build header */
...
#endif /* MYSQL_OPT_RECONNECT */

Enum values from mysql.h not visible as cpp macros.
[18 Aug 2008 19:00] Jess Balint 
Fix committed as rev 1141 and will be released in 3.51.27.
[5 Jan 17:51] Tony Bedford 
An entry was added to both the 3.51.27 and 5.1.6 changelogs:

The connection string option Enable Auto-reconnect did not work. When the connection
failed, it could not be restored, and the errors generated were the same as if the option
had not been selected.