[SR-Users] Kamailio SQL error

[Marcos Pytel]

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 at gmail.com> 
Enviado el: martes 6 de noviembre del 2018 05:42
Para: Kamailio (SER) - Users Mailing List <sr-users at lists.kamailio.org>; Marcos Pytel <marcos.pytel at 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 at 10.7.255.250 <mailto: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 <mailto: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 <mailto:sr-users at lists.kamailio.org> 
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users





-- 
Daniel-Constantin Mierla -- www.asipto.com <http://www.asipto.com> 
www.twitter.com/miconda <http://www.twitter.com/miconda>  -- www.linkedin.com/in/miconda <http://www.linkedin.com/in/miconda> 
Kamailio World Conference -- www.kamailioworld.com <http://www.kamailioworld.com> 
Kamailio Advanced Training, Nov 12-14, 2018, in Berlin -- www.asipto.com <http://www.asipto.com> 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20181106/8fae0250/attachment.html>