Why did Vertica crash?

David_P_1David_P_1
in General Discussion

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?

Comments

  • Rahul_ChoudharyRahul_Choudhary

    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

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...