We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Endless projection recovery — Vertica Forum

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