Database is taking a long time to stop. Error: Notice 5940
I am trying to stop database, but it is showing the following errors.
Database onenode is taking a long time to stop.
Error: NOTICE 5940: LastGoodEpoch (631) is lagging the latest epoch (632). Shutting down now may lose data. Check vertica.log for details.Use Database Cluster State in Main Menu to continue to monitor stop progress, and/or check vertica process logs.
If you need to force a database shutdown, use the 'Stop Vertica on Host' command in the Advanced menu, selecting the appropriate nodes to stop.
What should I do in this situation?
Thank you.
Comments
There is a great blog post titled "Understanding Vertica Epochs" here:
https://my.vertica.com/kb/Understanding-Vertica-Epochs/Content/BestPractices/Understanding-Vertica-Epochs.htm
Go down to the "Troubleshooting Epoch Issues/Last Good Epoch Does Not Advance" section for recommendations!
Let us know if this helps or does not help