Bug #64059 lost mysql connection from VC++ windows service application
Submitted: 18 Jan 2012 15:02 Modified: 18 Jan 2012 17:00
Reporter: santhosh kumar Email Updates:
Status: Not a Bug Impact on me:
Category:MySQL Server: C API (client library) Severity:S2 (Serious)
Version:5.1.34 OS:Windows (xp)
Assigned to: CPU Architecture:Any

[18 Jan 2012 15:02] santhosh kumar
We have created a windows service application (a standard one) in Visual studio 2005. It is entirely C/C++ code. Service application establishes connection with MYSQL. My windows service application looks like the one in http://msdn.microsoft.com/en-us/library/bb540475(v=vs.85).aspx

On our local machine (OS: Windows XP), application is running fine.
On server (OS: Windows server 2007), service application is losing mysql connection after 15 minutes of successful execution. Error code returned while querying data was 2006. This indicates a time out issue from the information i searched. 

Where as our program has regular queries and has no idle time. There is no issue with query cache size also. It is a small table and data to be returned for query is also small. This is not a MYISAM engine. This is not a embedded connection.

My doubt: Is Windows service application compatible with MYSQL C API? 

How to repeat:
I also do not know how to repeat this.
[18 Jan 2012 17:00] Sveta Smirnova
We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.

Search for definition of MySQL %timeout% variables and how do they affect connections.
[19 Jan 2012 9:09] Peter Laursen
@Santosh .. maybe this will help: 
(try to reaise max_allowed_packet).

And YES: of course you can write a Windows service program with the C-API.