[OpenSIPS-Users] multiple sub interfaces - opensips crashes

M S medeanwz at gmail.com
Tue Nov 3 21:41:47 EST 2020 

thank you!

On Tue, Nov 3, 2020 at 8:15 PM Federico Edorna <fedorna at anura.com.ar> wrote:

> I didn't read that it was mysql, sorry. I think my suggestion is for
> another thread :)
>
> Anyway, it seems that proxysql <https://proxysql.com/> can be a choice
> for mysql...
>
>
> On Tue, Nov 3, 2020 at 3:46 PM M S <medeanwz at gmail.com> wrote:
>
>> Thanks for the suggestion Federico. I'm using Myql, is there an
>> equivalent?
>>
>> On Tue, Nov 3, 2020 at 3:42 PM Federico Edorna <fedorna at anura.com.ar>
>> wrote:
>>
>>> If it helps, we are using pgbouncer <https://www.pgbouncer.org/> to
>>> avoid opening a lot of connections to db. Pgbouncer acts as a db server for
>>> opensips with full workers connections and opens just a few (on demand) to
>>> real db server. It helps a lot when you have backup/standby opensips, not
>>> increasing those db connections.
>>>
>>>
>>> On Tue, Nov 3, 2020 at 9:13 AM Bogdan-Andrei Iancu <bogdan at opensips.org>
>>> wrote:
>>>
>>>> Maybe we should consider (as future extension) the possibility to
>>>> bundle
>>>> multiple UDP listeners on the same worker.  In this case, we can have a
>>>> large number of listeners with a relatively small number of workers/
>>>> processes.
>>>>
>>>> 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/3/20 10:10 AM, Răzvan Crainea 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
>>>>
>>>>
>>>> _______________________________________________
>>>> 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
>>>
>> _______________________________________________
>> 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/85aec20a/attachment.html>

More information about the Users mailing list