You can translate the question and the replies:

Denodo doesnt kill the database connection when the query times out

Using the latest Denodo 8.0 with the Aug patch. Question - Per the time limit set for ODBC in VDP server config file, when a query runs beyond 15 mins it gets killed in VDP client but it doesnt kill the respective connection in the source database (Redshift). Is there a specific setting that we should use to kill the db connection as well or its a known defect in Denodo? Please clarify.
user
25-10-2022 16:51:53 -0400
code

3 Answers

Hi, The query timeout settings for the ODBC connection in the VDBConfiguration file are used to set timeout settings for the queries and not for the database connection. It refers to the maximum time the Virtual DataPort waits for a particular query to finish. Currently, it is not possible to kill the database connection from the VDBConfiguration file. Alternatively, you can kill a database connection using the [**Diagnostic and Monitoring Tool**](https://community.denodo.com/docs/html/browse/latest/en/vdp/dmt/index). To do so, follow the below steps: * Add a server in the Diagnostic and Monitoring Tool. * Click on the **Sessions** tab. * Right-click on any of the sessions and select **Cancel Connection** to kill a database connection. Hope this helps!
Denodo Team
26-10-2022 01:55:22 -0400
code
Ok, There are two scenarios that we need to clarify. 1 - Queries gets stuck in Denodo VDP client and also in the source database even after 15 mins. It is an ODBC connection and we have the limit set to 15 mins. Is there a particular scenario where this timeout limit wont be enforced on Denodo connections? 2. Next scenario - Query is cleared in Denodo but still running in Redshift. Understand this can be killed from DMT but when this is how we use Denodo platform regulary then we cant constantly watch and kill it. How do we handle in that case?
user
27-10-2022 17:03:55 -0400
Hi, To kill the database connection you can configure ODBC socket inactivity timeout by executing the following statement in the VQL shell: `SET 'com.denodo.vdb.vdbinterface.server.odbc.socketTimeout'='<Value>'` This property will close the ODBC connection after the specified time. If you still need further assistance and if you are a user with valid support access then you can raise a support case in Denodo Support Site so that our support team can help you. Hope this helps!
Denodo Team
28-10-2022 08:26:55 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here