Upgrade from hdp2.4 to 2.5 is failing as hive schema upgrade is failing to get version table

[#1]

Im upgrading hdp from 2.4 to 2.5 and hive metastore is failing to upgrade as schematool is failing to upgrade. I'm using poatgres as metastore. The schematool upgrade is throwing error that version table doesn't exist or is empty. But my version table has data.

[#2]

Can you please share the error log

[#3 · Accepted solution]

This was due to poatgres DB not accepting connection. Made changes to DB conf and its resolved.