The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
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?