[Spce-user] Database Question (CDRs) v2.6
Kevin Masse
kmasse at questblue.com
Thu Apr 4 09:15:43 EDT 2013
Hello, I would like to see if there are any other users that have seen
duplicate call records in the CDRs (accounting.cdr)
We are attempting to pull the CDRs based on ID and we are seeing
duplicated data in the report. At first we thought it could have
something to do with our query but when I login to MySQL on Sipwise I
see the duplicates are there so the data we are pulling is valid.
224836
#########
1#########
ok
200
4/3/2013 8:59
4/3/2013 8:59
1254.35
224837
#########
1#########
ok
200
4/3/2013 8:59
4/3/2013 8:59
1254.35
224838
#########
1#########
ok
200
4/3/2013 8:59
4/3/2013 8:59
1254.35
The above information is coming from our report externally but I used
the query below to verify the records match:
mysql> select * from cdr where source_account_id=115 or
destination_account_id=115 \G
As I thought, the records we are pulling are accurate but the client did
have 3 calls at the very same time for the exact amount of seconds in
reality. Additionally, there are numerous duplications on the clients
CDR's but not all of them.
*************************** 56. row ***************************
id: 224836
update_time: 2013-04-03 09:20:17
source_user_id: daf5bfbe-731f-4f0c-b490-598b45bac427
source_provider_id: 1
source_external_subscriber_id:
source_external_contract_id:
source_account_id: 115
source_user: ##########
source_domain: ##.##.##.##
source_cli: ##########
source_clir: 0
source_ip: ##.##.##.##
destination_user_id: 0
destination_provider_id: 3
destination_external_subscriber_id:
destination_external_contract_id:
destination_account_id: 0
destination_user: 1##########
destination_domain: ##.##.##.##
destination_user_dialed: 1##########
destination_user_in: 1##########
destination_domain_in: ##.##.##.##
peer_auth_user:
peer_auth_realm:
call_type: call
call_status: ok
call_code: 200
init_time: 1364993954.737
start_time: 1364993958.260
duration: 1254.350
call_id:
098f8fb12a0313c11f2d940c37f0cd14@##.##.##.##:5060
carrier_cost: 0.00
reseller_cost: 0.00
customer_cost: 0.00
carrier_free_time: NULL
reseller_free_time: NULL
customer_free_time: NULL
carrier_billing_fee_id: NULL
reseller_billing_fee_id: NULL
customer_billing_fee_id: NULL
carrier_billing_zone_id: NULL
reseller_billing_zone_id: NULL
customer_billing_zone_id: NULL
frag_carrier_onpeak: NULL
frag_reseller_onpeak: NULL
frag_customer_onpeak: NULL
is_fragmented: NULL
split: 0
rated_at: NULL
rating_status: unrated
exported_at: NULL
export_status: unexported
*************************** 57. row ***************************
id: 224837
update_time: 2013-04-03 09:20:17
source_user_id: daf5bfbe-731f-4f0c-b490-598b45bac427
source_provider_id: 1
source_external_subscriber_id:
source_external_contract_id:
source_account_id: 115
source_user: ##########
source_domain: ##.##.##.##
source_cli: ##.##.##.##
source_clir: 0
source_ip: ##.##.##.##
destination_user_id: 0
destination_provider_id: 3
destination_external_subscriber_id:
destination_external_contract_id:
destination_account_id: 0
destination_user: 1##########
destination_domain: ##.##.##.##
destination_user_dialed: 1##########
destination_user_in: 1##########
destination_domain_in: ##.##.##.##
peer_auth_user:
peer_auth_realm:
call_type: call
call_status: ok
call_code: 200
init_time: 1364993954.737
start_time: 1364993958.260
duration: 1254.350
call_id:
098f8fb12a0313c11f2d940c37f0cd14@##.##.##.##:5060
carrier_cost: 0.00
reseller_cost: 0.00
customer_cost: 0.00
carrier_free_time: NULL
reseller_free_time: NULL
customer_free_time: NULL
carrier_billing_fee_id: NULL
reseller_billing_fee_id: NULL
customer_billing_fee_id: NULL
carrier_billing_zone_id: NULL
reseller_billing_zone_id: NULL
customer_billing_zone_id: NULL
frag_carrier_onpeak: NULL
frag_reseller_onpeak: NULL
frag_customer_onpeak: NULL
is_fragmented: NULL
split: 0
rated_at: NULL
rating_status: unrated
exported_at: NULL
export_status: unexported
*************************** 58. row ***************************
id: 224838
update_time: 2013-04-03 09:20:17
source_user_id: daf5bfbe-731f-4f0c-b490-598b45bac427
source_provider_id: 1
source_external_subscriber_id:
source_external_contract_id:
source_account_id: 115
source_user: ##########
source_domain: ##.##.##.##
source_cli: ##########
source_clir: 0
source_ip: ##.##.##.##
destination_user_id: 0
destination_provider_id: 3
destination_external_subscriber_id:
destination_external_contract_id:
destination_account_id: 0
destination_user: 1##########
destination_domain: ##.##.##.##
destination_user_dialed: 1##########
destination_user_in: 1##########
destination_domain_in: ##.##.##.##
peer_auth_user:
peer_auth_realm:
call_type: call
call_status: ok
call_code: 200
init_time: 1364993954.737
start_time: 1364993958.260
duration: 1254.350
call_id:
098f8fb12a0313c11f2d940c37f0cd14@##.##.##.##:5060
carrier_cost: 0.00
reseller_cost: 0.00
customer_cost: 0.00
carrier_free_time: NULL
reseller_free_time: NULL
customer_free_time: NULL
carrier_billing_fee_id: NULL
reseller_billing_fee_id: NULL
customer_billing_fee_id: NULL
carrier_billing_zone_id: NULL
reseller_billing_zone_id: NULL
customer_billing_zone_id: NULL
frag_carrier_onpeak: NULL
frag_reseller_onpeak: NULL
frag_customer_onpeak: NULL
is_fragmented: NULL
split: 0
rated_at: NULL
rating_status: unrated
exported_at: NULL
export_status: unexported
What could cause the data for the call to duplicate?
Thank you
Kevin
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/mailman/private/spce-user_lists.sipwise.com/attachments/20130404/0f3f63f2/attachment.html>
More information about the Spce-user
mailing list