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 mailto: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 mailto: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 List sr-users@lists.kamailio.org mailto:sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users