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 <na...@pivotal.io> on 2016/02/05 00:08:40 UTC
Review Request 43226: HAWQ service failure on single node clusters
-----------------------------------------------------------
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
Re: Review Request 43226: HAWQ service failure on single node clusters
Posted by jun aoki <ju...@gmail.com>.
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/43226/#review117918
-----------------------------------------------------------
Ship it!
Ship It!
- jun aoki
On Feb. 4, 2016, 11:08 p.m., Newton Alex wrote:
>
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/43226/
> -----------------------------------------------------------
>
> (Updated Feb. 4, 2016, 11:08 p.m.)
>
>
> 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
>
>
Re: Review Request 43226: HAWQ service failure on single node clusters
Posted by Matt <mi...@gmail.com>.
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/43226/#review117903
-----------------------------------------------------------
Ship it!
Ship It!
- Matt
On Feb. 4, 2016, 3:08 p.m., Newton Alex wrote:
>
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/43226/
> -----------------------------------------------------------
>
> (Updated Feb. 4, 2016, 3:08 p.m.)
>
>
> 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
>
>
Re: Review Request 43226: HAWQ service failure on single node clusters
Posted by Lav Jain <lj...@pivotal.io>.
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/43226/#review117909
-----------------------------------------------------------
Ship it!
Ship It!
- Lav Jain
On Feb. 4, 2016, 11:08 p.m., Newton Alex wrote:
>
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/43226/
> -----------------------------------------------------------
>
> (Updated Feb. 4, 2016, 11:08 p.m.)
>
>
> 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
>
>