Why did Vertica crash?

Vertica Analytic Database v7.1.2-0


Today the Vertica database shut down on its own.  The final entry in vertica.log is


2016-06-25 05:03:49.446 Init Session:0x7fa56c013360-a00000005913b6 [Txn] <INFO> Begin Txn: a00000005913b6 ' update transaction t set ...' 


(The sql update statement is long so I truncated it here for brevity)


How do I diagnose why it shut down?


  • Hi David,


    Check for traces in "/var/log/messages" file if this node went down due to OOM (Out of Memory) causing this abrupt shutdown.


    Also if nothing is found in the messages file please also check dblog (inside the catalog directory and see if something fishy reported out there (like for kernel crash).





Leave a Comment

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