search

asipto / siremis

Web Admin Interface for Kamailio
http://www.siremis.org
99 stars 47 forks source link

duplicate key issue #20

Closed dipenpatel235 closed 6 years ago

dipenpatel235 commented 7 years ago

hello... i am using acc and cdr for accounting.. but getting duplicate issue so cdr is skip and due to that accounting is miss.

Below error when execute PROCEDURE kamailio_cdrs.

ERROR 1062 (23000) at line 1: Duplicate entry '2-rNf2C1Tc-ejTp~gJOf-U1g5rrSDD696r' for key 'uk_cft'

Thanks.

miconda commented 7 years ago

There seem to be two cdrs having same call-id, from-tag and to-tag. Can you check that in the acc table and see if there are many INVITE records with those values matching?

dipenpatel235 commented 7 years ago

Yes. I have seen that. Many invite record entry are match. That's why duplicate key issue.

So I am not understand it is unique then why it is generate duplicate many invite ?

Thanks

On Sep 5, 2017 11:08 PM, "Daniel-Constantin Mierla" < notifications@github.com> wrote:

There seem to be two cdrs having same call-id, from-tag and to-tag. Can you check that in the acc table and see if there are many INVITE records with those values matching?

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/asipto/siremis/issues/20#issuecomment-327250240, or mute the thread https://github.com/notifications/unsubscribe-auth/AHwhuRfVWMUg_Bt6WpG22NnatmwidTbvks5sfYcjgaJpZM4PK0PU .

miconda commented 6 years ago

The acc table doesn't have a constraint on the call, from-tag and to-tag. Based on your config for kamailio, the call can get more than one record for the same INVITE. If you do so, you need to adjust the stored procedures to deal with such cases.

The siremis cdr generation relies on the fact that kamailio writes a single INVTE record for each call in acc table.