[Spce-user] Error rating CDR batch - after upgrade

[Andrew Pogrebennyk]

Skyler, this means you need to fix the accounting record by inserting
"call" into the blank space, e.g.:

update acc set
src_leg='1ceb0639-329d-412a-828f-4ca1f1147c19|14574176498|sip.mydomain.com|14574176498||1605|3|||0|call|1335300610.209136'
where id=129;

Make sure to not copy it from email, as it may split src_leg to multiple
lines. Do the same for second acc record and after that restart the
mediator. Or just drop them if you don't need the CDR :-)

I'm pretty sure the broken accounting comes from click2dial, can tell
for sure if you have the proxy.log for this callid.

The fixes for click2dial case are available in 2.5 sipwise repository
(make sure to apply the new templates).

Normally this mysql select should produce zero rows.

On 04/25/2012 05:22 PM, Skyler wrote:
>     Could you show me
>     select * from acc where src_leg like "%||133%"\G
>     ?
> 
> 
> 
> mysql> select * from acc where src_leg like "%||133%"\G;
> *************************** 1. row ***************************
>         id: 129
>     method: INVITE
>   from_tag: 5F808EAC-4F9712020003249B-15116700
>     to_tag: 18AED02F-4F971202000333DD-13C01700
>     callid: 700B2758-4F971202000324A4-15116700
>   sip_code: 200
> sip_reason: OK
>       time: 2012-04-24 13:50:14
> time_hires: 1335300614.920
>    src_leg:
> 1ceb0639-329d-412a-828f-4ca1f1147c19|14574176498|sip.mydomain.com
> <http://sip.mydomain.com>|14574176498||1605|3|||0||1335300610.209136
>    dst_leg:
> |1605|3|14574176498|1ceb0639-329d-412a-828f-4ca1f1147c19|14574176498|sip.mydomain.com
> <http://sip.mydomain.com>|14574176498|sip.mydomain.com
> <http://sip.mydomain.com>
>   dst_user: 14574176498
>  dst_ouser: +13564176492
> dst_domain: 25.116.109.202
>   src_user: 
> src_domain: sip.mydomain.com <http://sip.mydomain.com>
> *************************** 2. row ***************************
>         id: 130
>     method: INVITE
>   from_tag: 753CF869-4F9712080004EA9E-14A0F700
>     to_tag: 
>     callid: 66E2CDF9-4F9712080004EAA1-14A0F700
>   sip_code: 404
> sip_reason: 
>       time: 2012-04-24 13:50:16
> time_hires: 1335300616.320
>    src_leg:
> 1ceb0639-329d-412a-828f-4ca1f1147c19|16044173292|sip.mydomain.com
> <http://sip.mydomain.com>|14574176498||1605|3|||0||1335300616.324150
>    dst_leg: ||0|+13564176492|0|+13564176492|sip.mydomain.com
> <http://sip.mydomain.com>|+13564176492|sip.mydomain.com
> <http://sip.mydomain.com>
>   dst_user: +13564176492
>  dst_ouser: +13564176492
> dst_domain: sip.mydomain.com <http://sip.mydomain.com>
>   src_user: 
> src_domain: sip.mydomain.com <http://sip.mydomain.com>
> 2 rows in set (0.00 sec)