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 <mico...@gmail.com <mailto:mico...@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
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/

Index: modules/db_mysql/dbase.c
===================================================================
--- modules/db_mysql/dbase.c	(revision 5865)
+++ modules/db_mysql/dbase.c	(working copy)
@@ -104,6 +104,7 @@
 	 * will most of the time stop at the second or sometimes at the third
 	 * iteration.
 	 */
+	LM_ERR("submit_query(): %.*s\n", _s->len, _s->s);
 	for (i=0; i < (db_mysql_auto_reconnect ? 3 : 1); i++) {
 		if (mysql_real_query(CON_CONNECTION(_h), _s->s, _s->len) == 0) {
 			return 0;
_______________________________________________
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

Reply via email to