5 Nov
2018
5 Nov
'18
5:57 p.m.
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(a)10.7.255.250-f3067022b00c564156251ba2f28f' for key
'active_watchers_idx' (1062)
How can I fix it?
Thank you!
Marcos.
6 Nov
6 Nov
11:42 a.m.
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(a)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(a)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(a)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
3:05 p.m.
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(a)gmail.com>
Enviado el: martes 6 de noviembre del 2018 05:42
Para: Kamailio (SER) - Users Mailing List <sr-users(a)lists.kamailio.org>rg>; Marcos
Pytel <marcos.pytel(a)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(a)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(a)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(a)lists.kamailio.org <mailto:sr-users@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>
2208
days inactive
2209
days old
2 comments
2 participants
participants (2)
-
Daniel-Constantin Mierla -
Marcos Pytel