Creating View Error: Can't run historical queries at epochs prior to the Ancient History Mark
Hi - While creating a view one of our devs got the following error:
Error: ROLLBACK: Can't run historical queries at epochs prior to the Ancient History Mark
The view only touches 1 table - its a select of 2 columns with a where clause, its not trying to use epochs to view historical data. The DB is not configured to store historical data and the AHM is current. I can't recreate the error and neither can the user so it looks like a one-off but I'd like to understand how it came about?
Thanks, Mark
Error: ROLLBACK: Can't run historical queries at epochs prior to the Ancient History Mark
The view only touches 1 table - its a select of 2 columns with a where clause, its not trying to use epochs to view historical data. The DB is not configured to store historical data and the AHM is current. I can't recreate the error and neither can the user so it looks like a one-off but I'd like to understand how it came about?
Thanks, Mark
0
Comments
Although this post is quite old, But I faced this issue today. Vertica experts, do you have any comment on this pls?
It looks like an old bug which was fixed at version 9.3 via VER-68828.
Please open a support case if you are using a later version and encountering the same issue.
Okay. we are using 11.0.2-4
It looks like some projections are holding epochs. Could you please if there are any projections whose checkpoint_epoch < your_AHM_value?