you might need to analyze your tables one by one in ambari where it fetchs the HDF-3.0 info.
some useful tables are metainfo ,hostcomponentstate + some tables i mentioned in my previous comment
@Ilya Li looks like you have null reference in upgrade_history table.
Can you review the entries from below query and see if from_repo_version_id, target_repo_version_id are NULL.
select * from upgrade_history; //Look for zookeeper entry and correct that to valid repo version id.
After correcting that you would need to restart ambari server before attempting the upgrade again.
Hi @Ilya Li ,
Can you please have a look at this table
select * from repo_version; select * from stack;
I hope you will get some clue.
probably the stack_id of newly registered 3.1.2 will be pointing towards the wrong stack in stack table.
As Amar suggested I would suggest you downgrade the cluster
do the service checks on the zookeeper. change some configs in zookeeper and make sure it works. and then proceed with upgrade.
I made downgrade, service check on the zookeeper. Nothing helped. Which configs do I need to change in zookeeper?
Hi @Ilya Li,
Oh this commands everything seems to be ok.
Can you investigate further with this commands :
1) SELECT id, component_id, repo_version_id, state, user_name FROM ambari.servicecomponent_version; 2) select * from servicecomponentdesiredstate where service_name='ZOOKEEPER'; 3) select * from repo_version where repo_version_id in ( select desired_repo_version_id from servicecomponentdesiredstate where service_name='ZOOKEEPER'); 4) select * from repo_version where repo_version_id in ( select desired_repo_version_id from servicecomponentdesiredstate); 5) select * from servicecomponentdesiredstate where desired_repo_version_id not in ( select repo_version_id from repo_version);
If you happened to see two repo_versions in command 3 and 4 or get some output for command 5 ( which is empty in my env ) you can suspect that's the wrong entry in database and act accordingly.
Hope this helps.
In the end, I created the new cluster with HDF 3.2.0.
With NiFi Registry made it very fast.
Thanks to all which tried to help.