I’m running Asterisk 126.96.36.199 from Fedora 12 and I saw a starnge things: a few call have billsec greater than duration.
cdb=# select count(*) from cdr;
cdb=# select count(*) from cdr where billsec > duration;
minimum is duration=5sec,billsec=8sec
maximum is duration=5sec,billsec=298sec
a part of this calls is local to ouside calls, another part is outside to local. All calls SIP to SIP via ethernet. Very simple dialplan.
Post the raw cdr data for these call, at the moment you have posted no details that will help explain it.
Post the raw cdr data for these call, at the moment you have posted no details that will help explain it.[/quote]
This is all data about strange call:
acctid | 612649
calldate | 2011-02-11 10:27:15+02
clid | 5551
src | 5551
dst | XXXXXXXXXX
dcontext | out2siptrunk
channel | SIP/5551-0000015e
dstchannel | SIP/out2siptrunk-0000015f
lastapp | Dial
lastdata | SIP/XXXXXXXXXX@out2siptrunk,60
duration | 5
billsec | 45
disposition | ANSWERED
amaflags | 3
uniqueid | 1297412835.350
Nope thats from the DB by the looks of it , I mean teh raw CDR file data.
CDRs are known not to handle complex cases well. If you want to do that, you need to use version 1.8 and call event logging.