[OpenSIPS-Users] multiple sub interfaces - opensips crashes

[Răzvan Crainea]

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
>