Bug #76078 | Stopping a query causes Workbench to crash | ||
---|---|---|---|
Submitted: | 27 Feb 2015 13:20 | Modified: | 21 Oct 2015 10:07 |
Reporter: | Jonathan Corwin | Email Updates: | |
Status: | Duplicate | Impact on me: | |
Category: | MySQL Workbench: SQL Editor | Severity: | S3 (Non-critical) |
Version: | 6.2.4 | OS: | Windows (Microsoft Windows 8.1 Pro) |
Assigned to: | CPU Architecture: | Any | |
Tags: | WBBugReporter |
[27 Feb 2015 13:20]
Jonathan Corwin
[27 Feb 2015 14:22]
MySQL Verification Team
Query Cancelled output
Attachment: query_cancelled.png (image/png, text), 36.81 KiB.
[27 Feb 2015 14:25]
MySQL Verification Team
I couldn't repeat (see prior attached picture with the expected action) retrieving a large result set. Please give more details how to repeat the issue. My environment is: MySQL Workbench Community (GPL) for Windows version 6.2.4 revision 12437 build 2426 (64 bit) Configuration Directory: C:\Users\Miguel\AppData\Roaming\MySQL\Workbench Data Directory: C:\Program Files\MySQL\MySQL Workbench 6.2 CE Cairo Version: 1.10.2 OS: Microsoft Windows 8.1 Pro CPU: 8x Intel(R) Core(TM) i7-4790 CPU @ 3.60GHz, 16.0 GiB RAM Active video adapter NVIDIA GeForce GT 720 Installed video RAM: 1024 MB Current video mode: 3840 x 2160 x 4294967296 colors Used bit depth: 32 Driver version: 9.18.13.4725 Installed display drivers: nvd3dumx.dll,nvwgf2umx.dll,nvwgf2umx.dll,nvd3dum,nvwgf2um,nvwgf2um Current user language: Portuguese (Brazil)
[27 Feb 2015 14:48]
Jonathan Corwin
A bit of further experimentation with some simpler queries and I couldn't reproduce. However I have tried it with a fabricated query of: SELECT * FROM myverybigtable INNER JOIN (SELECT * FROM myverybigtable) x This would take a significant amount of time to run if I left it. Workbench shows "Running..." with duration/fetch "? / ?" at the point when it crashes. Looking at the processlist, the query was in a stage of Query / "Copying to tmp table"
[3 Mar 2015 21:20]
MySQL Verification Team
Client out of memory
Attachment: out_of_memory.png (image/png, text), 33.51 KiB.
[3 Mar 2015 21:22]
MySQL Verification Team
Thank you for the feedback. I still not able to repeat when I ran a query like you provide which creates a large dataset I got a message that the client ran out of memory and the query stop button interrupt the query.
[4 Apr 2015 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".
[21 Oct 2015 10:07]
MySQL Verification Team
Making this one duplicate of http://bugs.mysql.com/bug.php?id=78881 which was verified.
[31 Jul 2016 7:50]
Daniel Blokh
Greetings, i've got two connections to two different databases. one of them works just fine, the other one when i run a query windows curshes the application for no actual reason.