MySQL Bugs: #73542: Dont add Foreign Key

Bug #73542	Dont add Foreign Key
Submitted:	11 Aug 2014 23:28	Modified:	12 Sep 2014 14:06
Reporter:	José Geraldo Sousa Rodrigues	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S2 (Serious)
Version:	6.1.7	OS:	Windows (Microsoft build 9200, 64-bit)
Assigned to:		CPU Architecture:	Any
Tags:	WBBugReporter

Description:
20:04:59 [ERR][      Workbench]: Console redirection failed.
20:04:59 [INF][      WBContext]: Parsing application arguments.
20:04:59 [INF][      WBContext]:     C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\MySQLWorkbench.exe
20:04:59 [INF][      Workbench]: Starting up Workbench
20:04:59 [INF][      Workbench]: Current environment:
	Command line: "C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\MySQLWorkbench.exe" 
	CurrentDirectory: C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE
	HasShutdownStarted: False
	OSVersion: Microsoft Windows NT 6.2.9200.0
	SystemDirectory: C:\WINDOWS\system32
	TickCount: 96800250
	UserInteractive: True
	Version: 4.0.30319.18449
	WorkingSet: 27762688
20:04:59 [INF][      Workbench]: Environment variables:
	Path = C:\Program Files (x86)\Intel\iCLS Client\;C:\Program Files\Intel\iCLS Client\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Windows Live\Shared;C:\Program Files (x86)\Intel\OpenCL SDK\2.0\bin\x86;C:\Program Files (x86)\Intel\OpenCL SDK\2.0\bin\x64;C:\Program Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files\TortoiseSVN\bin;C:\Program Files (x86)\MySQL\MySQL Utilities 1.3.6\
	SESSIONNAME = Console
	PATHEXT = .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
	USERDOMAIN = GÊ
	PROCESSOR_ARCHITECTURE = x86
	ProgramW6432 = C:\Program Files
	PUBLIC = C:\Users\Public
	APPDATA = C:\Users\José\AppData\Roaming
	windir = C:\WINDOWS
	LOCALAPPDATA = C:\Users\José\AppData\Local
	CommonProgramW6432 = C:\Program Files\Common Files
	VBOX_INSTALL_PATH = C:\Program Files\Oracle\VirtualBox\
	TMP = C:\Users\JOS~1\AppData\Local\Temp
	USERPROFILE = C:\Users\José
	ProgramFiles = C:\Program Files (x86)
	PROCESSOR_LEVEL = 6
	FP_NO_HOST_CHECK = NO
	HOMEPATH = \Users\José
	COMPUTERNAME = GÊ
	PROCESSOR_ARCHITEW6432 = AMD64
	USERNAME = José
	NUMBER_OF_PROCESSORS = 4
	PROCESSOR_IDENTIFIER = Intel64 Family 6 Model 58 Stepping 9, GenuineIntel
	Platform = MCD
	PCBRAND = Pavilion
	ComSpec = C:\WINDOWS\system32\cmd.exe
	LOGONSERVER = \\MicrosoftAccount
	TEMP = C:\Users\JOS~1\AppData\Local\Temp
	ProgramFiles(x86) = C:\Program Files (x86)
	CommonProgramFiles = C:\Program Files (x86)\Common Files
	__COMPAT_LAYER = DetectorsWin8
	OnlineServices = Online Services
	USERDOMAIN_ROAMINGPROFILE = GÊ
	PROCESSOR_REVISION = 3a09
	SystemRoot = C:\WINDOWS
	CommonProgramFiles(x86) = C:\Program Files (x86)\Common Files
	ALLUSERSPROFILE = C:\ProgramData
	SystemDrive = C:
	PSModulePath = C:\WINDOWS\system32\WindowsPowerShell\v1.0\Modules\
	OS = Windows_NT
	ProgramData = C:\ProgramData
	HOMEDRIVE = C:
20:04:59 [INF][      Workbench]: Current version given by meta info is: 6.1.7
20:04:59 [INF][      Workbench]: Setting PATH to: C:\WINDOWS\system32;C:\Program Files (x86)\Intel\iCLS Client\;C:\Program Files\Intel\iCLS Client\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Windows Live\Shared;C:\Program Files (x86)\Intel\OpenCL SDK\2.0\bin\x86;C:\Program Files (x86)\Intel\OpenCL SDK\2.0\bin\x64;C:\Program Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files\TortoiseSVN\bin;C:\Program Files (x86)\MySQL\MySQL Utilities 1.3.6\
20:04:59 [INF][ mforms managed]: Initializing mforms wrapper
20:04:59 [INF][   WBContext UI]: Initializing workbench context UI with these values:
	base dir: C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE
	plugin path: C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE
	struct path: 
	module path: C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE/modules
	library path: C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE
	user data dir: C:\Users\José\AppData\Roaming\MySQL\Workbench
	open at start: 
	open type: 
	run at startup: 
	run type: 
	Force SW rendering: No
	Force OpenGL: No
	quit when done: No
20:04:59 [INF][      WBContext]: WbContext::init
20:04:59 [INF][            grt]: Scanning module directory C:\Users\José\AppData\Roaming\MySQL\Workbench\modules.	
20:04:59 [INF][            grt]: Scanning module directory ..	
20:04:59 [INF][            grt]: Scanning module directory C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE/modules.	
20:05:00 [INF][            WBA]: Looking for extension modules for WBA...
20:05:00 [INF][            WBA]: 0 extension modules found
20:05:00 [INF][            grt]: Scanning module directory C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE.	
20:05:00 [WRN][            grt]: C:\Users\José\AppData\Roaming\MySQL\Workbench\server_instances.xml:27: link '{17D383EB-EA1E-4B9A-8051-4CD6883F73D5}' <object GrtObject> key=owner could not be resolved
20:05:00 [INF][      WBContext]: System info:
 	MySQL Workbench Community (GPL) for Windows version 6.1.7  revision 11891 build 1788
	Configuration Directory: C:\Users\José\AppData\Roaming\MySQL\Workbench
	Data Directory: C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE
	Cairo Version: 1.8.8
	OS: Microsoft  (build 9200), 64-bit
	CPU: 4x Intel(R) Core(TM) i5-3210M CPU @ 2.50GHz, 5.9 GiB RAM
	Active video adapter Intel(R) HD Graphics 4000
	Installed video RAM: -1984 MB
	Current video mode: 1366 x 768 x 4294967296 cores
	Used bit depth: 32
	Driver version: 9.17.10.2828
	Installed display drivers: igdumd64.dll,igd10umd64.dll,igd10umd64.dll,igdumd32,igd10umd32,igd10umd32
	Current user language: Português (Brasil)

20:05:00 [INF][      Workbench]: UI is up
20:05:00 [INF][      Workbench]: Running the application
20:05:05 [INF][     SSH tunnel]: Starting tunnel
20:05:05 [ERR][  GRTDispatcher]: exception in grt execute_task, continuing: Exception: Access denied for user 'root'@'localhost' (using password: NO)
20:05:06 [INF][        WQE.net]: Launching SQL IDE
20:05:06 [INF][        WQE.net]: SQL IDE UI is ready
20:06:19 [INF][  TableEditorBE]: Creating stub schema and table businesscontrol.fornecedores for foreign key
20:09:50 [INF][  TableEditorBE]: Creating stub schema and table businesscontrol.fornecedores for foreign key
20:14:06 [INF][  TableEditorBE]: Creating stub schema and table businesscontrol.fornecedores for foreign key
20:16:57 [INF][  TableEditorBE]: Creating stub schema and table businesscontrol.marca for foreign key
20:20:04 [INF][  TableEditorBE]: Creating stub schema and table businesscontrol.fornecedores for foreign key
20:20:14 [INF][  TableEditorBE]: Creating stub schema and table businesscontrol.marca for foreign key

How to repeat:
Try add a foreign key on any table

Suggested fix:
Fix It please

Please provide the test case steps you did to get the crash. Thanks.

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