| Bug #72234 | Workbench crash when a lost connection to a remote db is encountered | ||
|---|---|---|---|
| Submitted: | 4 Apr 2014 7:24 | Modified: | 14 Aug 2014 9:14 |
| Reporter: | Timothy Craib | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Workbench | Severity: | S5 (Performance) |
| Version: | 6.1.4 | OS: | Windows (Microsoft build 9200, 64-bit) |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | WBBugReporter | ||
[28 Apr 2014 8:42]
Gilad Ivry
reproducible on Ubuntu 12.04 64-bit as well (WB 6.1.4)
[1 May 2014 13:33]
Scott Cosner
I'm also randomly encountering this error, "Error Code: 2013 Lost connection to MySQL server during query", when running queries when it doesn't crash. I've also included my log files if there is any relevant information there. (USERNAME and HOST were replaced.)
09:20:31 [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\USERNAME\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
09:20:31 [INF][ WBContext]: WbContext::init
09:20:31 [INF][ grt]: Scanning module directory C:\Users\USERNAME\AppData\Roaming\MySQL\Workbench\modules.
09:20:31 [INF][ grt]: Scanning module directory ..
09:20:31 [INF][ grt]: Scanning module directory C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE/modules.
09:20:31 [INF][ WBA]: Looking for extension modules for WBA...
09:20:31 [INF][ WBA]: 0 extension modules found
09:20:31 [INF][ grt]: Scanning module directory C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE.
09:20:32 [WRN][ grt]: C:\Users\USERNAME\AppData\Roaming\MySQL\Workbench\connections.xml:26: link '{5F29B7DC-9B60-4AC3-A8C9-99CA244B86CE}' <object GrtObject> key=owner could not be resolved
09:20:32 [INF][ WBContext]: System info:
MySQL Workbench Community (GPL) for Windows version 6.1.4 revision 11773 build 1454
Configuration Directory: C:\Users\USERNAME\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 Intel(R) Core(TM) i5-3450 CPU @ 3.10GHz, 6.0 GiB RAM
Active video adapter NVIDIA GeForce GT 620
Installed video RAM: 1024 MB
Current video mode: 1680 x 1050 x 4294967296 colors
Used bit depth: 32
Driver version: 9.18.13.2078
Installed display drivers: nvd3dumx.dll,nvwgf2umx.dll,nvwgf2umx.dll,nvd3dum,nvwgf2um,nvwgf2um
Current user language: English (United States)
09:20:32 [INF][ Workbench]: UI is up
09:20:32 [INF][ Workbench]: Running the application
09:20:33 [INF][ SSH tunnel]: Starting tunnel
09:20:33 [ERR][ GRTDispatcher]: exception in grt execute_task, continuing: Exception: Access denied for user 'USERNAME'@'HOST' (using password: NO)
09:20:36 [INF][ WQE.net]: Launching SQL IDE
09:20:37 [INF][ WQE.net]: SQL IDE UI is ready
[27 May 2014 12:20]
David Hollingshead
This is also happening to me every time I connect to a database with MySQL Workbench using SSH tunnel. 15:58:27 [INF][ SSH tunnel]: TunnelManager.wait_connection returned OK 15:58:27 [INF][ SSH tunnel]: SSH tunnel connect executed OK 15:58:27 [ERR][ GRTDispatcher]: exception in grt execute_task, continuing: Exception: Access denied for user 'root'@'localhost' (using password: NO) [happens with any user, including root] I also get the Error 2013 when trying to select rows on a table if I do not wait at least 10 seconds.
[27 May 2014 13:18]
Scott Cosner
I'm also still getting this with 6.1.6. It crashes after these log statements. I did notice the strange statement in the line before the system info. Also, the access denied part shows one host IP address, but the "Can't connect to MySQL server" is with a different IP address which seems strange.
09:03:22 [WRN][ grt]: C:\Users\USERNAME\AppData\Roaming\MySQL\Workbench\connections.xml:27: link '{CA2A9B98-8F7B-4342-B6EF-E55324AAA804}' <object GrtObject> key=owner could not be resolved
09:03:22 [INF][ WBContext]: System info:
MySQL Workbench Community (GPL) for Windows version 6.1.6 revision 11834 build 1642
Configuration Directory: C:\Users\USERNAME\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 Intel(R) Core(TM) i5-3450 CPU @ 3.10GHz, 6.0 GiB RAM
Active video adapter NVIDIA GeForce GT 620
Installed video RAM: 1024 MB
Current video mode: 1680 x 1050 x 4294967296 colors
Used bit depth: 32
Driver version: 9.18.13.2078
Installed display drivers: nvd3dumx.dll,nvwgf2umx.dll,nvwgf2umx.dll,nvd3dum,nvwgf2um,nvwgf2um
Current user language: English (United States)
09:03:22 [INF][ Workbench]: UI is up
09:03:23 [INF][ Workbench]: Running the application
09:03:37 [INF][ SSH tunnel]: Starting tunnel
09:03:37 [ERR][ GRTDispatcher]: exception in grt execute_task, continuing: Exception: Access denied for user 'USERNAME'@'HOST1' (using password: NO)
09:03:41 [INF][ WQE.net]: Launching SQL IDE
09:03:41 [INF][ WQE.net]: SQL IDE UI is ready
09:03:55 [ERR][ AutoCCache]: Exception during update of cache for 'DATABASE
TABLE1': Lost connection to MySQL server during query
09:04:00 [ERR][ AutoCCache]: Exception during update of cache for 'DATABASE
TABLE2': Lost connection to MySQL server during query
09:04:00 [ERR][ AutoCCache]: Exception during update of cache for 'DATABASE
TABLE3': Can't connect to MySQL server on 'HOST2' (0)
09:04:03 [ERR][ AutoCCache]: Exception during update of cache for 'DATABASE
TABLE4': Lost connection to MySQL server during query
[6 Jun 2014 21:58]
Greg Havener
This is also becoming a huge problem for me. It seems that any time MySQL Workbench loses a database connection it does not behave properly. This includes sleeping/hibernating a computer while MySQL Workbench is running. When you restore, you will be unable to run any queries without it freezing. I have noticed the following symptoms: - When you run a query, the "Execute Query" button (lighting bolt) does not disable, and the "stop query" button does not enable. However, you do get an animated "spinning" icon on the current tab. - The UI can remain usable, however you cannot run any queries, or cancel the currently outstanding hung query. - Frequently, the program can then become completely unresponsive and hang. - You cannot close the application, the status bar indicates "Cannot close IDE while busy". I usually kill the application and restart, however today I decided to leave it running and after a long time I got the error message "Error Code 2013: Lost connection my MySQL server" in the action output pane. At this point, the "stop query" button became available and after another 20 minutes or so the program became usable again. I have reproduced this problem on Fedora Linux as well as Mac OS X 10.9.2. A colleague recently switched back to Windows due to this issue and claims the problem is not occurring. My latest log file is below. Interestingly, the IP it lists in the "access denied" errors is my public IP address. I don't know how/why this appears here. 09:24:40 [INF][ WBContext]: Parsing application arguments. 09:24:40 [INF][ WBContext]: /Applications/MySQLWorkbench.app/Contents/MacOS/MySQLWorkbench 09:24:40 [INF][ WBContext]: -psn_0_40970 09:24:40 [INF][ Workbench]: Starting up Workbench 09:24:40 [INF][ Workbench]: Loading main window 09:24:41 [INF][ WBContext UI]: Initializing workbench context UI with these values: base dir: /Applications/MySQLWorkbench.app/Contents/Resources plugin path: /Applications/MySQLWorkbench.app/Contents/PlugIns struct path: /Applications/MySQLWorkbench.app/Contents/Resources/grt module path: /Applications/MySQLWorkbench.app/Contents/PlugIns library path: /Applications/MySQLWorkbench.app/Contents/Resources/libraries user data dir: /Users/greg/Library/Application Support/MySQL/Workbench open at start: open type: run at startup: run type: Force SW rendering: No Force OpenGL: No quit when done: No 09:24:41 [INF][ WBContext]: WbContext::init 09:24:41 [INF][ WBA]: Looking for extension modules for WBA... 09:24:41 [INF][ WBA]: 0 extension modules found 09:24:41 [WRN][ grt]: /Users/greg/Library/Application Support/MySQL/Workbench/connections.xml:25: link 'FFE365E7-0D58-42DE-A005-F500433C7D71' <object GrtObject> key=owner could not be resolved 09:24:41 [INF][ WBContext]: System info: MySQL Workbench Community (GPL) for Mac OS X version 6.1.6 revision 11834 build 1642 Configuration Directory: /Users/greg/Library/Application Support/MySQL/Workbench Data Directory: /Applications/MySQLWorkbench.app/Contents/Resources Cairo Version: 1.10.2 OS: OS X 10.9.x Mavericks CPU: 8x Intel(R) Core(TM) i7-4750HQ CPU @ 2.00GHz - 8.00GiB RAM 09:51:40 [INF][ SSH tunnel]: Starting tunnel 09:51:40 [ERR][ GRTDispatcher]: exception in grt execute_task, continuing: Exception: Access denied for user 'greg'@'50.xxx.xxx.xxx’ (using password: NO) 09:51:43 [ERR][ AutoCCache]: Exception during update of cache for ‘is******* so*****’: DBMS connection is not available 09:51:43 [ERR][ AutoCCache]: Exception during update of cache for 'is******* so******’: DBMS connection is not available 09:51:43 [ERR][ AutoCCache]: Exception during update of cache for 'is******* so******’: DBMS connection is not available 09:51:43 [ERR][ AutoCCache]: Exception during update of cache for 'is******* so******’: DBMS connection is not available 09:51:43 [ERR][ AutoCCache]: Exception during update of cache for 'is******* so******’: DBMS connection is not available 09:51:43 [ERR][ AutoCCache]: Exception during update of cache for 'is******* te******’: DBMS connection is not available 09:51:43 [ERR][ AutoCCache]: Exception during update of cache for 'is******* te****’: DBMS connection is not available 09:51:43 [ERR][ AutoCCache]: Exception during update of cache for 'is******* te*****’: DBMS connection is not available youtube_stats': DBMS connection is not available 09:51:46 [ERR][ GRTDispatcher]: exception in grt execute_task, continuing: Exception: Access denied for user 'greg'@'50.xxx.xxx.xxx’ (using password: NO)
[12 Jul 2014 21:32]
MySQL Verification Team
Please try version 6.1.7. Thanks.
[13 Aug 2014 1: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".
[14 Aug 2014 9:14]
Timothy Craib
The error appears to be resolved in the latest version of MySQL Workbench.
[6 Nov 2014 17:02]
Robert Dudley
If the error is resolved in the "latest version", what does that mean? What was the latest version as of August 14th 2014? I have 6.2.3 and I experience the same issues explained in this report.
[23 Nov 2015 13:22]
IGG t
I am seeing this problem in the latest version (6.3.5). Runing on Windows 7 64 bit. Database is connected via tcp connection and is MySQL 5.5.44 on Debian Linux.
[17 Dec 2015 7:04]
Valeriy Marinets
Ubuntu 14.04, Workbench 6.3. When connection is lost (computer waked up from sleep) - cannot close the application, the status bar indicates "Cannot close IDE while busy".
Description: ----[For better reports, please attach the log file after submitting. You can find it in C:\Users\Timothy\AppData\Roaming\MySQL\Workbench/log/wb.log] 08:46:25 [INF][ Workbench]: UI is up 08:46:25 [INF][ Workbench]: Running the application 08:47:00 [INF][ SSH tunnel]: Starting tunnel 08:47:01 [ERR][ GRTDispatcher]: exception in grt execute_task, continuing: Exception: Access denied for user 'root'@'localhost' (using password: NO) 08:47:01 [INF][ WQE.net]: Launching SQL IDE 08:47:02 [INF][ WQE.net]: SQL IDE UI is ready 08:47:05 [ERR][ SqlEditor]: SqlEditorForm: exception in do_connect method: Exception: Can't connect to MySQL server on '127.0.0.1' (10061) 08:47:05 [INF][ SqlEditor]: Error 2003 connecting to server, assuming server is down and opening editor with no connection 08:47:06 [INF][ WQE.net]: Launching SQL IDE 08:47:06 [INF][ WQE.net]: SQL IDE UI is ready 08:47:07 [ERR][wb_admin_control.py:init:266]: Error connecting to MySQL: Can't connect to MySQL server on '127.0.0.1' (10061) (code 2003) 08:47:07 [INF][wb_admin_control.py:acquire_admin_access:240]: Target OS detection returned: os_type=windows, os_name=Windows 8.1 Single Language, os_variant=Windows, os_version=Microsoft Windows [Version 6.3.9600] 08:47:08 [ERR][wb_admin_main.py:shutdown:208]: shutting down admn 08:47:08 [INF][ WQE.net]: Shutting down SQL editor (MWEB SOLIDDev01) 08:47:08 [ERR][wb_admin_main.py:shutdown:208]: shutting down admn 08:47:08 [ERR][wb_admin_control.py:server_polling_thread:482]: Error creating SQL connection for monitoring: MySQLError("Can't connect to MySQL server on '127.0.0.1' (10061) (code 2003)",) 08:47:10 [ERR][ GRTDispatcher]: exception in grt execute_task, continuing: Exception: Access denied for user 'root'@'localhost' (using password: NO) 08:47:13 [INF][ WQE.net]: Launching SQL IDE 08:47:14 [INF][ WQE.net]: SQL IDE UI is ready 08:47:50 [INF][ ]: unhandled sidebar action admin_connections 08:47:51 [ERR][wb_admin_control.py:get_config_options:620]: Could not open the file "%ProgramData%\MySQL\MySQL Server 5.5\my.ini": 'NoneType' object has no attribute 'get_file_content' 08:47:51 [INF][wb_admin_control.py:query_server_info:753]: Currently connected to MySQL server version '5.5.17-55', conn status = True, active plugins = ['partition', 'XTRADB_ADMIN_COMMAND', 'INNODB_CMPMEM_RESET', 'INNODB_SYS_FIELDS', 'CSV', 'mysql_native_password', 'INNODB_SYS_TABLES', 'InnoDB', 'ARCHIVE', 'INNODB_CMP', 'INNODB_TRX', 'binlog', 'INNODB_LOCKS', 'INNODB_CMPMEM', 'INNODB_INDEX_STATS', 'INNODB_LOCK_WAITS', 'MEMORY', 'BLACKHOLE', 'INNODB_SYS_INDEXES', 'INNODB_BUFFER_POOL_PAGES_BLOB', 'MRG_MYISAM', 'PERFORMANCE_SCHEMA', 'mysql_old_password', 'INNODB_SYS_FOREIGN_COLS', 'INNODB_RSEG', 'MyISAM', 'INNODB_SYS_TABLESTATS', 'INNODB_SYS_FOREIGN', 'INNODB_CMP_RESET', 'INNODB_SYS_STATS', 'INNODB_BUFFER_POOL_PAGES_INDEX', 'INNODB_SYS_COLUMNS', 'INNODB_TABLE_STATS', 'INNODB_BUFFER_POOL_PAGES'] 08:47:51 [INF][wb_admin_control.py:server_polling_thread:487]: Monitoring thread running... 08:48:12 [ERR][ AutoCCache]: Exception during update of cache for 'mwebcoredb fn_quote_notifications': Lost connection to MySQL server during query How to repeat: Using a database accessed on a remote server with an unstable connection. Run a series of queries and if the database connection is lost, Instead of resolving the connection the entire workbench application crashes. Suggested fix: Handle lost database connections.