Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Ambari can't stop Mysql service

Solved Go to solution

Ambari can't stop Mysql service

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

Accepted Solutions

Re: Ambari can't stop Mysql service

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.

1 REPLY 1

Re: Ambari can't stop Mysql service

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.

Don't have an account?
Coming from Hortonworks? Activate your account here