0

We have small Hadoop-Hawq Cluster. In that, once of slave host service fails When I am executing the check of HAWQ services.

Getting following error From Ambari UI:

**stderr:** 
Traceback (most recent call last):
  File "/var/lib/ambari-agent/cache/stacks/PHD/3.0/services/HAWQ/package/scripts/service_check.py", line 9, in <module>
    HAWQServiceCheck().execute()
  File "/usr/lib/python2.6/site-packages/resource_management/libraries/script/script.py", line 123, in execute
    method(env)
  File "/var/lib/ambari-agent/cache/stacks/PHD/3.0/services/HAWQ/package/scripts/service_check.py", line 6, in service_check
    hawq.verify_segments_state(env)
  File "/var/lib/ambari-agent/cache/stacks/PHD/3.0/services/HAWQ/package/scripts/hawq.py", line 20, in verify_segments_state
    raise Exception("gpstate command returned non-zero result: {0}. Out: {1} Error: {2}".format(retcode, out, err))
Exception: gpstate command returned non-zero result: 255. Out:  Error: Permission denied, please try again.
Permission denied, please try again.
Permission denied (publickey,gssapi-keyex,gssapi-with-mic,password).
 **stdout:**
(255, '', 'Permission denied, please try again.\r\nPermission denied, please try again.\r\nPermission denied (publickey,gssapi-keyex,gssapi-with-mic,password).\r\n')

Any help on it would be much appreciated ?

NEO
  • 389
  • 8
  • 31
  • Hi @vickps, welcome to SO or sort of ... Have you tried to run the script in a verbose mode before asking the question here? It seems that there is a permission issue ... Look at that before going further. You know the expression 'step by step' ... – Andy K Jun 06 '16 at 10:29
  • We are doing the check from Ambari UI . and there is no verbose option. – NEO Jun 06 '16 at 10:31
  • then you have a real issue ... What your sysadmin is saying...? – Andy K Jun 06 '16 at 10:32
  • I am the sysadmin and responsible person for HAWQ related issue – NEO Jun 06 '16 at 10:35
  • ... (gasp) @vickps – Andy K Jun 06 '16 at 10:36
  • is there command to check the service with verbose option ? – NEO Jun 06 '16 at 10:36
  • Does it help @vickps http://stackoverflow.com/questions/31010016/permission-denied-publickey-gssapi-keyex-gssapi-with-mic-password-during-ambar – Andy K Jun 06 '16 at 10:39
  • or this one @vickps https://discuss.zendesk.com/hc/en-us/articles/206099047-Host-registration-in-Ambari-fails-with-Permission-denied- – Andy K Jun 06 '16 at 10:40
  • Thanks , Let me check both the Link . – NEO Jun 06 '16 at 10:49
  • [root@Ambari ~]# ssh hawqmachine Last login: Mon Jun 6 11:16:30 2016 from Ambari [root@hawqmachine ~]# – NEO Jun 06 '16 at 11:18
  • When i am executing the command it is picking from ambari all host and slave has ability to passwordless SSH – NEO Jun 06 '16 at 11:18
  • when you connect through ssh via prompt is different when you run it in an automated way. Have a try with an automated script to see if things are the same in terms of connection – Andy K Jun 06 '16 at 11:28
  • Sure . Let me check run of the automated script using Ambari Command line. – NEO Jun 06 '16 at 11:32
  • any updates on what you have done? – Andy K Jun 06 '16 at 12:10
  • Let us [continue this discussion in chat](http://chat.stackoverflow.com/rooms/113936/discussion-between-vickps-and-andy-k). – NEO Jun 06 '16 at 15:03

1 Answers1

4

HAWQ requires passwordless ssh access to all cluster nodes. Check if the system is configured to allow that, and execute the following hawq command to set up passwordless ssh on the nodes defined in your hostfile:

$ gpssh-exkeys -f hostfile (in version 1.x)

$ hawq ssh-exkeys -f hostfile (in version 2.x)

Community
  • 1
  • 1
user5368785
  • 53
  • 1
  • 5