Ambari admin stack versions hangs

[#1]

We recently upgraded HDP from 2.3 to 2.5 (1245) Ambari version 2.4.1.0.

Also today we tried install zeppelin, which failed.

Probably some data in database is now inconsistent

Ambari server log error is in attachment

[#2]

As @jaimin indicated, it is safe to cascade delete the offending record. At the end of the day, the repository_version_id values should be singular across the cluster_version and host_version tables. Since you will have two records with the same version string, the id-lookup is what matters.

[#3]

I found that there was problem in repo_version table, version column value should be "2.5.0.0-1245". I had only "2.5.0.0"

Beacuse of that all services failed start or restart, with this error:

ambari-python-wrap /usr/bin/conf-select set-conf-dir --package hadoop --stack-version 2.5.0.0 --conf-version 0' returned 1. 2.5.0.0 Incorrect stack version

I still don't know how this situation happend.

I updated version column to "2.5.0.0-1245" in database repo_version table