You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hawq.apache.org by "Lin Wen (JIRA)" <ji...@apache.org> on 2017/08/29 09:58:06 UTC

[jira] [Created] (HAWQ-1521) Idle QE Processes Can't Quit After An Interval

Lin Wen created HAWQ-1521:
-----------------------------

             Summary: Idle QE Processes Can't Quit After An Interval
                 Key: HAWQ-1521
                 URL: https://issues.apache.org/jira/browse/HAWQ-1521
             Project: Apache HAWQ
          Issue Type: Bug
            Reporter: Lin Wen
            Assignee: Radar Lei


After a query is finished, there are some idle QE processes on segments. These QE processes are expected to quit after a time interval, this interval is controlled by a GUC gp_vmem_idle_resource_timeout, the default value is 18 seconds.

However, this does't act as expected. Idle QE processes on segments always exist there, unless the QD process quit. 

The reason is in postgres.c, the codes to enable this timer can't get executed. function gangsExist() always return false, since gang related structures are all NULL.

	if (IdleSessionGangTimeout > 0 && gangsExist())
		if (!enable_sig_alarm( IdleSessionGangTimeout /* ms */, false))
			elog(FATAL, "could not set timer for client wait timeout");




--
This message was sent by Atlassian JIRA
(v6.4.14#64029)