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_type | description | session_start_timestamp |
| LICENSE_AUDIT | Txn: a00000007962aa 'get the license' | 9/21/2016 11:58:13 AM |
| LICENSE_AUDIT | Txn: a00000007962ab 'figure out object oids' | 9/21/2016 11:58:13 AM |
| LICENSE_AUDIT | Txn: a00000007962ac 'executing audit' | 9/21/2016 11:58:13 AM |
| SHUTDOWN | Txn: fff00000000005c0 'prepareShutdown' | 9/21/2016 12:50:26 PM |
| LICENSE_AUDIT | Txn: a00000007963e0 'get the license' | 9/21/2016 1:22:44 PM |
| LICENSE_AUDIT | Txn: a00000007963e1 'figure out object oids' | 9/21/2016 1:22:44 PM |
| LICENSE_AUDIT | Txn: 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?
0
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
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.