Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. If you'd prefer to explore, try our test area to get started. And see here for current known issues.

New Member

Physical size of ACS db is more than 50% of its Actual Size. (ACS Version : 5.5.0.46)

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

 

Purge and Incremental Backup History  
NameStart TimeEnd TimeStatus
DatabasePurge-JobMon Mar 17 04:00:00 CET 2014Mon 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:

http://www.cisco.com/c/en/us/td/docs/net_mgmt/cisco_secure_access_control_system/5-5/user/guide/acsuserguide/viewer_sys_ops.html#wp1065174

"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. 

 

 

 

Everyone's tags (1)
1 REPLY
Hall of Fame Super Gold

Duplicate posts.   Go here:

Duplicate posts.  

 

Go here:  http://supportforums.cisco.com/discussion/12143331/physical-size-acs-db-more-50-its-actual-size-acs-version-55046

49
Views
0
Helpful
1
Replies