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


audit_license_size -- running many times? — Vertica Forum

audit_license_size -- running many times?

Hello, 

 

I am wondering if it is normal to see many running select audit_license_size(); queries like the attached image shows.

 

 

Comments

  • SruthiASruthiA Administrator

    Yes. it is normal. Increase in data/ creating new projections will trigger audit_license_size query

  • Thanks for the quick reply.

     

    I just did a copycluster and am seeing many of these:

     

    Completed Queries: 202  as of 6 hrs ago. --- only 6 queries out of the 202 are something other than audit_license_size()

     

    Thanks again,

    Drew

     

  • Would you really expect Completed Queries: 916 of these in < 12 hours?

     

    Something seems wrong.

     

    Thanks again,

    Drew

  • If anyone else runs into this, it was fixed in a hotfix:

     

    VER-39069UI - Management ConsoleManagement Console previously performed continuous license audits, which could negatively affect performance of other queries. This issue has been resolved.

     

    https://my.vertica.com/docs/ReleaseNotes/7.1.x/HP_Vertica_7.1.x_Release_Notes.htm

Leave a Comment

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