<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<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 class="moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="moz-txt-link-freetext" href="https://www.opensips-solutions.com">https://www.opensips-solutions.com</a>
OpenSIPS Bootcamp 2020 online
<a class="moz-txt-link-freetext" href="https://opensips.org/training/OpenSIPS_eBootcamp_2020/">https://opensips.org/training/OpenSIPS_eBootcamp_2020/</a></pre>
<div class="moz-cite-prefix">On 11/2/20 1:23 AM, M S wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAEZrhoNBaDegtVxdGSY8ZScUbccKN_i758DqGEVWHJUNWRWvEw@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<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 class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</body>
</html>