UPgrading ambari 2.4 to 2.5.0.3 mysqld service is getting STOPPED

I am trying to bring back MySQL Server but it not able to remain running, message "This host-level alert is triggered if the Hive Metastore process cannot be determined to be up and listening on the network."

Re: UPgrading ambari 2.4 to 2.5.0.3 mysqld service is getting STOPPED

@Jorge Luis Hernandez Olmos Please check the log file (usually at /var/log/mysql/) and look for the actual error. Also check if there any stale instance of mysqld, is already running. To check this, please execute following command:

ps -ef | grep mysql

If you find any running instance then try to stop mysqld gracefully and if it does not work then kill the daemon. Now try again to start mysql from Ambari.

Re: UPgrading ambari 2.4 to 2.5.0.3 mysqld service is getting STOPPED

@Jorge Luis Hernandez Olmos Please check the log file (usually at /var/log/mysql/) and look for the actual error. Also check if there any stale instance of mysqld, is already running. To check this, please execute following command:

ps -ef | grep mysql

If you find any running instance then try to stop mysqld gracefully and if it does not work then kill the daemon. Now try again to start mysql from Ambari.

Re: UPgrading ambari 2.4 to 2.5.0.3 mysqld service is getting STOPPED

Thank you Manish, this was odd, since logs didn't show anythin in particular, just that session had been successfully terminated, and there was no process running for mysql. After some minutes, we simply try to start the services directly from the linux command line on the server and that bring it up on ambari permanently.