[OpenSIPS-Users] multiple sub interfaces - opensips crashes

[M S]

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 <razvan at 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 <bogdan at opensips.org
> > <mailto:bogdan at 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 at lists.opensips.org  <mailto:Users at lists.opensips.org>
> >>     http://lists.opensips.org/cgi-bin/mailman/listinfo/users
> >
> >
> > _______________________________________________
> > Users mailing list
> > Users at lists.opensips.org
> > http://lists.opensips.org/cgi-bin/mailman/listinfo/users
> >
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20201103/531ab70a/attachment.html>