Mysql Server Gone Away

[vygi]

Small issue:

when the SQLyog client remains running over night and connection to MySQL times out, it does not try to reconnect when I try to copy a table to different host/DB. “MySQL server gone away” message appears.

I think it reconnects to this different server but does not reconnect to the current one.

Vygi

[peterlaursen]

I am afraid I do not fully understand this:

Quote:

I think it reconnects to this different server but does not reconnect to the current one.

You experience that reconnects fails with this specific server, but normally it works?

Did you experience this once or is it reproducable?

Do you know if the server may have been unreachable for a period of time that night?

[vygi]

peterlaursen wrote on Apr 25 2007, 11:56 AM:

I am afraid I do not fully understand this:

You experience that reconnects fails with this specific server, but normally it works?

Did you experience this once or is it reproducable?

Do you know if the server may have been unreachable for a period of time that night?

I had SQLyog open since yesterday and now I start to copy a table from server A (connection A) to B. Here I get “Mysql Server Gone Away” error because current connection is not valid anymore. I have eg. first to switch between databases on curent server A (to force re-connection).

Some time ago SQLyog has even crashed when connection B (copy table TO) was timed out. This issue has been fixed, and SQLyou reconnects to server B when I try to copy table and connection A is okay but B is not. It just still makes troubles when also A is timed out.

Hope you understand now….

And yes, I can reproduce it:

1: in SQLyog open connection B to server B

2: in SQLyog open connection A to server A

3: in SQLyog focus any database/table you want to copy to B

3: kill connection A in the background (eg. from mysql command line)

4: in SQLyog try to copy table from server A to B –> Mysql Server Gone Away!

[peterlaursen]

We will try to follow your description.

BTW: you do not mind if I move this post to the SQLyog category? 😛

[peterlaursen]

and ..

PROGRAM VERSION PLEASE!

always program version .. always program version .. program version .. program version .. version .. version 😕

[peterlaursen]

reproduced as you describe with 5.29 as well as 6.0 beta 4. Actually we fixed in 6.0 beta2 for the common gui (DATA tab etc) but seems to have forgotten that 'copy .. to other' is another code module!

Thanks for reporting!

[vygi]

peterlaursen wrote on Apr 25 2007, 01:53 PM:

BTW: you do not mind if I move this post to the SQLyog category? 😛

Oooops…. SORRY!

I thought I have posted in “BETA Discussions”, but I was totally wrong 😉

[Author]

Posts