ODBC "Lost connection to MySQL server during query"

------=_NextPart_000_0023_01C7541A.A4145FB0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

Hello,



I have an application that uses pooled ODBC resources.



After 8 hours, the application encounters "Lost connection to MySQL server
during query" errors, although the SQL statement succeeds.



It lasts for 10 minutes, and then doesn't return for another 8 hours.



Is this a bug in the driver? I can't simple ignore that error on all
occasions, and changing wait_timeout in mysql will just change the frequency
of the issue.



Thanks for your help,



Eric




------=_NextPart_000_0023_01C7541A.A4145FB0--

RE: ODBC "Lost connection to MySQL server during query"

------=_NextPart_000_0071_01C754EC.F7488AD0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

Here's an interesting observation.



I am using the MySQL ODBC 3.51 driver on Windows XP.



If I connect to a MySQL server running on Windows using TCP/IP, as long as
my "Time that unused connections remain in the pool in seconds" setting is
less than the wait_timeout setting, all is well. If the setting is greater
than the wait_timeout, I experience the error.



If I connect to a MySQL server running on Linux using TCP/IP, I get the
error every 8 hours (default wait_timeout setting) even though "Time that
unused connections remain in the pool in seconds" is 60 seconds.



Any suggestions?





------=_NextPart_000_0071_01C754EC.F7488AD0
Content-Type: text/plain; charset=us-ascii


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org
------=_NextPart_000_0071_01C754EC.F7488AD0--