Crash Genering Update Sql

[Mitch]

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)’

 

[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.

[peterlaursen]

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.

[Mitch]

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

[Author]

Posts