On Tue, Jun 9, 2009 at 5:32 PM, Pascal Maugeri <pascal.maugeri@gmail.com> wrote:

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.com> wrote:

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 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

--
Daniel-Constantin Mierla
http://www.asipto.com/