Error 2013: Lost Connection To Mysql Server During Query

[bhammer]

Hi,

Whenever I run a query that takes > 20 minutes or so I get the following error:

Error Code : 2013

Lost connection to MySQL server during query

The query is still running on the box. Is there a time-out somewhere that I can increase? I'm using v5.03

Thanks in advance.

[peterlaursen]

Basically if you want us to help with that you should upgrade to the latest stable version and verify if the problems persists.

Whatever issue there might be, we can only possibly fix issues in FUTURE versions – not in PAST versions.

But the connection type (direct, HTTP or SSH) would probably be relevant information to give!

[bhammer]

I've upgraded to v6.07 and still get the same error. I'm not sure how I'm connecting. All I'm using is a host address and a port (3306). Does this tell you anything? Where else can I look to see how I'm connecting.

Thanks.

[peterlaursen]

If it is COMMUNITY version it is direct connection!

if it is EXACTLY 20 minutes it looks like a time-out setting on the server/the remote network or some networking gear.

if it is more RANDOM it simply may be the connection that is not very stable. Could you try from another location (home/office/a friend/whatever)

[Author]

Posts