[OpenSIPS-Devel] ERROR:db_mysql:db_mysql_submit_query

[Iñaki Baz Castillo]

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