Skip to main content

Why did Vertica crash?

  • June 25, 2016
  • 1 reply
  • 8 views

David_P_1
Forum|alt.badge.img+2

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?

1 reply

Rahul_Choudhary
Forum|alt.badge.img
  • Participating Frequently
  • June 27, 2016

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).

 

 

Thanks

Rahul