https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-stop-HAWQ-segment-from-the-terminal/m-p/119224#M51051 <P>I am trying to restart the HAWQ service using Ambari. However, for some reason the segments are not Stopping and the operation is timing out after 600 seconds. Is there a way to stop the segments and/or restart them from the terminal?</P><P>I am using HDP 2.4.2 and HAWQ 2.0.1</P> Mon, 09 Jan 2017 03:46:28 GMT p_routray 2017-01-09T03:46:28Z https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-stop-HAWQ-segment-from-the-terminal/m-p/119224#M51051 <P>I am trying to restart the HAWQ service using Ambari. However, for some reason the segments are not Stopping and the operation is timing out after 600 seconds. Is there a way to stop the segments and/or restart them from the terminal?</P><P>I am using HDP 2.4.2 and HAWQ 2.0.1</P> Mon, 09 Jan 2017 03:46:28 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-stop-HAWQ-segment-from-the-terminal/m-p/119224#M51051 p_routray 2017-01-09T03:46:28Z https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-stop-HAWQ-segment-from-the-terminal/m-p/119225#M51052 <P>waiting for server to shut down........................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................... failed 20170108:19:26:51:311785 hawq_stop:datanode01-dev:gpadmin-[INFO]:-pg_ctl: server does not shut down 20170108:19:26:51:311785 hawq_stop:datanode01-dev:gpadmin-[ERROR]:-Segment stop failed, exit 20170108:19:36:55:313713 hawq_stop:datanode01-dev:gpadmin-[INFO]:-Prepare to do 'hawq stop' 20170108:19:36:55:313713 hawq_stop:datanode01-dev:gpadmin-[INFO]:-You can find log in: 20170108:19:36:55:313713 hawq_stop:datanode01-dev:gpadmin-[INFO]:-/home/gpadmin/hawqAdminLogs/hawq_stop_20170108.log 20170108:19:36:55:313713 hawq_stop:datanode01-dev:gpadmin-[INFO]:-GPHOME is set to: 20170108:19:36:55:313713 hawq_stop:datanode01-dev:gpadmin-[INFO]:-/usr/local/hawq/. 20170108:19:36:55:313713 hawq_stop:datanode01-dev:gpadmin-[DEBUG]:-Current user is 'gpadmin' 20170108:19:36:55:313713 hawq_stop:datanode01-dev:gpadmin-[DEBUG]:-Parsing config file: 20170108:19:36:55:313713 hawq_stop:datanode01-dev:gpadmin-[DEBUG]:-/usr/local/hawq/./etc/hawq-site.xml 20170108:19:36:55:313713 hawq_stop:datanode01-dev:gpadmin-[INFO]:-Stop hawq with args: ['stop', 'segment'] 20170108:19:36:55:313713 hawq_stop:datanode01-dev:gpadmin-[INFO]:-Stop hawq segment waiting for server to shut down........................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................... failed 20170108:19:46:56:313713 hawq_stop:datanode01-dev:gpadmin-[INFO]:-pg_ctl: server does not shut down 20170108:19:46:56:313713 hawq_stop:datanode01-dev:gpadmin-[ERROR]:-Segment stop failed, exit 20170108:19:48:12:314792 hawq_stop:datanode01-dev:gpadmin-[INFO]:-Prepare to do 'hawq stop' 20170108:19:48:12:314792 hawq_stop:datanode01-dev:gpadmin-[INFO]:-You can find log in: 20170108:19:48:12:314792 hawq_stop:datanode01-dev:gpadmin-[INFO]:-/home/gpadmin/hawqAdminLogs/hawq_stop_20170108.log 20170108:19:48:12:314792 hawq_stop:datanode01-dev:gpadmin-[INFO]:-GPHOME is set to: 20170108:19:48:12:314792 hawq_stop:datanode01-dev:gpadmin-[INFO]:-/usr/local/hawq/. 20170108:19:48:12:314792 hawq_stop:datanode01-dev:gpadmin-[DEBUG]:-Current user is 'gpadmin' 20170108:19:48:12:314792 hawq_stop:datanode01-dev:gpadmin-[DEBUG]:-Parsing config file: 20170108:19:48:12:314792 hawq_stop:datanode01-dev:gpadmin-[DEBUG]:-/usr/local/hawq/./etc/hawq-site.xml 20170108:19:48:12:314792 hawq_stop:datanode01-dev:gpadmin-[INFO]:-Stop hawq with args: ['stop', 'segment'] 20170108:19:48:12:314792 hawq_stop:datanode01-dev:gpadmin-[INFO]:-Stop hawq segment waiting for server to shut down..........................................20170108:19:48:51:314926 hawq_stop:datanode01-dev:gpadmin-[INFO]:-Prepare to do 'hawq stop' 20170108:19:48:51:314926 hawq_stop:datanode01-dev:gpadmin-[INFO]:-You can find log in: 20170108:19:48:51:314926 hawq_stop:datanode01-dev:gpadmin-[INFO]:-/home/gpadmin/hawqAdminLogs/hawq_stop_20170108.log 20170108:19:48:51:314926 hawq_stop:datanode01-dev:gpadmin-[INFO]:-GPHOME is set to: 20170108:19:48:51:314926 hawq_stop:datanode01-dev:gpadmin-[INFO]:-/usr/local/hawq/. 20170108:19:48:51:314926 hawq_stop:datanode01-dev:gpadmin-[INFO]:-Stop hawq with args: ['stop', 'segment'] .......20170108:19:48:58:314926 hawq_stop:datanode01-dev:gpadmin-[INFO]:-Stop hawq segment waiting for server to shut down........................................................................................................................................................................................[root@datanode01-dev ~]#</P> Mon, 09 Jan 2017 03:51:44 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-stop-HAWQ-segment-from-the-terminal/m-p/119225#M51052 p_routray 2017-01-09T03:51:44Z https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-stop-HAWQ-segment-from-the-terminal/m-p/119226#M51053 <P>Hi Piyush , </P><P>You can login to the hawq segment server and can stop the segment with the following </P><P>ssh hawq-segment</P><P>su - gpadmin </P><P>source /usr/local/hawq/greenplum_path.sh</P><P>hawq stop segment </P><P>If it still not getting stopped ,look for the orphan segment process in the server and manually kill it (ps -ef|grep postgres ) .It would be good to the check segment logs in the server for the details .</P><P>Thanks </P><P>Pratheesh Nair</P> Mon, 09 Jan 2017 03:51:55 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-stop-HAWQ-segment-from-the-terminal/m-p/119226#M51053 pratheeshnair37 2017-01-09T03:51:55Z https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-stop-HAWQ-segment-from-the-terminal/m-p/119227#M51054 <P>Killing the process(es) helped. Thanks!</P> Mon, 09 Jan 2017 04:04:51 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-stop-HAWQ-segment-from-the-terminal/m-p/119227#M51054 p_routray 2017-01-09T04:04:51Z https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-stop-HAWQ-segment-from-the-terminal/m-p/119228#M51055 <P>Hi Piyush,</P><P>Additionally, you can try using the following commands:</P><P>hawq stop segment -M fast</P><P>If the above does not work stop with option "immediate" should kill the process for you:</P><P>hawq stop segment -M immediate</P><P>If you do not provide any option with -M the stop/shutdown uses "smart" mode which does not really kill anything if there is any active connection or query.</P> Sat, 18 Feb 2017 01:16:59 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-stop-HAWQ-segment-from-the-terminal/m-p/119228#M51055 gbrahmi 2017-02-18T01:16:59Z