[Kamailio-Users] db_mysql errors doing presence activity

Daniel-Constantin Mierla miconda at gmail.com
Tue Jun 9 17:27:38 CEST 2009


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 at gmail.com <mailto:miconda at 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 at gmail.com <mailto:pascal.maugeri at gmail.com>
>         <mailto: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>
>            <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 at gmail.com <mailto:pascal.maugeri at gmail.com>
>         <mailto: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>
>         <mailto: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>
>         <mailto: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>>
>                                <mailto: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>
>                                <mailto: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/
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Kamailio (OpenSER) - Users mailing list
> 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/





More information about the sr-users mailing list