Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

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.