03-17-2014 06:01 AM - edited 03-10-2019 09:32 PM
Since the Migration to ACS 5.5.0.46 we keep seeing the following message in the alarm inbox
Cisco Secure ACS Alarm (CRITICAL): Physical size of ACS db is more than 50% of its Actual Size.
Cisco Secure ACS - Alarm Notification | |
Severity: Critical |
Alarm Name | System Alarm [Database Purging] |
Cause/Trigger | Physical size of ACS db is more than 50% of its Actual Size. |
Alarm Details | Physical size of ACS db is more than 50% of its Actual Size.The size will be reduced after purge ACS transaction log and compress ACS db. |
Generated On | Mon Mar 17 05:00:06 CET 2014 |
ACS View Database Compression and Backup is configured and runs without error:
The Backup Job stores a maximum of 4 Months to a FTP Server.
Fullbackup: Monthly
Incremental: Weekly
DB: Compression activated
Name | Start Time | End Time | Status |
---|
DatabasePurge-Job | Mon Mar 17 04:00:00 CET 2014 | Mon Mar 17 04:00:00 CET 2014 |
as far as I can see from the CLI there should be an oversized DB:
ACS21/acsadmin(config-acs)# acsview show-dbsize
Actual DB Size (bytes) : 1585192960
Actual DB Size (GBs) :1.48
Physical DB Size (bytes):1605386240
Physical DB Size (GBs) :1.5
Physical ACSviewlog file Size (GBs) :0
ACS21/acsadmin(config-acs)# exit
ACS21/admin# show application status acs
ACS role: PRIMARY
Process 'database' running
Process 'management' running
Process 'runtime' running
Process 'adclient' running
Process 'ntpd' running
Process 'view-database' running
Process 'view-jobmanager' running
Process 'view-alertmanager' running
Process 'view-collector' running
Process 'view-logprocessor' running
Looking at the User guide:
"The ACS Database needs to be compressed as a part of maintenance operation. You can run the acsview-db-compress command from acs-config mode to reduce the physical size of the view database when there is a difference between the physical size and actual size of the view database. ACS 5.5 stops only the log collector services during compress operation and will be up and running after the compress operation is completed. You need to enable the log recovery feature to recover the log messages that are received during the database compress operation.
In ACS 5.5, database compress operation is automated. You can check the Enable ACS View Database Compress check box to compress the ACS View database automatically every day at 5 A.M. The database compress operation is run everyday automatically at 5 A.M whenever there is a need."
I already tried to manually compress the DB via "acsview-db-compress" without any effect.
03-17-2014 03:08 PM
Duplicate posts.
Go here: http://supportforums.cisco.com/discussion/12143331/physical-size-acs-db-more-50-its-actual-size-acs-version-55046
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide