Vertica - Cannot cancel a running query

[dbeaver]

Vertica - Cannot cancel a running query

[serge-rider]

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);"

[wmorin]

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

[serge-rider]

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.

[wmorin]

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

[serge-rider]

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

[wmorin]

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

[wmorin]

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!

[serge-rider]

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.

[wmorin]

Thank you Serge,
On my side, I try to contact HP Vertica support regarding this issue.

[serge-rider]

I'll close this issue as there is nothing I can do for now..