<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"><meta name="Generator" content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;
color:#212121;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#2A76C6;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:gray;
text-decoration:underline;}
span.E-MailFormatvorlage17
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body bgcolor="#f7f7f7" lang="DE-AT" link="#2a76c6" vlink="#808080" text="#212121"><div>Hi,</div><div><br></div><div>i made further investigation and noticed that the messages are real.</div><div><b><br></b></div><div><span style="color:#000000;background-color:#ffffff;"><br></span><span style="color:#000000;background-color:#ffffff;"># Time: 161102 1:14:11
</span></div><div><span style="font-family:monospace"># User@Host: rateomat[rateomat] @ localhost []
<br># <font color="#ff0000"><b>Query_time: 68.930217</b></font> Lock_time: 0.000057 Rows_sent: 100 Rows_examined: 1346093
<br>SET timestamp=1478045651;
<br></span><span style="font-family: monospace;"><b>SELECT * FROM accounting.cdr WHERE rating_status = 'unrated' ORDER BY start_time ASC LIMIT 100;</b></span></div><div><br></div><div>This query run by rate-o-mat takes too long, more than the mysql wait timeout which is 60 sec.</div><div>I had to realize that this query caused very high disk utilization (80-90% peak time busy i can see on munin graph)</div><div><br></div><div>As workaround i removed "<b style="font-family: monospace;">ORDER BY start_time ASC" </b>from the query (on rate-o-mat source) and everything works fine and fast.</div><div><br></div><div>Regards,</div><div>imedve</div><div><br></div><div><br></div><div><br></div><div>On Tue, 2016-11-01 at 23:14 +0100, Rene Krenn wrote:</div><blockquote type="cite"><div class="WordSection1"><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">Hi,<o:p></o:p></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">actually these messages indicate caught exceptions before reopening connections,<o:p></o:p></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">which can be a regular case if the system is almost idle (hardly any calls). They should<o:p></o:p></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">be suppressed in a future patch.<o:p></o:p></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">Just to make sure, do you use dedicated billing fees at all and how frequently do you see<o:p></o:p></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">it? To gain more infos, the rate-o-mat log level can be increased by enabling the debug<o:p></o:p></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">flag.<o:p></o:p></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">regards, rene<o:p></o:p></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p><div><div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm"><p class="MsoNormal"><b><span lang="DE" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:windowtext">Von:</span></b><span lang="DE" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:windowtext"> Spce-user [mailto:spce-user-bounces@lists.sipwise.com] <b>Im Auftrag von </b>Medve István<br><b>Gesendet:</b> Dienstag, 1. November 2016 22:59<br><b>An:</b> spce-user@lists.sipwise.com<br><b>Betreff:</b> [Spce-user] rate-o-mat<o:p></o:p></span></p></div></div><p class="MsoNormal"><o:p> </o:p></p><div><p class="MsoNormal">Hi All,<o:p></o:p></p></div><div><p class="MsoNormal"><o:p> </o:p></p></div><div><p class="MsoNormal">i can see the following messages periodically:<o:p></o:p></p></div><div><p class="MsoNormal"><o:p> </o:p></p></div><div><p class="MsoNormal"><span style="font-family:"Courier New";color:black;background:white">rate-o-mat: DBD::mysql::db do failed: MySQL server has gone </span><span style="font-family:"Courier New"">away at /usr/sbin/rate-o-mat line 291. <br>rate-o-mat: rollback ineffective with AutoCommit enabled at /usr/sbin/rate-o-mat line 312. <br>rate-o-mat: rollback ineffective with AutoCommit enabled at /usr/sbin/rate-o-mat line 312. <br>rate-o-mat: rollback ineffective with AutoCommit enabled at /usr/sbin/rate-o-mat line 312.</span><o:p></o:p></p></div><div><p class="MsoNormal"><o:p> </o:p></p></div><div><p class="MsoNormal"><span style="font-family:"Courier New"">Everything seems to work fine, no mysql issues. I have no ideal why these messages appear.</span><o:p></o:p></p></div><div><p class="MsoNormal"><o:p> </o:p></p></div><div><p class="MsoNormal">I use CE mr4.4.1<o:p></o:p></p></div><div><p class="MsoNormal"><o:p> </o:p></p></div><div><p class="MsoNormal">Could someone give me any hint ?<o:p></o:p></p></div><div><p class="MsoNormal"><o:p> </o:p></p></div><div><p class="MsoNormal">Regards,<o:p></o:p></p></div><div><p class="MsoNormal">imedve<o:p></o:p></p></div><div><p class="MsoNormal"><o:p> </o:p></p></div></div></blockquote></body></html>