Re: [Kamailio-Users] db_mysql errors doing presence activity

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 wrote: > 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 PUB

Re: [Kamailio-Users] db_mysql errors doing presence activity

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

Re: [Kamailio-Users] db_mysql errors doing presence activity

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 wrote: > ok I try it again > -pascal > > > On Tue, Jun 9, 2009 at 5:27 PM, Daniel-Constantin Mierla < > mico...@gmail.com> wrote: > >> I mistakenly returned error code even all was

Re: [Kamailio-Users] db_mysql errors doing presence activity

ok I try it again -pascal On Tue, Jun 9, 2009 at 5:27 PM, Daniel-Constantin Mierla 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

Re: [Kamailio-Users] db_mysql errors doing presence activity

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

Re: [Kamailio-Users] db_mysql errors doing presence activity

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

Re: [Kamailio-Users] db_mysql errors doing presence activity

2009/6/9 Pascal Maugeri : > 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 ;) --

Re: [Kamailio-Users] db_mysql errors doing presence activity

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

Re: [Kamailio-Users] db_mysql errors doing presence activity

> 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

Re: [Kamailio-Users] db_mysql errors doing presence activity

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 m

Re: [Kamailio-Users] db_mysql errors doing presence activity

2009/6/9 Daniel-Constantin Mierla : >> 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 >> et

Re: [Kamailio-Users] db_mysql errors doing presence activity

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 doma

Re: [Kamailio-Users] db_mysql errors doing presence activity

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

Re: [Kamailio-Users] db_mysql errors doing presence activity

Daniel, do you want me to do other test ? -pascal On Fri, Jun 5, 2009 at 4: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

Re: [Kamailio-Users] db_mysql errors doing presence activity

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

Re: [Kamailio-Users] db_mysql errors doing presence activity

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 wrote: > Hi > > I just applied your patch and I get

Re: [Kamailio-Users] db_mysql errors doing presence activity

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]: ER

Re: [Kamailio-Users] db_mysql errors doing presence activity

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 t

Re: [Kamailio-Users] db_mysql errors doing presence activity

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). Che

Re: [Kamailio-Users] db_mysql errors doing presence activity

Never mind, at first I thought it could be a config issue ;) On Thu, Jun 4, 2009 at 2:16 PM, Pascal Maugeri wrote: > which configuration parameters do you want to see ? > -pascal > > On Thu, Jun 4, 2009 at 11:12 AM, Saúl Ibarra wrote: >> >> Can you paste you DB  settings? >> >> On Thu, Jun 4,

Re: [Kamailio-Users] db_mysql errors doing presence activity

which configuration parameters do you want to see ? -pascal On Thu, Jun 4, 2009 at 11:12 AM, Saúl Ibarra wrote: > Can you paste you DB settings? > > On Thu, Jun 4, 2009 at 10:49 AM, Pascal Maugeri > wrote: > > Hello > > > > I'm getting these errors using Kamailio 1.5.1: > > > > Jun 4 12:25:10

Re: [Kamailio-Users] db_mysql errors doing presence activity

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 wrote: > Hello, > > > On 06/04/2009 11:49 AM, Pascal Maugeri wrote: > >> Hello >> >> I'm getting these

Re: [Kamailio-Users] db_mysql errors doing presence activity

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 an

Re: [Kamailio-Users] db_mysql errors doing presence activity

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 par

Re: [Kamailio-Users] db_mysql errors doing presence activity

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 OpenS

Re: [Kamailio-Users] db_mysql errors doing presence activity

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 sandbo

Re: [Kamailio-Users] db_mysql errors doing presence activity

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

Re: [Kamailio-Users] db_mysql errors doing presence activity

Can you paste you DB settings? On Thu, Jun 4, 2009 at 10: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

[Kamailio-Users] db_mysql errors doing presence activity

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