[OpenSIPS-Devel] ERROR:db_mysql:db_mysql_submit_query

[Iñaki Baz Castillo]

El Lunes, 15 de Diciembre de 2008, Bogdan-Andrei Iancu escribió:
> Hi Iñaki,
>
> But, based on the mysql logs, what is the last query performed by proc
> 23847  before generating the "out of sync" errors?
>
> The error from 23846 is not related as each process uses a dedicated
> mysql connection to server.

Ok, I don't have the same log file, but I created now a new one with debug=4.

There are a lot of queries before the error, always related to presence. The 
error occurs in two processes: 20542 and 20551. The complete logs are here:

  http://aliax.net/public/opensips_ERROR%3Adb_mysql_process_20542
  http://aliax.net/public/opensips_ERROR%3Adb_mysql_process_20551

Note that I've started opensips at 11:23:45 and the mysql ERROR has occurred 
for the first time at 13:56:32 (in process 20542) and at 13:56:33 (in process 
20551).

After the first occurrence of the error, it occurs various times per minute in 
process 20551 and just 4 times more in process 20542.


In order to easily find the first "ERROR:db_mysql" I've marked it with "###" 
in both files.


The most interesting for me is the fact that the same error occurs in both 
process at the same time (13:56:32 and 13:56:33).

More data: I'm running OpenSIPS with presence module and:
  children=4
  listen=MY_IP:MY_PORT
  listen=MY_IP:MY_PORT2
  listen=MY_IP2:MY_PORT
  listen=MY_IP2:MY_PORT2

Those are the existing OpenSIPS process:

~# pidof opensips
20558 20557 20556 20555 20554 20553 20552 20551 20550 20549 20548 20547 20546 
20545 20544 20543 20542 20541 20540 20539 20538 20537 20536 20535 20534


"ERROR:db_mysql" just occurs for processes 20542 and 20551, no more. I assume 
they are the processes acting as a presence server.



Can I provide more data?



-- 
Iñaki Baz Castillo