<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<tt>yes</tt><br>
<pre class="moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="moz-txt-link-freetext" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a></pre>
<div class="moz-cite-prefix">On 30.09.2016 12:29, Denis wrote:<br>
</div>
<blockquote cite="mid:148152963.20160930122959@ptl.ru" type="cite">
<title>Re: [OpenSIPS-Users] Opensips 2.2.1 dr_rules is empty</title>
<span style=" font-family:'Times New Roman'; font-size: 12pt;">Bogdan,
you need all log between two dr_reload?<br>
<br>
</span><a moz-do-not-send="true" style=" font-family:'arial';
font-size: 10pt;" href="mailto:denis7979@mail.ru">mailto:denis7979@mail.ru</a><br>
<br>
<table bgcolor="#ffffff">
<tbody>
<tr>
<td bgcolor="#0000ff" width="2"><br>
</td>
<td><span style=" font-family:'courier new'; font-size:
12pt;">Hi Denis.<br>
<br>
The log you posted covers only 16:21, so I cannot see
the 16:29 reload.<br>
<br>
Please pot the whole log on a pastebin or dropbox.<br>
<br>
Regards,<br>
Bogdan-Andrei Iancu<br>
OpenSIPS Founder and Developer<br>
</span><a moz-do-not-send="true" style="
font-family:'courier new'; font-size: 12pt;"
href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a><br>
<span style=" font-family:'times new roman'; font-size:
12pt;">On 30.09.2016 11:57, Denis wrote:<br>
</span>
<table>
<tbody>
<tr>
<td bgcolor="#3200ff" width="2"><br>
</td>
<td><span style=" font-family:'times new roman';
font-size: 12pt;">Re: [OpenSIPS-Users] Opensips
2.2.1 dr_rules is empty Ok, but exactly in 16:21
(time you can see in the log) we got the main
problem, i.e. after dr_reload.<br>
<br>
Everything became fine after next dr_reload
command has been received<br>
Sep 26 16:29:41 opensips-main
/usr/local/opensips2.2/sbin/opensips[30942]: </span><a
moz-do-not-send="true" style="
font-family:'times new roman'; font-size: 12pt;"
href="INFO:drouting:dr_reload_cmd">INFO:drouting:dr_reload_cmd</a><span
style=" font-family:'times new roman';
font-size: 12pt;">: dr_reload MI command
received!<br>
Sep 26 16:29:41 opensips-main
/usr/local/opensips2.2/sbin/opensips[30942]: </span><a
moz-do-not-send="true" style="
font-family:'times new roman'; font-size: 12pt;"
href="INFO:drouting:add_dst">INFO:drouting:add_dst</a><span
style=" font-family:'times new roman';
font-size: 12pt;">: pgw tree 0x7fd11c20a480<br>
<br>
<br>
<br>
</span><a moz-do-not-send="true" style="
font-family:'arial'; font-size: 10pt;"
href="mailto:denis7979@mail.ru">mailto:denis7979@mail.ru</a><br>
<br>
<table bgcolor="#ffffff">
<tbody>
<tr>
<td bgcolor="#0000ff" width="2"><br>
</td>
<td><span style=" font-family:'courier new';
font-size: 12pt;">Hi Denis,<br>
<br>
yes, but the errors on failed attempted
connections are not related to drouting
(they are linked to the acc module).<br>
<br>
In DR, even before attempting to perform
any DB query, there is a log about
receiving the MI "dr_reload" command -
which is only one. Some how, I am not
convinced that a second dr_reload is
actually reaching OpenSIPS.<br>
<br>
Regards,<br>
Bogdan-Andrei Iancu<br>
OpenSIPS Founder and Developer<br>
</span><a moz-do-not-send="true" style="
font-family:'courier new'; font-size:
12pt;"
href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a><br>
<span style=" font-family:'times new
roman'; font-size: 12pt;">On 30.09.2016
08:46, Denis wrote:<br>
</span>
<table>
<tbody>
<tr>
<td bgcolor="#3200ff" width="2"><br>
</td>
<td><span style=" font-family:'times
new roman'; font-size: 12pt;">Re:
[OpenSIPS-Users] Opensips 2.2.1
dr_rules is empty Hello, Bogdan!<br>
<br>
Yes, in the log i noticed only
one dr_reload when the problem
appears.<br>
I wanted to show that opensips
tries to make many attempts to
connect to mysql but dr_rules
becomes empty.<br>
<br>
Next dr_reload had been applied
over 9 minutes about.<br>
<br>
</span><a moz-do-not-send="true"
style=" font-family:'arial';
font-size: 10pt;"
href="mailto:denis7979@mail.ru">mailto:denis7979@mail.ru</a><br>
<br>
<table bgcolor="#ffffff">
<tbody>
<tr>
<td bgcolor="#0000ff"
width="2"><br>
</td>
<td><span style="
font-family:'courier
new'; font-size: 12pt;">Hi
Denis,<br>
<br>
The log you attached
shows one single
dr_reload command
received, leading to the
load of 198 GWs. After
that there are no logs
related to DR at all.<br>
<br>
Regards,<br>
Bogdan<br>
Bogdan-Andrei Iancu<br>
OpenSIPS Founder and
Developer<br>
</span><a
moz-do-not-send="true"
style="
font-family:'courier
new'; font-size: 12pt;"
href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a><br>
<span style="
font-family:'times new
roman'; font-size:
12pt;">On 27.09.2016
09:47, Denis wrote:<br>
</span>
<table>
<tbody>
<tr>
<td
bgcolor="#3200ff"
width="2"><br>
</td>
<td><span style="
font-family:'times
new roman';
font-size:
12pt;">Re:
[OpenSIPS-Users]
Opensips 2.2.1
dr_rules is
empty Hello,
Liviu!<br>
<br>
The problem is
still active.<br>
In attachment
you can see the
latest log of
the problem.<br>
<br>
After the last
string mysql
connection
became correct.<br>
<br>
I want to ask,
does it make any
sense to
increase timer
parameters for
mysql
connection.<br>
Ok, suppose we
have some
problem with the
server and
increasing of
timer
parameters will
help for it, but
why does
dr_rules becomes
empty if it has
mysql connection
problem?<br>
<br>
<br>
</span><a
moz-do-not-send="true"
style="
font-family:'arial';
font-size:
10pt;"
href="mailto:denis7979@mail.ru">mailto:denis7979@mail.ru</a><br>
<br>
<table
bgcolor="#ffffff">
<tbody>
<tr>
<td
bgcolor="#0000ff"
width="2"><br>
</td>
<td><span
style="
font-family:'courier
new';
font-size:
12pt;">Correct,
Denis - they
have nothing
to do with
each other. I
am just trying
to isolate our
problem (by
excluding "too
many
reconnects"),
so we can
better
understand
what's
happening.<br>
Liviu Chircu<br>
OpenSIPS
Developer<br>
</span><a
moz-do-not-send="true"
style="
font-family:'courier
new';
font-size:
12pt;"
href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a><br>
<span style="
font-family:'times new roman'; font-size: 12pt;">On 12.09.2016 15:45,
Denis wrote:<br>
</span>
<table>
<tbody>
<tr>
<td
bgcolor="#3200ff"
width="2"><br>
</td>
<td><br>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</blockquote>
<br>
</body>
</html>