[Spce-user] URGENT: mysql database ist growing until disk is full (mr6.5.4.1)

Alex Lutay alutay at sipwise.com
Fri May 10 07:15:21 EDT 2019


There is a process mediator which converts accounting
into CDRs. Accounting are stored into Redis, and for some
reason you have a garbage? there. It should be investigated
and fixed, as it is the origin of the problem:

>> May 10 07:24:04 spce (warning) mediator[5130]: medredis.c:303
>> [medredis_check_reply_string]: Received Redis reply type 4 instead of 1
>> (string) for branch_id field of cid '3218c40fc8dc84f2' using key
>> 'acc:entry::3218c40fc8dc84f2:1556875485.599718'

Meanwhile all accounting which were not converted into CDRs are stored
into acc_trash for further investigation. I would say you have too much
of them. As a fast solution for weekend and I hint you to dump/backup
acc_trash (just in case) and truncate the table to have a time with
investigation of mediator<->redis issue.

On 5/10/19 12:55 PM, Thomas Georg wrote:
> -rw-rw----  1 mysql mysql  62G May 10 12:41 acc_trash.ibd
> It seems that kamilio is eating all of our disk-space.

> Why do we get as much  of „trash“? How can we stop that and delete the
> „trash“?

Alex Lutay

More information about the Spce-user mailing list