| Bug #72507 | Repeated crashing of Workbench 6.1 on two different servers | ||
|---|---|---|---|
| Submitted: | 1 May 2014 21:14 | Modified: | 22 May 2014 14:48 |
| Reporter: | Martin O'Shea | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | MySQL Workbench: SQL Editor | Severity: | S2 (Serious) |
| Version: | 6.1.4 | OS: | Windows (Microsoft Windows 7 Service Pack 1 build 7601, 32-bit) |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | WBBugReporter | ||
[1 May 2014 21:15]
Martin O'Shea
This issue has been raised in the MySQL Workbench forum at: http://forums.mysql.com/read.php?152,613226,613226
[1 May 2014 22:28]
MySQL Verification Team
Thank you for the bug report. Please elaborate in number of word 'several': have several thousand tables, each of which may contain several hundred columns. Thanks.
[1 May 2014 23:10]
Martin O'Shea
Concerning my use of the term 'several', one particular schema of mine stores some 4700 tables. About 4500 of these are made up of up to 600 columns and approximately 15000 rows. Workbench fails when this schema is queried, but this occurs only when the tables for the schema are loaded into the Navigator.
[14 May 2014 15:04]
Philip Nelson
I am having the same issue. I have narrowed it down to the connection using ssl if available option in the connection. With the ssl option I get app crash consistently. Without I don't crash, but sometimes get Error Code: 2013 Lost connection to MySQL server during query. In my case it is happening querying an Amazon RDS instances. These same instances all worked with this version of workbench for the prior 2 days when I installed it. Other users with an earlier 6.1 version of workbench are fine, and users are also fine with a 6.0 version, all using ssl.
[14 May 2014 22:36]
Martin O'Shea
I don't have need to use SSL normally when connecting to Workbench. I am administrator of my two servers and I also log into Workbench as 'root' anyway. But I have just tried SSL in my connections to Workbench and my queries continue to fail, even for tables with only a few hundred records. As before, Workbench simply crashes with: 23:06:02 [INF][ WQE backend]: Found auto-save workspace C:\Users\madmin.rzone.000\AppData\Roaming\MySQL\Workbench\sql_workspaces\Local_instance_MySQL-2.autosave 23:06:02 [INF][ WQE backend]: Found auto-save workspace C:\Users\madmin.rzone.000\AppData\Roaming\MySQL\Workbench\sql_workspaces\myDataSharer-1.autosave 23:06:02 [INF][ WQE backend]: Found auto-save workspace C:\Users\madmin.rzone.000\AppData\Roaming\MySQL\Workbench\sql_workspaces\visualRSS-1.autosave 23:06:02 [INF][ Workbench]: UI is up 23:06:03 [INF][ Workbench]: Running the application 23:06:15 [INF][ SSH tunnel]: Starting tunnel 23:06:16 [ERR][ GRTDispatcher]: exception in grt execute_task, continuing: Exception: Access denied for user 'root'@'localhost' (using password: NO) 23:06:16 [INF][ WQE.net]: Launching SQL IDE 23:06:18 [INF][ WQE.net]: SQL IDE UI is ready 23:13:36 [ERR][ AutoCCache]: Exception during update of cache for 'schemaA _dm_19284_591305_07112013_1383849338694_keyword_frequencies': Malformed packet 23:13:45 [ERR][ AutoCCache]: Exception during update of cache for 'schemaA _dm_19366_349975_13112013_1384362718663_keyword_frequencies': Malformed packet The data in both of the tables referred to in the messages above appears to be intact. So for the moment I am using Query Browser.
[22 May 2014 14:48]
Marcin Szalowicz
This is a duplicate of bug #72486
[25 Jun 2014 13:02]
Robert Mouat
I am seeing similar problems. I am running 6.1.6 on windows 7 64bit with 8GB RAM. I am connecting to MySQL 5.1.69 hosted on Amazon RDS. I get a repeatable crash by doing the following: * start workbench * connect to database as root (using SSL and password) * 'use myschema' * 'select * from MYTABLE' I have a workaround. It doesn't crash if I run 'desc MYTABLE' before the select query. In the logs I see a dozen errors of the form: 13:44:52 [ERR][ AutoCCache]: Exception during update of cache for 'myschema MYTABLE': Insufficient memory: cannot create MySQL handle using mysql_init()
[30 Sep 2014 16:17]
wes romero
I am also facing the same issue when running MySQL Workbench. I'll run a simple SELECT * FROM Table1 WHERE Column1 = 'email@email.com'; and then it will crash. Faulting application name: MySQLWorkbench.exe, version: 6.1.6.11834, time stamp: 0x53729aea Faulting module name: ntdll.dll, version: 6.1.7601.18247, time stamp: 0x521ea8e7 Exception code: 0xc0000005 Fault offset: 0x000337a2 Faulting process id: 0x1090 Faulting application start time: 0x01cfdcc88c67d2e9 Faulting application path: C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\MySQLWorkbench.exe Faulting module path: C:\Windows\SysWOW64\ntdll.dll Report Id: d9a507ca-48bb-11e4-ac22-5c514f932154 Application: MySQLWorkbench.exe Framework Version: v4.0.30319 Description: The process was terminated due to an unhandled exception. Exception Info: exception code c0000005, exception address 772E37A2 Stack:
Description: I have installed MySQL Workbench 6.1 on two different Windows 7 64 bit servers, each with 8Gb memory and good processors. The usual pattern of this incident is that: i. I log into Workbench via a MySQL Connection. ii. The schemae load but his can take several minutes because my schemae have several thousand tables, each of which may contain several hundred columns but only about 1500 records. iii. If I run a simple, single table query, Workbench crashes. This issue has never occurred in previous Workbench instances. Query Browser works fine. The following is an instance of a Workbench log today: 12:33:08 [ERR][ Workbench]: Console redirection failed. 12:33:08 [INF][ WBContext]: Parsing application arguments. 12:33:08 [INF][ WBContext]: C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\MySQLWorkbench.exe 12:33:08 [INF][ Workbench]: Starting up Workbench 12:33:08 [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.1.7601 Service Pack 1 SystemDirectory: C:\Windows\system32 TickCount: 1905433386 UserInteractive: True Version: 4.0.30319.18444 WorkingSet: 27435008 12:33:08 [INF][ Workbench]: Environment variables: Path = C:\Perl64\site\bin;C:\Perl64\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Sun\JavaDB\bin;C:\Condor\bin\;C:\CONDOR\bin;C:\Program Files (x86)\Git\cmd;C:\Program Files (x86)\Graphviz 2.28\bin SESSIONNAME = RDP-Tcp#0 PATHEXT = .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC USERDOMAIN = nismes PROCESSOR_ARCHITECTURE = x86 ProgramW6432 = C:\Program Files DERBY_HOME = C:\Program Files (x86)\Sun\JavaDB APPDATA = C:\Users\mrgraverol.nismes.000\AppData\Roaming windir = C:\Windows LOCALAPPDATA = C:\Users\mrgraverol.nismes.000\AppData\Local CommonProgramW6432 = C:\Program Files\Common Files windows_tracing_flags = 3 windows_tracing_logfile = C:\BVTBin\Tests\installpackage\csilogfile.log TMP = C:\Users\mrgraverol~2.000\AppData\Local\Temp USERPROFILE = C:\Users\mrgraverol.nismes.000 ProgramFiles = C:\Program Files (x86) PROCESSOR_LEVEL = 21 FP_NO_HOST_CHECK = NO HOMEPATH = \Users\mrgraverol.nismes.000 COMPUTERNAME = nismes PROCESSOR_ARCHITEW6432 = AMD64 USERNAME = mrgraverol NUMBER_OF_PROCESSORS = 4 PROCESSOR_IDENTIFIER = AMD64 Family 21 Model 2 Stepping 0, AuthenticAMD SystemRoot = C:\Windows ComSpec = C:\Windows\system32\cmd.exe LOGONSERVER = \\nismes TEMP = C:\Users\mrgraverol~2.000\AppData\Local\Temp ProgramFiles(x86) = C:\Program Files (x86) CommonProgramFiles = C:\Program Files (x86)\Common Files JAVA_HOME = C:\Program Files\Java\jdk1.6.0_26 PUBLIC = C:\Users\Public PROCESSOR_REVISION = 0200 CLIENTNAME = thebox 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: 12:33:08 [INF][ Workbench]: Current version given by meta info is: 6.1.4 12:33:09 [INF][ Workbench]: Setting PATH to: C:\Windows\system32;C:\Perl64\site\bin;C:\Perl64\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Sun\JavaDB\bin;C:\Condor\bin\;C:\CONDOR\bin;C:\Program Files (x86)\Git\cmd;C:\Program Files (x86)\Graphviz 2.28\bin 12:33:09 [INF][ mforms managed]: Initializing mforms wrapper 12:33:10 [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\mrgraverol.nismes.000\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 12:33:10 [INF][ WBContext]: WbContext::init 12:33:11 [INF][ grt]: Scanning module directory C:\Users\mrgraverol.nismes.000\AppData\Roaming\MySQL\Workbench\modules. 12:33:11 [INF][ grt]: Scanning module directory .. 12:33:12 [INF][ grt]: Scanning module directory C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE/modules. 12:33:19 [INF][ WBA]: Looking for extension modules for WBA... 12:33:19 [INF][ WBA]: 0 extension modules found 12:33:19 [INF][ grt]: Scanning module directory C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE. 12:33:20 [WRN][ grt]: C:\Users\mrgraverol.nismes.000\AppData\Roaming\MySQL\Workbench\connections.xml:18: link '{32E6E0AB-6332-4ED3-B9CA-24F39DAEAC5E}' <object GrtObject> key=owner could not be resolved 12:33:21 [INF][ WBContext]: System info: MySQL Workbench Community (GPL) for Windows version 6.1.4 revision 11773 build 1454 Configuration Directory: C:\Users\mrgraverol.nismes.000\AppData\Roaming\MySQL\Workbench Data Directory: C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE Cairo Version: 1.8.8 OS: Microsoft Windows 7 Service Pack 1 (build 7601), 64-bit CPU: 4x AMD Opteron(tm) Processor 6376 , 8.0 GiB RAM Active video adapter Standard VGA Graphics Adapter Installed video RAM: 0 MB Current video mode: NULL Used bit depth: NULL Driver version: 6.1.7600.16385 Installed display drivers: NULL Current user language: English (United Kingdom) 12:33:21 [INF][ WQE backend]: Found auto-save workspace C:\Users\mrgraverol.nismes.000\AppData\Roaming\MySQL\Workbench\sql_workspaces\Local_instance_MySQL-2.autosave 12:33:21 [INF][ WQE backend]: Found auto-save workspace C:\Users\mrgraverol.nismes.000\AppData\Roaming\MySQL\Workbench\sql_workspaces\schemaa-1.autosave 12:33:21 [INF][ WQE backend]: Found auto-save workspace C:\Users\mrgraverol.nismes.000\AppData\Roaming\MySQL\Workbench\sql_workspaces\schemab-1.autosave 12:33:21 [INF][ Workbench]: UI is up 12:33:21 [INF][ Workbench]: Running the application 12:34:02 [INF][ SSH tunnel]: Starting tunnel 12:34:03 [ERR][ GRTDispatcher]: exception in grt execute_task, continuing: Exception: Access denied for user 'root'@'localhost' (using password: NO) 12:34:04 [INF][ WQE.net]: Launching SQL IDE 12:34:05 [INF][ WQE.net]: SQL IDE UI is ready 12:36:03 [ERR][ AutoCCache]: Exception during update of cache for 'schemab _dm_18840_491500_05112013_1383674775155_keyword_frequencies': Insufficient memory: cannot create MySQL handle using mysql_init() A second error follows: 12:40:05 [INF][ Workbench]: UI is up 12:40:06 [INF][ Workbench]: Running the application 12:42:29 [INF][ SSH tunnel]: Starting tunnel 12:42:29 [ERR][ GRTDispatcher]: exception in grt execute_task, continuing: Exception: Access denied for user 'root'@'localhost' (using password: NO) 12:42:31 [INF][ WQE.net]: Launching SQL IDE 12:42:32 [INF][ WQE.net]: SQL IDE UI is ready 12:44:51 [ERR][ AutoCCache]: Exception during update of cache for 'schemab _dm_19115_164440_06112013_1383754574216_keyword_frequencies': Malformed packet 12:45:07 [ERR][ AutoCCache]: Exception during update of cache for 'schemab _dm_19273_810672_07112013_1383847714168_keyword_frequencies': Malformed packet Any information would be helpful here. Thanks Martin O'Shea. How to repeat: I am unsure what to say here because I do not know how it could be repeated without use of my database schemae. Although maybe a table of several hundred mixed text and numeric columns and about 1500 records would suffice despite queries on more conventional tables also suffering the crashing. The log files refer to different tables in one of the schemae and apparently different causes.