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

Lost Connection To Mysql Server During Query

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Lost Connection To Mysql Server During Query

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • November 17, 2011 at 8:25 pm #32850
      smine
      Participant

      ah, i just found something! if i turn off the Profiler, i don't get the error.

    • November 18, 2011 at 6:12 am #32851
      ashwin
      Member

      Hello,

      Can you please tell your MySQL server version(SELECT VERSION())? If you are using server version less than 5.1.49 then you will be hitting this server bug: http://bugs.mysql.com/bug.php?id=52711

      This is the bug fix in server 5.1.49:

      – Security Fix: Using EXPLAIN with queries of the form SELECT … UNION … ORDER BY (SELECT … WHERE …) could cause a server crash. (Bug #52711, CVE-2010-3682)

      Refer: http://dev.mysql.com/doc/refman/5.1/en/news-5-1-49.html

      When you executed in command line you did not encounter “Lost Connection To Mysql Server During Query” because EXPLAIN SELECT was not included in the query. If the Profiler is ON and when you run the query, EXPLAIN SELECT is executed.

      You can verify this by including EXPLAIN SELECT query in command line 🙂 .

      Regards,

      Ashwin A

    • November 18, 2011 at 7:13 pm #32852
      smine
      Participant

      ah, yes, thank you. we are running v5.0.45 🙁

  • Author
    Posts
Viewing 2 reply threads
  • You must be logged in to reply to this topic.