Backup-data failed due to mysql table

Support
, ,
1

Good evening,

Since one week ago, I made some regular software update from the software center.
Then i received some mail when my backup-data task failed to start.
So I read the /var/log/messages and found this:

Jan 16 14:26:18 mail esmith::event[17515]: ===== Report for configuration backup =====
Jan 16 14:26:18 mail esmith::event[17515]: Backup started at 2021-01-16 14:26:18
Jan 16 14:26:18 mail esmith::event[17608]: Event: pre-backup-config
Jan 16 14:26:18 mail esmith::event[17608]: expanding /etc/backup-config.d/nethserver-sssd.include
Jan 16 14:26:18 mail esmith::event[17608]: Action: /etc/e-smith/events/actions/generic_template_expand SUCCESS [0.12535]
Jan 16 14:26:18 mail esmith::event[17608]: Action: /etc/e-smith/events/pre-backup-config/S20nethserver-directory-dump-ldap SUCCESS [0.046609]
Jan 16 14:26:18 mail esmith::event[17608]: Action: /etc/e-smith/events/pre-backup-config/S40nethserver-mail-shrmbx-cfgbackup SUCCESS [0.011668]
Jan 16 14:26:18 mail esmith::event[17608]: Action: /etc/e-smith/events/pre-backup-config/S40nethserver-sssd-backup-tdb SUCCESS [0.003177]
Jan 16 14:26:20 mail esmith::event[17608]: Action: /etc/e-smith/events/pre-backup-config/S50nethserver-backup-config-list-packages SUCCESS [2.088627]
Jan 16 14:26:20 mail esmith::event[17608]: Event: pre-backup-config SUCCESS
Jan 16 14:26:20 mail esmith::event[17515]: Event pre-backup-config: SUCCESS
Jan 16 14:26:21 mail esmith::event[17515]: Action backup-config-execute: SUCCESS
Jan 16 14:26:21 mail esmith::event[18433]: Event: post-backup-config
Jan 16 14:26:21 mail esmith::event[18433]: Event: post-backup-config SUCCESS
Jan 16 14:26:21 mail esmith::event[17515]: Event post-backup-config: SUCCESS
Jan 16 14:26:21 mail esmith::event[17515]: Backup status: SUCCESS
Jan 16 14:26:21 mail esmith::event[17515]: Backup ended at 2021-01-16 14:26:21
Jan 16 14:26:21 mail esmith::event[17515]: Time elapsed: 0 hours, 0 minutes, 3 seconds
Jan 16 14:26:21 mail esmith::event[17515]: Action: /etc/e-smith/events/pre-backup-data/S20nethserver-backup-config-predatabackup SUCCESS [3.087426]
Jan 16 14:26:22 mail esmith::event[17515]: mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table sogo_cache_folder_marino_D_gentile at row: 96
Jan 16 14:26:22 mail esmith::event[17515]: Action: /etc/e-smith/events/pre-backup-data/S50mysql-dump-tables FAILED: 1 [1.325041]
Jan 16 14:26:22 mail esmith::event[17515]: Action: /etc/e-smith/events/pre-backup-data/S80nethserver-sogo-backup-users SUCCESS [0.229221]
Jan 16 14:26:22 mail esmith::event[17515]: Event: pre-backup-data FAILED
Jan 16 14:26:29 mail systemd: cockpit-backup-data-backup-data.service: main process exited, code=exited, status=1/FAILURE
Jan 16 14:26:29 mail systemd: Unit cockpit-backup-data-backup-data.service entered failed state.
Jan 16 14:26:29 mail systemd: cockpit-backup-data-backup-data.service failed.

Searching on the net, I tried to make a manual mysqldump and some command to repair and optimize the tables, but I always have this error:
mysqldump: Error 2013: Lost connection to MySQL server…

Can I drop and re-create that table in a secure way? It can affect the user mailbox? I use SOGo for ActiveSync mail service

Thank you

2

How big is the table?
Do you get the same error if manually running mysqldump with --max_allowed_packet=128M parameter (128M is just an example)?

3

Hi,

Is there a specific command to know how big is the table? The user mailbox is about 20GB.

I’m trying that, but I have the same error (related to that table).
I also try to increase value of --max_allowed_packet to 1024M and this error appear:

mysqldump: Got error: 2013: "Lost connection to MySQL server during query" when using LOCK TABLES

Any idea?
Thanks

4

Easily seen using phpmyadmin. Command could be as per

5

Hi

I’ve had that error on a well used server…
A reboot solved that. The same error didn’t turn up, and export (dump) worked…

Turn off sogo from services!

My 2 cents
Andy