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

Vertica super slow, problem with license audit?

Vertica 7.1.2 on CentOS 6.7

 

Database starting running very slow, so using adminTools I restarted it.

 

After restart it is still running very slow, and top is at 18.

 

vertica.log

>Nothing interesting

 

select * from sessions;

>Nothing'

 

select * from v_internal.vs_sessions;

 >License Audit    user dbadmin (executing audit)    9/21/2016 1:22:44 PM 

 

select * from system_sessions where is_active='t';

 

session_typedescriptionsession_start_timestamp
LICENSE_AUDITTxn: a00000007962aa 'get the license'9/21/2016 11:58:13 AM
LICENSE_AUDITTxn: a00000007962ab 'figure out object oids'9/21/2016 11:58:13 AM
LICENSE_AUDITTxn: a00000007962ac 'executing audit'9/21/2016 11:58:13 AM
SHUTDOWNTxn: fff00000000005c0 'prepareShutdown'9/21/2016 12:50:26 PM
LICENSE_AUDITTxn: a00000007963e0 'get the license'9/21/2016 1:22:44 PM
LICENSE_AUDITTxn: a00000007963e1 'figure out object oids'9/21/2016 1:22:44 PM
LICENSE_AUDITTxn: a00000007963e2 'executing audit'9/21/2016 1:22:44 PM

 

The time is now 3:25pm, so it seems something is wrong with the license audit process.  Its a small database, just around 150gig data.  Also it looks like there is shutdown process still running.  Any ideas?

 

 

Comments

  • Hi David,

    Can i ask what did you do for this problem? Were you able to solve it?We're having the same issue with LICENSE_AUDIT taking long time to complete

  • Jim_KnicelyJim_Knicely Administrator

    Do you have MC installed? There was a hotfix for MC: 7.2.0 (10/21/2015) UI - Management Console - Management Console previously performed continuous license audits, which could negatively affect performance of other queries. This issue has been resolved.

  • Hi,

    We're not using MC , it's jus whenever internal audit_license kicks off , we're experiencing serious performance degradation , the only thing we could is changing it's starting time from midnight to evening when database activity is least but still we can see the impact of it as our data load starts lagging. I tried to change it's confidence level and error tolerance parameters but it looks like vertica does not care about these parameters so i cannot relax how license_audit running , it's still running with these parameters as 95 and 5.

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.