We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


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

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

Mark_1Mark_1
in General Discussion
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 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
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...