Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Endless projection recovery

Hi there,

I am experiencing an endless recovery on apparently all the projections that I do not really undestand because all the nodes are up and running , there are no entries at projection_recoveries either and I am able to query them seamlessly, I am solving it by recreating fresh new projections and removing the ones held in that recovery status.

Is there something else I should take care of ? There are no further errors shown in Nagios and we are running v6.1.0-0.


2013-12-18 16:17:55.023 DistCall Dispatch:0x7f5ba4a2cca0 [Catalog] <INFO> Checking for missed restore table events
2013-12-18 16:17:55.023 DistCall Dispatch:0x7f5ba4a2cca0 [Catalog] <INFO> Found no missed restore table events
2013-12-18 16:17:55.027 DistCall Dispatch:0x7f5ba4a2cca0 [Recover] <INFO> Get Local Node LGE: node current cpe is 8da8
2013-12-18 16:17:55.027 DistCall Dispatch:0x7f5ba4a2cca0 [Recover] <INFO> Get Local Node LGE: projection public.promotion_DBD_214_rep_dec9_dec9_node0008, CPE is 8da8
2013-12-18 16:17:55.027 DistCall Dispatch:0x7f5ba4a2cca0 [Recover] <INFO> Get Local Node LGE: projection public.imtype_DBD_213_rep_dec9_dec9_node0008, CPE is 8da8
2013-12-18 16:17:55.031 DistCall Dispatch:0x7f5ba4a2cca0 [Txn] <INFO> Rollback Txn: b0000000253933 'Manage Epochs: Advance AHM'


Thanks in advance,
A.A.


Leave a Comment

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.