[Spce-user] ERROR: accounting.cdr is too big on localhost:3306 for an upgrade: 6945390 rows
Dhaniels Nieto
dhanielsnieto at gmail.com
Mon Apr 10 16:28:14 EDT 2023
Thanks Oscar, but the issue still persists, and looks like the table "cdr"
of the "accounting" database is the main reason for the error.
any other solution?
Regards!
--
*Dhaniels Nieto*
*+1 787 7108591*
*+57 320 5153851*
El lun, 10 abr 2023 a las 15:18, Oscar Javier Bello Pérez (<
oscar.bello at dialapplet.com>) escribió:
> 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
> [image: Facebook icon] <https://www.facebook.com/Dialapplet> [image:
> LinkedIn icon] <https://www.linkedin.com/company/dialapplet> [image:
> Twitter icon] <https://twitter.com/Dialapplet> [image: Youtube icon]
> <https://www.dialapplet.com> [image: Instagram icon] <info at dialapplet.com>
>
> [image: Logo] <https://www.dialapplet.com/> T: (+57) 601 914 4999
> E: oscar.bello at dialapplet.com
> W: 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/2128ff26/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/2128ff26/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/2128ff26/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/2128ff26/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/2128ff26/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/2128ff26/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/2128ff26/attachment-0011.png>
More information about the Spce-user
mailing list