<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<tt>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>
</tt>
<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 11:57, Denis wrote:<br>
</div>
<blockquote cite="mid:162899020.20160930115736@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;">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]:
<a class="moz-txt-link-freetext" href="INFO:drouting:dr_reload_cmd">INFO:drouting:dr_reload_cmd</a>: dr_reload MI command received!<br>
Sep 26 16:29:41 opensips-main
/usr/local/opensips2.2/sbin/opensips[30942]:
<a class="moz-txt-link-freetext" href="INFO:drouting:add_dst">INFO:drouting:add_dst</a>: 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>
</blockquote>
<br>
</body>
</html>