Hi Iñaki.<br><br>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.<br><br>That is exactly the fix I put on function, to try to check whether it solves it.<br>
<br>Regards.<br><br>Sergio.<br><br><div class="gmail_quote">On Sun, Nov 23, 2008 at 11:04 AM, Iñaki Baz Castillo <span dir="ltr"><<a href="mailto:ibc@aliax.net">ibc@aliax.net</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div class="Ih2E3d">El Domingo, 23 de Noviembre de 2008, Iñaki Baz Castillo escribió:<br>
> El Domingo, 23 de Noviembre de 2008, Iñaki Baz Castillo escribió:<br>
> > El Domingo, 23 de Noviembre de 2008, Sergio Gutierrez escribió:<br>
> > > Hello Iñaki.<br>
> > ><br>
> > > Could you enable mysql query logging?<br>
> ><br>
> > Do you mean uncommenting the following line in my.conf?:<br>
> ><br>
> > log = /var/log/mysql/mysql.log<br>
> ><br>
> > Thanks.<br>
><br>
> I've enabled that log (that just shows all the SQL queries) and when I've<br>
> got the same OpenSIPS error the query doesn't appear in<br>
> /var/log/mysql/mysql.log. This is, the error I'm reporting occurs before<br>
> the query arrives to MySQL server.<br>
<br>
</div>I've found similar problems, specially this thread:<br>
<a href="http://www.mail-archive.com/devel%40lists.openser.org/msg02761.html" target="_blank">http://www.mail-archive.com/devel%40lists.openser.org/msg02761.html</a><br>
in which Bogdan finally says:<br>
<br>
---------<br>
as the DB connections are TCP connections, if the connection is opened<br>
before the fork, it will inherited by all the forked child procs. This<br>
is a typical error if you mishandle a DB connection from mod_init().<br>
---------<br>
<br>
What does it mean exactly?<br>
Yes, probably those errors occur to because I'm restarting OpenSIPS very<br>
often, but anyway I would like to understand them properly (and how to avoid<br>
them).<br>
<br>
Thanks.<br>
<div><div></div><div class="Wj3C7c"><br>
<br>
<br>
--<br>
Iñaki Baz Castillo<br>
<br>
_______________________________________________<br>
Devel mailing list<br>
<a href="mailto:Devel@lists.opensips.org">Devel@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/devel" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/devel</a><br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>Sergio Gutiérrez<br>