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

["Newton Alex (JIRA)" <ji...@apache.org>]

Newton Alex created AMBARI-14931:
------------------------------------

             Summary: 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


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)