Solved: CDR_log growing rapidly - need help!

erik.stillman · ‎06-01-2004

Hi,

Suddenly, the CDR transaction log is growing over 1GB every 24 hours. The log file is now 8GB even though the CDR database is 1.5 GB.

We've stopped the CDR insert service and the log file appears to have stopped growing. Does anyone know what's happening here?

Thanks!

Erik.

electro22 · ‎06-01-2004

Hi Erik -

Yup, had the same thing happen to me! Apparently its a bug. I was told its surfaces when you don't backup your CDR records...

Bug ID: CSCea55522

I would recomend opening a TAC case. If you do not have access to TAC, let me know and I will send you the procedure to shrink the file. However, I do not know of a permanent fix at this time.

-Jaret

View solution in original post

rnarayana · ‎06-01-2004

Yes I ran in to this bug this weekend .I had to upgrade callmanager from 3.2 to 3.3.3.I had the same problem.I heard this bug is fixed in Callmanager 3.3.4.Don't try to purge the CDR database using the CAR page.This will cause the disk space to decrease still.(CSCea55522).Let me know if you need the procedure to shrink the database.

Thanks,

Radhika

View solution in original post

rnarayana · ‎06-01-2004

What is the version of CallManager are you running?

Thanks,

Radhika.

electro22 · ‎06-01-2004

Hi Erik -

Yup, had the same thing happen to me! Apparently its a bug. I was told its surfaces when you don't backup your CDR records...

Bug ID: CSCea55522

I would recomend opening a TAC case. If you do not have access to TAC, let me know and I will send you the procedure to shrink the file. However, I do not know of a permanent fix at this time.

-Jaret

rnarayana · ‎06-01-2004

Yes I ran in to this bug this weekend .I had to upgrade callmanager from 3.2 to 3.3.3.I had the same problem.I heard this bug is fixed in Callmanager 3.3.4.Don't try to purge the CDR database using the CAR page.This will cause the disk space to decrease still.(CSCea55522).Let me know if you need the procedure to shrink the database.

Thanks,

Radhika

erik.stillman · ‎06-01-2004

We did the exact same upgrade!

Thanks very much for your post - we will contact TAC.

Regards,

Erik

ischarcm · ‎06-02-2004

I would like to have the procedure, I have had this happen to me before... im no sql expert, so the plainer the description the better...

I appreciate it!

ischarcm · ‎06-02-2004

sorry, forgot my email chris.charron@parrishmed.com

thank you!

lyanes · ‎06-02-2004

It sounds as if the CDR transaction log has a stuck. Do you have an ART db?

Here are the procedure for truncating the transaction log and shrinking the DB.

====CDR====

From SQL Query analizer select the CDR DB from the pulldown and execute the following

querys:

dump tran "cdr" with no_log

dbcc shrinkdatabase (cdr)

====ART====

From SQL Query analizer select the ART DB from the pulldown and execute the following

querys:

dump tran "art" with no_log

dbcc shrinkdatabase (art)