Cannot recover yet, some non-current nodes have LGE behind

@karthik : Please open a support case. since we need to review logs to perform the RCA.

Thanks Sruthi. Will submit one

@karthik
The message LGE is behind: 214191296 instead of 214199608, indicating there are some projections holding epoch 214191296 and
some projections holding epoch 214199608.
[1]
Run the below query to Identify impacted projections
SELECT e.node_name, t.table_schema, t.table_name, e.projection_schema, e.projection_name, checkpoint_epoch FROM projection_checkpoint_epochs e, projections p, tables t WHERE e.projection_id = p.projection_id and p.anchor_table_id = t.table_id and is_behind_ahm ;
[2]
Once you find the projections and decided to bring the DB up from higher epoch you need to run abortrecovery on those projection.
You can use the below query and that will create the abort command.
select 'select do_tm_task('||'''abortrecovery'''||','||''''||projection_schema||'.'|| projection_name ||''');' as command from (select distinct projection_schema, projection_name from v_catalog.projection_checkpoint_epochs
where checkpoint_epoch = ) as v1;

@Nimmi_gupta , Thanks. This helps.