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


  • arunaiyaduraiarunaiyadurai Vertica Customer

    Although this post is quite old, But I faced this issue today. Vertica experts, do you have any comment on this pls?

  • moshegmosheg Vertica Employee Administrator

    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.

  • arunaiyaduraiarunaiyadurai Vertica Customer

    Okay. we are using 11.0.2-4

  • SruthiASruthiA Vertica Employee Employee

    It looks like some projections are holding epochs. Could you please if there are any projections whose checkpoint_epoch < your_AHM_value?

Leave a Comment

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