question Need help cleaning up after failed move of Hive mysql service in Archives of Support Questions (Read Only)

Need help cleaning up after failed move of Hive mysql service

jwhitmore — Fri, 20 Jan 2017 22:33:08 GMT

Hello HCC,

I attempted to perform a move of the mysql service in Hive to another node, but it failed due to a repository problem. Ambari showed a message that there was manual cleanup that needed to be done, but I cannot find any information on how to do it. In the Hive Services screen of Ambari, there are two mysql servers listed, one that runs and the other that does not. This is HDP 2.5.3. Any help cleaning up will be greatly appreciated!

Thanks,

John

Re: Need help cleaning up after failed move of Hive mysql service

PranayV — Fri, 20 Jan 2017 22:59:04 GMT

1) Login to Ambari -> Hive -> Config. Check the mysql connection properties to determine which mysql server is currently configured to use.

2) Verify hive works and you are able to access metadata.

3) If you are able to access metadata, go to ambari -> hosts -> select host hosting 2nd instance of mysql.

4) the services is probably stopped or in installed failed state. click on actions and look for delete option.

Re: Need help cleaning up after failed move of Hive mysql service

jwhitmore — Sat, 21 Jan 2017 00:57:01 GMT

Thank you, Pranay!