While billsec greater than duration?

Asterisk Asterisk Support
1

Hello!

I’m running Asterisk 1.6.1.18 from Fedora 12 and I saw a starnge things: a few call have billsec greater than duration.

cdb=# select count(*) from cdr;
count

607800
(1 row)

cdb=# select count(*) from cdr where billsec > duration;
count

264
(1 row)

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.

???

2

Hi

Post the raw cdr data for these call, at the moment you have posted no details that will help explain it.

3

[quote=“ianplain”]Hi

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
accountcode |
uniqueid | 1297412835.350
userfield |

4

Hi

Nope thats from the DB by the looks of it , I mean teh raw CDR file data.

/var/log/asterisk/cdr-csv/Master.csv

Ian

5

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.