Skip to main content

Vertica database corruption

  • March 7, 2014
  • 1 reply
  • 6 views

Sai_Pasupulati
what is the best way to find vertica.log file for database corruption

1 reply

Forum|alt.badge.img+2
  • Participating Frequently
  • March 7, 2014
Hi Sai,

Vertica has a built in data integrity checker called the CRC (cyclic redundancy check). You can read more about this here in the doc:

https://my.vertica.com/docs/7.0.x/HTML/index.htm#Authoring/AdministratorsGuide/OperatingTheDatabase/...

If the CRC finds an issue, it will print out a message similar to what is outlined in the doc link below in the vertica.log file:

https://my.vertica.com/docs/7.0.x/HTML/index.htm#Authoring/AdministratorsGuide/OperatingTheDatabase/...

Let me know if you have any additional questions.

- Mitch