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


I get this error when I make the database backup SQL command "select database_snapshot('produccion_f — Vertica Forum

I get this error when I make the database backup SQL command "select database_snapshot('produccion_f

agutierrezcagutierrezc Community Edition User
in General Discussion

I al new in VERTICA DBA some one can help me

SQL command "select database_snapshot('produccion_full',false);" failed: ERROR 7804: LGE is lagging behind for 39617 seconds, it exceeds 3600 seconds threshold, LGE: 8972777, current epoch: 8986317

Answers

  • Vertica_CurtisVertica_Curtis Employee

    Your epoch is lagging. Epoch is a number which corresponds to a single commit. Every commit in Vertica is assigned a unique epoch #. Vertica uses epochs internally to track things like internal consistency, and snapshots are based on epoch values.

    Why your LGE (Last good Epoch) is lagging for so long is a different question, but can you try running:

    Select make_AHM_now() ;

    And then try your command again?

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 ...