The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Data consistency at cluster failure


What happens with data in a k-safe cluster (k=1) when a transaction is complete but the data is still in the WOS and not yet in the ROS,  and the entire cluster shuts down ungracefully (not just 1 node). Say due to power outage.

Will all data in previously only in WOS be lost?

Thank you,


  • Well when that happens you will lose all that data if the transaction was not commited(written to disk). If one node would go down the data could be recoverd from the other nodes. So if the moveout doesn't happen before the crush data will be lost. To manage this you need to make sure in case of large loads to use DIRECT so data goes to ROS and no data is lost when the instance crash. To monitor this you need to keep your eyes on the stale checkpoint events and make sure LGE is not behind one any of your nodes.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file