<html><head><title>Re: [OpenSIPS-Users] Opensips 2.2.1 dr_rules is empty</title>
</head>
<body>
<span style=" font-family:'Times New Roman'; font-size: 12pt;">Bogdan, log is here<br>
</span><a 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 style=" font-family:'arial'; font-size: 10pt;" href="mailto:d.putyato@ptl.ru">mailto:denis7979@mail.ru</a><br>
<br>
<table bgcolor="#ffffff">
<tr>
<td width=2 bgcolor= #0000ff><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 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>
<tr>
<td width=2 bgcolor= #3200ff><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 style=" font-family:'arial'; font-size: 10pt;" href="mailto:denis7979@mail.ru">mailto:denis7979@mail.ru</a><br>
<br>
<table bgcolor="#ffffff">
<tr>
<td width=2 bgcolor= #0000ff><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 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>
<tr>
<td width=2 bgcolor= #3200ff><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 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 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 style=" font-family:'arial'; font-size: 10pt;" href="mailto:denis7979@mail.ru">mailto:denis7979@mail.ru</a><br>
<br>
<table bgcolor="#ffffff">
<tr>
<td width=2 bgcolor= #0000ff><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 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>
<tr>
<td width=2 bgcolor= #3200ff><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 style=" font-family:'arial'; font-size: 10pt;" href="mailto:denis7979@mail.ru">mailto:denis7979@mail.ru</a><br>
<br>
<table bgcolor="#ffffff">
<tr>
<td width=2 bgcolor= #0000ff><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 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>
<tr>
<td width=2 bgcolor= #3200ff><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 style=" font-family:'arial'; font-size: 10pt;" href="mailto:denis7979@mail.ru">mailto:denis7979@mail.ru</a><br>
<br>
<table bgcolor="#ffffff">
<tr>
<td width=2 bgcolor= #0000ff><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 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>
<tr>
<td width=2 bgcolor= #3200ff><br>
</td>
<td><br>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</body></html>