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.



>Nothing interesting


select * from sessions;



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';


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?




  • Options

    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

  • Options
    Jim_KnicelyJim_Knicely - Select Field - 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.

  • Options


    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
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file