distal-attribute
distal-attribute
distal-attribute
distal-attribute

Random disconnects

User, date Message
Written by briandancer
4 years ago
Category: Creating a connection
3 posts since Wed, 29 Sep 10
My user has HeidiSQL open all day, and keeps our company's website database open all day. If he leaves HeidiSQL for a few minutes to work on something else (like Outlook, Chrome, etc.), and comes back to HeidiSQL, the connection is not active, and he gets a "SQL Error (2013): Lost connection to MySQL server during query" message.

He then hits OK, and HeidiSQL reconnects to the database and he's off and running.

Why is this disconnection happening? How can I stop that?
Written by ansgar
4 years ago
4793 posts since Fri, 07 Apr 06
Please read the message twice:
Lost connection to MySQL server during query
He gets disconnected in the middle of executing some query. In order to analyze that I need a more exact description of what query he was executing before and after he got back to HeidiSQL.

There is also a server variable called "wait_timeout" which says how many seconds to wait before an idle connection is killed automatically. But that seems not to be the case here. In this case HeidiSQL would just detect the disconnect and reconnect you.
Written by briandancer
4 years ago
3 posts since Wed, 29 Sep 10
He says it not anything consistent that he's doing before or after he uses HeidiSQL. It's not queries so much as coming back to the Heidi window, and clicking anything (data field, table, etc) and that's when he gets the error. Prior to moving away from the Heidi window, he might have done any number of things, like queries, changing a table name, updating data values, etc.
Written by briandancer
4 years ago
3 posts since Wed, 29 Sep 10
Is HeidiSQL not meant to be used on Windows 7 for some reason? That is his OS.
Written by ansgar
4 years ago
4793 posts since Fri, 07 Apr 06
Windows 7 is surely not the problem - I'm constantly using HeidiSQL on W7 several hours a day.

There might be missing some important thing which has not got mentioned here. This problem is yet unsolvable with these few infos. Probably a list of server variables could give a hint. What about some forum post from your user himself? Would be slightly easier would it?
 

Please login to leave a reply, or register at first.