-
Title
Authentication performance has degraded and the vas_misc.vdb is very large. -
Description
Authentication can slow down or fail as the vas_misc.vdb grows too large. Sizes of over 1 gig can lead to problems.
-
Cause
In older versions of VAS, around 3.3.x, duplicate entries were increasing the directory_monitor table causing the vas_misc.vdb to grow in size, causing slow downs and eventually time outs.
The results of this query should be only a few entries, when this problem occurs there will be a very significant number of duplicates.
/opt/quest/libexec/vas/sqlite3 /var/opt/quest/vas/vasd/vas_misc.vdb "SELECT * FROM directory_monitor" -
Resolution
Ensure you are using a newer version of VAS, Preferably 3.5.2 and up. A new entry was made in the database to keep duplicates from occuring.
Run the following command.
/opt/quest/libexec/vas/sqlite3 /var/opt/quest/vas/vasd/vas_misc.vdb ".schema directory_monitor"Affected databases will not have this in the results 'CREATE UNIQUE INDEX'.
-
Additional Information
Machines that have been upgraded to a newer version may not have the 'CREATE UNIQUE INDEX' since the upgrade process does not recreate the database. You will need to perform a full flush.
ftp://ftp.vintela.com/vas/support/vas_full_flush.sh.gz
Note: This script will completely rewrite the database. If you are unsure if this should be run please contact Quest Technical Support.
This does not work with QAS 4.0 and above. It was written for a very specific use case and due to changes in caching in 4.0 it should no longer be needed. If there are caching issues a support case should be opened to investigate.