| Bug #82409 | Sporadic crash of MySQL Workbench | ||
|---|---|---|---|
| Submitted: | 2 Aug 2016 12:25 | Modified: | 27 May 2017 12:43 |
| Reporter: | Alex Khakham | Email Updates: | |
| Status: | No Feedback | Impact on me: | |
| Category: | MySQL Workbench: SQL Editor | Severity: | S2 (Serious) |
| Version: | 6.3.7 | OS: | MacOS (El Capitan) |
| Assigned to: | CPU Architecture: | Any | |
[2 Aug 2016 12:25]
Alex Khakham
[2 Aug 2016 15:53]
MySQL Verification Team
Hello Alex Khakham, Thank you for the report. Observed this on Mac OS X 10.11.6 with WB 6.3.7. -- System Integrity Protection: enabled Crashed Thread: 15 Exception Type: EXC_CRASH (SIGABRT) Exception Codes: 0x0000000000000000, 0x0000000000000000 Exception Note: EXC_CORPSE_NOTIFY Application Specific Information: abort() called *** error for object 0x7fe6b52886d0: pointer being freed was not allocated Thread 15 Crashed: 0 libsystem_kernel.dylib 0x00007fff92acdf06 __pthread_kill + 10 1 libsystem_pthread.dylib 0x00007fff99cad4ec pthread_kill + 90 2 libsystem_c.dylib 0x00007fff8cb786df abort + 129 3 libsystem_malloc.dylib 0x00007fff93d02041 free + 425 4 libmysqlclient.20.dylib 0x000000010f43b3b5 yaSSL::SSL::~SSL() + 69 5 libmysqlclient.20.dylib 0x000000010f439227 yaSSL_free + 23 6 libmysqlclient.20.dylib 0x000000010f410c22 vio_ssl_delete + 82 7 libmysqlclient.20.dylib 0x000000010f3de962 end_server + 50 8 libmysqlclient.20.dylib 0x000000010f3de5d1 cli_safe_read_with_ok + 193 9 libmysqlclient.20.dylib 0x000000010f3e7bdd cli_read_query_result + 29 10 libmysqlclient.20.dylib 0x000000010f3e5de5 mysql_real_query + 37 11 libmysqlcppconn.7.1.1.7.dylib 0x000000010f35d6aa sql::mysql::MySQL_Statement::do_query(sql::SQLString const&) + 106 12 libmysqlcppconn.7.1.1.7.dylib 0x000000010f35dd41 sql::mysql::MySQL_Statement::executeQuery(sql::SQLString const&) + 49 13 libwbpublic.be.dylib 0x000000010a66d955 AutoCompleteCache::refresh_columns_w(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&) + 233 14 libwbpublic.be.dylib 0x000000010a66bf3e AutoCompleteCache::refresh_cache_thread() + 204 15 libwbpublic.be.dylib 0x000000010a66f877 AutoCompleteCache::_refresh_cache_thread(void*) + 11 16 libglib-2.0.0.dylib 0x0000000109f1ba2a g_thread_proxy + 90 17 libsystem_pthread.dylib 0x00007fff99caa99d _pthread_body + 131 18 libsystem_pthread.dylib 0x00007fff99caa91a _pthread_start + 168 19 libsystem_pthread.dylib 0x00007fff99ca8351 thread_start + 13 Thanks, Umesh
[3 Aug 2016 6:07]
MySQL Verification Team
Bug #82158 marked as duplicate of this
[3 Aug 2016 6:53]
Alex Khakham
This issue should be considered as S2 because it makes WB being useless for large amount of MYSQL customers. Please provide me with any kind of solution or workaround. Thanks.
[3 Aug 2016 7:43]
Greg Bridle
Hi Alex, I also experienced the same problem (my bug is referenced to yours). I could work around with version 6.3.6 build 511 CE on El Capitan which has been relatively stable and supports the JSON data type. SQL Workbench has been problematic for us on OSX so hopefully a bug fix is forthcoming as the software would be truly fantastic if the stability problems could be resolved. Greg
[10 Aug 2016 7:56]
Alex Khakham
Hi Grag, Thank you for your workaround. I will try to use the build mentioned by you and post my outcomes. Hope Oracle will fix this silly bug and make this product more stable. Regards, Alex.
[10 Aug 2016 7:58]
Alex Khakham
Hi GrEg, Sorry for the typo in your name from the previous comment :) Regards, Alex.
[7 Sep 2016 16:21]
Mike H
This defect occurs frequently depending on the database / table and is easily triggered by a simple SELECT * FROM Table even on local connections. Host: 127.0.0.1 Port: 3308 SSL: enabled with DHE-RSA-AES256-SHA I have a set of tables that I cannot query when starting MySQL Workbench. Applies to both OS X 10.11.6 (15G31) and macOS 10.12 (16A313a). Also see this variation a lot during mysql_ping: 0 libsystem_kernel.dylib 0x00007fff9adc2dda __pthread_kill + 10 1 libsystem_pthread.dylib 0x00007fff9aead797 pthread_kill + 90 2 libsystem_c.dylib 0x00007fff9ad28440 abort + 129 3 libsystem_malloc.dylib 0x00007fff9ae18097 free + 530 4 libmysqlclient.20.dylib 0x0000000106dfb3b5 yaSSL::SSL::~SSL() + 69 5 libmysqlclient.20.dylib 0x0000000106df9227 yaSSL_free + 23 6 libmysqlclient.20.dylib 0x0000000106dd0c22 vio_ssl_delete + 82 7 libmysqlclient.20.dylib 0x0000000106d9e962 end_server + 50 8 libmysqlclient.20.dylib 0x0000000106d9e5d1 cli_safe_read_with_ok + 193 9 libmysqlclient.20.dylib 0x0000000106d9f1e7 cli_advanced_command + 1671 10 libmysqlclient.20.dylib 0x0000000106d98526 mysql_ping + 54 11 libmysqlcppconn.7.1.1.7.dylib 0x0000000106cdb6f3 sql::mysql::MySQL_Connection::isValid() + 131 12 libwbprivate.be.dylib 0x000000010571dbed SqlEditorForm::ensure_valid_dbc_connection(boost::shared_ptr<sql::Dbc_connection_handler>&, base::RecMutex&, bool) + 145 13 libwbprivate.be.dylib 0x00000001057146e5 SqlEditorForm::get_autocompletion_connection(boost::shared_ptr<sql::Dbc_connection_handler>&) + 41 14 libwbprivate.be.dylib 0x0000000105732bb9 boost::detail::function::function_obj_invoker1<boost::_bi::bind_t<base::RecMutexLock, boost::_mfi::mf1<base::RecMutexLock, SqlEditorForm, boost::shared_ptr<sql::Dbc_connection_handler>&>, boost::_bi::list2<boost::_bi::value<SqlEditorForm*>, boost::arg<1> > >, base::RecMutexLock, boost::shared_ptr<sql::Dbc_connection_handler>&>::invoke(boost::detail::function::function_buffer&, boost::shared_ptr<sql::Dbc_connection_handler>&) + 41 15 libwbpublic.be.dylib 0x0000000104a5816e boost::function1<base::RecMutexLock, boost::shared_ptr<sql::Dbc_connection_handler>&>::operator()(boost::shared_ptr<sql::Dbc_connection_handler>&) const + 34 16 libwbpublic.be.dylib 0x0000000104a548b4 AutoCompleteCache::refresh_columns_w(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&) + 72 17 libwbpublic.be.dylib 0x0000000104a52f3e AutoCompleteCache::refresh_cache_thread() + 204 18 libwbpublic.be.dylib 0x0000000104a56877 AutoCompleteCache::_refresh_cache_thread(void*) + 11 19 libglib-2.0.0.dylib 0x00000001042fea2a g_thread_proxy + 90 20 libsystem_pthread.dylib 0x00007fff9aeaaabb _pthread_body + 180 21 libsystem_pthread.dylib 0x00007fff9aeaaa07 _pthread_start + 286 22 libsystem_pthread.dylib 0x00007fff9aeaa231 thread_start + 13
[29 Sep 2016 14:43]
Steve Fatula
Crashes all the time, at least 50% of the queries.
Attachment: Workbench CrashLog.txt (text/plain), 94.61 KiB.
[2 Oct 2016 17:02]
Mike H
My workaround for this was to disable SSL. ie Use SSL = No I'm connecting via SSH tunnels so not a security issue.
[16 Oct 2016 6:56]
MAHMOUD ABDEL-FATTAH
I've the same problem on macOS Sierra... once I run ANY query it crashes! Will try 6.3.6 now and will let you know my feedback.
[16 Oct 2016 7:23]
MAHMOUD ABDEL-FATTAH
I moved to 6.3.6 and it is stable! I'll be away from 6.3.7 for now and hope this weird bug got fixed on 6.3.8
[16 Oct 2016 7:59]
Greg Bridle
I have just performed a clean install of OSX Sierra and it also crashes for me on every query. Disabling SSH has no effect. Using 6.3.4 is ok but it also suffers from poor reliability with frequent crashes.
[20 Oct 2016 13:55]
Steven Willis
This was happening to me on 6.3.7 as well. My crash log is: Process: MySQLWorkbench [52623] Path: /Applications/MySQLWorkbench.app/Contents/MacOS/MySQLWorkbench Identifier: com.oracle.mysql.workbench Version: 6.3.7.CE (1) Code Type: X86-64 (Native) Parent Process: ??? [1] Responsible: MySQLWorkbench [52623] User ID: 501 Date/Time: 2016-09-21 14:02:52.648 -0400 OS Version: Mac OS X 10.10.5 (14F1713) Report Version: 11 Anonymous UUID: C3D36F96-11A2-5880-7B10-5EABA98AEF85 Sleep/Wake UUID: F21C683A-1F46-4622-80EC-2B51D8D3036E Time Awake Since Boot: 940000 seconds Time Since Wake: 17000 seconds Crashed Thread: 22 Exception Type: EXC_CRASH (SIGABRT) Exception Codes: 0x0000000000000000, 0x0000000000000000 Application Specific Information: abort() called *** error for object 0x7f888b1b2c00: pointer being freed was not allocated Thread 22 Crashed: 0 libsystem_kernel.dylib 0x00007fff90fc0286 __pthread_kill + 10 1 libsystem_c.dylib 0x00007fff87ed39ab abort + 129 2 libsystem_malloc.dylib 0x00007fff898b31cb free + 428 3 libmysqlclient.20.dylib 0x0000000106dac92c vio_delete + 44 4 libmysqlclient.20.dylib 0x0000000106d7b962 end_server + 50 5 libmysqlclient.20.dylib 0x0000000106d7b5d1 cli_safe_read_with_ok + 193 6 libmysqlclient.20.dylib 0x0000000106d84bdd cli_read_query_result + 29 7 libmysqlclient.20.dylib 0x0000000106d82de5 mysql_real_query + 37 8 libmysqlcppconn.7.1.1.7.dylib 0x0000000106cfa6aa sql::mysql::MySQL_Statement::do_query(sql::SQLString const&) + 106 9 libmysqlcppconn.7.1.1.7.dylib 0x0000000106cfad41 sql::mysql::MySQL_Statement::executeQuery(sql::SQLString const&) + 49 10 libwbpublic.be.dylib 0x0000000101fee955 AutoCompleteCache::refresh_columns_w(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&) + 233 11 libwbpublic.be.dylib 0x0000000101fecf3e AutoCompleteCache::refresh_cache_thread() + 204 12 libwbpublic.be.dylib 0x0000000101ff0877 AutoCompleteCache::_refresh_cache_thread(void*) + 11 13 libglib-2.0.0.dylib 0x000000010189ba2a g_thread_proxy + 90 14 libsystem_pthread.dylib 0x00007fff8989305a _pthread_body + 131 15 libsystem_pthread.dylib 0x00007fff89892fd7 _pthread_start + 176 16 libsystem_pthread.dylib 0x00007fff898903ed thread_start + 13 Thread 22 crashed with X86 Thread State (64-bit): rax: 0x0000000000000000 rbx: 0x0000000000000006 rcx: 0x0000000113950958 rdx: 0x0000000000000000 rdi: 0x000000000000377f rsi: 0x0000000000000006 rbp: 0x0000000113950980 rsp: 0x0000000113950958 r8: 0x0000000000000001 r9: 0x0000000000000000 r10: 0x0000000008000000 r11: 0x0000000000000206 r12: 0x000000010199a000 r13: 0x0000000000000007 r14: 0x0000000113951000 r15: 0x0000000000000000 rip: 0x00007fff90fc0286 rfl: 0x0000000000000206 cr2: 0x00007fff75fd8fd8 Logical CPU: 0 Error Code: 0x02000148 Trap Number: 133 I also downgraded to 6.3.6 and haven't had the crash since. For me the crashes seemed to occur on the first query on a new table during a single session. Any time I did a 'select * from some_table' on a new table it would crash. I'd restart the program and run the exact same query (which was auto-saved by mysqlworkbench) and it would succeed. If I then queried a different table, it would crash again.
[27 Apr 2017 12:43]
Marcin Szalowicz
Hello, Could you try with version 6.3.9 please.
[28 May 2017 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".
[28 May 2017 6:07]
Greg Bridle
Version 6.3.9 is definitely more stable than the previous version, but introduced a number of other bugs, most noteably the data grid is now useless with keyboard alone. Moving between cells and then editing has unpredictable behaviour. This was not seen in previous versions so we seem to get a version that fixes one bug but introduces others in areas that never had bugs before. There is obviously still issues with quality control in this product.
