[jira] [Resolved] (HAWQ-733) Command utility takes about 75 sec to process result
[
https://issues.apache.org/jira/browse/HAWQ-733?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ruilong Huo resolved HAWQ-733.
--
Resolution: Fixed
> Command utility takes about 75 sec to process result
>
>
> Key: HAWQ-733
> URL: https://issues.apache.org/jira/browse/HAWQ-733
> Project: Apache HAWQ
> Issue Type: Test
> Components: Tests
>Affects Versions: 2.0.0
>Reporter: Ruilong Huo
>Assignee: Ruilong Huo
>Priority: Minor
> Fix For: 2.0.0
>
>
> Command utility is designed to run a shell command in hawq test. It follows
> below steps to run command:
> {noformat}
> Step 1: prepare the shell command string
> Step 2: run the command using popen
> Step 3: save the result of command in memory (i.e., stdio returned from popen)
> Step 4: check the status of the command (i.e., status returned from popen)
> Step 5: save the result to file if output file is specified
> {noformat}
> Now it takes about 75 sec to save the result of command in memory in step 3
> if the command is to run SQL file using psql. This needs to be fixed so as to
> improved the performance.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Resolved] (HAWQ-733) Command utility takes about 75 sec to process result
[
https://issues.apache.org/jira/browse/HAWQ-733?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ruilong Huo resolved HAWQ-733.
--
Resolution: Not A Problem
This is a false alarm. The root cause is that when there are connection issues
when psql talking with hawq, it timeout in about 75 seconds.
> Command utility takes about 75 sec to process result
>
>
> Key: HAWQ-733
> URL: https://issues.apache.org/jira/browse/HAWQ-733
> Project: Apache HAWQ
> Issue Type: Test
> Components: Tests
>Reporter: Ruilong Huo
>Assignee: Ruilong Huo
>Priority: Minor
>
> Command utility is designed to run a shell command in hawq test. It follows
> below steps to run command:
> {noformat}
> Step 1: prepare the shell command string
> Step 2: run the command using popen
> Step 3: save the result of command in memory (i.e., stdio returned from popen)
> Step 4: check the status of the command (i.e., status returned from popen)
> Step 5: save the result to file if output file is specified
> {noformat}
> Now it takes about 75 sec to save the result of command in memory in step 3
> if the command is to run SQL file using psql. This needs to be fixed so as to
> improved the performance.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
