On 8/20/10 1:24 PM, A J Stiles wrote: > On Wednesday 11 Aug 2010, Tilghman Lesher wrote: >> On Wednesday 11 August 2010 03:59:28 A J Stiles wrote: >>> I'm having a problem with Asterisk 1.6.2.9 with the MySQL cdr addon. >>> >>> With some calls, the value in the `billsec` field in the CDR is exceeding >>> the value in the `duration` field. >> I'd love to know what circumstance caused that. I agree that this should >> not occur. > I've done some more digging about. I was getting calls in the monitor folder > where the outgoing and incoming halves were different lengths; so I > temporarily disabled removing them after combining them into a single file, > and let them build up for a few days. > > There doesn't seem to be any correlation between this phenomenon and > billsec being> duration, though. > > Can anyone else with a similar setup try running a query such as > SELECT COUNT(*) FROM cdr WHERE calldate LIKE "2010-08-20%" AND > billsec>duration ; > and seeing if they have any calls like this? > Any chance this has something to do with your system time? Are you running ntpd, or setting time at regular intervals via a central system clock and a cron job? Again... also just stabbing in the dark.
N. -- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users