Vertica node recovery stuck
We have a 3 node cluster, out of which we had to restart one of the node to clear up some zombie sessions (it wouldn't go away with close_session).
After the restart, we see that the node is repeatedly getting stuck in RECOVERY phase for long time and eventually goes back to DOWN state.
While searching through vertica.log, we see below errors for multiple tables
2019-06-21 04:55:27.744 RecoverTable:7eff617f5700 @v_db_node0001: 01000/6772: Fail to recover table table-name due to error: Could not stop all dirty transactions[txnId = 49539595915837339; ]
Can someone please guide in how we can get this node to recover and get back in UP state?