[Spce-user] cdr error

[David Martínez]

Hi,

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:

May 24 13:31:31 sip00 mediator[28631]: Locking process.
May 24 13:31:31 sip00 mediator[28631]: Daemonizing process.
May 24 13:31:31 sip00 mediator[28632]: Writing pid file.
May 24 13:31:31 sip00 mediator[28632]: ACC acc database host='localhost', port='3306', user='kamailio', name='kamailio'
May 24 13:31:31 sip00 mediator[28632]: CDR acc database host='localhost', port='3306', user='mediator', name='accounting'
May 24 13:31:31 sip00 mediator[28632]: PROV database host='localhost', port='3306', user='mediator', name='provisioning'
May 24 13:31:31 sip00 mediator[28632]: STATS database host='localhost', port='3306', user='mediator', name='stats'
May 24 13:31:31 sip00 mediator[28632]: Setting up mysql connections.
May 24 13:31:31 sip00 mediator[28632]: Up and running, daemonized=1, pid-path='/var/run/mediator.pid', interval=10
May 24 13:37:12 sip00 mediator[28632]: Lost connection to SQL server during query, retrying...
May 24 13:37:22 sip00 mediator[28632]: Lost connection to SQL server during query, retrying...
May 24 13:37:32 sip00 mediator[28632]: Overall 93418 CDRs created so far.
May 24 13:43:06 sip00 mediator[28632]: Lost connection to SQL server during query, retrying...
May 24 13:43:16 sip00 mediator[28632]: Lost connection to SQL server during query, retrying...
May 24 13:43:26 sip00 mediator[28632]: Overall 186855 CDRs created so far.

After some days, i see that log says:

May 29 11:06:31 sip00 mediator[28632]: Overall 118815884 CDRs created so far.
May 29 11:13:55 sip00 mediator[28632]: Lost connection to SQL server during query, retrying...
May 29 11:14:05 sip00 mediator[28632]: Lost connection to SQL server during query, retrying...
May 29 11:14:15 sip00 mediator[28632]: Overall 118916574 CDRs created so far.
May 29 11:21:10 sip00 mediator[28632]: Lost connection to SQL server during query, retrying...
May 29 11:21:20 sip00 mediator[28632]: Lost connection to SQL server during query, retrying...
May 29 11:21:30 sip00 mediator[28632]: Overall 119017291 CDRs created so far.
May 29 11:28:18 sip00 mediator[28632]: Lost connection to SQL server during query, retrying...
May 29 11:28:28 sip00 mediator[28632]: Lost connection to SQL server during query, retrying...
May 29 11:28:38 sip00 mediator[28632]: Overall 119118049 CDRs created so far.
May 29 11:34:32 sip00 mediator[28632]: Lost connection to SQL server during query, retrying...
May 29 11:34:42 sip00 mediator[28632]: Lost connection to SQL server during query, retrying...
May 29 11:34:52 sip00 mediator[28632]: Overall 119218842 CDRs created so far.
May 29 11:41:24 sip00 mediator[28632]: Lost connection to SQL server during query, retrying...
May 29 11:41:34 sip00 mediator[28632]: Lost connection to SQL server during query, retrying...
May 29 11:41:44 sip00 mediator[28632]: Overall 119319664 CDRs created so far.


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:

Apr  4 11:38:08 sip00 mediator[3948]: Overall 3038 CDRs created so far.
Apr  4 11:38:32 sip00 mediator[3948]: Overall 3039 CDRs created so far.
Apr  4 11:38:45 sip00 mediator[3948]: Overall 3040 CDRs created so far.
Apr  4 11:38:58 sip00 mediator[3948]: Error getting acc callids: Server shutdown in progress
Apr  4 11:38:58 sip00 mediator[3948]: Shutting down.
Apr  4 11:38:58 sip00 mediator[3948]: Successfully shut down.
Apr  4 11:38:58 sip00 mediator[3948]: Unlocking mediator.

 I searched on mailing list (using google cache, because server is down now) and i didn’t found how to debug mediator.

Can anyone help?

Regards
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/mailman/private/spce-user_lists.sipwise.com/attachments/20170529/70ed5235/attachment.html>