Skip to main content

audit_license_size -- running many times?

  • June 15, 2016
  • 4 replies
  • 26 views

ScubaDrew
Forum|alt.badge.img+1

Hello, 

 

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

 

 

4 replies

SruthiA
Forum|alt.badge.img+1
  • Participating Frequently
  • June 15, 2016

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


ScubaDrew
Forum|alt.badge.img+1
  • Author
  • Participating Frequently
  • June 15, 2016

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
Forum|alt.badge.img+1
  • Author
  • Participating Frequently
  • June 16, 2016

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

 

Something seems wrong.

 

Thanks again,

Drew


ScubaDrew
Forum|alt.badge.img+1
  • Author
  • Participating Frequently
  • June 23, 2016

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