[Kamailio-Users] db_mysql errors doing presence activity

Daniel-Constantin Mierla miconda at gmail.com
Tue Jun 9 10:30:39 CEST 2009


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 at gmail.com <mailto:pascal.maugeri at 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 at gmail.com <mailto:pascal.maugeri at 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 at gmail.com <mailto:miconda at 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 at gmail.com
>                     <mailto:miconda at gmail.com>
>                     <mailto:miconda at gmail.com
>                     <mailto:miconda at 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 at lists.kamailio.org
>                     <mailto:Users at 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/




More information about the Users mailing list