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

Comments

  • 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 Administrator

    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
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file