How to manually make vertica to fail
search cancel

How to manually make vertica to fail


Article ID: 14830


Updated On:


CA Infrastructure Management CA Performance Management - Usage and Administration


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!