Bug #14136 No automatic reconnect after disconnect by timeout
Submitted: 19 Oct 2005 10:56 Modified: 19 Oct 2005 11:51
Reporter: Alexey Akimov Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version:1.1.14 OS:Windows (Windows XP)
Assigned to: CPU Architecture:Any

[19 Oct 2005 10:56] Alexey Akimov 
Description:
My workstation works 24/7 so I not have to exit "MySQL Query Browser" tonight.
Next day when trying to update or delete rows I receive error message saying that "server has gone away" or "no connection", but I still able to do SELECT queries.

The only thing I can do is File->Reconnect and after that all my changes being lost.

Suggestion is that MySQL server closes the connection after 8 hour (default) timeout.

How to repeat:
Wait until server will timeout Browser connection and then try to do UPDATE or DELETE query.
[19 Oct 2005 11:12] Alexey Akimov 
This report seems to be a duplicate of #12724 2005-08-22 17:03
[19 Oct 2005 11:51] Valeriy Kravchuk 
Thank you for a problem report. For me it also looks like a duplicate of http://bugs.mysql.com/bug.php?id=12724. So, please, try newer version (1.1.15 is available already) and add your comment to that report, if any.