[Spce-user] cdr error

[Rene Krenn]

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?

 

regards

 

Von: Spce-user [mailto:spce-user-bounces at lists.sipwise.com] Im Auftrag von David Martínez
Gesendet: Montag, 29. Mai 2017 13:07
An: spce-user at lists.sipwise.com
Betreff: [Spce-user] cdr error

 

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/pipermail/spce-user_lists.sipwise.com/attachments/20170529/39f75171/attachment-0001.html>