06-01-2004 12:34 AM - edited 03-13-2019 05:05 AM
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.
Solved! Go to Solution.
06-01-2004 08:28 AM
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
06-01-2004 08:53 AM
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
06-01-2004 06:39 AM
What is the version of CallManager are you running?
Thanks,
Radhika.
06-01-2004 08:28 AM
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
06-01-2004 08:53 AM
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
06-01-2004 04:43 PM
We did the exact same upgrade!
Thanks very much for your post - we will contact TAC.
Regards,
Erik
06-02-2004 04:51 PM
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!
06-02-2004 04:52 PM
sorry, forgot my email chris.charron@parrishmed.com
thank you!
06-02-2004 07:40 PM
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)
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide