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?
