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 <[EMAIL PROTECTED]> 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 > [email protected] > http://lists.opensips.org/cgi-bin/mailman/listinfo/devel > -- Sergio Gutiérrez
_______________________________________________ Devel mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/devel
