Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

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 Employee

    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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.