Thank you Bogdan. I actually use: socket=udp:*:5060 in config file. Is there a way to not open a process per interface, to not have 1200 or 600 workers? as I said in my previous email, I tried auto scaling and it didn't work. Also, I have increased MySQL max connections but it didn't fix the problem - I wonder if anybody has experience with this...
Thanks! On Mon, Nov 2, 2020 at 9:24 AM Bogdan-Andrei Iancu <bog...@opensips.org> wrote: > 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 > listUsers@lists.opensips.orghttp://lists.opensips.org/cgi-bin/mailman/listinfo/users > > >
_______________________________________________ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users