Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Community 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 not 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 ACCEPTED SOLUTION

Accepted Solutions

Hello,You're running into bug

Hello,

You're running into bug CSCum51180. The alarm should be a warning, not critical, and should be raised only when the physical size exceeds the actual size by more than a gigabyte (in your case, the difference is very small, 1.5 vs. 1.48).

The fix should be present on a future patch.

Javier Henderson

Cisco Systems

1 REPLY

Hello,You're running into bug

Hello,

You're running into bug CSCum51180. The alarm should be a warning, not critical, and should be raised only when the physical size exceeds the actual size by more than a gigabyte (in your case, the difference is very small, 1.5 vs. 1.48).

The fix should be present on a future patch.

Javier Henderson

Cisco Systems

1435
Views
0
Helpful
1
Replies
CreatePlease to create content