Environment
Vertica Analytics Platform 12.0.4
Situation
One node went down in 7 node cluster and recovery keeps failing.
Resolution
Recovery was failing because of old stale sessions referring to dirty transactions. Once the database was restarted to clean up stale sessions, node recovered successfully.