<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title></title>
</head>
<body>
<div name="messageBodySection" style="font-size: 14px; font-family: -apple-system, BlinkMacSystemFont, sans-serif;">Hi Rene,
<div><br /></div>
<div>SPCE version is 3.8.8 LTS. Mediator version is 1.2.0.</div>
<div><br /></div>
<div>Regards.</div>
</div>
<div name="messageReplySection" style="font-size: 14px; font-family: -apple-system, BlinkMacSystemFont, sans-serif;"><br />
On 29 may 2017 14:44 +0200, Rene Krenn <rkrenn@sipwise.com>, wrote:<br />
<blockquote type="cite" style="margin: 5px 5px; padding-left: 10px; border-left: thin solid #1abc9c;">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">There was a fix for mediator to gracefully handly large numbers of records in kamailio.acc (eg. as a consequence of long mediator inactivity), which version are you running?</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"> </span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">regards</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"> </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" xml:lang="DE">Von:</span></b> <span lang="DE" style="font-size:11.0pt;font-family:"Calibri",sans-serif" xml:lang="DE">Spce-user [mailto:spce-user-bounces@lists.sipwise.com] <b>Im Auftrag von</b> David Martínez<br />
<b>Gesendet:</b> Montag, 29. Mai 2017 13:07<br />
<b>An:</b> spce-user@lists.sipwise.com<br />
<b>Betreff:</b> [Spce-user] cdr error</span></p>
</div>
</div>
<p class="MsoNormal"> </p>
<div name="messageBodySection">
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Arial",sans-serif">Hi,</span></p>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Arial",sans-serif"> </span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Arial",sans-serif">Since some days ago, cdr stops working. Seeing whats happening I noticed that mediator service was not running. So i started it and then i see this on cdr.log file:</span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Arial",sans-serif"> </span></p>
</div>
<div>
<div>
<div>
<p class="MsoNormal"><i><span style="font-size:10.5pt;font-family:"Arial",sans-serif">May 24 13:31:31 sip00 mediator[28631]: Locking process.</span></i></p>
</div>
<div>
<p class="MsoNormal"><i><span style="font-size:10.5pt;font-family:"Arial",sans-serif">May 24 13:31:31 sip00 mediator[28631]: Daemonizing process.</span></i></p>
</div>
<div>
<p class="MsoNormal"><i><span style="font-size:10.5pt;font-family:"Arial",sans-serif">May 24 13:31:31 sip00 mediator[28632]: Writing pid file.</span></i></p>
</div>
<div>
<p class="MsoNormal"><i><span style="font-size:10.5pt;font-family:"Arial",sans-serif">May 24 13:31:31 sip00 mediator[28632]: ACC acc database host='localhost', port='3306', user='kamailio', name='kamailio'</span></i></p>
</div>
<div>
<p class="MsoNormal"><i><span style="font-size:10.5pt;font-family:"Arial",sans-serif">May 24 13:31:31 sip00 mediator[28632]: CDR acc database host='localhost', port='3306', user='mediator', name='accounting'</span></i></p>
</div>
<div>
<p class="MsoNormal"><i><span style="font-size:10.5pt;font-family:"Arial",sans-serif">May 24 13:31:31 sip00 mediator[28632]: PROV database host='localhost', port='3306', user='mediator', name='provisioning'</span></i></p>
</div>
<div>
<p class="MsoNormal"><i><span style="font-size:10.5pt;font-family:"Arial",sans-serif">May 24 13:31:31 sip00 mediator[28632]: STATS database host='localhost', port='3306', user='mediator', name='stats'</span></i></p>
</div>
<div>
<p class="MsoNormal"><i><span style="font-size:10.5pt;font-family:"Arial",sans-serif">May 24 13:31:31 sip00 mediator[28632]: Setting up mysql connections.</span></i></p>
</div>
<div>
<p class="MsoNormal"><i><span style="font-size:10.5pt;font-family:"Arial",sans-serif">May 24 13:31:31 sip00 mediator[28632]: Up and running, daemonized=1, pid-path='/var/run/mediator.pid', interval=10</span></i></p>
</div>
<div>
<p class="MsoNormal"><i><span style="font-size:10.5pt;font-family:"Arial",sans-serif">May 24 13:37:12 sip00 mediator[28632]: Lost connection to SQL server during query, retrying...</span></i></p>
</div>
<div>
<p class="MsoNormal"><i><span style="font-size:10.5pt;font-family:"Arial",sans-serif">May 24 13:37:22 sip00 mediator[28632]: Lost connection to SQL server during query, retrying...</span></i></p>
</div>
<div>
<p class="MsoNormal"><i><span style="font-size:10.5pt;font-family:"Arial",sans-serif">May 24 13:37:32 sip00 mediator[28632]: Overall 93418 CDRs created so far.</span></i></p>
</div>
<div>
<p class="MsoNormal"><i><span style="font-size:10.5pt;font-family:"Arial",sans-serif">May 24 13:43:06 sip00 mediator[28632]: Lost connection to SQL server during query, retrying...</span></i></p>
</div>
<div>
<p class="MsoNormal"><i><span style="font-size:10.5pt;font-family:"Arial",sans-serif">May 24 13:43:16 sip00 mediator[28632]: Lost connection to SQL server during query, retrying...</span></i></p>
</div>
<div>
<p class="MsoNormal"><i><span style="font-size:10.5pt;font-family:"Arial",sans-serif">May 24 13:43:26 sip00 mediator[28632]: Overall 186855 CDRs created so far.</span></i></p>
</div>
</div>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Arial",sans-serif"> </span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Arial",sans-serif">After some days, i see that log says:</span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Arial",sans-serif"> </span></p>
</div>
<div>
<div>
<p class="MsoNormal"><i><span style="font-size:10.5pt;font-family:"Arial",sans-serif">May 29 11:06:31 sip00 mediator[28632]: Overall 118815884 CDRs created so far.</span></i></p>
</div>
<div>
<p class="MsoNormal"><i><span style="font-size:10.5pt;font-family:"Arial",sans-serif">May 29 11:13:55 sip00 mediator[28632]: Lost connection to SQL server during query, retrying...</span></i></p>
</div>
<div>
<p class="MsoNormal"><i><span style="font-size:10.5pt;font-family:"Arial",sans-serif">May 29 11:14:05 sip00 mediator[28632]: Lost connection to SQL server during query, retrying...</span></i></p>
</div>
<div>
<p class="MsoNormal"><i><span style="font-size:10.5pt;font-family:"Arial",sans-serif">May 29 11:14:15 sip00 mediator[28632]: Overall 118916574 CDRs created so far.</span></i></p>
</div>
<div>
<p class="MsoNormal"><i><span style="font-size:10.5pt;font-family:"Arial",sans-serif">May 29 11:21:10 sip00 mediator[28632]: Lost connection to SQL server during query, retrying...</span></i></p>
</div>
<div>
<p class="MsoNormal"><i><span style="font-size:10.5pt;font-family:"Arial",sans-serif">May 29 11:21:20 sip00 mediator[28632]: Lost connection to SQL server during query, retrying...</span></i></p>
</div>
<div>
<p class="MsoNormal"><i><span style="font-size:10.5pt;font-family:"Arial",sans-serif">May 29 11:21:30 sip00 mediator[28632]: Overall 119017291 CDRs created so far.</span></i></p>
</div>
<div>
<p class="MsoNormal"><i><span style="font-size:10.5pt;font-family:"Arial",sans-serif">May 29 11:28:18 sip00 mediator[28632]: Lost connection to SQL server during query, retrying...</span></i></p>
</div>
<div>
<p class="MsoNormal"><i><span style="font-size:10.5pt;font-family:"Arial",sans-serif">May 29 11:28:28 sip00 mediator[28632]: Lost connection to SQL server during query, retrying...</span></i></p>
</div>
<div>
<p class="MsoNormal"><i><span style="font-size:10.5pt;font-family:"Arial",sans-serif">May 29 11:28:38 sip00 mediator[28632]: Overall 119118049 CDRs created so far.</span></i></p>
</div>
<div>
<p class="MsoNormal"><i><span style="font-size:10.5pt;font-family:"Arial",sans-serif">May 29 11:34:32 sip00 mediator[28632]: Lost connection to SQL server during query, retrying...</span></i></p>
</div>
<div>
<p class="MsoNormal"><i><span style="font-size:10.5pt;font-family:"Arial",sans-serif">May 29 11:34:42 sip00 mediator[28632]: Lost connection to SQL server during query, retrying...</span></i></p>
</div>
<div>
<p class="MsoNormal"><i><span style="font-size:10.5pt;font-family:"Arial",sans-serif">May 29 11:34:52 sip00 mediator[28632]: Overall 119218842 CDRs created so far.</span></i></p>
</div>
<div>
<p class="MsoNormal"><i><span style="font-size:10.5pt;font-family:"Arial",sans-serif">May 29 11:41:24 sip00 mediator[28632]: Lost connection to SQL server during query, retrying...</span></i></p>
</div>
<div>
<p class="MsoNormal"><i><span style="font-size:10.5pt;font-family:"Arial",sans-serif">May 29 11:41:34 sip00 mediator[28632]: Lost connection to SQL server during query, retrying...</span></i></p>
</div>
<div>
<p class="MsoNormal"><i><span style="font-size:10.5pt;font-family:"Arial",sans-serif">May 29 11:41:44 sip00 mediator[28632]: Overall 119319664 CDRs created so far.</span></i></p>
</div>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Arial",sans-serif"> </span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Arial",sans-serif"> </span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Arial",sans-serif">I think that our system is too young to have that number of calls, so i search log file when mediator stops and i see:</span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Arial",sans-serif"> </span></p>
</div>
<div>
<div>
<p class="MsoNormal"><i><span style="font-size:10.5pt;font-family:"Arial",sans-serif">Apr 4 11:38:08 sip00 mediator[3948]: Overall 3038 CDRs created so far.</span></i></p>
</div>
<div>
<p class="MsoNormal"><i><span style="font-size:10.5pt;font-family:"Arial",sans-serif">Apr 4 11:38:32 sip00 mediator[3948]: Overall 3039 CDRs created so far.</span></i></p>
</div>
<div>
<p class="MsoNormal"><i><span style="font-size:10.5pt;font-family:"Arial",sans-serif">Apr 4 11:38:45 sip00 mediator[3948]: Overall 3040 CDRs created so far.</span></i></p>
</div>
<div>
<p class="MsoNormal"><i><span style="font-size:10.5pt;font-family:"Arial",sans-serif">Apr 4 11:38:58 sip00 mediator[3948]: Error getting acc callids: Server shutdown in progress</span></i></p>
</div>
<div>
<p class="MsoNormal"><i><span style="font-size:10.5pt;font-family:"Arial",sans-serif">Apr 4 11:38:58 sip00 mediator[3948]: Shutting down.</span></i></p>
</div>
<div>
<p class="MsoNormal"><i><span style="font-size:10.5pt;font-family:"Arial",sans-serif">Apr 4 11:38:58 sip00 mediator[3948]: Successfully shut down.</span></i></p>
</div>
<div>
<p class="MsoNormal"><i><span style="font-size:10.5pt;font-family:"Arial",sans-serif">Apr 4 11:38:58 sip00 mediator[3948]: Unlocking mediator.</span></i></p>
</div>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Arial",sans-serif"> </span></p>
</div>
<div>
<p class="MsoNormal"><i><span style="font-size:10.5pt;font-family:"Arial",sans-serif"> </span></i><span style="font-size:10.5pt;font-family:"Arial",sans-serif">I searched on mailing list (using google cache, because server is down now) and i didn’t found how to debug mediator.</span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Arial",sans-serif"> </span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Arial",sans-serif">Can anyone help?</span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Arial",sans-serif"> </span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Arial",sans-serif">Regards</span></p>
</div>
</div>
</div>
</blockquote>
</div>
</body>
</html>