Comments (10)
Can't reproduce that (I don't have a Vertica instance for testing) but most likely it is Vertica driver-specific issue.
Does cancel not happen only for some particular long-running queries or for any query?
You can test it by running query like "SELECT SLEEP(10);"
from dbeaver.
Hi Serge,
I just try and it fail in the same way using "SELECT SLEEP(100)". I launch the query and click cancel, then it wait 100 second and the query result appear. It seems that it's not cancelling the request.
Maybe you can try to reproduce it using a docker Vertica instance :
docker run -d -p 5433:5433 sumitchawla/vertica
Then you can connect on port 5433 using:
host: <your docker ip>
port 5433:
username: dbadmin
password: dbadmin
from dbeaver.
Thank for idea, I'll try it.
However I suspect that Vertica driver just doesn't support query canceling.. Anyway I'll try to find some workaround.
from dbeaver.
It seems to be the same issue as reported in http://dbeaver.jkiss.org/forum/viewtopic.php?f=2&t=1783&p=4586&hilit=vertica#p4586
from dbeaver.
Still no luck with docker..
Anyhow - if this issue still bothers you - could you post a process thread dump when DBeaver hangs and cancel doesn't work?
To get the thread dump:
- Find DBeaver process id (ps auxf | grep dbeaver)
- Execute jstack <dbeaver-pid> > thread-dump.txt
- Post file thread-dump.txt here
Thanks in advance
from dbeaver.
Hi Serge,
Happy to ear that you are on it. Find attached the dump after I hit cancel button.
Thank you fo your time. Let me know if I can help doing anything else.
thread-dump.txt
from dbeaver.
Hi Serge,
Was the thread dump useful? Let me know if I can be of any help.
And by way, thank you so much for the grid control redesign! It's gorgeous!
from dbeaver.
Hey.
Yes, dump was useful, thank you.
Vertica driver doesn't support statement cancellation.
Now I'm thinking about possible workarounds (e.g. connection close or thread interrupt). But I still don't have test environment with Vertica so this issue was postponed for a while.
from dbeaver.
Thank you Serge,
On my side, I try to contact HP Vertica support regarding this issue.
from dbeaver.
I'll close this issue as there is nothing I can do for now..
from dbeaver.
Related Issues (20)
- Ocient - DDL generating incorrectly HOT 1
- Summarized Query execution HOT 1
- DBeaver not reading SQLite composite foreign keys correctly HOT 1
- 24.0.3 - Execute as script not working correctly HOT 1
- Execute SQL Query and Execute SQL Script are no longer executing correctly HOT 1
- Unable to read databricks table, error reads: Unable to read this table because it requires reader table feature(s) that is unsupported by this version of Databricks: deletionVectors
- Inconsistent "DROP TABLE YES NO" warning HOT 1
- One-line execution and SAVEPOINT do not work HOT 1
- Virtual Foreign key: Reference table container selector doesn't work HOT 1
- DBeaver locking up / getting into a 'Not responding' state when a table has a PostgreSQL 'AccessExclusiveLock' HOT 2
- Ctrl+Enter returns error when vacuum command is present in the editor HOT 1
- LOAD DATA INFILE throwing error HOT 2
- Active Catalog Schema Opens Multiple Windows of the Same HOT 3
- problem with query execution HOT 1
- SQL Server - don't recognize "go" HOT 1
- Endless errors while working with tables with composite FK HOT 1
- CTRL+ENTER and ALT+X not working HOT 2
- Flashing disconnect countdown HOT 1
- When encountering an Oracle database, batch execution of SQL reports an error. HOT 1
- How to connect to RedShift using dBeaver and IAM
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from dbeaver.