[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 16:35:48 EDT 2023
ngcp-cleanup-acc
On 10/04/23 3:28 p. m., Dhaniels Nieto wrote:
>> 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 <mailto: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
> 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 <mailto: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.
>
>
>
> --
>
--
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/a4d08657/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/a4d08657/attachment-0012.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/a4d08657/attachment-0013.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/a4d08657/attachment-0014.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/a4d08657/attachment-0015.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/a4d08657/attachment-0016.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/a4d08657/attachment-0017.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: fbijnabgkkpleelg.png
Type: image/png
Size: 1571 bytes
Desc: not available
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20230410/a4d08657/attachment-0018.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: oofpcmkkpjkicfmd.png
Type: image/png
Size: 1670 bytes
Desc: not available
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20230410/a4d08657/attachment-0019.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: bbadkbeiapijaamo.png
Type: image/png
Size: 1873 bytes
Desc: not available
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20230410/a4d08657/attachment-0020.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: njiadgcpcechnpmn.png
Type: image/png
Size: 1792 bytes
Desc: not available
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20230410/a4d08657/attachment-0021.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: bfacpdlcfbaajljn.png
Type: image/png
Size: 1768 bytes
Desc: not available
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20230410/a4d08657/attachment-0022.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: gmbmkimacblifenm.png
Type: image/png
Size: 17697 bytes
Desc: not available
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20230410/a4d08657/attachment-0023.png>
More information about the Spce-user
mailing list