[OpenSIPS-Users] multiple sub interfaces - opensips crashes

[M S]

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>
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 at lists.opensips.orghttp://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20201102/c1fb0686/attachment-0001.html>