Physical size of ACS db is more than 50% of its Actual Size. (ACS Version : 18.104.22.168)
Since the Migration to ACS 22.214.171.124 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
System Alarm [Database Purging]
Physical size of ACS db is more than 50% of its Actual Size.
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.
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.
DB: Compression activated
Purge and Incremental Backup History
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
"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.
Table of ContentsIntroductionVersion HistoryPossible Future
UpdatesDocuments PurposeNAT Operation in ASA 8.3+ SectionsRule Types
Network Object NATTwice NAT / Manual NATRule Types used per SectionNAT
Types used with Twice NAT / Manual NAT and Network Obje...
Table of Contents Introduction:This document describes details on how
NAT-T works. Background: ESP encrypts all critical information,
encapsulating the entire inner TCP/UDP datagram within an ESP header.
ESP is an IP protocol in the same sense that TCP an...