[SR-Users] Kamailio SQL error

[Daniel-Constantin Mierla]

Hello,

it looks like some SUBSCRIBE request was re-transmitted and not caught
(maybe re-sent too late) or it was reusing the call-id and from-tag.

One option to solve it is to delete the record from database table
active_watchers -- look for the record that has a call-id like:
6c23f96-0001-0003-0030 at 10.7.255.250

Cheers,
Daniel


On 05.11.18 15:57, Marcos Pytel wrote:
>
> Hello team!
>
>  
>
> Im using kamailio in sipwise!
>
>  
>
> I get this errors:
>
>  
>
> Nov  5 11:51:34 sipwise proxy[1943]: ERROR: <core> [db_query.c:235]:
> db_do_insert_cmd(): error while submitting query
>
> Nov  5 11:51:34 sipwise proxy[1943]: ERROR: presence
> [subscribe.c:2514]: update_db_subs_timer(): unsuccessful sql insert
>
> Nov  5 11:51:34 sipwise proxy[1943]: ERROR: db_mysql [km_dbase.c:127]:
> db_mysql_submit_query(): driver error on query: Duplicate entry
> '6c23f96-0001-0003-0030 at 10.7.255.250-f3067022b00c564156251ba2f28f' for
> key 'active_watchers_idx' (1062)
>
>  
>
> How can I fix it?
>
>  
>
> Thank you!
>
>
> Marcos.
>
>
>
> _______________________________________________
> Kamailio (SER) - Users Mailing List
> sr-users at lists.kamailio.org
> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users

-- 
Daniel-Constantin Mierla -- www.asipto.com
www.twitter.com/miconda -- www.linkedin.com/in/miconda
Kamailio World Conference -- www.kamailioworld.com
Kamailio Advanced Training, Nov 12-14, 2018, in Berlin -- www.asipto.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20181106/f92fe285/attachment.html>