Mailing-List: contact dev-help@ambari.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@ambari.apache.org
Content-Type: multipart/alternative;
 boundary="===============6972194875213545766=="
MIME-Version: 1.0
Subject: Review Request 43226: HAWQ service failure on single node clusters
From: Newton Alex <nalex@pivotal.io>
To: Newton Alex <nalex@pivotal.io>, Ambari <dev@ambari.apache.org>
Date: Thu, 04 Feb 2016 23:08:40 -0000
Message-ID: <20160204230840.1669.37149@reviews.apache.org>
Auto-Submitted: auto-generated
Sender: Newton Alex <noreply@reviews.apache.org>
Reply-To: Newton Alex <nalex@pivotal.io>

--===============6972194875213545766==
MIME-Version: 1.0
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: 7bit


-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/43226/
-----------------------------------------------------------

Review request for Ambari.


Bugs: AMBARI-14931
    https://issues.apache.org/jira/browse/AMBARI-14931


Repository: ambari


Description
-------

Fix for HAWQ service failure on single node clusters


Diffs
-----

  ambari-server/src/main/resources/common-services/HAWQ/2.0.0/package/scripts/utils.py e607a28 

Diff: https://reviews.apache.org/r/43226/diff/


Testing
-------

Manual testing done

Single Node:
```
2016-02-04 20:24:22,716 - Validating data inserted, finding sum of all the inserted entries. Expected output: 55
2016-02-04 20:24:22,716 - Command executed: su - gpadmin -c "export PGPORT=10432 && source /usr/local/hawq/greenplum_path.sh && psql -t -d template1 -c \"SELECT sum(col1) FROM ambari_hawq_test;\""
2016-02-04 20:24:23,481 - Output:
  55


2016-02-04 20:24:23,482 - Dropping ambari_hawq_test table if exists
2016-02-04 20:24:23,482 - Command executed: su - gpadmin -c "export PGPORT=10432 && source /usr/local/hawq/greenplum_path.sh && psql -d template1 -c \"DROP  TABLE IF EXISTS ambari_hawq_test;\""
2016-02-04 20:24:23,697 - Output:
DROP TABLE

2016-02-04 20:24:23,698 - PXF not installed. Skipping HAWQ-PXF checks...
2016-02-04 20:24:23,698 - Service check completed successfully
```


Multi Node:
```
2016-02-04 22:42:33,348 - Validating data inserted, finding sum of all the inserted entries. Expected output: 55
2016-02-04 22:42:33,349 - Command executed: su - gpadmin -c 'ssh -o StrictHostKeyChecking=no -o UserKnownHostsFile=/dev/null c6410.ambari.apache.org "export PGPORT=5432 && source /usr/local/hawq/greenplum_path.sh && psql -t -d template1 -c \"SELECT sum(col1) FROM ambari_hawq_test;\" " '
2016-02-04 22:42:33,904 - Output:
  55


2016-02-04 22:42:33,904 - Dropping ambari_hawq_test table if exists
2016-02-04 22:42:33,905 - Command executed: su - gpadmin -c 'ssh -o StrictHostKeyChecking=no -o UserKnownHostsFile=/dev/null c6410.ambari.apache.org "export PGPORT=5432 && source /usr/local/hawq/greenplum_path.sh && psql -d template1 -c \"DROP  TABLE IF EXISTS ambari_hawq_test;\" " '
2016-02-04 22:42:34,131 - Output:
DROP TABLE

2016-02-04 22:42:34,131 - PXF not installed. Skipping HAWQ-PXF checks...
2016-02-04 22:42:34,132 - Service check completed successfully
```


Thanks,

Newton Alex


--===============6972194875213545766==--