[OpenSIPS-Devel] ERROR:db_mysql:db_mysql_submit_query

[Bogdan-Andrei Iancu]

Hi Iñaki,

are you running in forking mode or not?

What you can do is to log the mysql traffic and which opensips process 
generates it, and when the error pops out, to see what was the last 
mysql query performed by the guilty process.

Regards,
Bogdan

Iñaki Baz Castillo wrote:
> El Domingo, 23 de Noviembre de 2008, Iñaki Baz Castillo escribió:
>
>   
>> ---------
>> 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).
>>     
>
> I've two users registered (alice and bob), both registered in the same Twinkle 
> sofphone.
> - If alice calls (so OpenSIPS sends 407) the OpenSIPS returns 500 when alice 
> re-sends the INVITE with credentials (auth_db issue clearly).
> - If bob calls (OpenSIPS sends also 407) bob re-sends the INVITE with 
> credentials and there is no problem.
> ¿?¿?
>
> Of course, after restarting OpenSIPS the problem dissapears (temporaly?).
>
>
>
>