× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
tgreen reported 2022-07-22T12:40:02Z  · last modified 2023-02-23T00:58:38Z

ADS hangs and becomes unresponsive @ ~ 4 min mark when retrieving results of slow queries over SSH tunnel


Dev
QA
Priority Low
Complexity Unknown
Component DB - Aurora MySQL
Version 22.1

Updated Summary to reflect this appears to be related to using an ssh tunnel - see most recent comments

-------------------------------------

I have a frequent need to run so slow queries against our Aurora MySQL databases. Once a query gets to approximately the 4m runtime, ADS becomes unresponsive until the results are returned. Can't do anything within the UI at that point and other tabs aren't accessible. It doesn't seem to be dependent on the amount of data returned either. The results might have 0 rows or 10000. This means I can't use ADS exclusively for my querying even though I prefer it, and can't really recommend it to colleagues because of this hassle. So I use ADS *and* MySqlWorkbench.

Attached is an example showing how the query and UI hung at the 4 min mark, and then results which in this case was 0 rows after 10 minutes.

I hope you can help. Let me know if there's other information you need.

Tim

 

Product: Aqua Data Studio

Version: 22.1.1
Build #: 59026
Build Date: 2021-Oct-20 02:42:43 PM
 
Operating Environment: Mac OS X (10.16, x86_64) / UTF-8 / en / US / AdoptOpenJDK 1.8.0_222-b10
Memory: Max=3,817,865,216;  Total=295,698,432;  Free=39,134,224;  CPUs=12
 
In-Window Graphics Capabilities
Graphics Vendor: ATI Technologies Inc.
OpenGL Renderer: AMD Radeon Pro 560X OpenGL Engine
OpenGL Version: 2.1 ATI-4.8.54
Double-Buffering: Enabled
Anti-Aliasing: Enabled
Anti-Aliasing Sample Count: 8
Hardware Acceleration: Enabled
Color Bits: Red: 8  Green: 8  Blue: 8  Alpha: 8
Depth Bits: 16
Accumulation Buffer Bits: Red: 0  Green: 0  Blue: 0
Initialization Time: 1309 ms
 
 
Offscreen Graphics Capabilities
Graphics Vendor: Brian Paul
OpenGL Renderer: Mesa OffScreen
OpenGL Version: 2.1 Mesa 7.8.2
Double-Buffering: Disabled
Anti-Aliasing: Disabled
Anti-Aliasing Sample Count: 0
Hardware Acceleration: Disabled
Color Bits: Red: 8  Green: 8  Blue: 8  Alpha: 8
Depth Bits: 16
Accumulation Buffer Bits: Red: 16  Green: 16  Blue: 16
Initialization Time: 147 ms
Hardware PBuffer Available: No
Using PBuffer: No
Using Ram Buffer: Yes
Offscreen Rendering: Enabled
Offscreen Buffer Size: 800x600
 
 
4 attachments

Issue #15902

New
 
 
Completion
No due date
No fixed build
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017