Random disconnects

[expired user #5203]'s profile image [expired user #5203] posted 13 years ago in Creating a connection Permalink
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?
ansgar's profile image ansgar posted 13 years ago Permalink
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.
[expired user #5203]'s profile image [expired user #5203] posted 13 years ago Permalink
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.
[expired user #5203]'s profile image [expired user #5203] posted 13 years ago Permalink
Is HeidiSQL not meant to be used on Windows 7 for some reason? That is his OS.
ansgar's profile image ansgar posted 13 years ago Permalink
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.