[cisco-voip] CDR flat files not being deleted

[Ryan Ratliff]

CSCsd88223 is the bug that is viewable on CCO, though the workaround  
I disagree with.

It's fixed in 4.1(3)ES55 or later, which is after SR3a.

-Ryan

On Aug 1, 2006, at 9:08 AM, Ryan Ratliff wrote:

Most likely you are running into an issue with sql deadlock.

There are a couple bugs out there, CSCsd95330 being one of them.

Basically Aupair and the CIPT Optimize SQL job get into a deadlock on
the CDR database.  Aupair is trying to remove old records to bring
the number of CDR records down to the max (1.5 million by default)
and the CIPT Optimize job is doing it's thing.  This deadlock keeps
CDRInsert from inserting new records.

If you look in SQL Enterprise Manager under Management->SQL Server
Agent->Jobs the CIPT Optimizations job will still be running.  A
quick check of the history shows it normally only runs for a few
minutes.  Manually killing the pid in SQL for the job will recover
everything and once Aupair finishes it's thing CDRInsert will run
normally.

If you are at all unsure about doing this please open a TAC SR and
unicast me the SR number.

-Ryan

On Aug 1, 2006, at 9:01 AM, Ruben Montes ((EU)) wrote:

Hi,

I've tried to restart the CDRInsert and I've had this "nice" message:

No response to restart the server

I supoose it's time to open a TAC SR??

Regards,

Ruben


-----Mensaje original-----
De: Ryan Ratliff [mailto:rratliff at cisco.com]
Enviado el: mar 01/08/2006 14:37
Para: Ruben Montes (EU)
CC: cisco-voip at puck.nether.net
Asunto: Re: [cisco-voip] CDR flat files not being deleted

Is the CDRInsert service running on your publisher?  If so try
restarting it.  If it is slow to restart (or fails to stop at all)
then it could be that some database activity has blocked CDRInsert.

You can use the command sp_who2 to find out which sql pid has locked
the CDR database.   If you get to that point and need assistance
still please open a TAC SR.

-Ryan

On Aug 1, 2006, at 6:11 AM, Ruben Montes ((EU)) wrote:

Hi,

I'm having some trouble with CDR service. I've noticed that the last
three weeks I have an Eventviewer error every night telling that the
CDR files are being backed up and not deleted.
Nothing has been changed and this has never happened before. What
could have happened?
I have enabled detailed traces but traces/DBL/DCRinsert files are
empty (0Kb)

Thanks in advance,

Ruben
_______________________________________________
cisco-voip mailing list
cisco-voip at puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip




_______________________________________________
cisco-voip mailing list
cisco-voip at puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip