How to manually make vertica to fail

Document ID : KB000014830
Last Modified Date : 14/02/2018
Show Technical Document Details

It may be needed to check the database backup and restore if something goes wrong with vertica.


How to manually corrupt vertica database so that client can test if a restore is working good.

CAPC 2.6 through 3.1

Deleting data and catalog folder would almost always mean that a full/scratch recovery would occur. If you just want to see recovery work, there are easier ways - like deleting only some of the ROS containers in data folder or even a single .gt file in a container.

You also have a high chance of corrupting data on some nodes if you manually kill a node (simulate hardware/OS crash) while there is data loading in progress.

P.S. Making suggestions how to corrupt Vertica DB is contrary to what we usually advise, so please test on a TEST/QA DB that does not contain important data and always have a full backup handy!