LMS 2.6: Long-running ChangeAuditDefaultPurge job

[yjdabear]

I've been trying to find out why my LMS 2.6 backups are getting bigger by several hundred MBs a day again. I've known /var/adm/CSCOpx/files/rme/dcma/difffiles/ is the one doing the growing, but I finally find this is because the daily ChangeAuditDefaultPurge job kicked off at Feb. 25 at 2am has not finished running even to this moment. Is there any remedy to this situation? Is it safe to stop the job? /var/adm/CSCOpx/files/rme/jobs/cas/1393.log shows the Change Audit purge has not been running daily, as scheduled:

[ Tue Jan 22 02:00:05 EST 2008 ],INFO ,[main],com.cisco.nm.rmeng.util.db.Databa

seConnectionPool,getConnection,59,Inside ICSDatabaseConnection, MAX_COUNT =20

[ Tue Jan 22 02:00:08 EST 2008 ],INFO ,[main],Successfully deleted 279 ChangeAu

dit records

[ Sat Jan 26 02:00:05 EST 2008 ],INFO ,[main],Successfully deleted 21 Audit tra

il records

[ Sat Jan 26 02:00:07 EST 2008 ],INFO ,[main],com.cisco.nm.rmeng.util.db.Databa

seConnectionPool,getConnection,59,Inside ICSDatabaseConnection, MAX_COUNT =20

[ Sat Jan 26 02:00:20 EST 2008 ],INFO ,[main],Successfully deleted 1044 ChangeA

udit records

[ Sat Feb 23 02:00:04 EST 2008 ],INFO ,[main],Successfully deleted 190 Audit tr

ail records

[ Sat Feb 23 02:00:06 EST 2008 ],INFO ,[main],com.cisco.nm.rmeng.util.db.Databa

seConnectionPool,getConnection,59,Inside ICSDatabaseConnection, MAX_COUNT =20

[ Sat Feb 23 02:07:22 EST 2008 ],INFO ,[main],Successfully deleted 7420 ChangeA

udit records

[ Mon Feb 25 02:00:05 EST 2008 ],INFO ,[main],Successfully deleted 15 Audit tra

il records

[ Mon Feb 25 02:00:06 EST 2008 ],INFO ,[main],com.cisco.nm.rmeng.util.db.Databa

seConnectionPool,getConnection,59,Inside ICSDatabaseConnection, MAX_COUNT =20

[ Mon Feb 25 02:00:13 EST 2008 ],INFO ,[main],Successfully deleted 908 ChangeAu

dit records

I tried to stop the job (#1393) via the web GUI but got the response it "could not be stopped".

[Joe Clarke · Accepted solution]

This sounds like CSCsm03001. I have a patch available you can get by calling the TAC. To stop this job, you will need to restart dmgtd.

[yjdabear]

The patch works, but my dcma/difffiles directory is still adding hundreds of MBs a day. Take today's Change Audit purge for example (30-day retention for both change audit and audit trail records):

Job ID: 1393 Status: Succeeded

Job Summary

Change Audit Purge: Succeeded

Purge Change Audit Records older than : Feb 17 2008

Job Type: Change Audit Default Purge

Audit Trail Purge: Succeeded

Number of Audit Trail Records purged: 88

Purge Audit Trail Records older than : Feb 17 2008

Purge ended at : 2008-03-18 01:00:51

Purge started at : 2008-03-18 01:00:04

Number of Change Audit Records purged: 5127

Yet, I'm still finding diff files from as old as Dec 7, 2007.

/var/adm/CSCOpx/files/rme/dcma/difffiles/379/PRIMARY/RUNNING)->ls -al

total 2

drwxrwx--- 29 casuser casusers 1024 Mar 18 02:37 .

drwxrwx--- 3 casuser casusers 96 Dec 7 10:07 ..

drwxrwx--- 2 casuser casusers 96 Jan 18 08:23 2

drwxrwx--- 2 casuser casusers 96 Dec 7 10:07 25

drwxrwx--- 2 casuser casusers 96 Jan 25 02:01 33

drwxrwx--- 2 casuser casusers 96 Jan 25 02:01 34

drwxrwx--- 2 casuser casusers 96 Jan 31 01:58 35

drwxrwx--- 2 casuser casusers 96 Feb 2 01:56 36

drwxrwx--- 2 casuser casusers 96 Feb 2 01:56 37

drwxrwx--- 2 casuser casusers 96 Feb 3 01:46 38

drwxrwx--- 2 casuser casusers 96 Feb 7 02:34 39

drwxrwx--- 2 casuser casusers 96 Feb 7 02:34 40

drwxrwx--- 2 casuser casusers 96 Feb 7 02:34 41

drwxrwx--- 2 casuser casusers 96 Feb 8 02:00 42

drwxrwx--- 2 casuser casusers 96 Feb 14 01:50 43

drwxrwx--- 2 casuser casusers 96 Feb 21 01:51 44

drwxrwx--- 2 casuser casusers 96 Mar 6 01:56 45

drwxrwx--- 2 casuser casusers 96 Mar 7 01:54 46

drwxrwx--- 2 casuser casusers 96 Mar 7 01:54 47

drwxrwx--- 2 casuser casusers 96 Mar 7 01:54 48

drwxrwx--- 2 casuser casusers 96 Mar 8 02:00 49

drwxrwx--- 2 casuser casusers 96 Mar 8 02:00 50

drwxrwx--- 2 casuser casusers 96 Mar 13 01:55 51

drwxrwx--- 2 casuser casusers 96 Mar 13 01:55 52

drwxrwx--- 2 casuser casusers 96 Mar 14 01:50 53

drwxrwx--- 2 casuser casusers 96 Mar 14 01:51 54

drwxrwx--- 2 casuser casusers 96 Mar 14 01:51 55

drwxrwx--- 2 casuser casusers 96 Mar 15 02:03 56

drwxrwx--- 2 casuser casusers 96 Mar 18 02:37 57

[Joe Clarke · Accepted solution]

The difffiles are not purged automatically. You can manually delete them, however, as they are not referenced by anything. They will be recreated as needed.