Bug #52434 Exception when choosing foreign key in "referenced column" on "Foreign Keys" tab
Submitted: 29 Mar 2010 11:32 Modified: 1 May 2010 6:35
Reporter: Luap Luap Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Workbench: Modeling Severity:S3 (Non-critical)
Version:5.2.16 OS:Microsoft Windows
Assigned to: CPU Architecture:Any
Tags: exception, foreign key

[29 Mar 2010 11:32] Luap Luap
Description:
I got a pop up message asking me to report this:

Exception = System.Runtime.InteropServices.SEHException
Message = External component has thrown an exception.
FullText = System.Runtime.InteropServices.SEHException: External component has thrown an exception.
   at bec.FKConstraintColumnsListBE.get_column_is_fk(FKConstraintColumnsListBE* , NodeId* )
   at MySQL.Grt.Db.FKConstraintColumnsListBE.get_column_is_fk(NodeId node)
   at MySQL.GUI.Workbench.Plugins.DbMysqlTableFkColumnListModel.columnEnabledFkNodeControl_CheckStateChanged(Object sender, TreePathEventArgs e)
   at System.EventHandler`1.Invoke(Object sender, TEventArgs e)
   at Aga.Controls.Tree.NodeControls.NodeCheckBox.OnCheckStateChanged(TreePathEventArgs args)
   at Aga.Controls.Tree.NodeControls.NodeCheckBox.OnCheckStateChanged(TreeNodeAdv node)
   at Aga.Controls.Tree.NodeControls.NodeCheckBox.SetCheckState(TreeNodeAdv node, CheckState value)
   at Aga.Controls.Tree.NodeControls.NodeCheckBox.MouseDown(TreeNodeAdvMouseEventArgs args)
   at Aga.Controls.Tree.TreeViewAdv.OnMouseDown(MouseEventArgs e)
   at System.Windows.Forms.Control.WmMouseDown(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

How to repeat:
Unable to repeat. My second attempt to set the foreign key worked without the error being generated.
[29 Mar 2010 11:43] Valeriy Kravchuk
What exact data types referencing and referenced columns have?
[30 Mar 2010 12:32] Luap Luap
Hi,

The datatypes are both INT. 

I have encountered the problem a few times now. It happens when I click  to open the drop down menu of foreign key choices. It seems to happen randomly, I can't pinpoint anything I am doing to make it happen! But when it does happen, if I click to a differnet tab and then back to the foreign key tab then it works fine.

I think if I click the drop down menu after the error then the list is empty. I will double check if I get the error again.
[31 Mar 2010 6:49] Valeriy Kravchuk
Does it happen with Referenced Table or Referenced Column drop down box?
[31 Mar 2010 12:36] Luap Luap
It is the Referenced Column.
[1 Apr 2010 6:35] Susanne Ebrecht
Many thanks for writing a bug report.

Unfortunately, we have too less informations here to make
a deeper analysis.

We either need to know how we can reproduce this or we
need a backtrace.

Please read: http://bugs.mysql.com/how-to-report.php
[1 May 2010 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".