You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hawq.apache.org by Guo Kai <gu...@gmail.com> on 2016/12/22 07:04:58 UTC

hawq stop cluster error

hello, when I execute 'hawq stop cluster', it goes wrong.

The error shows:

[hadoop@Master ~]$ hawq stop cluster
20161217:19:59:31:004594 hawq_stop:Master:hadoop-[INFO]:-Prepare to do
'hawq stop'
20161217:19:59:31:004594 hawq_stop:Master:hadoop-[INFO]:-You can check log
in /home/hadoop/hawqAdminLogs/hawq_stop_20161217.log
20161217:19:59:31:004594 hawq_stop:Master:hadoop-[INFO]:-Stop hawq with
args: ['stop', 'cluster']

Continue with HAWQ service stop Yy|Nn (default=N):

20161217:19:59:38:004594 hawq_stop:Master:hadoop-[INFO]:-No standby host
configured
20161217:19:59:38:004594 hawq_stop:Master:hadoop-[INFO]:-Stop hawq cluster
Traceback (most recent call last):
  File "/home/hadoop/hawq/bin/hawq_ctl", line 1276, in <module>
    stop_hawq(opts, hawq_dict)
  File "/home/hadoop/hawq/bin/hawq_ctl", line 1043, in stop_hawq
    instance.run()
  File "/home/hadoop/hawq/bin/hawq_ctl", line 891, in run
    check_return_code(self._stopAll())
  File "/home/hadoop/hawq/bin/hawq_ctl", line 816, in _stopAll
    master_result = self._stop_master()
  File "/home/hadoop/hawq/bin/hawq_ctl", line 760, in _stop_master
    self._stop_master_checks()
  File "/home/hadoop/hawq/bin/hawq_ctl", line 712, in _stop_master_checks
    self.conn = dbconn.connect(self.dburl, utility=True)
  File "/home/hadoop/hawq/lib/python/gppylib/db/dbconn.py", line 211, in
connect
    cnx  = pgdb._connect_(cstr, dbhost, dbport, dbopt, dbtty, dbuser,
dbpasswd)
AttributeError: 'module' object has no attribute '_connect_'

​I tried to reinstall pygresql, but it still failed.

I am looking forward your reply. :)

-- 
Guo Kai,
guokaiwhu@gmail.com

Re: hawq stop cluster error

Posted by 胡晓 <hu...@icloud.com>.
Hi,Kai
I think you must make sure the installation of this python module 

发自我的 iPhone

> 在 2016年12月22日,15:52,Radar Da lei <rl...@pivotal.io> 写道:
> 
> Hi Kai,
> 
> This seems like pygresql install issue.
> 
> Are you using latest hawq? How do you reinstall pygresql?
> 
> Make sure you don't see any compile errors while making pygresql.
> 
> Thanks.
> 
> Regards,
> Radar
> 
>> On Thu, Dec 22, 2016 at 3:27 PM, Ma Hongxu <in...@outlook.com> wrote:
>> 
>> Hi kai
>> 
>> It seems that you didn't source greenplum_path.sh in your
>> {hawq-install-dir}.
>> You can also check PYTHONPATH environment variable, it should be
>> '{hawq-install-dir}/lib/python:{other}'. And which version of python do
>> you have installed?
>> 
>> 
>> 在 22/12/2016 15:04, Guo Kai 写道:
>> 
>> hello, when I execute 'hawq stop cluster', it goes wrong.
>> 
>> The error shows:
>> 
>> [hadoop@Master ~]$ hawq stop cluster
>> 20161217:19:59:31:004594 hawq_stop:Master:hadoop-[INFO]:-Prepare to do
>> 'hawq stop'
>> 20161217:19:59:31:004594 hawq_stop:Master:hadoop-[INFO]:-You can check log
>> in /home/hadoop/hawqAdminLogs/hawq_stop_20161217.log
>> 20161217:19:59:31:004594 hawq_stop:Master:hadoop-[INFO]:-Stop hawq with
>> args: ['stop', 'cluster']
>> 
>> Continue with HAWQ service stop Yy|Nn (default=N):
>> 
>> 20161217:19:59:38:004594 hawq_stop:Master:hadoop-[INFO]:-No standby host
>> configured
>> 20161217:19:59:38:004594 hawq_stop:Master:hadoop-[INFO]:-Stop hawq cluster
>> Traceback (most recent call last):
>>  File "/home/hadoop/hawq/bin/hawq_ctl", line 1276, in <module>
>>    stop_hawq(opts, hawq_dict)
>>  File "/home/hadoop/hawq/bin/hawq_ctl", line 1043, in stop_hawq
>>    instance.run()
>>  File "/home/hadoop/hawq/bin/hawq_ctl", line 891, in run
>>    check_return_code(self._stopAll())
>>  File "/home/hadoop/hawq/bin/hawq_ctl", line 816, in _stopAll
>>    master_result = self._stop_master()
>>  File "/home/hadoop/hawq/bin/hawq_ctl", line 760, in _stop_master
>>    self._stop_master_checks()
>>  File "/home/hadoop/hawq/bin/hawq_ctl", line 712, in _stop_master_checks
>>    self.conn = dbconn.connect(self.dburl, utility=True)
>>  File "/home/hadoop/hawq/lib/python/gppylib/db/dbconn.py", line 211, in
>> connect
>>    cnx  = pgdb._connect_(cstr, dbhost, dbport, dbopt, dbtty, dbuser,
>> dbpasswd)
>> AttributeError: 'module' object has no attribute '_connect_'
>> 
>> I tried to reinstall pygresql, but it still failed.
>> 
>> I am looking forward your reply. :)
>> 
>> 
>> 
>> 

Re: hawq stop cluster error

Posted by Radar Da lei <rl...@pivotal.io>.
Hi Kai,

This seems like pygresql install issue.

Are you using latest hawq? How do you reinstall pygresql?

Make sure you don't see any compile errors while making pygresql.

Thanks.

Regards,
Radar

On Thu, Dec 22, 2016 at 3:27 PM, Ma Hongxu <in...@outlook.com> wrote:

> Hi kai
>
> It seems that you didn't source greenplum_path.sh in your
> {hawq-install-dir}.
> You can also check PYTHONPATH environment variable, it should be
> '{hawq-install-dir}/lib/python:{other}'. And which version of python do
> you have installed?
>
>
> 在 22/12/2016 15:04, Guo Kai 写道:
>
> hello, when I execute 'hawq stop cluster', it goes wrong.
>
> The error shows:
>
> [hadoop@Master ~]$ hawq stop cluster
> 20161217:19:59:31:004594 hawq_stop:Master:hadoop-[INFO]:-Prepare to do
> 'hawq stop'
> 20161217:19:59:31:004594 hawq_stop:Master:hadoop-[INFO]:-You can check log
> in /home/hadoop/hawqAdminLogs/hawq_stop_20161217.log
> 20161217:19:59:31:004594 hawq_stop:Master:hadoop-[INFO]:-Stop hawq with
> args: ['stop', 'cluster']
>
> Continue with HAWQ service stop Yy|Nn (default=N):
>
> 20161217:19:59:38:004594 hawq_stop:Master:hadoop-[INFO]:-No standby host
> configured
> 20161217:19:59:38:004594 hawq_stop:Master:hadoop-[INFO]:-Stop hawq cluster
> Traceback (most recent call last):
>   File "/home/hadoop/hawq/bin/hawq_ctl", line 1276, in <module>
>     stop_hawq(opts, hawq_dict)
>   File "/home/hadoop/hawq/bin/hawq_ctl", line 1043, in stop_hawq
>     instance.run()
>   File "/home/hadoop/hawq/bin/hawq_ctl", line 891, in run
>     check_return_code(self._stopAll())
>   File "/home/hadoop/hawq/bin/hawq_ctl", line 816, in _stopAll
>     master_result = self._stop_master()
>   File "/home/hadoop/hawq/bin/hawq_ctl", line 760, in _stop_master
>     self._stop_master_checks()
>   File "/home/hadoop/hawq/bin/hawq_ctl", line 712, in _stop_master_checks
>     self.conn = dbconn.connect(self.dburl, utility=True)
>   File "/home/hadoop/hawq/lib/python/gppylib/db/dbconn.py", line 211, in
> connect
>     cnx  = pgdb._connect_(cstr, dbhost, dbport, dbopt, dbtty, dbuser,
> dbpasswd)
> AttributeError: 'module' object has no attribute '_connect_'
>
> ​I tried to reinstall pygresql, but it still failed.
>
> I am looking forward your reply. :)
>
>
>
>

Re: hawq stop cluster error

Posted by Ma Hongxu <in...@outlook.com>.
Hi kai

It seems that you didn't source greenplum_path.sh in your {hawq-install-dir}.
You can also check PYTHONPATH environment variable, it should be '{hawq-install-dir}/lib/python:{other}'. And which version of python do you have installed?


在 22/12/2016 15:04, Guo Kai 写道:

hello, when I execute 'hawq stop cluster', it goes wrong.

The error shows:

[hadoop@Master ~]$ hawq stop cluster
20161217:19:59:31:004594 hawq_stop:Master:hadoop-[INFO]:-Prepare to do
'hawq stop'
20161217:19:59:31:004594 hawq_stop:Master:hadoop-[INFO]:-You can check log
in /home/hadoop/hawqAdminLogs/hawq_stop_20161217.log
20161217:19:59:31:004594 hawq_stop:Master:hadoop-[INFO]:-Stop hawq with
args: ['stop', 'cluster']

Continue with HAWQ service stop Yy|Nn (default=N):

20161217:19:59:38:004594 hawq_stop:Master:hadoop-[INFO]:-No standby host
configured
20161217:19:59:38:004594 hawq_stop:Master:hadoop-[INFO]:-Stop hawq cluster
Traceback (most recent call last):
  File "/home/hadoop/hawq/bin/hawq_ctl", line 1276, in <module>
    stop_hawq(opts, hawq_dict)
  File "/home/hadoop/hawq/bin/hawq_ctl", line 1043, in stop_hawq
    instance.run()
  File "/home/hadoop/hawq/bin/hawq_ctl", line 891, in run
    check_return_code(self._stopAll())
  File "/home/hadoop/hawq/bin/hawq_ctl", line 816, in _stopAll
    master_result = self._stop_master()
  File "/home/hadoop/hawq/bin/hawq_ctl", line 760, in _stop_master
    self._stop_master_checks()
  File "/home/hadoop/hawq/bin/hawq_ctl", line 712, in _stop_master_checks
    self.conn = dbconn.connect(self.dburl, utility=True)
  File "/home/hadoop/hawq/lib/python/gppylib/db/dbconn.py", line 211, in
connect
    cnx  = pgdb._connect_(cstr, dbhost, dbport, dbopt, dbtty, dbuser,
dbpasswd)
AttributeError: 'module' object has no attribute '_connect_'

​I tried to reinstall pygresql, but it still failed.

I am looking forward your reply. :)