If the AHM is not advancing, troubleshoot using this checklist:
|1||Check whether the Last Good Epoch (LGE) is advancing.
||If the LGE is advancing, go to Step 2.
If the LGE is not advancing, go to Step 5.
|2||Check whether all nodes are UP.
||If all the nodes are UP, go to Step 3.
If one or more node is DOWN, bring all the nodes UP.
|3||Check for unrefreshed projections.
||If one or more of your projections is out of date (IS_UP_TO_DATE is f), do one of the following tasks:
|4||Did the AHM advance? => SELECT GET_AHM_EPOCH();||If yes, this is the end of your checklist.
If no, start this checklist again to find an alternative path. If the AHM continues not to advance, contact Vertica Support.
|5||Check whether there is data in WOS.
If there is data in WOS, force a MOVEOUT.
|6||Check for a node where LGE is behind others.
||If one node’s LGE is older than another node’s LGE, go to Step 7.
If all the nodes have the same LGE, open a ticket with Vertica Technical Support.
|7||Check whether moveout is executing and move-out is not slow due to replay-deletes.
||If moveout is executing and the AHM advanced