MySQL Bugs: #41325: Unknown Exception in Wb.h when working on large (190+ tables) model design

Bug #41325	Unknown Exception in Wb.h when working on large (190+ tables) model design
Submitted:	9 Dec 2008 11:56	Modified:	19 Jun 2009 10:36
Reporter:	Stuart Ramsay	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench	Severity:	S2 (Serious)
Version:	5.0.28 SE Rev 3356	OS:	Windows (XP SP3)
Assigned to:	Alfredo Kojima	CPU Architecture:	Any
Tags:	CHECKED

Description:
Workbench frequently crashes with an unknown exception in Wb.h at line 1010.

This occurs while working on tables within EER diagrams on a design consisting over 190 tables and some 20 EER diagrams.

How to repeat:
It's hard to pinpoint the exact cause but in general it appears to occur when manipulating objects on the EER diagram. 

Pressing OK on the Exception dialogue does not halt Workbench but instability persists and often diagrams do not refresh and workbench needs to be closed and reopened.

would it be possible to upload your model for us to try? (you can mark it as "private" so only us developer can access it)

Problems persisted and in fact became worse as the model grew in size. 

However, following an installation of Internet Explorer 8 BETA 2 the problems encountered have ceased to occur since.

Not sure what was updated by IE8 but suspect it may be .NET related.

Thank you for the feedback.

Exception verified, although with different error. How to repeat will follow by hidden comment as I guess table names can be confidential data.

I too have encountered an "Unknown Exception...Wb.h at line 1010". I have a workbook of 121 tables BUT none of my EER diagrams have more than 10 tables on each one.

The error was thrown when I tried to edit a table's propeties by double clicking on it.

Below is my System's Info:
Looking for user plugins in C:\Documents and Settings\david\Application Data\MySQL\Workbench\plugins
MySQL Workbench OSS for Windows version 5.0.30
Cairo Version: 1.5.12
Rendering Mode: GDI Rendering
OpenGL Driver Version: Not Detected
OS: Windows XP
CPU: 2x Intel(R) Pentium(R) 4 CPU 2.80GHz, 2.0 GB RAM
Video adapter info:
Adapter type: ATI Radeon X300/X550/X1050 Series
Chip Type: ATI Radeon Graphics Processor (0x5B60)
BIOS String: 113-A33406-100
Video Memory: 131072 KB

Screenshot of error message

Attachment: MySQL WorkBench Screenshot.png (image/png, text), 4.59 KiB.

...Just to add... I have (with great reluctance) Internet Explorer 8 installed, and Microsoft .NET Framework v1.1, v2.0, v3.0 and v3.5.

The problem is caused by incorrectly defined foreign keys. Load time checks were added to Workbench 5.1 so that such errors are detected and automatically fixed.

It would be very helpful if you could give us an example of an incorrect FK's. I have look again at my current model and can find nothing untoward and certainly no errors reported by the validation checks in WB.

It's not incorrect in the sense of a mistake made by the user (more like a bug in WB), but the 
exact problem is that sometimes the mapping to referenced columns in foreign keys get half 
lost when deleting a referenced column, because the user forgot to set the referenced column 
or something else that we haven't determined yet. So if a FK has a column toggled but no matching 
referenced column set, it will cause crashes elsewhere.

Anyway, the tables with foreign keys in the uploaded model that contain the error are:
fk_vrs_account_vrs_accounttype
vrs_paytype_id

this was fixed in 5.1.13

An entry was added to the 5.1.13 changelog:

MySQL Workbench frequently crashed with an unknown exception in Wb.h at line 1010.

This occurred while working on tables within EER diagrams on a design consisting of more than 190 tables and 20 EER diagrams.