projection_recoveries, what does error-fatal mean

Sam37

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

SruthiA

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.

Sam37

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