Hi Razvan, I tried, but it didn't start properly. I guess it is Mysql that returns an error, but usually Opensips just prints a warning and continues running if it cannot connect to database, right? I'm using Mysql for sql_cacher. Is it possible that Opensips is running out of some other resources? I sent the error messages I received in the original email...
Thanks! On Tue, Nov 3, 2020 at 9:13 AM Răzvan Crainea <raz...@opensips.org> wrote: > Hello! > > No, there is no way to prevent OpenSIPS from opening connections for > each process. Did you try to start opensips with fewer workers, for > example just 1, or 3? Does it start properly? > > Best regards, > > Răzvan Crainea > OpenSIPS Core Developer > http://www.opensips-solutions.com > > On 11/2/20 1:55 PM, M S wrote: > > 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 > > <mailto: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 list > >> Users@lists.opensips.org <mailto: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 > > > > _______________________________________________ > 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