[Spce-user] ERROR: accounting.cdr is too big on localhost:3306 for an upgrade: 6945390 rows
Oscar Javier Bello Pérez
oscar.bello at dialapplet.com
Mon Apr 10 15:18:14 EDT 2023
Ensure you have at least 80GB of free space on disk, then open a screen
<https://linuxize.com/post/how-to-use-linux-screen/> session and run
this command:
ngcp-cleanup-cdr-files
This command will take a very long time to execute if there is no
previous CDR maintenance.
Don't do it on production time.
Regards!
On 10/04/23 1:49 p. m., Dhaniels Nieto wrote:
> 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
> /
>
--
Oscar Bello
Departamento de Telefonía
Facebook icon <https://www.facebook.com/Dialapplet> LinkedIn icon
<https://www.linkedin.com/company/dialapplet> Twitter icon
<https://twitter.com/Dialapplet> Youtube icon
<https://www.dialapplet.com> Instagram icon <mailto:info at dialapplet.com>
Logo <https://www.dialapplet.com/> T: (+57) 601 914 4999
E: oscar.bello at dialapplet.com
W: www.dialapplet.com <https://www.dialapplet.com> Colombia
110221 Bogotá, D.C.
Calle 99 No. 10 - 19 Piso 4
AVISO DE CONFIDENCIALIDAD
Le informamos, como destinatario de este mensaje, que el correo
electrónico vía Internet no permite asegurar la confidencialidad de los
mensajes transmitidos ni su integridad o correcta recepción. Si no
consintiera la utilización del correo electrónico vía Internet, rogamos
nos lo comunique de forma inmediata. Este mensaje va dirigido de manera
exclusiva a su destinatario y puede contener información confidencial
cuya divulgación está prohibida por la ley. Si ha recibido este mensaje
por error, le rogamos nos lo comunique de forma inmediata por esta misma
vía y proceda a su eliminación, así como a la de cualquier documento
adjunto al mismo. Asímismo, si no es el destinatario del mensaje, se le
informa de que su lectura, copia, distribución y utilización, así como
la de cualquier documento adjunto, sea cual sea su finalidad, están
prohibidas.
CONFIDENTIALITY WARNING
We hereby inform you, as addressee of this message, that Internet e-mail
neither guarantees the confidentiality nor the completeness or proper
receipt of the messages sent. If you do not consent to the use of
Internet e-mail, please notify us immediately. This message is intended
exclusively for its addressee and may contain confidential information
protected from disclosure by law. If you have received this message in
error, please immediately notify us via e-mail and delete it and any
attachment. If you are not the addressee indicated in this message,
please be informed that any reading, copy, distribution or use of it or
its attachments, for any purpose, is forbidden.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20230410/163e997c/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: kecoiocnahigkiji.png
Type: image/png
Size: 1571 bytes
Desc: not available
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20230410/163e997c/attachment-0006.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: fppenogfilknkcal.png
Type: image/png
Size: 1670 bytes
Desc: not available
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20230410/163e997c/attachment-0007.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: dahbaojdoeldebdk.png
Type: image/png
Size: 1873 bytes
Desc: not available
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20230410/163e997c/attachment-0008.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pdknpleieokipgfe.png
Type: image/png
Size: 1792 bytes
Desc: not available
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20230410/163e997c/attachment-0009.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: mbbndiolfplpfmic.png
Type: image/png
Size: 1768 bytes
Desc: not available
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20230410/163e997c/attachment-0010.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: mgmfkghodddclcml.png
Type: image/png
Size: 17697 bytes
Desc: not available
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20230410/163e997c/attachment-0011.png>
More information about the Spce-user
mailing list