Our Community is getting an upgrade! To get everything ready for the relaunch, we’ll be placing the site in read-only mode starting September 21st.
We really appreciate your understanding while we get things set up behind the scenes. Catch up on all the exciting details about the move here.
Need help or have questions? Drop us a line at [email protected]

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.