audit_license_size -- running many times?

ScubaDrew

Hello, 

 

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

 

 

SruthiA

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

ScubaDrew

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

 

ScubaDrew

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

 

Something seems wrong.

 

Thanks again,

Drew

ScubaDrew

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

 

VER-39069

UI - Management Console

Management 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