Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Mysql Server Gone Away

forums forums SQLyog SQLyog: Bugs / Feature Requests Mysql Server Gone Away

  • This topic is empty.
Viewing 6 reply threads
  • Author
    Posts
    • #10301
      vygi
      Member

      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

    • #23839
      peterlaursen
      Participant

      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?

    • #23840
      vygi
      Member
      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!

    • #23841
      peterlaursen
      Participant

      We will try to follow your description.

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

    • #23842
      peterlaursen
      Participant

      and ..

      PROGRAM VERSION PLEASE!

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

    • #23843
      peterlaursen
      Participant

      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!

    • #23844
      vygi
      Member
      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 😉

Viewing 6 reply threads
  • You must be logged in to reply to this topic.