Options

audit_license_size -- running many times?

ScubaDrewScubaDrew
in General Discussion

Hello, 

 

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

 

 

Comments

  • Options
    SruthiASruthiA Vertica Employee Administrator

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

  • Options
    ScubaDrewScubaDrew

    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

     

  • Options
    ScubaDrewScubaDrew

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

     

    Something seems wrong.

     

    Thanks again,

    Drew

  • Options
    ScubaDrewScubaDrew

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