Hi OpenSIPer,
With 600 interfaces (btw , have actually listed the 600 sockets into the
cfg or pointed the socket to the interface?) with 2 workers per socket
-> 1200 workers / processes. That means 1200 connections to your DB
server, which may be a bottle neck (by default, mysql accepts around 100
simultaneous connections).
I suspect your mysql server cannot cope with the 1200 conn, preventing
OpenSIPS to properly start.
Regards,
Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
https://www.opensips-solutions.com
OpenSIPS Bootcamp 2020 online
https://opensips.org/training/OpenSIPS_eBootcamp_2020/
On 11/2/20 1:23 AM, M S wrote:
Hi all,
I have a machine with 600 subinterfaces. when I start opensips with 2
udp workers per interface, it doesn't start and keeps restarting.
First error message was about too many connections to Mysql which I
fixed by increasing max_connections, but now I am getting:
ERROR:db_mysql:db_mysql_new_connection: initial connect failed
ERROR:core:db_do_init: could not add connection to the pool
ERROR:sql_cacher:child_init: Cannot connect to SQL DB from child
ERROR:core:init_mod_child: failed to initializing module sql_cacher,
rank 683
ERROR:core:send_status_code: write(-1) failed (-1): 32, Broken pipe
ERROR:core:udp_start_processes: failed to send -1 status code
ERROR:db_mysql:db_mysql_connect: driver error(2002): Can't connect to
local MySQL server through socket '/var/lib/mysql/mysql.sock' (11)
and:
ERROR:core:send_status_code: write(-1) failed (-1): 32, Broken pipe
ERROR:core:udp_start_processes: failed to send -1 status code
Any ideas how I can fix this?
Also, can I just limit number of opensips forked processes, to run
just a certain number process instead of x numbers per interface? I
tried using auto_scaling but it did not help. in my opensips.conf, I
have:
socket=udp:*:5060
and adding an autoscaling profile in front of it seems to limit the
processes per interface again, not all...
Any help is appreciated.
Thanks!
_______________________________________________
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
