You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ambari.apache.org by "Newton Alex (JIRA)" <ji...@apache.org> on 2016/02/05 00:05:40 UTC

[jira] [Updated] (AMBARI-14931) HAWQ service checks failing for single node clusters

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

Newton Alex updated AMBARI-14931:
---------------------------------
    Attachment: AMBARI-14931.patch

> HAWQ service checks failing for single node clusters
> ----------------------------------------------------
>
>                 Key: AMBARI-14931
>                 URL: https://issues.apache.org/jira/browse/AMBARI-14931
>             Project: Ambari
>          Issue Type: Bug
>          Components: stacks
>            Reporter: Newton Alex
>            Assignee: Newton Alex
>         Attachments: AMBARI-14931.patch
>
>
> Here is the log:
> ```
> 2016-02-04 19:01:30,163 - SQL command executed failed: export PGPORT=10432 && source /usr/local/hawq/greenplum_path.sh && psql -d template1 -c \\\"DROP  TABLE IF EXISTS ambari_hawq_test;\\\"
> Returncode: 127
> Stdout: 
> Stderr: psql: warning: extra command-line argument "IF" ignored
> psql: warning: extra command-line argument "EXISTS" ignored
> psql: warning: extra command-line argument "ambari_hawq_test" ignored
> psql: FATAL:  no pg_hba.conf entry for host "[local]", user "TABLE", database "template1", SSL off
> -bash: ": command not found
> 2016-02-04 19:01:30,164 - SERVICE CHECK FAILED: HAWQ was not able to write and query from a table
> 2016-02-04 19:01:30,229 - SQL command executed failed: export PGPORT=10432 && source /usr/local/hawq/greenplum_path.sh && psql -d template1 -c \\\"DROP  TABLE IF EXISTS ambari_hawq_test;\\\"
> Returncode: 127
> Stdout: 
> Stderr: psql: warning: extra command-line argument "IF" ignored
> psql: warning: extra command-line argument "EXISTS" ignored
> psql: warning: extra command-line argument "ambari_hawq_test" ignored
> psql: FATAL:  no pg_hba.conf entry for host "[local]", user "TABLE", database "template1", SSL off
> -bash: ": command not found
> Traceback (most recent call last):
>   File "/var/lib/ambari-agent/cache/common-services/HAWQ/2.0.0/package/scripts/service_check.py", line 170, in <module>
>     HAWQServiceCheck().execute()
>   File "/usr/lib/python2.6/site-packages/resource_management/libraries/script/script.py", line 238, in execute
>     method(env)
>   File "/var/lib/ambari-agent/cache/common-services/HAWQ/2.0.0/package/scripts/service_check.py", line 48, in service_check
>     self.check_hawq()
>   File "/var/lib/ambari-agent/cache/common-services/HAWQ/2.0.0/package/scripts/service_check.py", line 99, in check_hawq
>     self.drop_table(table)
>   File "/var/lib/ambari-agent/cache/common-services/HAWQ/2.0.0/package/scripts/service_check.py", line 131, in drop_table
>     exec_psql_cmd(sql_cmd, self.active_master_host, self.active_master_port)
>   File "/var/lib/ambari-agent/cache/common-services/HAWQ/2.0.0/package/scripts/utils.py", line 106, in exec_psql_cmd
>     raise Fail("SQL command executed failed.")
> resource_management.core.exceptions.Fail: SQL command executed failed.
> ```



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