<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<tt>Hi Denis,<br>
<br>
For each dr_reload triggering, the logs report 198 GWs loaded - so
it seems to be successful every time.<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 14:13, Denis wrote:<br>
</div>
<blockquote cite="mid:4610277829.20160930141319@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,
log is here<br>
</span><a moz-do-not-send="true" style=" font-family:'Times New
Roman'; font-size: 12pt;"
href="https://cloud.mail.ru/public/HRtb/zn9igdL7C">https://cloud.mail.ru/public/HRtb/zn9igdL7C</a>
<br>
<br>
<a moz-do-not-send="true" style=" font-family:'arial'; font-size:
10pt;" href="mailto:d.putyato@ptl.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;">yes<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 12:29, 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 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>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</blockquote>
<br>
</body>
</html>