projection_recoveries, what does error-fatal mean

hi 

 

We just had one of the node recovered in Dev after it took a very long time. During this, looking at projection_recoveries, it showed error-fatal count to be 20976, 

 

select status, count(*) from projection_recoveries group by 1;

 

ignored | 98736

finished|3434

error-fatal|20976

 

I did not see any proper documentation on what these status mean for, if this is something we need to worry about. I thought this was an issue, but the node is finally UP :-/

 

Thanks

Comments

  • SruthiASruthiA Vertica Employee Administrator

    It means thar projection recovery has failed. "fatal" can be misleading. During recovery the node rejects new connection requests as it's not ready to process data, and these rejections are posted in the vertica.log as FATAL (see below).
    FATAL 4149: Node startup/recovery in progress. Not yet ready to accept connections.

  • Thanks Sruthi for your response. I thought projection recovery might have failed, but the node finally became UP and is working fine. I don't see any critical nodes.

     

    How should I verify if the projections have any issues after the recovery?

     

    thanks

Leave a Comment

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