[SR-Users] Siremis CDR problems

[Daniel-Constantin Mierla]

Hello,

On 10/4/11 12:57 PM, Klaus Darilion wrote:
> Very weird - if I call kamailio_cdrs() manually I often get errors 
> which are gone when I call kamailio_cdrs() again. Strange......
sql stored procedures are known to have AI and self-healing capabilities 
:-) ...

Well, I guess that the flag for unprocessed INVITEs is set to processed 
state (cdr_id!=0) even when inserting in cdrs table fails due to unique 
key collision, so a second call will not go again through those invites.

Maybe there is a way to find that the INSERT in cdrs fails, and if so, 
do not do UPDATE to acc.

Cheers,
Daniel

>
> regards
> klaus
>
> On 04.10.2011 12:33, Klaus Darilion wrote:
>> Hi! When populating cdrs table from timer route I get some errors:
>>
>> ERROR: db_mysql [km_dbase.c:120]: driver error on query: Duplicate entry
>> '088827BCD0738B6F at 111.11.111.11-00E0F510042319395872000014D3-6ADB' for
>> key 2
>> ERROR: <core> [db_query.c:130]: error while submitting query
>> ERROR: sqlops [sql_api.c:217]: cannot do the query
>>
>>
>> Checking the acc table for those key I found the entries in the 
>> attachment.
>>
>> Maybe it be that the stored procedure can not handle PRACK or reINVITEs
>> correctly?
>>
>> Thanks
>> Klaus
>>
>>
>> _______________________________________________
>> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
>> sr-users at lists.sip-router.org
>> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> sr-users at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

-- 
Daniel-Constantin Mierla -- http://www.asipto.com
Kamailio Advanced Training, Dec 5-8, Berlin: http://asipto.com/u/kat
http://linkedin.com/in/miconda -- http://twitter.com/miconda