Hi,
We’ve noticed that jetbackup plugin isn’t able to take backups of databases when WP Cerber is active.
This is what the company we rent our dedicated servers from, has told to us:
It looks like the backups were failing because of cerber. There are a few databases with the same issue, its odd because its all cerber.
[23 May 2024 03:05:19 AM -0500] [ERROR] mysqldump: Error 2013: Lost connection to server during query when dumping table wp_cerber_sets at row: 16
Something about this table was corrupt causing the backup to fail
Couple others sites beside those 2 mentioned by you:
[23 May 2024 05:58:35 AM -0500] [ERROR] mysqldump: Couldn’t execute ‘show create table cerber_lab’: Can’t find file: ‘./{cpanel_user}/cerber_lab.MYI’ (errno: 2 “No such file or directory”) (1017)
[23 May 2024 01:03:16 AM -0500] [ERROR] mysqldump: Couldn’t execute ‘show create table cerber_lab’: Can’t find file: ‘./YYYother_cpanel_user/cerber_lab.MYI’ (errno: 2 “No such file or directory”) (1017)
I’ve removed those missing tables and since importing the database you provided not seen any issues.
We’re using the free cerber on quite a handful of sites hence pointing this out.
PHP version from 7.4 to 8.0
| Server Version | 10.6.18-MariaDB |
|---|---|
| Extension | mysqli |
| Client Version | 80030 (8.0.30) |
| Host | localhost |
| innodb_buffer_pool_size | 3221225472 (~3 GB) |
| key_buffer_size | 134217728 (~128 MB) |
| max_allowed_packet | 268435456 (~256 MB) |
| max_connections | 400 |
We’ve recently upgraded MariaDB (maybe 1 month ago) and half a year ago it surely worked just fine (referring to jetbackups)