[Spce-user] Database Question (CDRs) v2.6
Aníbal Cañada
anibal at hercom.es
Thu Apr 4 09:40:26 EDT 2013
Hi,
We had this issue with a virtualized Sipwise.
I have a script for clean the database but was a dirty and temporal solution.
The unique solution we found was install in bare metal machine.
We installing Sipwise in a Dell r420 and all the problems had gone.
Sorry for my bad english , i am writting from my phone.
Anibal cañada
El 04/04/2013, a las 15:15, "Kevin Masse" <kmasse at questblue.com> escribió:
> 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
>
>
> _______________________________________________
> Spce-user mailing list
> Spce-user at lists.sipwise.com
> http://lists.sipwise.com/listinfo/spce-user
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20130404/220557a8/attachment-0001.html>
More information about the Spce-user
mailing list