[Spce-user] ERROR: accounting.cdr is too big on localhost:3306 for an upgrade: 6945390 rows

[Dhaniels Nieto]

Hello, I hope you are doing well.
today i logged into my system to verify that everything is working
as expected, and then try to update to a more recent version.
after entered the command: ngcp-status i see a warning wich says:
"accounting.cdr is too big on localhost:3306 for an upgrade: 6945390 rows"
and the HDD is almost full.
This server has been running with no issues for more than 3 years.

How can I fix this problem?

here is the full output:

root at grml:~# ngcp-status
+---------------------------+----------------------------------------------
2023-04-10 20:39:09 -+
| 149.XX.XX.XX             | NGCP: CE mr9.1.1          nodes setup
               [  ] |
| grml                      | NGCP: subscribers:189 locations:121 calls:49
                      |
| grml.                     |   OS: buster (10.7) 4.19.0-13-amd64 SMP
(ext4)                     |
| (PRODUCTION - ACTIVE)     |  CPU: 8 = 2 x Common KVM processor (HT)
                     |
|                           |   HW: Standard PC (i440FX + PIIX, 1996) by
QEMU                    |
|                           | BIOS: rel-1.16.1-0-g3208b0... (04/01/2014) by
SeaBIOS              |
|                           |  RAM: 15Gi (used 13%/cache 79%)
kamailio[7.9%] influxd[3.1%]       |
|                           |   LA: system load OK: 0.39 0.79 0.81
                      |
|                           | DISK: /dev/sda [HDD] /dev/sr0 [CDROM]
                     |
|                           ! DISK: space used /[91%]
                     |
|                           | DISK: inodes in use /[4%]
                     |
|                           |  CFG: [5aaf0b2] net  (6 weeks ago)
                      |
|                           ? NGCP: allowed root remote SSH by password,
use 'prohibit-password' |
|                           ?   DB: accounting.cdr is too big on
localhost:3306 for an upgrade: 6945390 rows |
|                           | MODs: License OFF, Fax ON,
                      |
+-------------------5 sec---+-----
 ---------------------------------------9.1.1.1+0~mr9.1.1.1---+


-- 
*Dhaniels Nieto*
*+1 787 7108591*

*+57 320 5153851*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20230410/9fbfc996/attachment.html>