[OpenSIPS-Devel] ERROR:db_mysql:db_mysql_submit_query

[Sergio Gutierrez]

Hi Iñaki.

Takin a look at mysql documentation, I see that error is related caused by
not freeing the result of a query after issuing another query.

That is exactly the fix I put on function, to try to check whether it solves
it.

Regards.

Sergio.

On Sun, Nov 23, 2008 at 11:04 AM, Iñaki Baz Castillo <ibc at aliax.net> wrote:

> El Domingo, 23 de Noviembre de 2008, Iñaki Baz Castillo escribió:
> > El Domingo, 23 de Noviembre de 2008, Iñaki Baz Castillo escribió:
> > > El Domingo, 23 de Noviembre de 2008, Sergio Gutierrez escribió:
> > > > Hello Iñaki.
> > > >
> > > > Could you enable mysql query logging?
> > >
> > > Do you mean uncommenting the following line in my.conf?:
> > >
> > >   log             = /var/log/mysql/mysql.log
> > >
> > > Thanks.
> >
> > I've enabled that log (that just shows all the SQL queries) and when I've
> > got the same OpenSIPS error the query doesn't appear in
> > /var/log/mysql/mysql.log. This is, the error I'm reporting occurs before
> > the query arrives to MySQL server.
>
> I've found similar problems, specially this thread:
>  http://www.mail-archive.com/devel%40lists.openser.org/msg02761.html
> in which Bogdan finally says:
>
> ---------
> as the DB connections are TCP connections, if the connection is opened
> before the fork, it will inherited by all the forked child procs. This
> is a typical error if you mishandle a DB connection from mod_init().
> ---------
>
> What does it mean exactly?
> Yes, probably those errors occur to because I'm restarting OpenSIPS very
> often, but anyway I would like to understand them properly (and how to
> avoid
> them).
>
> Thanks.
>
>
>
> --
> Iñaki Baz Castillo
>
> _______________________________________________
> Devel mailing list
> Devel at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/devel
>



-- 
Sergio Gutiérrez
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.opensips.org/pipermail/devel/attachments/20081123/ef314c90/attachment.htm