Archives of Support Questions (Read Only)

This is an archived board for historical reference. Information and links may no longer be available or relevant
Announcements
This board is archived and read-only for historical reference. To ask a new question, please post a new topic on the appropriate active board.

Ambari can't stop Mysql service

avatar
Expert Contributor

I use HDP 2.6.4 Sandbox. When I try to restart Hive mysql service from Ambari, Ambari can't stop mysql.

Python script has been killed due to timeout after waiting 900 secs

2018-05-08 11:02:25,622 - MariaDB RedHat Support: false
2018-05-08 11:02:25,628 - Using hadoop conf dir: /usr/hdp/2.6.4.0-91/hadoop/conf
2018-05-08 11:02:25,636 - call['ambari-python-wrap /usr/bin/hdp-select status hive-server2'] {'timeout': 20}
2018-05-08 11:02:25,680 - call returned (0, 'hive-server2 - 2.6.4.0-91')
2018-05-08 11:02:25,681 - Stack Feature Version Info: Cluster Stack=2.6, Command Stack=None, Command Version=2.6.4.0-91 -> 2.6.4.0-91
2018-05-08 11:02:25,686 - File['/var/lib/ambari-agent/cred/lib/CredentialUtil.jar'] {'content': DownloadSource('http://sandbox-hdp.hortonworks.com:8080/resources/CredentialUtil.jar'), 'mode': 0755}
2018-05-08 11:02:25,688 - Not downloading the file from http://sandbox-hdp.hortonworks.com:8080/resources/CredentialUtil.jar, because /var/lib/ambari-agent/tmp/CredentialUtil.jar already exists
2018-05-08 11:02:25,689 - checked_call[('/usr/lib/jvm/java/bin/java', '-cp', '/var/lib/ambari-agent/cred/lib/*', 'org.apache.ambari.server.credentialapi.CredentialUtil', 'get', 'javax.jdo.option.ConnectionPassword', '-provider', 'jceks://file/var/lib/ambari-agent/cred/conf/mysql_server/hive-site.jceks')] {}
2018-05-08 11:02:26,647 - checked_call returned (0, 'SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".\nSLF4J: Defaulting to no-operation (NOP) logger implementation\nSLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.\nMay 08, 2018 11:02:26 AM org.apache.hadoop.util.NativeCodeLoader <clinit>\nWARNING: Unable to load native-hadoop library for your platform... using builtin-java classes where applicable\nhadoop')
2018-05-08 11:02:26,652 - Execute[('service', 'mysqld', 'stop')] {'logoutput': True, 'sudo': True, 'only_if': "pgrep -l '^mysqld$'"}
Stopping mysqld:  [  OK  ]
2018-05-08 11:02:26,773 - Waiting for actual component stop
2018-05-08 11:02:26,774 - Execute['pgrep -l '^mysqld$''] {}
2018-05-08 11:02:26,903 - Execute['pgrep -l '^mysqld$''] {}
2018-05-08 11:02:27,029 - Execute['pgrep -l '^mysqld$''] {}
2018-05-08 11:02:27,149 - Execute['pgrep -l '^mysqld$''] {}
2018-05-08 11:02:27,270 - Execute['pgrep -l '^mysqld$''] {}
2018-05-08 11:02:27,391 - Execute['pgrep -l '^mysqld$''] {}
....

2018-05-08 11:17:24,622 - Execute['pgrep -l '^mysqld$''] {}
2018-05-08 11:17:24,775 - Waiting for actual component stop
2018-05-08 11:17:24,777 - Execute['pgrep -l '^mysqld$''] {}
2018-05-08 11:17:24,924 - Execute['pgrep -l '^mysqld$''] {}
2018-05-08 11:17:25,077 - Execute['pgrep -l '^mysqld$''] {}
2018-05-08 11:17:25,231 - Execute['pgrep -l '^mysqld$''] {}
2018-05-08 11:17:25,376 - Execute['pgrep -l '^mysqld$''] {}
2018-05-08 11:17:25,522 - Execute['pgrep -l '^mysqld$''] {}

Command failed after 1 tries
1 ACCEPTED SOLUTION

avatar
Expert Contributor

I solved it. I learned mysqld pid with:

top

then killed it

kill 24678

I started mysqld :

service start mysqld

Then I retried from Ambari. It worked.

The problem was:

service mysqld stop

couldn't stop mysqld.

View solution in original post

1 REPLY 1

avatar
Expert Contributor

I solved it. I learned mysqld pid with:

top

then killed it

kill 24678

I started mysqld :

service start mysqld

Then I retried from Ambari. It worked.

The problem was:

service mysqld stop

couldn't stop mysqld.