[Kamailio-Users] db_mysql errors doing presence activity

Daniel-Constantin Mierla miconda at gmail.com
Tue Jun 9 13:57:47 CEST 2009


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 at gmail.com <mailto:pascal.maugeri at 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 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 sr-users mailing list