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

Crash Genering Update Sql

forums forums SQLyog SQLyog: Bugs / Feature Requests Crash Genering Update Sql

  • This topic is empty.
Viewing 3 reply threads
  • Author
    • #13483

      Repeatable crash generating update SQL for the following table:


      CREATE TABLE `hatch_summary` (

        `hatchsummaryid` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT ‘ID of this row’,

        `hatcheventgroupid` bigint(20) unsigned NOT NULL COMMENT ‘which hatch event group’,

        `breedid` int(11) NOT NULL COMMENT ‘which breed’,

        `availablestrun` int(11) NOT NULL COMMENT ‘how many st run are available’,

        `availablepullet` int(11) NOT NULL COMMENT ‘how many pullets are available’,

        `availablecockerel` int(11) NOT NULL COMMENT ‘how many males are available’,

        `soldstrun` int(11) NOT NULL COMMENT ‘how many were sold as st run’,

        `soldpullet` int(11) NOT NULL COMMENT ‘how many were sold as females’,

        `soldcockerel` int(11) NOT NULL COMMENT ‘how many were sold as males’,

        `closed` tinyint(1) NOT NULL COMMENT ‘did this assortment close’,

        PRIMARY KEY (`hatchsummaryid`)

      ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT=’summary of hatch data by hatch event group (from avail run)’


    • #35637
      Sibin A S

      Hello Mitch,


      So what exactly do you mean by writing “Repeatable crash”. Did the program simply disappear for instance? In case of a crash, there would be a crash dump file that would get generated. 


      Can you tell us in detail the steps that lead to the crash as we aren’t successful in reproducing it at our end.


      Also tell us the environment where SQLyog is installed and also the SQLyog version.

    • #35638

      More questions:


      Can you also please try same UPDATE statement with another client (you may copy it from HISTORY tab in SQLyog). What happens?

      Also does the UPDATE succeed or not?

      Is the table ‘parent’ in a Foreign Key setup?

      Does it help to “OPTIMIZE TABLE `hatch_summary`;”


      We need not only the table structure, but a full testcase (struture, data and statement/instruction (screenshot is a good thing here) on how you use GUI) where it is reproducible.


      But as asked by Sibin, please elaborate the exact meaning of the term “crash” as you experience it here. If there is a crash-dump, please attach it.

    • #35639

      Sorry – I should have been more clear.  The crash happens when I do Right Click -> Paste SQL Statement -> Update.

      I get this message: SQLyog crashed. Dump file saved in …


      That dump is attached.


      PS this is Ubuntu 14.04 64 bit

      Wine 1.6.2

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