[AMBARI-14931] HAWQ service checks failing for single node clusters

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.3.0, 2.2.2
• Component/s: stacks
• Assignee: Newton Alex
• Reporter: Newton Alex
• Created: 04/Feb/16 22:56
• Updated: 06/Feb/16 04:34
• Resolved: 06/Feb/16 00:15

Description

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.
```

Issue Links

• links to: Review board