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