Skip to main content

Creating View Error: Can't run historical queries at epochs prior to the Ancient History Mark

  • April 7, 2014
  • 4 replies
  • 8 views
Mark_1
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

    4 replies

    arunaiyadurai
    • arunaiyadurai
    • New Participant
    • May 24, 2023

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

    mosheg
    Forum|alt.badge.img+2
    • mosheg
    • Participating Frequently
    • May 24, 2023

    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.

    arunaiyadurai
    • arunaiyadurai
    • New Participant
    • May 25, 2023

    Okay. we are using 11.0.2-4

    SruthiA
    Forum|alt.badge.img+1
    • SruthiA
    • Participating Frequently
    • May 25, 2023

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

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement