Thank you Daniel!
I tried it, but didn’t work. The entries have reappeared again and the error persist ☹
Maybe the problem is the remote equipment that have all of those subscribers?
Thank you again.
De: Daniel-Constantin Mierla <miconda@gmail.com>
Enviado el: martes 6 de noviembre del 2018 05:42
Para: Kamailio (SER) - Users Mailing List <sr-users@lists.kamailio.org>; Marcos Pytel <marcos.pytel@cotesma.com.ar>
Asunto: Re: [SR-Users] Kamailio SQL error
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@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@10.7.255.250-f3067022b00c564156251ba2f28f' for key 'active_watchers_idx' (1062)
How can I fix it?
Thank you!
Marcos.
_______________________________________________Kamailio (SER) - Users Mailing Listsr-users@lists.kamailio.orghttps://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