<div dir="ltr"><div dir="ltr">Thank you Bogdan. I actually use: socket=udp:*:5060 in config file.</div><div>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.</div><div>Also, I have increased MySQL max connections but it didn't fix the problem - I wonder if anybody has experience with this...</div><div><br></div><div>Thanks!</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Mon, Nov 2, 2020 at 9:24 AM Bogdan-Andrei Iancu <<a href="mailto:bogdan@opensips.org">bogdan@opensips.org</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div>
<tt>Hi OpenSIPer,<br>
<br>
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).<br>
<br>
I suspect your mysql server cannot cope with the 1200 conn,
preventing OpenSIPS to properly start.<br>
<br>
Regards,<br>
</tt>
<pre cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a href="https://www.opensips-solutions.com" target="_blank">https://www.opensips-solutions.com</a>
OpenSIPS Bootcamp 2020 online
<a href="https://opensips.org/training/OpenSIPS_eBootcamp_2020/" target="_blank">https://opensips.org/training/OpenSIPS_eBootcamp_2020/</a></pre>
<div>On 11/2/20 1:23 AM, M S wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">Hi all,
<div>I have a machine with 600 subinterfaces. when I start
opensips with 2 udp workers per interface, it doesn't
start and keeps restarting.</div>
<div>First error message was about too many connections to
Mysql which I fixed by increasing max_connections, but
now I am getting:</div>
<div><br>
</div>
<div>
<div>ERROR:db_mysql:db_mysql_new_connection: initial
connect failed</div>
<div>ERROR:core:db_do_init: could not add connection to
the pool</div>
<div>ERROR:sql_cacher:child_init: Cannot connect to SQL
DB from child</div>
<div>ERROR:core:init_mod_child: failed to initializing
module sql_cacher, rank 683</div>
<div>ERROR:core:send_status_code: write(-1) failed (-1):
32, Broken pipe</div>
<div>ERROR:core:udp_start_processes: failed to send -1
status code</div>
<div>ERROR:db_mysql:db_mysql_connect: driver
error(2002): Can't connect to local MySQL server
through socket '/var/lib/mysql/mysql.sock' (11)</div>
</div>
<div><br>
</div>
<div>and:</div>
<div><br>
</div>
<div>
<div>ERROR:core:send_status_code: write(-1) failed (-1):
32, Broken pipe</div>
<div>ERROR:core:udp_start_processes: failed to send -1
status code</div>
</div>
<div><br>
</div>
<div>Any ideas how I can fix this? </div>
<div>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: </div>
<div>socket=udp:*:5060</div>
<div>and adding an autoscaling profile in front of it
seems to limit the processes per interface again, not
all...</div>
<div><br>
</div>
<div>Any help is appreciated.</div>
<div><br>
</div>
<div>Thanks!</div>
</div>
</div>
</div>
</div>
<br>
<fieldset></fieldset>
<pre>_______________________________________________
Users mailing list
<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</div>
</blockquote></div>