[jira] [Closed] (HAWQ-984) hawq config is too slow.

["Paul Guo (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HAWQ-984?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Paul Guo closed HAWQ-984.
-------------------------
       Resolution: Fixed
         Assignee: Paul Guo  (was: Lei Chang)
    Fix Version/s:     (was: backlog)
                   2.0.1.0-incubating

> hawq config is too slow.
> ------------------------
>
>                 Key: HAWQ-984
>                 URL: https://issues.apache.org/jira/browse/HAWQ-984
>             Project: Apache HAWQ
>          Issue Type: Bug
>          Components: Command Line Tools
>            Reporter: Paul Guo
>            Assignee: Paul Guo
>             Fix For: 2.0.1.0-incubating
>
>
> I tried to set a simple guc value via "hawq config" on my centos
> virtual system, but it spends >6 seconds. I know "hawq config" just
> simple scp-update xml files to various nodes. This should have
> been very fast if network situation is fine (My test hawq system is all-in-one
> test environment so network latency is not an issue.)
> I expect this is done on my test system (just one seg node) in < 1 second.
> But actually the time is:
> $ time hawq config -c lc_messages -v en_US.UTF-8
> GUC lc_messages already exist in hawq-site.xml
> Update it with value: en_US.UTF-8
> GUC		: lc_messages
> Value		: en_US.UTF-8
> real	0m6.363s
> user	0m0.943s
> sys	0m1.258s
> I quickly monitored the processes when running "hawq config",
> it seems that the scp command finishes very early and adding
> print debug code in python file gpscp shows that the code in it
> finishes also very early.
> I'm not sure if anyone sees that long like my case (my system
> is probably quite mangled after dev and test). I roughly traced
> the python stack. I suspect there is something wrong in python
> or we are not using related module well or we should replace modules.
> I just checked "hawq config" but it is possible other CLI suffers from this also.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)