How to manually make vertica to fail

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

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

Question:

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

Environment:
CAPC 2.6 through 3.1
Answer:

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!