Options
We want to get current epoch and ahm_epoch value from the vertica.log on each node.
We want to get current epoch and ahm_epoch value from the vertica.log on each node.
Anyone, please advice me how to identify these value from vertica.log
0
Answers
The CE and AHM should be the same across the cluster unless a node is down.
You can find the AHM in the vertica.log file on each node with Linux commands... something like the following (I have 3 nodes, database name is test_db):
Note that the log file stores epochs in HEX. You can convert them to integer in Linux like this:
Similarly, you can find the Current Epoch in Vertica logs...
Hi,
Best method is to look for Epoch.log file which is located under your catalog directory:
catalog//v___catalog/Epoch.log
Sure!
But the Epoch.log file, which is used during recovery to indicate the latest epoch that contains a complete set of data, is only there when the DB or node was shut down cleanly. It's not there on an up DB or after a crash.
Examples:
DB shut down cleanly (Epoch.log created):
Node shut down cleanly, after restarting the DB (Epoch.log created):
DB node killed, after restarting node from previous example (Epoch.log NOT created):
Hello Jim,
thanks for the clarification. In our case, most of the time, we find this file in our system so it is easy for us to use it.