Hello
I'm getting these errors using Kamailio 1.5.1:
Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:core:db_do_update: error while submitting query Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:presence:update_db_subs: updating in database Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:core:db_do_query: error while submitting query Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:presence:msg_watchers_clean: querying database for expired messages Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:core:db_do_query: error while submitting query Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:presence:msg_presentity_clean: querying database for expired messages
I haven't seen anything similar in the issue tracker ? Is it a new bug ? How can I track it down ?
Regards, Pascal
Can you paste you DB settings?
On Thu, Jun 4, 2009 at 10:49 AM, Pascal Maugeri pascal.maugeri@gmail.com wrote:
Hello
I'm getting these errors using Kamailio 1.5.1:
Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:core:db_do_update: error while submitting query Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:presence:update_db_subs: updating in database Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:core:db_do_query: error while submitting query Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:presence:msg_watchers_clean: querying database for expired messages Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:core:db_do_query: error while submitting query Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:presence:msg_presentity_clean: querying database for expired messages
I haven't seen anything similar in the issue tracker ? Is it a new bug ? How can I track it down ?
Regards, Pascal
Kamailio (OpenSER) - Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users http://lists.openser-project.org/cgi-bin/mailman/listinfo/users
which configuration parameters do you want to see ? -pascal
On Thu, Jun 4, 2009 at 11:12 AM, Saúl Ibarra saghul@gmail.com wrote:
Can you paste you DB settings?
On Thu, Jun 4, 2009 at 10:49 AM, Pascal Maugeri pascal.maugeri@gmail.com wrote:
Hello
I'm getting these errors using Kamailio 1.5.1:
Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out
of
sync; you can't run this command now Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]:
ERROR:core:db_do_update:
error while submitting query Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:presence:update_db_subs: updating in database Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out
of
sync; you can't run this command now Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:core:db_do_query: error while submitting query Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:presence:msg_watchers_clean: querying database for expired messages Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out
of
sync; you can't run this command now Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:core:db_do_query: error while submitting query Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:presence:msg_presentity_clean: querying database for expired
messages
I haven't seen anything similar in the issue tracker ? Is it a new bug ?
How
can I track it down ?
Regards, Pascal
Kamailio (OpenSER) - Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users http://lists.openser-project.org/cgi-bin/mailman/listinfo/users
-- Saúl -- "Nunca subestimes el ancho de banda de un camión lleno de disketes."
Kamailio (OpenSER) - Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users http://lists.openser-project.org/cgi-bin/mailman/listinfo/users
Never mind, at first I thought it could be a config issue ;)
On Thu, Jun 4, 2009 at 2:16 PM, Pascal Maugeri pascal.maugeri@gmail.com wrote:
which configuration parameters do you want to see ? -pascal
On Thu, Jun 4, 2009 at 11:12 AM, Saúl Ibarra saghul@gmail.com wrote:
Can you paste you DB settings?
On Thu, Jun 4, 2009 at 10:49 AM, Pascal Maugeri pascal.maugeri@gmail.com wrote:
Hello
I'm getting these errors using Kamailio 1.5.1:
Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:core:db_do_update: error while submitting query Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:presence:update_db_subs: updating in database Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:core:db_do_query: error while submitting query Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:presence:msg_watchers_clean: querying database for expired messages Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:core:db_do_query: error while submitting query Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:presence:msg_presentity_clean: querying database for expired messages
I haven't seen anything similar in the issue tracker ? Is it a new bug ? How can I track it down ?
Regards, Pascal
Kamailio (OpenSER) - Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users http://lists.openser-project.org/cgi-bin/mailman/listinfo/users
-- Saúl -- "Nunca subestimes el ancho de banda de un camión lleno de disketes."
Kamailio (OpenSER) - Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users http://lists.openser-project.org/cgi-bin/mailman/listinfo/users
El Jueves, 4 de Junio de 2009, Pascal Maugeri escribió:
Hello
I'm getting these errors using Kamailio 1.5.1:
ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out
There have been some issues since OpenSer in some presence modules related to DB errors like te above. In OpenSIPS most of them have been fixed (it doesn't occur to me from the last bug fix), but I think these errors still exist in Kamailio.
Go to OpenSIPS bug tracker and search for this error (and other related to presence), you will find good information.
For example, if you are using xcap_client, it has a bug in the DB connection casuing the above problem, try to remove it. Note however that the above bug occured in more cases (also fixed now).
Regards.
On 06/04/2009 12:34 PM, Iñaki Baz Castillo wrote:
El Jueves, 4 de Junio de 2009, Pascal Maugeri escribió:
Hello
I'm getting these errors using Kamailio 1.5.1:
ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out
There have been some issues since OpenSer in some presence modules related to DB errors like te above.
I am running Kamailio presence server in 4 production places and I haven't spotted anyone so far. It might be a particular case, but if something is reported then it will be fixed.
Note that the db api is different in the two projects now and code diverged, so patches from one to the other might not work
In OpenSIPS most of them have been fixed (it doesn't occur to me from the last bug fix), but I think these errors still exist in Kamailio.
Why do you think that? Have you used kamailio and got these ones?
Cheers, Daniel
Go to OpenSIPS bug tracker and search for this error (and other related to presence), you will find good information.
For example, if you are using xcap_client, it has a bug in the DB connection casuing the above problem, try to remove it. Note however that the above bug occured in more cases (also fixed now).
Regards.
El Jueves, 4 de Junio de 2009, Daniel-Constantin Mierla escribió:
There have been some issues since OpenSer in some presence modules related to DB errors like te above.
I am running Kamailio presence server in 4 production places and I haven't spotted anyone so far. It might be a particular case, but if something is reported then it will be fixed.
Note that the db api is different in the two projects now and code diverged, so patches from one to the other might not work
Yes, it could be. However in OpenSIPS there were some bugs related to presence and DB access but these bugs also existed in OpenSer.
In OpenSIPS most of them have been fixed (it doesn't occur to me from the last bug fix), but I think these errors still exist in Kamailio.
Why do you think that? Have you used kamailio and got these ones?
I've tryed both. Some time ago I discovered the same DB related bugs in Kamailio and OpenSIPS presence (and family) modules. For a project I used OpenSIPS as presence server so I gave it more testing and reported more bugs.
Of course, I must get some spare time to compile all those bugs and re-check them in kamailio (and report the bug or try to fix). I will do it, hope soon :)
Regards.
On 06/04/2009 01:37 PM, Iñaki Baz Castillo wrote:
El Jueves, 4 de Junio de 2009, Daniel-Constantin Mierla escribió:
There have been some issues since OpenSer in some presence modules related to DB errors like te above.
I am running Kamailio presence server in 4 production places and I haven't spotted anyone so far. It might be a particular case, but if something is reported then it will be fixed.
Note that the db api is different in the two projects now and code diverged, so patches from one to the other might not work
Yes, it could be. However in OpenSIPS there were some bugs related to presence and DB access but these bugs also existed in OpenSer.
In OpenSIPS most of them have been fixed (it doesn't occur to me from the last bug fix), but I think these errors still exist in Kamailio.
Why do you think that? Have you used kamailio and got these ones?
I've tryed both. Some time ago I discovered the same DB related bugs in Kamailio and OpenSIPS presence (and family) modules. For a project I used OpenSIPS as presence server so I gave it more testing and reported more bugs.
Of course, I must get some spare time to compile all those bugs and re-check them in kamailio (and report the bug or try to fix). I will do it, hope soon :)
there were lot of fixes in kamailio presence server as well and I understood that there were lot of inconsistent changes in the db api, so it is why things from the other project might not apply at all.
Cheers, Daniel
Hello,
On 06/04/2009 11:49 AM, Pascal Maugeri wrote:
Hello
I'm getting these errors using Kamailio 1.5.1:
Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:core:db_do_update: error while submitting query Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:presence:update_db_subs: updating in database Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:core:db_do_query: error while submitting query Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:presence:msg_watchers_clean: querying database for expired messages Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:core:db_do_query: error while submitting query Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:presence:msg_presentity_clean: querying database for expired messages
I haven't seen anything similar in the issue tracker ? Is it a new bug ? How can I track it down ?
there seems to be a case when the result from db is not freed before making a new query. To sort it out, please apply the patch attached and send me the last two queries you get for the same process - the one that gives the error and the one before.
Thanks, Daniel
ok, I've applied your patch changed my kamailio.cfg to have debug=5 and restarted the test. I will send you send feedback ASAP
-pascal
On Thu, Jun 4, 2009 at 12:09 PM, Daniel-Constantin Mierla <miconda@gmail.com
wrote:
Hello,
On 06/04/2009 11:49 AM, Pascal Maugeri wrote:
Hello
I'm getting these errors using Kamailio 1.5.1:
Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:core:db_do_update: error while submitting query Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:presence:update_db_subs: updating in database Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:core:db_do_query: error while submitting query Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:presence:msg_watchers_clean: querying database for expired messages Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:core:db_do_query: error while submitting query Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:presence:msg_presentity_clean: querying database for expired messages
I haven't seen anything similar in the issue tracker ? Is it a new bug ? How can I track it down ?
there seems to be a case when the result from db is not freed before making a new query. To sort it out, please apply the patch attached and send me the last two queries you get for the same process - the one that gives the error and the one before.
Should
Thanks, Daniel
-- Daniel-Constantin Mierla http://www.asipto.com/
On 06/04/2009 03:14 PM, Pascal Maugeri wrote:
ok, I've applied your patch changed my kamailio.cfg to have debug=5 and restarted the test. I will send you send feedback ASAP
ok, thanks. If it is too annoying, you can change the LM_DBG to LM_ERR or something else (like in attached patch).
Cheers, Daniel
-pascal
On Thu, Jun 4, 2009 at 12:09 PM, Daniel-Constantin Mierla <miconda@gmail.com mailto:miconda@gmail.com> wrote:
Hello, On 06/04/2009 11:49 AM, Pascal Maugeri wrote: Hello I'm getting these errors using Kamailio 1.5.1: Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:core:db_do_update: error while submitting query Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:presence:update_db_subs: updating in database Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:core:db_do_query: error while submitting query Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:presence:msg_watchers_clean: querying database for expired messages Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:core:db_do_query: error while submitting query Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:presence:msg_presentity_clean: querying database for expired messages I haven't seen anything similar in the issue tracker ? Is it a new bug ? How can I track it down ? there seems to be a case when the result from db is not freed before making a new query. To sort it out, please apply the patch attached and send me the last two queries you get for the same process - the one that gives the error and the one before.Should
Thanks, Daniel -- Daniel-Constantin Mierla http://www.asipto.com/
Kamailio (OpenSER) - Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users http://lists.openser-project.org/cgi-bin/mailman/listinfo/users
On 06/05/2009 10:55 AM, Daniel-Constantin Mierla wrote:
On 06/04/2009 03:14 PM, Pascal Maugeri wrote:
ok, I've applied your patch changed my kamailio.cfg to have debug=5 and restarted the test. I will send you send feedback ASAP
ok, thanks. If it is too annoying, you can change the LM_DBG to LM_ERR or something else (like in attached patch).
... patch attached now.
Cheers, Daniel
-pascal
On Thu, Jun 4, 2009 at 12:09 PM, Daniel-Constantin Mierla <miconda@gmail.com mailto:miconda@gmail.com> wrote:
Hello, On 06/04/2009 11:49 AM, Pascal Maugeri wrote: Hello I'm getting these errors using Kamailio 1.5.1: Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:core:db_do_update: error while submitting query Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:presence:update_db_subs: updating in database Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:core:db_do_query: error while submitting query Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:presence:msg_watchers_clean: querying database for expired messages Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:core:db_do_query: error while submitting query Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:presence:msg_presentity_clean: querying database for expired messages I haven't seen anything similar in the issue tracker ? Is it a new bug ? How can I track it down ? there seems to be a case when the result from db is not freed before making a new query. To sort it out, please apply the patch attached and send me the last two queries you get for the same process - the one that gives the error and the one before.Should
Thanks, Daniel -- Daniel-Constantin Mierla http://www.asipto.com/
Kamailio (OpenSER) - Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users http://lists.openser-project.org/cgi-bin/mailman/listinfo/users
Hi
I just applied your patch and I get - with no traffic yet - continusouly this log:
Jun 5 16:07:24 sandbox /usr/sbin/kamailio[14713]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): delete from active_watchers where expires<1244210834 Jun 5 16:07:24 sandbox /usr/sbin/kamailio[14713]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): select id from watchers where inserted_time<1244124444 AND status=2 Jun 5 16:07:24 sandbox /usr/sbin/kamailio[14713]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): select username,domain,etag,event from presentity where expires<1244210844 order by username
and it never stops.
I noticed that this occurs when presence server cleans or updates database. So I change these configuration parameters:
modparam("presence", "db_update_period", 10) modparam("presence", "clean_period", 10)
It changes the frequency of the log but the log always appear periodically (for clean/update actions).
Regards, Pascal
On Fri, Jun 5, 2009 at 10:04 AM, Daniel-Constantin Mierla <miconda@gmail.com
wrote:
On 06/05/2009 10:55 AM, Daniel-Constantin Mierla wrote:
On 06/04/2009 03:14 PM, Pascal Maugeri wrote:
ok, I've applied your patch changed my kamailio.cfg to have debug=5 and restarted the test. I will send you send feedback ASAP
ok, thanks. If it is too annoying, you can change the LM_DBG to LM_ERR or something else (like in attached patch).
... patch attached now.
Cheers, Daniel
-pascal
On Thu, Jun 4, 2009 at 12:09 PM, Daniel-Constantin Mierla < miconda@gmail.com mailto:miconda@gmail.com> wrote:
Hello,
On 06/04/2009 11:49 AM, Pascal Maugeri wrote:
Hello I'm getting these errors using Kamailio 1.5.1: Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:core:db_do_update: error while submitting query Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:presence:update_db_subs: updating in database Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:core:db_do_query: error while submitting query Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:presence:msg_watchers_clean: querying database for expired messages Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:core:db_do_query: error while submitting query Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:presence:msg_presentity_clean: querying database for expired messages I haven't seen anything similar in the issue tracker ? Is it a new bug ? How can I track it down ?there seems to be a case when the result from db is not freed before making a new query. To sort it out, please apply the patch attached and send me the last two queries you get for the same process - the one that gives the error and the one before.
Should
Thanks, Daniel
-- Daniel-Constantin Mierla http://www.asipto.com/
Kamailio (OpenSER) - Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users http://lists.openser-project.org/cgi-bin/mailman/listinfo/users
-- Daniel-Constantin Mierla http://www.asipto.com/
Sorry I misunderstood what you want me to do: please just forget my previous email.
Now I'm going to generate some load to reproduce the failure and I'll send you the feedback you expect.
-pascal
On Fri, Jun 5, 2009 at 2:15 PM, Pascal Maugeri pascal.maugeri@gmail.comwrote:
Hi
I just applied your patch and I get - with no traffic yet - continusouly this log:
Jun 5 16:07:24 sandbox /usr/sbin/kamailio[14713]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): delete from active_watchers where expires<1244210834 Jun 5 16:07:24 sandbox /usr/sbin/kamailio[14713]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): select id from watchers where inserted_time<1244124444 AND status=2 Jun 5 16:07:24 sandbox /usr/sbin/kamailio[14713]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): select username,domain,etag,event from presentity where expires<1244210844 order by username
and it never stops.
I noticed that this occurs when presence server cleans or updates database. So I change these configuration parameters:
modparam("presence", "db_update_period", 10) modparam("presence", "clean_period", 10)
It changes the frequency of the log but the log always appear periodically (for clean/update actions).
Regards, Pascal
On Fri, Jun 5, 2009 at 10:04 AM, Daniel-Constantin Mierla < miconda@gmail.com> wrote:
On 06/05/2009 10:55 AM, Daniel-Constantin Mierla wrote:
On 06/04/2009 03:14 PM, Pascal Maugeri wrote:
ok, I've applied your patch changed my kamailio.cfg to have debug=5 and restarted the test. I will send you send feedback ASAP
ok, thanks. If it is too annoying, you can change the LM_DBG to LM_ERR or something else (like in attached patch).
... patch attached now.
Cheers, Daniel
-pascal
On Thu, Jun 4, 2009 at 12:09 PM, Daniel-Constantin Mierla < miconda@gmail.com mailto:miconda@gmail.com> wrote:
Hello,
On 06/04/2009 11:49 AM, Pascal Maugeri wrote:
Hello I'm getting these errors using Kamailio 1.5.1: Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:core:db_do_update: error while submitting query Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:presence:update_db_subs: updating in database Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:core:db_do_query: error while submitting query Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:presence:msg_watchers_clean: querying database for expired messages Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:core:db_do_query: error while submitting query Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:presence:msg_presentity_clean: querying database for expired messages I haven't seen anything similar in the issue tracker ? Is it a new bug ? How can I track it down ?there seems to be a case when the result from db is not freed before making a new query. To sort it out, please apply the patch attached and send me the last two queries you get for the same process - the one that gives the error and the one before.
Should
Thanks, Daniel
-- Daniel-Constantin Mierla http://www.asipto.com/
Kamailio (OpenSER) - Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users http://lists.openser-project.org/cgi-bin/mailman/listinfo/users
-- Daniel-Constantin Mierla http://www.asipto.com/
OK now I can provide you more feedback regarding this issue and using your patch:
Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15152]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): select body,sender from presentity where domain='intra.genaker.net' AND username='sipp1' AND event='presence' AND etag='a.1244218834.15152.106.1' Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15150]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): select body,sender from presentity where domain='intra.genaker.net' AND username='sipp1' AND event='presence' AND etag='a.1244218834.15151.101.0' Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15152]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): delete from presentity where domain='intra.genaker.net' AND username='sipp1' AND event='presence' AND etag='a.1244218834.15152.106.1' Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15150]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): update presentity set etag='a.1244218834.15150.110.1',expires=1244218977,received_time=1244218877,body='<?xml version=\"1.0\" encoding=\"UTF-8\"?> [HIDDEN]' where domain=' intra.genaker.net' AND username='sipp1' AND event='presence' AND etag='a.1244218834.15151.101.0' Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15153]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): select body,sender from presentity where domain='intra.genaker.net' AND username='sipp1' AND event='presence' AND etag='a.1244218834.15152.107.1' Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15153]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15153]: ERROR:core:db_do_query: error while submitting query
So you can see the previous SQL commands sent.
Do you need anything else ?
-pascal
On Fri, Jun 5, 2009 at 2:53 PM, Pascal Maugeri pascal.maugeri@gmail.comwrote:
Sorry I misunderstood what you want me to do: please just forget my previous email.
Now I'm going to generate some load to reproduce the failure and I'll send you the feedback you expect.
-pascal
On Fri, Jun 5, 2009 at 2:15 PM, Pascal Maugeri pascal.maugeri@gmail.comwrote:
Hi
I just applied your patch and I get - with no traffic yet - continusouly this log:
Jun 5 16:07:24 sandbox /usr/sbin/kamailio[14713]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): delete from active_watchers where expires<1244210834 Jun 5 16:07:24 sandbox /usr/sbin/kamailio[14713]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): select id from watchers where inserted_time<1244124444 AND status=2 Jun 5 16:07:24 sandbox /usr/sbin/kamailio[14713]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): select username,domain,etag,event from presentity where expires<1244210844 order by username
and it never stops.
I noticed that this occurs when presence server cleans or updates database. So I change these configuration parameters:
modparam("presence", "db_update_period", 10) modparam("presence", "clean_period", 10)
It changes the frequency of the log but the log always appear periodically (for clean/update actions).
Regards, Pascal
On Fri, Jun 5, 2009 at 10:04 AM, Daniel-Constantin Mierla < miconda@gmail.com> wrote:
On 06/05/2009 10:55 AM, Daniel-Constantin Mierla wrote:
On 06/04/2009 03:14 PM, Pascal Maugeri wrote:
ok, I've applied your patch changed my kamailio.cfg to have debug=5 and restarted the test. I will send you send feedback ASAP
ok, thanks. If it is too annoying, you can change the LM_DBG to LM_ERR or something else (like in attached patch).
... patch attached now.
Cheers, Daniel
-pascal
On Thu, Jun 4, 2009 at 12:09 PM, Daniel-Constantin Mierla < miconda@gmail.com mailto:miconda@gmail.com> wrote:
Hello,
On 06/04/2009 11:49 AM, Pascal Maugeri wrote:
Hello I'm getting these errors using Kamailio 1.5.1: Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:core:db_do_update: error while submitting query Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:presence:update_db_subs: updating in database Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:core:db_do_query: error while submitting query Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:presence:msg_watchers_clean: querying database for expired messages Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:core:db_do_query: error while submitting query Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:presence:msg_presentity_clean: querying database for expired messages I haven't seen anything similar in the issue tracker ? Is it a new bug ? How can I track it down ?there seems to be a case when the result from db is not freed before making a new query. To sort it out, please apply the patch attached and send me the last two queries you get for the same process - the one that gives the error and the one before.
Should
Thanks, Daniel
-- Daniel-Constantin Mierla http://www.asipto.com/
Kamailio (OpenSER) - Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users http://lists.openser-project.org/cgi-bin/mailman/listinfo/users
-- Daniel-Constantin Mierla http://www.asipto.com/
Daniel, do you want me to do other test ? -pascal
On Fri, Jun 5, 2009 at 4:26 PM, Pascal Maugeri pascal.maugeri@gmail.comwrote:
OK now I can provide you more feedback regarding this issue and using your patch:
Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15152]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): select body,sender from presentity where domain='intra.genaker.net' AND username='sipp1' AND event='presence' AND etag='a.1244218834.15152.106.1' Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15150]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): select body,sender from presentity where domain='intra.genaker.net' AND username='sipp1' AND event='presence' AND etag='a.1244218834.15151.101.0' Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15152]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): delete from presentity where domain='intra.genaker.net' AND username='sipp1' AND event='presence' AND etag='a.1244218834.15152.106.1' Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15150]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): update presentity set etag='a.1244218834.15150.110.1',expires=1244218977,received_time=1244218877,body='<?xml version=\"1.0\" encoding=\"UTF-8\"?> [HIDDEN]' where domain=' intra.genaker.net' AND username='sipp1' AND event='presence' AND etag='a.1244218834.15151.101.0' Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15153]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): select body,sender from presentity where domain='intra.genaker.net' AND username='sipp1' AND event='presence' AND etag='a.1244218834.15152.107.1' Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15153]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15153]: ERROR:core:db_do_query: error while submitting query
So you can see the previous SQL commands sent.
Do you need anything else ?
-pascal
On Fri, Jun 5, 2009 at 2:53 PM, Pascal Maugeri pascal.maugeri@gmail.comwrote:
Sorry I misunderstood what you want me to do: please just forget my previous email.
Now I'm going to generate some load to reproduce the failure and I'll send you the feedback you expect.
-pascal
On Fri, Jun 5, 2009 at 2:15 PM, Pascal Maugeri pascal.maugeri@gmail.comwrote:
Hi
I just applied your patch and I get - with no traffic yet - continusouly this log:
Jun 5 16:07:24 sandbox /usr/sbin/kamailio[14713]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): delete from active_watchers where expires<1244210834 Jun 5 16:07:24 sandbox /usr/sbin/kamailio[14713]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): select id from watchers where inserted_time<1244124444 AND status=2 Jun 5 16:07:24 sandbox /usr/sbin/kamailio[14713]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): select username,domain,etag,event from presentity where expires<1244210844 order by username
and it never stops.
I noticed that this occurs when presence server cleans or updates database. So I change these configuration parameters:
modparam("presence", "db_update_period", 10) modparam("presence", "clean_period", 10)
It changes the frequency of the log but the log always appear periodically (for clean/update actions).
Regards, Pascal
On Fri, Jun 5, 2009 at 10:04 AM, Daniel-Constantin Mierla < miconda@gmail.com> wrote:
On 06/05/2009 10:55 AM, Daniel-Constantin Mierla wrote:
On 06/04/2009 03:14 PM, Pascal Maugeri wrote:
ok, I've applied your patch changed my kamailio.cfg to have debug=5 and restarted the test. I will send you send feedback ASAP
ok, thanks. If it is too annoying, you can change the LM_DBG to LM_ERR or something else (like in attached patch).
... patch attached now.
Cheers, Daniel
-pascal
On Thu, Jun 4, 2009 at 12:09 PM, Daniel-Constantin Mierla < miconda@gmail.com mailto:miconda@gmail.com> wrote:
Hello,
On 06/04/2009 11:49 AM, Pascal Maugeri wrote:
Hello I'm getting these errors using Kamailio 1.5.1: Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:core:db_do_update: error while submitting query Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:presence:update_db_subs: updating in database Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:core:db_do_query: error while submitting query Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:presence:msg_watchers_clean: querying database for expired messages Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:core:db_do_query: error while submitting query Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:presence:msg_presentity_clean: querying database for expired messages I haven't seen anything similar in the issue tracker ? Is it a new bug ? How can I track it down ?there seems to be a case when the result from db is not freed before making a new query. To sort it out, please apply the patch attached and send me the last two queries you get for the same process - the one that gives the error and the one before.
Should
Thanks, Daniel
-- Daniel-Constantin Mierla http://www.asipto.com/
Kamailio (OpenSER) - Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users http://lists.openser-project.org/cgi-bin/mailman/listinfo/users
-- Daniel-Constantin Mierla http://www.asipto.com/
Hello Pascal,
On 06/08/2009 04:54 PM, Pascal Maugeri wrote:
Daniel, do you want me to do other test ?
it was a long weekend here due to public holiday, so I was most of the time offline, without having the time to check your last email. I will investigate tomorrow, thanks,
Daniel
-pascal
On Fri, Jun 5, 2009 at 4:26 PM, Pascal Maugeri <pascal.maugeri@gmail.com mailto:pascal.maugeri@gmail.com> wrote:
OK now I can provide you more feedback regarding this issue and using your patch: Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15152]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): select body,sender from presentity where domain='intra.genaker.net <http://intra.genaker.net>' AND username='sipp1' AND event='presence' AND etag='a.1244218834.15152.106.1' Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15150]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): select body,sender from presentity where domain='intra.genaker.net <http://intra.genaker.net>' AND username='sipp1' AND event='presence' AND etag='a.1244218834.15151.101.0' Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15152]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): delete from presentity where domain='intra.genaker.net <http://intra.genaker.net>' AND username='sipp1' AND event='presence' AND etag='a.1244218834.15152.106.1' Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15150]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): update presentity set etag='a.1244218834.15150.110.1',expires=1244218977,received_time=1244218877,body='<?xml version=\"1.0\" encoding=\"UTF-8\"?> [HIDDEN]' where domain='intra.genaker.net <http://intra.genaker.net>' AND username='sipp1' AND event='presence' AND etag='a.1244218834.15151.101.0' Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15153]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): select body,sender from presentity where domain='intra.genaker.net <http://intra.genaker.net>' AND username='sipp1' AND event='presence' AND etag='a.1244218834.15152.107.1' Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15153]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15153]: ERROR:core:db_do_query: error while submitting query So you can see the previous SQL commands sent. Do you need anything else ? -pascal On Fri, Jun 5, 2009 at 2:53 PM, Pascal Maugeri <pascal.maugeri@gmail.com <mailto:pascal.maugeri@gmail.com>> wrote: Sorry I misunderstood what you want me to do: please just forget my previous email. Now I'm going to generate some load to reproduce the failure and I'll send you the feedback you expect. -pascal On Fri, Jun 5, 2009 at 2:15 PM, Pascal Maugeri <pascal.maugeri@gmail.com <mailto:pascal.maugeri@gmail.com>> wrote: Hi I just applied your patch and I get - with no traffic yet - continusouly this log: Jun 5 16:07:24 sandbox /usr/sbin/kamailio[14713]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): delete from active_watchers where expires<1244210834 Jun 5 16:07:24 sandbox /usr/sbin/kamailio[14713]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): select id from watchers where inserted_time<1244124444 AND status=2 Jun 5 16:07:24 sandbox /usr/sbin/kamailio[14713]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): select username,domain,etag,event from presentity where expires<1244210844 order by username and it never stops. I noticed that this occurs when presence server cleans or updates database. So I change these configuration parameters: modparam("presence", "db_update_period", 10) modparam("presence", "clean_period", 10) It changes the frequency of the log but the log always appear periodically (for clean/update actions). Regards, Pascal On Fri, Jun 5, 2009 at 10:04 AM, Daniel-Constantin Mierla <miconda@gmail.com <mailto:miconda@gmail.com>> wrote: On 06/05/2009 10:55 AM, Daniel-Constantin Mierla wrote: On 06/04/2009 03:14 PM, Pascal Maugeri wrote: ok, I've applied your patch changed my kamailio.cfg to have debug=5 and restarted the test. I will send you send feedback ASAP ok, thanks. If it is too annoying, you can change the LM_DBG to LM_ERR or something else (like in attached patch). ... patch attached now. Cheers, Daniel -pascal On Thu, Jun 4, 2009 at 12:09 PM, Daniel-Constantin Mierla <miconda@gmail.com <mailto:miconda@gmail.com> <mailto:miconda@gmail.com <mailto:miconda@gmail.com>>> wrote: Hello, On 06/04/2009 11:49 AM, Pascal Maugeri wrote: Hello I'm getting these errors using Kamailio 1.5.1: Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:core:db_do_update: error while submitting query Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:presence:update_db_subs: updating in database Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:core:db_do_query: error while submitting query Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:presence:msg_watchers_clean: querying database for expired messages Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:core:db_do_query: error while submitting query Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:presence:msg_presentity_clean: querying database for expired messages I haven't seen anything similar in the issue tracker ? Is it a new bug ? How can I track it down ? there seems to be a case when the result from db is not freed before making a new query. To sort it out, please apply the patch attached and send me the last two queries you get for the same process - the one that gives the error and the one before. Should Thanks, Daniel -- Daniel-Constantin Mierla http://www.asipto.com/ ------------------------------------------------------------------------ _______________________________________________ Kamailio (OpenSER) - Users mailing list Users@lists.kamailio.org <mailto:Users@lists.kamailio.org> http://lists.kamailio.org/cgi-bin/mailman/listinfo/users http://lists.openser-project.org/cgi-bin/mailman/listinfo/users -- Daniel-Constantin Mierla http://www.asipto.com/
I did a fix for what Inaki reported for xcap_client, you can get latest svn version for 1.5 and try again, maybe that was the issue.
Thanks, Daniel
On 06/08/2009 04:54 PM, Pascal Maugeri wrote:
Daniel, do you want me to do other test ? -pascal
On Fri, Jun 5, 2009 at 4:26 PM, Pascal Maugeri <pascal.maugeri@gmail.com mailto:pascal.maugeri@gmail.com> wrote:
OK now I can provide you more feedback regarding this issue and using your patch: Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15152]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): select body,sender from presentity where domain='intra.genaker.net <http://intra.genaker.net>' AND username='sipp1' AND event='presence' AND etag='a.1244218834.15152.106.1' Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15150]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): select body,sender from presentity where domain='intra.genaker.net <http://intra.genaker.net>' AND username='sipp1' AND event='presence' AND etag='a.1244218834.15151.101.0' Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15152]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): delete from presentity where domain='intra.genaker.net <http://intra.genaker.net>' AND username='sipp1' AND event='presence' AND etag='a.1244218834.15152.106.1' Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15150]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): update presentity set etag='a.1244218834.15150.110.1',expires=1244218977,received_time=1244218877,body='<?xml version=\"1.0\" encoding=\"UTF-8\"?> [HIDDEN]' where domain='intra.genaker.net <http://intra.genaker.net>' AND username='sipp1' AND event='presence' AND etag='a.1244218834.15151.101.0' Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15153]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): select body,sender from presentity where domain='intra.genaker.net <http://intra.genaker.net>' AND username='sipp1' AND event='presence' AND etag='a.1244218834.15152.107.1' Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15153]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15153]: ERROR:core:db_do_query: error while submitting query So you can see the previous SQL commands sent. Do you need anything else ? -pascal On Fri, Jun 5, 2009 at 2:53 PM, Pascal Maugeri <pascal.maugeri@gmail.com <mailto:pascal.maugeri@gmail.com>> wrote: Sorry I misunderstood what you want me to do: please just forget my previous email. Now I'm going to generate some load to reproduce the failure and I'll send you the feedback you expect. -pascal On Fri, Jun 5, 2009 at 2:15 PM, Pascal Maugeri <pascal.maugeri@gmail.com <mailto:pascal.maugeri@gmail.com>> wrote: Hi I just applied your patch and I get - with no traffic yet - continusouly this log: Jun 5 16:07:24 sandbox /usr/sbin/kamailio[14713]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): delete from active_watchers where expires<1244210834 Jun 5 16:07:24 sandbox /usr/sbin/kamailio[14713]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): select id from watchers where inserted_time<1244124444 AND status=2 Jun 5 16:07:24 sandbox /usr/sbin/kamailio[14713]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): select username,domain,etag,event from presentity where expires<1244210844 order by username and it never stops. I noticed that this occurs when presence server cleans or updates database. So I change these configuration parameters: modparam("presence", "db_update_period", 10) modparam("presence", "clean_period", 10) It changes the frequency of the log but the log always appear periodically (for clean/update actions). Regards, Pascal On Fri, Jun 5, 2009 at 10:04 AM, Daniel-Constantin Mierla <miconda@gmail.com <mailto:miconda@gmail.com>> wrote: On 06/05/2009 10:55 AM, Daniel-Constantin Mierla wrote: On 06/04/2009 03:14 PM, Pascal Maugeri wrote: ok, I've applied your patch changed my kamailio.cfg to have debug=5 and restarted the test. I will send you send feedback ASAP ok, thanks. If it is too annoying, you can change the LM_DBG to LM_ERR or something else (like in attached patch). ... patch attached now. Cheers, Daniel -pascal On Thu, Jun 4, 2009 at 12:09 PM, Daniel-Constantin Mierla <miconda@gmail.com <mailto:miconda@gmail.com> <mailto:miconda@gmail.com <mailto:miconda@gmail.com>>> wrote: Hello, On 06/04/2009 11:49 AM, Pascal Maugeri wrote: Hello I'm getting these errors using Kamailio 1.5.1: Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:core:db_do_update: error while submitting query Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:presence:update_db_subs: updating in database Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:core:db_do_query: error while submitting query Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:presence:msg_watchers_clean: querying database for expired messages Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:core:db_do_query: error while submitting query Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:presence:msg_presentity_clean: querying database for expired messages I haven't seen anything similar in the issue tracker ? Is it a new bug ? How can I track it down ? there seems to be a case when the result from db is not freed before making a new query. To sort it out, please apply the patch attached and send me the last two queries you get for the same process - the one that gives the error and the one before. Should Thanks, Daniel -- Daniel-Constantin Mierla http://www.asipto.com/ ------------------------------------------------------------------------ _______________________________________________ Kamailio (OpenSER) - Users mailing list Users@lists.kamailio.org <mailto:Users@lists.kamailio.org> http://lists.kamailio.org/cgi-bin/mailman/listinfo/users http://lists.openser-project.org/cgi-bin/mailman/listinfo/users -- Daniel-Constantin Mierla http://www.asipto.com/
I just tried your fix but now the server does not start any more and gives the following error:
Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15982]: INFO:core:init_mod: initializing module xcap_client Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15982]: INFO:core:init_mod: initializing module pua Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15982]: INFO:pua:db_restore: the query returned no result Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15982]: INFO:core:probe_max_receive_buffer: using a UDP receive buffer of 255 kb Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15989]: ERROR:core:init_mod_child: failed to initializing module xcap_client, rank 1 Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15989]: ERROR:core:main_loop: init_child failed for UDP listener Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15990]: ERROR:core:init_mod_child: failed to initializing module xcap_client, rank 2 Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15990]: ERROR:core:main_loop: init_child failed for UDP listener Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15992]: ERROR:core:init_mod_child: failed to initializing module xcap_client, rank 3 Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15993]: ERROR:core:init_mod_child: failed to initializing module xcap_client, rank 4 Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15993]: ERROR:core:main_loop: init_child failed for UDP listener Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15992]: ERROR:core:main_loop: init_child failed for UDP listener
-pascal
On Tue, Jun 9, 2009 at 1:57 PM, Daniel-Constantin Mierla miconda@gmail.comwrote:
I did a fix for what Inaki reported for xcap_client, you can get latest svn version for 1.5 and try again, maybe that was the issue.
Thanks, Daniel
On 06/08/2009 04:54 PM, Pascal Maugeri wrote:
Daniel, do you want me to do other test ? -pascal
On Fri, Jun 5, 2009 at 4:26 PM, Pascal Maugeri <pascal.maugeri@gmail.commailto: pascal.maugeri@gmail.com> wrote:
OK now I can provide you more feedback regarding this issue and using your patch:
Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15152]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): select body,sender from presentity where domain='intra.genaker.net http://intra.genaker.net' AND username='sipp1' AND event='presence' AND etag='a.1244218834.15152.106.1' Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15150]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): select body,sender from presentity where domain='intra.genaker.net http://intra.genaker.net' AND username='sipp1' AND event='presence' AND etag='a.1244218834.15151.101.0' Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15152]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): delete from presentity where domain='intra.genaker.net http://intra.genaker.net' AND username='sipp1' AND event='presence' AND etag='a.1244218834.15152.106.1' Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15150]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): update presentity set
etag='a.1244218834.15150.110.1',expires=1244218977,received_time=1244218877,body='<?xml version=\"1.0\" encoding=\"UTF-8\"?> [HIDDEN]' where domain='intra.genaker.net http://intra.genaker.net' AND username='sipp1' AND event='presence' AND etag='a.1244218834.15151.101.0' Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15153]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): select body,sender from presentity where domain='intra.genaker.net http://intra.genaker.net' AND username='sipp1' AND event='presence' AND etag='a.1244218834.15152.107.1' Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15153]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15153]: ERROR:core:db_do_query: error while submitting query
So you can see the previous SQL commands sent.
Do you need anything else ?
-pascal
On Fri, Jun 5, 2009 at 2:53 PM, Pascal Maugeri <pascal.maugeri@gmail.com mailto:pascal.maugeri@gmail.com> wrote:
Sorry I misunderstood what you want me to do: please just forget my previous email. Now I'm going to generate some load to reproduce the failure and I'll send you the feedback you expect. -pascal On Fri, Jun 5, 2009 at 2:15 PM, Pascal Maugeri <pascal.maugeri@gmail.com <mailto:pascal.maugeri@gmail.com>> wrote: Hi I just applied your patch and I get - with no traffic yet - continusouly this log: Jun 5 16:07:24 sandbox /usr/sbin/kamailio[14713]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): delete from active_watchers where expires<1244210834 Jun 5 16:07:24 sandbox /usr/sbin/kamailio[14713]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): select id from watchers where inserted_time<1244124444 AND status=2 Jun 5 16:07:24 sandbox /usr/sbin/kamailio[14713]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): select username,domain,etag,event from presentity where expires<1244210844 order by username and it never stops. I noticed that this occurs when presence server cleans or updates database. So I change these configuration parameters: modparam("presence", "db_update_period", 10) modparam("presence", "clean_period", 10) It changes the frequency of the log but the log always appear periodically (for clean/update actions). Regards, Pascal On Fri, Jun 5, 2009 at 10:04 AM, Daniel-Constantin Mierla <miconda@gmail.com <mailto:miconda@gmail.com>> wrote: On 06/05/2009 10:55 AM, Daniel-Constantin Mierla wrote: On 06/04/2009 03:14 PM, Pascal Maugeri wrote: ok, I've applied your patch changed my kamailio.cfg to have debug=5 and restarted the test. I will send you send feedback ASAP ok, thanks. If it is too annoying, you can change the LM_DBG to LM_ERR or something else (like in attached patch). ... patch attached now. Cheers, Daniel -pascal On Thu, Jun 4, 2009 at 12:09 PM, Daniel-Constantin Mierla <miconda@gmail.com <mailto:miconda@gmail.com> <mailto:miconda@gmail.com <mailto:miconda@gmail.com>>> wrote: Hello, On 06/04/2009 11:49 AM, Pascal Maugeri wrote: Hello I'm getting these errors using Kamailio 1.5.1: Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:core:db_do_update: error while submitting query Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:presence:update_db_subs: updating in database Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:core:db_do_query: error while submitting query Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:presence:msg_watchers_clean: querying database for expired messages Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:core:db_do_query: error while submitting query Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:presence:msg_presentity_clean: querying database for expired messages I haven't seen anything similar in the issue tracker ? Is it a new bug ? How can I track it down ? there seems to be a case when the result from db is not freed before making a new query. To sort it out, please apply the patch attached and send me the last two queries you get for the same process - the one that gives the error and the one before. Should Thanks, Daniel -- Daniel-Constantin Mierla http://www.asipto.com/
_______________________________________________ Kamailio (OpenSER) - Users mailing list Users@lists.kamailio.org <mailto:Users@lists.kamailio.org>http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
http://lists.openser-project.org/cgi-bin/mailman/listinfo/users
-- Daniel-Constantin Mierla http://www.asipto.com/-- Daniel-Constantin Mierla http://www.asipto.com/
I mistakenly returned error code even all was ok, in the previous commit. Should be fixed on svn.
Thanks, Daniel
On 06/09/2009 06:22 PM, Pascal Maugeri wrote:
I just tried your fix but now the server does not start any more and gives the following error:
Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15982]: INFO:core:init_mod: initializing module xcap_client Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15982]: INFO:core:init_mod: initializing module pua Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15982]: INFO:pua:db_restore: the query returned no result Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15982]: INFO:core:probe_max_receive_buffer: using a UDP receive buffer of 255 kb Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15989]: ERROR:core:init_mod_child: failed to initializing module xcap_client, rank 1 Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15989]: ERROR:core:main_loop: init_child failed for UDP listener Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15990]: ERROR:core:init_mod_child: failed to initializing module xcap_client, rank 2 Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15990]: ERROR:core:main_loop: init_child failed for UDP listener Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15992]: ERROR:core:init_mod_child: failed to initializing module xcap_client, rank 3 Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15993]: ERROR:core:init_mod_child: failed to initializing module xcap_client, rank 4 Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15993]: ERROR:core:main_loop: init_child failed for UDP listener Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15992]: ERROR:core:main_loop: init_child failed for UDP listener
-pascal
On Tue, Jun 9, 2009 at 1:57 PM, Daniel-Constantin Mierla <miconda@gmail.com mailto:miconda@gmail.com> wrote:
I did a fix for what Inaki reported for xcap_client, you can get latest svn version for 1.5 and try again, maybe that was the issue. Thanks, Daniel On 06/08/2009 04:54 PM, Pascal Maugeri wrote: Daniel, do you want me to do other test ? -pascal On Fri, Jun 5, 2009 at 4:26 PM, Pascal Maugeri <pascal.maugeri@gmail.com <mailto:pascal.maugeri@gmail.com> <mailto:pascal.maugeri@gmail.com <mailto:pascal.maugeri@gmail.com>>> wrote: OK now I can provide you more feedback regarding this issue and using your patch: Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15152]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): select body,sender from presentity where domain='intra.genaker.net <http://intra.genaker.net> <http://intra.genaker.net>' AND username='sipp1' AND event='presence' AND etag='a.1244218834.15152.106.1' Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15150]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): select body,sender from presentity where domain='intra.genaker.net <http://intra.genaker.net> <http://intra.genaker.net>' AND username='sipp1' AND event='presence' AND etag='a.1244218834.15151.101.0' Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15152]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): delete from presentity where domain='intra.genaker.net <http://intra.genaker.net> <http://intra.genaker.net>' AND username='sipp1' AND event='presence' AND etag='a.1244218834.15152.106.1' Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15150]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): update presentity set etag='a.1244218834.15150.110.1',expires=1244218977,received_time=1244218877,body='<?xml version=\"1.0\" encoding=\"UTF-8\"?> [HIDDEN]' where domain='intra.genaker.net <http://intra.genaker.net> <http://intra.genaker.net>' AND username='sipp1' AND event='presence' AND etag='a.1244218834.15151.101.0' Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15153]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): select body,sender from presentity where domain='intra.genaker.net <http://intra.genaker.net> <http://intra.genaker.net>' AND username='sipp1' AND event='presence' AND etag='a.1244218834.15152.107.1' Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15153]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15153]: ERROR:core:db_do_query: error while submitting query So you can see the previous SQL commands sent. Do you need anything else ? -pascal On Fri, Jun 5, 2009 at 2:53 PM, Pascal Maugeri <pascal.maugeri@gmail.com <mailto:pascal.maugeri@gmail.com> <mailto:pascal.maugeri@gmail.com <mailto:pascal.maugeri@gmail.com>>> wrote: Sorry I misunderstood what you want me to do: please just forget my previous email. Now I'm going to generate some load to reproduce the failure and I'll send you the feedback you expect. -pascal On Fri, Jun 5, 2009 at 2:15 PM, Pascal Maugeri <pascal.maugeri@gmail.com <mailto:pascal.maugeri@gmail.com> <mailto:pascal.maugeri@gmail.com <mailto:pascal.maugeri@gmail.com>>> wrote: Hi I just applied your patch and I get - with no traffic yet - continusouly this log: Jun 5 16:07:24 sandbox /usr/sbin/kamailio[14713]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): delete from active_watchers where expires<1244210834 Jun 5 16:07:24 sandbox /usr/sbin/kamailio[14713]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): select id from watchers where inserted_time<1244124444 AND status=2 Jun 5 16:07:24 sandbox /usr/sbin/kamailio[14713]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): select username,domain,etag,event from presentity where expires<1244210844 order by username and it never stops. I noticed that this occurs when presence server cleans or updates database. So I change these configuration parameters: modparam("presence", "db_update_period", 10) modparam("presence", "clean_period", 10) It changes the frequency of the log but the log always appear periodically (for clean/update actions). Regards, Pascal On Fri, Jun 5, 2009 at 10:04 AM, Daniel-Constantin Mierla <miconda@gmail.com <mailto:miconda@gmail.com> <mailto:miconda@gmail.com <mailto:miconda@gmail.com>>> wrote: On 06/05/2009 10:55 AM, Daniel-Constantin Mierla wrote: On 06/04/2009 03:14 PM, Pascal Maugeri wrote: ok, I've applied your patch changed my kamailio.cfg to have debug=5 and restarted the test. I will send you send feedback ASAP ok, thanks. If it is too annoying, you can change the LM_DBG to LM_ERR or something else (like in attached patch). ... patch attached now. Cheers, Daniel -pascal On Thu, Jun 4, 2009 at 12:09 PM, Daniel-Constantin Mierla <miconda@gmail.com <mailto:miconda@gmail.com> <mailto:miconda@gmail.com <mailto:miconda@gmail.com>> <mailto:miconda@gmail.com <mailto:miconda@gmail.com> <mailto:miconda@gmail.com <mailto:miconda@gmail.com>>>> wrote: Hello, On 06/04/2009 11:49 AM, Pascal Maugeri wrote: Hello I'm getting these errors using Kamailio 1.5.1: Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:core:db_do_update: error while submitting query Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:presence:update_db_subs: updating in database Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:core:db_do_query: error while submitting query Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:presence:msg_watchers_clean: querying database for expired messages Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:core:db_do_query: error while submitting query Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:presence:msg_presentity_clean: querying database for expired messages I haven't seen anything similar in the issue tracker ? Is it a new bug ? How can I track it down ? there seems to be a case when the result from db is not freed before making a new query. To sort it out, please apply the patch attached and send me the last two queries you get for the same process - the one that gives the error and the one before. Should Thanks, Daniel -- Daniel-Constantin Mierla http://www.asipto.com/ ------------------------------------------------------------------------ _______________________________________________ Kamailio (OpenSER) - Users mailing list Users@lists.kamailio.org <mailto:Users@lists.kamailio.org> <mailto:Users@lists.kamailio.org <mailto:Users@lists.kamailio.org>> http://lists.kamailio.org/cgi-bin/mailman/listinfo/users http://lists.openser-project.org/cgi-bin/mailman/listinfo/users -- Daniel-Constantin Mierla http://www.asipto.com/ -- Daniel-Constantin Mierla http://www.asipto.com/
Kamailio (OpenSER) - Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users http://lists.openser-project.org/cgi-bin/mailman/listinfo/users
ok I try it again -pascal
On Tue, Jun 9, 2009 at 5:27 PM, Daniel-Constantin Mierla miconda@gmail.comwrote:
I mistakenly returned error code even all was ok, in the previous commit. Should be fixed on svn.
Thanks, Daniel
On 06/09/2009 06:22 PM, Pascal Maugeri wrote:
I just tried your fix but now the server does not start any more and gives the following error:
Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15982]: INFO:core:init_mod: initializing module xcap_client Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15982]: INFO:core:init_mod: initializing module pua Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15982]: INFO:pua:db_restore: the query returned no result Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15982]: INFO:core:probe_max_receive_buffer: using a UDP receive buffer of 255 kb Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15989]: ERROR:core:init_mod_child: failed to initializing module xcap_client, rank 1 Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15989]: ERROR:core:main_loop: init_child failed for UDP listener Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15990]: ERROR:core:init_mod_child: failed to initializing module xcap_client, rank 2 Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15990]: ERROR:core:main_loop: init_child failed for UDP listener Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15992]: ERROR:core:init_mod_child: failed to initializing module xcap_client, rank 3 Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15993]: ERROR:core:init_mod_child: failed to initializing module xcap_client, rank 4 Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15993]: ERROR:core:main_loop: init_child failed for UDP listener Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15992]: ERROR:core:main_loop: init_child failed for UDP listener
-pascal
On Tue, Jun 9, 2009 at 1:57 PM, Daniel-Constantin Mierla < miconda@gmail.com mailto:miconda@gmail.com> wrote:
I did a fix for what Inaki reported for xcap_client, you can get latest svn version for 1.5 and try again, maybe that was the issue.
Thanks, Daniel
On 06/08/2009 04:54 PM, Pascal Maugeri wrote:
Daniel, do you want me to do other test ? -pascal On Fri, Jun 5, 2009 at 4:26 PM, Pascal Maugeri <pascal.maugeri@gmail.com <mailto:pascal.maugeri@gmail.com> <mailto:pascal.maugeri@gmail.com <mailto:pascal.maugeri@gmail.com>>> wrote: OK now I can provide you more feedback regarding this issue and using your patch: Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15152]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): select body,sender from presentity where domain='intra.genaker.net <http://intra.genaker.net> <http://intra.genaker.net>' AND username='sipp1' AND event='presence' AND etag='a.1244218834.15152.106.1' Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15150]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): select body,sender from presentity where domain='intra.genaker.net <http://intra.genaker.net> <http://intra.genaker.net>' AND username='sipp1' AND event='presence' AND etag='a.1244218834.15151.101.0' Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15152]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): delete from presentity where domain='intra.genaker.net <http://intra.genaker.net> <http://intra.genaker.net>' AND username='sipp1' AND event='presence' AND etag='a.1244218834.15152.106.1' Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15150]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): update presentity setetag='a.1244218834.15150.110.1',expires=1244218977,received_time=1244218877,body='<?xml version=\"1.0\" encoding=\"UTF-8\"?> [HIDDEN]' where domain='intra.genaker.net http://intra.genaker.net http://intra.genaker.net' AND
username='sipp1' AND event='presence' AND etag='a.1244218834.15151.101.0' Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15153]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): select body,sender from presentity where domain='intra.genaker.net <http://intra.genaker.net> <http://intra.genaker.net>' AND username='sipp1' AND event='presence' AND etag='a.1244218834.15152.107.1' Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15153]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15153]: ERROR:core:db_do_query: error while submitting query So you can see the previous SQL commands sent. Do you need anything else ? -pascal On Fri, Jun 5, 2009 at 2:53 PM, Pascal Maugeri <pascal.maugeri@gmail.com <mailto:pascal.maugeri@gmail.com> <mailto:pascal.maugeri@gmail.com <mailto:pascal.maugeri@gmail.com>>> wrote: Sorry I misunderstood what you want me to do: please just forget my previous email. Now I'm going to generate some load to reproduce the failure and I'll send you the feedback you expect. -pascal On Fri, Jun 5, 2009 at 2:15 PM, Pascal Maugeri <pascal.maugeri@gmail.com <mailto:pascal.maugeri@gmail.com> <mailto:pascal.maugeri@gmail.com <mailto:pascal.maugeri@gmail.com>>> wrote: Hi I just applied your patch and I get - with no traffic yet - continusouly this log: Jun 5 16:07:24 sandbox /usr/sbin/kamailio[14713]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): delete from active_watchers where expires<1244210834 Jun 5 16:07:24 sandbox /usr/sbin/kamailio[14713]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): select id from watchers where inserted_time<1244124444 AND status=2 Jun 5 16:07:24 sandbox /usr/sbin/kamailio[14713]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): select username,domain,etag,event from presentity where expires<1244210844 order by username and it never stops. I noticed that this occurs when presence server cleans or updates database. So I change these configuration parameters: modparam("presence", "db_update_period", 10) modparam("presence", "clean_period", 10) It changes the frequency of the log but the log always appear periodically (for clean/update actions). Regards, Pascal On Fri, Jun 5, 2009 at 10:04 AM, Daniel-Constantin Mierla <miconda@gmail.com <mailto:miconda@gmail.com> <mailto:miconda@gmail.com <mailto:miconda@gmail.com>>> wrote: On 06/05/2009 10:55 AM, Daniel-Constantin Mierla wrote: On 06/04/2009 03:14 PM, Pascal Maugeri wrote: ok, I've applied your patch changed my kamailio.cfg to have debug=5 and restarted the test. I will send you send feedback ASAP ok, thanks. If it is too annoying, you can change the LM_DBG to LM_ERR or something else (like in attached patch). ... patch attached now. Cheers, Daniel -pascal On Thu, Jun 4, 2009 at 12:09 PM, Daniel-Constantin Mierla <miconda@gmail.com <mailto:miconda@gmail.com> <mailto:miconda@gmail.com <mailto:miconda@gmail.com>> <mailto:miconda@gmail.com <mailto:miconda@gmail.com> <mailto:miconda@gmail.com <mailto:miconda@gmail.com>>>> wrote: Hello, On 06/04/2009 11:49 AM, Pascal Maugeri wrote: Hello I'm getting these errors using Kamailio 1.5.1: Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]:ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:core:db_do_update: error while submitting query Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:presence:update_db_subs: updating in database Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]:
ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:core:db_do_query: error while submitting query Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:presence:msg_watchers_clean: querying database for expired messages Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]:
ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:core:db_do_query: error while submitting query Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:presence:msg_presentity_clean: querying database for expired messages
I haven't seen anything similar in the issue tracker ? Is it a new bug ? How can I track it down ? there seems to be a case when the result from db is not freed before making a new query. To sort it out, please apply the patch attached and send me the last two queries you get for the same process - the one that gives the error and the one before. Should Thanks, Daniel -- Daniel-Constantin Mierla http://www.asipto.com/
Kamailio (OpenSER) - Users mailing list Users@lists.kamailio.org <mailto:Users@lists.kamailio.org> <mailto:Users@lists.kamailio.org <mailto:Users@lists.kamailio.org>>http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
http://lists.openser-project.org/cgi-bin/mailman/listinfo/users
-- Daniel-Constantin Mierla http://www.asipto.com/-- Daniel-Constantin Mierla http://www.asipto.com/
Kamailio (OpenSER) - Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users http://lists.openser-project.org/cgi-bin/mailman/listinfo/users
-- Daniel-Constantin Mierla http://www.asipto.com/
at least it starts :-) let's see if I get these db errors ... -pascal
On Tue, Jun 9, 2009 at 5:28 PM, Pascal Maugeri pascal.maugeri@gmail.comwrote:
ok I try it again -pascal
On Tue, Jun 9, 2009 at 5:27 PM, Daniel-Constantin Mierla < miconda@gmail.com> wrote:
I mistakenly returned error code even all was ok, in the previous commit. Should be fixed on svn.
Thanks, Daniel
On 06/09/2009 06:22 PM, Pascal Maugeri wrote:
I just tried your fix but now the server does not start any more and gives the following error:
Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15982]: INFO:core:init_mod: initializing module xcap_client Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15982]: INFO:core:init_mod: initializing module pua Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15982]: INFO:pua:db_restore: the query returned no result Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15982]: INFO:core:probe_max_receive_buffer: using a UDP receive buffer of 255 kb Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15989]: ERROR:core:init_mod_child: failed to initializing module xcap_client, rank 1 Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15989]: ERROR:core:main_loop: init_child failed for UDP listener Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15990]: ERROR:core:init_mod_child: failed to initializing module xcap_client, rank 2 Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15990]: ERROR:core:main_loop: init_child failed for UDP listener Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15992]: ERROR:core:init_mod_child: failed to initializing module xcap_client, rank 3 Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15993]: ERROR:core:init_mod_child: failed to initializing module xcap_client, rank 4 Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15993]: ERROR:core:main_loop: init_child failed for UDP listener Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15992]: ERROR:core:main_loop: init_child failed for UDP listener
-pascal
On Tue, Jun 9, 2009 at 1:57 PM, Daniel-Constantin Mierla < miconda@gmail.com mailto:miconda@gmail.com> wrote:
I did a fix for what Inaki reported for xcap_client, you can get latest svn version for 1.5 and try again, maybe that was the issue.
Thanks, Daniel
On 06/08/2009 04:54 PM, Pascal Maugeri wrote:
Daniel, do you want me to do other test ? -pascal On Fri, Jun 5, 2009 at 4:26 PM, Pascal Maugeri <pascal.maugeri@gmail.com <mailto:pascal.maugeri@gmail.com> <mailto:pascal.maugeri@gmail.com <mailto:pascal.maugeri@gmail.com>>> wrote: OK now I can provide you more feedback regarding this issue and using your patch: Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15152]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): select body,sender from presentity where domain='intra.genaker.net <http://intra.genaker.net> <http://intra.genaker.net>' AND username='sipp1' AND event='presence' AND etag='a.1244218834.15152.106.1' Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15150]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): select body,sender from presentity where domain='intra.genaker.net <http://intra.genaker.net> <http://intra.genaker.net>' AND username='sipp1' AND event='presence' AND etag='a.1244218834.15151.101.0' Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15152]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): delete from presentity where domain='intra.genaker.net <http://intra.genaker.net> <http://intra.genaker.net>' AND username='sipp1' AND event='presence' AND etag='a.1244218834.15152.106.1' Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15150]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): update presentity setetag='a.1244218834.15150.110.1',expires=1244218977,received_time=1244218877,body='<?xml version=\"1.0\" encoding=\"UTF-8\"?> [HIDDEN]' where domain='intra.genaker.net http://intra.genaker.net http://intra.genaker.net' AND
username='sipp1' AND event='presence' AND etag='a.1244218834.15151.101.0' Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15153]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): select body,sender from presentity where domain='intra.genaker.net <http://intra.genaker.net> <http://intra.genaker.net>' AND username='sipp1' AND event='presence' AND etag='a.1244218834.15152.107.1' Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15153]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15153]: ERROR:core:db_do_query: error while submitting query So you can see the previous SQL commands sent. Do you need anything else ? -pascal On Fri, Jun 5, 2009 at 2:53 PM, Pascal Maugeri <pascal.maugeri@gmail.com <mailto:pascal.maugeri@gmail.com> <mailto:pascal.maugeri@gmail.com <mailto:pascal.maugeri@gmail.com>>> wrote: Sorry I misunderstood what you want me to do: please just forget my previous email. Now I'm going to generate some load to reproduce the failure and I'll send you the feedback you expect. -pascal On Fri, Jun 5, 2009 at 2:15 PM, Pascal Maugeri <pascal.maugeri@gmail.com <mailto:pascal.maugeri@gmail.com> <mailto:pascal.maugeri@gmail.com <mailto:pascal.maugeri@gmail.com>>> wrote: Hi I just applied your patch and I get - with no traffic yet - continusouly this log: Jun 5 16:07:24 sandbox /usr/sbin/kamailio[14713]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): delete from active_watchers where expires<1244210834 Jun 5 16:07:24 sandbox /usr/sbin/kamailio[14713]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): select id from watchers where inserted_time<1244124444 AND status=2 Jun 5 16:07:24 sandbox /usr/sbin/kamailio[14713]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): select username,domain,etag,event from presentity where expires<1244210844 order by username and it never stops. I noticed that this occurs when presence server cleans or updates database. So I change these configuration parameters: modparam("presence", "db_update_period", 10) modparam("presence", "clean_period", 10) It changes the frequency of the log but the log always appear periodically (for clean/update actions). Regards, Pascal On Fri, Jun 5, 2009 at 10:04 AM, Daniel-Constantin Mierla <miconda@gmail.com <mailto:miconda@gmail.com> <mailto:miconda@gmail.com <mailto:miconda@gmail.com>>> wrote: On 06/05/2009 10:55 AM, Daniel-Constantin Mierla wrote: On 06/04/2009 03:14 PM, Pascal Maugeri wrote: ok, I've applied your patch changed my kamailio.cfg to have debug=5 and restarted the test. I will send you send feedback ASAP ok, thanks. If it is too annoying, you can change the LM_DBG to LM_ERR or something else (like in attached patch). ... patch attached now. Cheers, Daniel -pascal On Thu, Jun 4, 2009 at 12:09 PM, Daniel-Constantin Mierla <miconda@gmail.com <mailto:miconda@gmail.com> <mailto:miconda@gmail.com <mailto:miconda@gmail.com>> <mailto:miconda@gmail.com <mailto:miconda@gmail.com> <mailto:miconda@gmail.com <mailto:miconda@gmail.com>>>> wrote: Hello, On 06/04/2009 11:49 AM, Pascal Maugeri wrote: Hello I'm getting these errors using Kamailio 1.5.1: Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]:ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:core:db_do_update: error while submitting query Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:presence:update_db_subs: updating in database Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]:
ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:core:db_do_query: error while submitting query Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:presence:msg_watchers_clean: querying database for expired messages Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]:
ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:core:db_do_query: error while submitting query Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:presence:msg_presentity_clean: querying database for expired messages
I haven't seen anything similar in the issue tracker ? Is it a new bug ? How can I track it down ? there seems to be a case when the result from db is not freed before making a new query. To sort it out, please apply the patch attached and send me the last two queries you get for the same process - the one that gives the error and the one before. Should Thanks, Daniel -- Daniel-Constantin Mierla http://www.asipto.com/
Kamailio (OpenSER) - Users mailing list Users@lists.kamailio.org <mailto:Users@lists.kamailio.org> <mailto:Users@lists.kamailio.org <mailto:Users@lists.kamailio.org>>http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
http://lists.openser-project.org/cgi-bin/mailman/listinfo/users
-- Daniel-Constantin Mierla http://www.asipto.com/-- Daniel-Constantin Mierla http://www.asipto.com/
Kamailio (OpenSER) - Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users http://lists.openser-project.org/cgi-bin/mailman/listinfo/users
-- Daniel-Constantin Mierla http://www.asipto.com/
OK good news, with the lastest of 1.5 branch I could not reproduced the bug I reported.
I've sent something like 3x1000 SIP PUBLISH requests and couldn't get the error (with 1.5.1. after 40-50 req, the bug was reproduced easily).
Thanks a lot to both for your help! -pascal
On Tue, Jun 9, 2009 at 5:32 PM, Pascal Maugeri pascal.maugeri@gmail.comwrote:
at least it starts :-) let's see if I get these db errors ... -pascal
On Tue, Jun 9, 2009 at 5:28 PM, Pascal Maugeri pascal.maugeri@gmail.comwrote:
ok I try it again -pascal
On Tue, Jun 9, 2009 at 5:27 PM, Daniel-Constantin Mierla < miconda@gmail.com> wrote:
I mistakenly returned error code even all was ok, in the previous commit. Should be fixed on svn.
Thanks, Daniel
On 06/09/2009 06:22 PM, Pascal Maugeri wrote:
I just tried your fix but now the server does not start any more and gives the following error:
Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15982]: INFO:core:init_mod: initializing module xcap_client Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15982]: INFO:core:init_mod: initializing module pua Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15982]: INFO:pua:db_restore: the query returned no result Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15982]: INFO:core:probe_max_receive_buffer: using a UDP receive buffer of 255 kb Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15989]: ERROR:core:init_mod_child: failed to initializing module xcap_client, rank 1 Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15989]: ERROR:core:main_loop: init_child failed for UDP listener Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15990]: ERROR:core:init_mod_child: failed to initializing module xcap_client, rank 2 Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15990]: ERROR:core:main_loop: init_child failed for UDP listener Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15992]: ERROR:core:init_mod_child: failed to initializing module xcap_client, rank 3 Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15993]: ERROR:core:init_mod_child: failed to initializing module xcap_client, rank 4 Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15993]: ERROR:core:main_loop: init_child failed for UDP listener Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15992]: ERROR:core:main_loop: init_child failed for UDP listener
-pascal
On Tue, Jun 9, 2009 at 1:57 PM, Daniel-Constantin Mierla < miconda@gmail.com mailto:miconda@gmail.com> wrote:
I did a fix for what Inaki reported for xcap_client, you can get latest svn version for 1.5 and try again, maybe that was the issue.
Thanks, Daniel
On 06/08/2009 04:54 PM, Pascal Maugeri wrote:
Daniel, do you want me to do other test ? -pascal On Fri, Jun 5, 2009 at 4:26 PM, Pascal Maugeri <pascal.maugeri@gmail.com <mailto:pascal.maugeri@gmail.com> <mailto:pascal.maugeri@gmail.com <mailto:pascal.maugeri@gmail.com>>> wrote: OK now I can provide you more feedback regarding this issueand using your patch:
Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15152]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): select body,sender from presentity where domain='intra.genaker.net <http://intra.genaker.net> <http://intra.genaker.net>' AND username='sipp1' AND event='presence' AND etag='a.1244218834.15152.106.1' Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15150]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): select body,sender from presentity where domain='intra.genaker.net <http://intra.genaker.net> <http://intra.genaker.net>' AND username='sipp1' AND event='presence' AND etag='a.1244218834.15151.101.0' Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15152]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): delete from presentity where domain='intra.genaker.net <http://intra.genaker.net> <http://intra.genaker.net>' AND username='sipp1' AND event='presence' AND etag='a.1244218834.15152.106.1' Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15150]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): update presentity setetag='a.1244218834.15150.110.1',expires=1244218977,received_time=1244218877,body='<?xml version=\"1.0\" encoding=\"UTF-8\"?> [HIDDEN]' where domain='intra.genaker.net http://intra.genaker.net http://intra.genaker.net' AND
username='sipp1' AND event='presence' AND etag='a.1244218834.15151.101.0' Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15153]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): select body,sender from presentity where domain='intra.genaker.net <http://intra.genaker.net> <http://intra.genaker.net>' AND username='sipp1' AND event='presence' AND etag='a.1244218834.15152.107.1' Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15153]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15153]: ERROR:core:db_do_query: error while submitting query So you can see the previous SQL commands sent. Do you need anything else ? -pascal On Fri, Jun 5, 2009 at 2:53 PM, Pascal Maugeri <pascal.maugeri@gmail.com <mailto:pascal.maugeri@gmail.com> <mailto:pascal.maugeri@gmail.com <mailto:pascal.maugeri@gmail.com>>> wrote: Sorry I misunderstood what you want me to do: please just forget my previous email. Now I'm going to generate some load to reproduce the failure and I'll send you the feedback you expect. -pascal On Fri, Jun 5, 2009 at 2:15 PM, Pascal Maugeri <pascal.maugeri@gmail.com <mailto:pascal.maugeri@gmail.com> <mailto:pascal.maugeri@gmail.com <mailto:pascal.maugeri@gmail.com>>> wrote: Hi I just applied your patch and I get - with no traffic yet - continusouly this log: Jun 5 16:07:24 sandbox /usr/sbin/kamailio[14713]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): delete from active_watchers where expires<1244210834 Jun 5 16:07:24 sandbox /usr/sbin/kamailio[14713]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): select id from watchers where inserted_time<1244124444 AND status=2 Jun 5 16:07:24 sandbox /usr/sbin/kamailio[14713]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): select username,domain,etag,event from presentitywhere expires<1244210844 order by username
and it never stops. I noticed that this occurs when presence server cleans or updates database. So I change these configuration parameters: modparam("presence", "db_update_period", 10) modparam("presence", "clean_period", 10) It changes the frequency of the log but the log always appear periodically (for clean/update actions). Regards, Pascal On Fri, Jun 5, 2009 at 10:04 AM, Daniel-Constantin Mierla <miconda@gmail.com <mailto:miconda@gmail.com> <mailto:miconda@gmail.com <mailto:miconda@gmail.com>>> wrote: On 06/05/2009 10:55 AM, Daniel-Constantin Mierla wrote: On 06/04/2009 03:14 PM, Pascal Maugeri wrote: ok, I've applied your patch changed my kamailio.cfg to have debug=5 and restarted the test. I will send you send feedback ASAP ok, thanks. If it is too annoying, you can change the LM_DBG to LM_ERR or something else (likein attached patch).
... patch attached now. Cheers, Daniel -pascal On Thu, Jun 4, 2009 at 12:09 PM, Daniel-Constantin Mierla <miconda@gmail.com <mailto:miconda@gmail.com> <mailto:miconda@gmail.com <mailto:miconda@gmail.com>> <mailto:miconda@gmail.com <mailto:miconda@gmail.com> <mailto:miconda@gmail.com <mailto:miconda@gmail.com>>>> wrote: Hello, On 06/04/2009 11:49 AM, Pascal Maugeri wrote: Hello I'm getting these errors using Kamailio 1.5.1: Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]:ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:core:db_do_update: error while submitting query Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:presence:update_db_subs: updating in database Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]:
ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:core:db_do_query: error while submitting query Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:presence:msg_watchers_clean: querying database for expired messages Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]:
ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:core:db_do_query: error while submitting query Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]:
ERROR:presence:msg_presentity_clean: querying database for expired messages
I haven't seen anything similar in the issue tracker ? Is it a new bug ? How can I track it down ? there seems to be a case when theresult from db is not freed before making a new query. To sort it out, please apply the patch attached and send me the last two queries you get for the same process - the one that gives the error and the one before.
Should Thanks, Daniel -- Daniel-Constantin Mierla http://www.asipto.com/
Kamailio (OpenSER) - Users mailing list Users@lists.kamailio.org <mailto:Users@lists.kamailio.org> <mailto:Users@lists.kamailio.org <mailto:Users@lists.kamailio.org>>http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
http://lists.openser-project.org/cgi-bin/mailman/listinfo/users
-- Daniel-Constantin Mierla http://www.asipto.com/-- Daniel-Constantin Mierla http://www.asipto.com/
Kamailio (OpenSER) - Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users http://lists.openser-project.org/cgi-bin/mailman/listinfo/users
-- Daniel-Constantin Mierla http://www.asipto.com/
it looks the email I sent yesterday has been blocked because of its size by the mailing-list agent. -pascal
On Tue, Jun 9, 2009 at 5:45 PM, Pascal Maugeri pascal.maugeri@gmail.comwrote:
OK good news, with the lastest of 1.5 branch I could not reproduced the bug I reported.
I've sent something like 3x1000 SIP PUBLISH requests and couldn't get the error (with 1.5.1. after 40-50 req, the bug was reproduced easily).
Thanks a lot to both for your help! -pascal
Hello Pascal,
On 06/05/2009 05:26 PM, Pascal Maugeri wrote:
OK now I can provide you more feedback regarding this issue and using your patch:
Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15152]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): select body,sender from presentity where domain='intra.genaker.net http://intra.genaker.net' AND username='sipp1' AND event='presence' AND etag='a.1244218834.15152.106.1' Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15150]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): select body,sender from presentity where domain='intra.genaker.net http://intra.genaker.net' AND username='sipp1' AND event='presence' AND etag='a.1244218834.15151.101.0' Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15152]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): delete from presentity where domain='intra.genaker.net http://intra.genaker.net' AND username='sipp1' AND event='presence' AND etag='a.1244218834.15152.106.1' Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15150]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): update presentity set etag='a.1244218834.15150.110.1',expires=1244218977,received_time=1244218877,body='<?xml version=\"1.0\" encoding=\"UTF-8\"?> [HIDDEN]' where domain='intra.genaker.net http://intra.genaker.net' AND username='sipp1' AND event='presence' AND etag='a.1244218834.15151.101.0' Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15153]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): select body,sender from presentity where domain='intra.genaker.net http://intra.genaker.net' AND username='sipp1' AND event='presence' AND etag='a.1244218834.15152.107.1' Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15153]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15153]: ERROR:core:db_do_query: error while submitting query
So you can see the previous SQL commands sent.
Do you need anything else ?
I hope you still have entire log as I need to see previous sql command sent by process with pid 15153 (the one that threw the error). Please grep it and send it to me.
Thanks, Daniel
-pascal
On Fri, Jun 5, 2009 at 2:53 PM, Pascal Maugeri <pascal.maugeri@gmail.com mailto:pascal.maugeri@gmail.com> wrote:
Sorry I misunderstood what you want me to do: please just forget my previous email. Now I'm going to generate some load to reproduce the failure and I'll send you the feedback you expect. -pascal On Fri, Jun 5, 2009 at 2:15 PM, Pascal Maugeri <pascal.maugeri@gmail.com <mailto:pascal.maugeri@gmail.com>> wrote: Hi I just applied your patch and I get - with no traffic yet - continusouly this log: Jun 5 16:07:24 sandbox /usr/sbin/kamailio[14713]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): delete from active_watchers where expires<1244210834 Jun 5 16:07:24 sandbox /usr/sbin/kamailio[14713]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): select id from watchers where inserted_time<1244124444 AND status=2 Jun 5 16:07:24 sandbox /usr/sbin/kamailio[14713]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): select username,domain,etag,event from presentity where expires<1244210844 order by username and it never stops. I noticed that this occurs when presence server cleans or updates database. So I change these configuration parameters: modparam("presence", "db_update_period", 10) modparam("presence", "clean_period", 10) It changes the frequency of the log but the log always appear periodically (for clean/update actions). Regards, Pascal On Fri, Jun 5, 2009 at 10:04 AM, Daniel-Constantin Mierla <miconda@gmail.com <mailto:miconda@gmail.com>> wrote: On 06/05/2009 10:55 AM, Daniel-Constantin Mierla wrote: On 06/04/2009 03:14 PM, Pascal Maugeri wrote: ok, I've applied your patch changed my kamailio.cfg to have debug=5 and restarted the test. I will send you send feedback ASAP ok, thanks. If it is too annoying, you can change the LM_DBG to LM_ERR or something else (like in attached patch). ... patch attached now. Cheers, Daniel -pascal On Thu, Jun 4, 2009 at 12:09 PM, Daniel-Constantin Mierla <miconda@gmail.com <mailto:miconda@gmail.com> <mailto:miconda@gmail.com <mailto:miconda@gmail.com>>> wrote: Hello, On 06/04/2009 11:49 AM, Pascal Maugeri wrote: Hello I'm getting these errors using Kamailio 1.5.1: Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:core:db_do_update: error while submitting query Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:presence:update_db_subs: updating in database Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:core:db_do_query: error while submitting query Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:presence:msg_watchers_clean: querying database for expired messages Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:core:db_do_query: error while submitting query Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:presence:msg_presentity_clean: querying database for expired messages I haven't seen anything similar in the issue tracker ? Is it a new bug ? How can I track it down ? there seems to be a case when the result from db is not freed before making a new query. To sort it out, please apply the patch attached and send me the last two queries you get for the same process - the one that gives the error and the one before. Should Thanks, Daniel -- Daniel-Constantin Mierla http://www.asipto.com/ ------------------------------------------------------------------------ _______________________________________________ Kamailio (OpenSER) - Users mailing list Users@lists.kamailio.org <mailto:Users@lists.kamailio.org> http://lists.kamailio.org/cgi-bin/mailman/listinfo/users http://lists.openser-project.org/cgi-bin/mailman/listinfo/users -- Daniel-Constantin Mierla http://www.asipto.com/
2009/6/9 Daniel-Constantin Mierla miconda@gmail.com:
Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15152]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): select body,sender from presentity where domain='intra.genaker.net http://intra.genaker.net' AND username='sipp1' AND event='presence' AND etag='a.1244218834.15152.106.1' Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15150]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): select body,sender from presentity where domain='intra.genaker.net http://intra.genaker.net' AND username='sipp1' AND event='presence' AND etag='a.1244218834.15151.101.0'
Hi Pascal, do you have loaded xcap_client module?
Indeed, yes I have the xcap_client module loaded.
I believe you found the gulty module : as I have another server without the xcap_client loaded and it does not give this db error !
-pascal
Hi Pascal, do you have loaded xcap_client module?
-- Iñaki Baz Castillo ibc@aliax.net
Kamailio (OpenSER) - Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users http://lists.openser-project.org/cgi-bin/mailman/listinfo/users
2009/6/9 Pascal Maugeri pascal.maugeri@gmail.com:
Indeed, yes I have the xcap_client module loaded.
I believe you found the gulty module : as I have another server without the xcap_client loaded and it does not give this db error !
http://openser.svn.sourceforge.net/viewvc/openser?view=rev&revision=5871
;)
Do you need anything else ?
I hope you still have entire log as I need to see previous sql command sent by process with pid 15153 (the one that threw the error). Please grep it and send it to me.
:-( no sorry I haven't keep the entire log. I'm sorry this is my fault as I remember you asked me to send this info as well. I'm restarting the test ... -pascal
Thanks, Daniel
-pascal
On Fri, Jun 5, 2009 at 2:53 PM, Pascal Maugeri <pascal.maugeri@gmail.commailto: pascal.maugeri@gmail.com> wrote:
Sorry I misunderstood what you want me to do: please just forget my previous email.
Now I'm going to generate some load to reproduce the failure and I'll send you the feedback you expect.
-pascal
On Fri, Jun 5, 2009 at 2:15 PM, Pascal Maugeri <pascal.maugeri@gmail.com mailto:pascal.maugeri@gmail.com> wrote:
Hi I just applied your patch and I get - with no traffic yet - continusouly this log: Jun 5 16:07:24 sandbox /usr/sbin/kamailio[14713]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): delete from active_watchers where expires<1244210834 Jun 5 16:07:24 sandbox /usr/sbin/kamailio[14713]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): select id from watchers where inserted_time<1244124444 AND status=2 Jun 5 16:07:24 sandbox /usr/sbin/kamailio[14713]: ERROR:db_mysql:db_mysql_submit_query: submit_query(): select username,domain,etag,event from presentity where expires<1244210844 order by username and it never stops. I noticed that this occurs when presence server cleans or updates database. So I change these configuration parameters: modparam("presence", "db_update_period", 10) modparam("presence", "clean_period", 10) It changes the frequency of the log but the log always appear periodically (for clean/update actions). Regards, Pascal On Fri, Jun 5, 2009 at 10:04 AM, Daniel-Constantin Mierla <miconda@gmail.com <mailto:miconda@gmail.com>> wrote: On 06/05/2009 10:55 AM, Daniel-Constantin Mierla wrote: On 06/04/2009 03:14 PM, Pascal Maugeri wrote: ok, I've applied your patch changed my kamailio.cfg to have debug=5 and restarted the test. I will send you send feedback ASAP ok, thanks. If it is too annoying, you can change the LM_DBG to LM_ERR or something else (like in attached patch). ... patch attached now. Cheers, Daniel -pascal On Thu, Jun 4, 2009 at 12:09 PM, Daniel-Constantin Mierla <miconda@gmail.com <mailto:miconda@gmail.com> <mailto:miconda@gmail.com <mailto:miconda@gmail.com>>> wrote: Hello, On 06/04/2009 11:49 AM, Pascal Maugeri wrote: Hello I'm getting these errors using Kamailio 1.5.1: Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:core:db_do_update: error while submitting query Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:presence:update_db_subs: updating in database Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:core:db_do_query: error while submitting query Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:presence:msg_watchers_clean: querying database for expired messages Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:core:db_do_query: error while submitting query Jun 4 12:25:10 sandbox /usr/sbin/kamailio[5060]: ERROR:presence:msg_presentity_clean: querying database for expired messages I haven't seen anything similar in the issue tracker ? Is it a new bug ? How can I track it down ? there seems to be a case when the result from db is not freed before making a new query. To sort it out, please apply the patch attached and send me the last two queries you get for the same process - the one that gives the error and the one before. Should Thanks, Daniel -- Daniel-Constantin Mierla http://www.asipto.com/
_______________________________________________ Kamailio (OpenSER) - Users mailing list Users@lists.kamailio.org <mailto:Users@lists.kamailio.org>http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
http://lists.openser-project.org/cgi-bin/mailman/listinfo/users
-- Daniel-Constantin Mierla http://www.asipto.com/-- Daniel-Constantin Mierla http://www.asipto.com/
-
Daniel-Constantin Mierla -
Iñaki Baz Castillo -
Pascal Maugeri -
Saúl Ibarra