4 Oct
2011
4 Oct
'11
9:02 p.m.
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:
--
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
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(a)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(a)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(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users