You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2016/05/18 00:58:12 UTC
[jira] [Commented] (TRAFODION-1956) timeout in tdm_arkcmp process
[ https://issues.apache.org/jira/browse/TRAFODION-1956?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15287991#comment-15287991 ]
ASF GitHub Bot commented on TRAFODION-1956:
-------------------------------------------
GitHub user selvaganesang opened a pull request:
https://github.com/apache/incubator-trafodion/pull/488
[TRAFODION-1956] Timeout for arkcmp process
A new CQD COMPILER_IDLE_TIMEOUT is added to control the compiler
timeout duration. Default value is 1800 seconds.
The compiler processes are killed when a SQL session ends at the
time of ODBC/JDBC disconnection. For an active session the compiler
process is killed when a compiler process remains idle more
than the compiler idle timeout.
The process in session needs to do some SQL for this feature to
kick in. For the idle connected process, the connection idle
timeout will enable killing compiler process. The compiler idle
timeout will be honored but it would take at least connection
idle timeout duration.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/selvaganesang/incubator-trafodion trafodion-1956
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-trafodion/pull/488.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #488
----
commit decb08cc3c928b4033cae28a81e0cc31b9d18d10
Author: selvaganesang <se...@esgyn.com>
Date: 2016-05-18T00:35:55Z
[TRAFODION-1956] Timeout for arkcmp process
A new CQD COMPILER_IDLE_TIMEOUT is added to control the compiler
timeout duration. Default value is 1800 seconds.
The compiler processes are killed when a SQL session ends at the
time of ODBC/JDBC disconnection. For an active session the compiler
process is killed when a compiler process remains idle more
than the compiler idle timeout.
The process in session needs to do some SQL for this feature to
kick in. For the idle connected process, the connection idle
timeout will enable killing compiler process. The compiler idle
timeout will be honored but it would take at least connection
idle timeout duration.
----
> timeout in tdm_arkcmp process
> -----------------------------
>
> Key: TRAFODION-1956
> URL: https://issues.apache.org/jira/browse/TRAFODION-1956
> Project: Apache Trafodion
> Issue Type: Improvement
> Components: sql-cmp
> Affects Versions: any
> Reporter: Henry Lin
> Assignee: Selvaganesan Govindarajan
> Labels: patch
>
> The tdm_arkcmp is spawned for extra sql compilation as needed, but the tdm_arkcmp process will never stop and become an orphan process. It would be better to introduce a mechanism to let tdm_arkcmp stop, e.g. timeout for an idle tdm_arkcmp.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)