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]
Created 05-08-2018 08:26 AM
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
Created 05-08-2018 10:48 AM
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.
Created 05-08-2018 10:48 AM
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.