4 Oct
2011
4 Oct
'11
8:58 p.m.
Hi Klaus,
On 10/4/11 12:33 PM, 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(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?
it is about the INVITEs, if you look at the stored procedure,
it loads
the unprocessed INVITEs and matches them against the BYE, writing a CDR
for each. Having re-INVITEs results in collisions of unique key.
I guess you want the CDR to be from initial INVITE to the BYE -- you
would need to adjust the stored procedure to select the first one. One
way is to store in a new column of acc table a flag saying whether is
the first INVITE or not (a re-INVITE) and adjust the stored procedure to
select only those INVITE records.
Cheers,
Daniel
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
--
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