lpinsivy
commented
2 years ago Hi @tlierdotfr,
What is the size of your centreon_storage database?
Open tlierdotfr opened 2 years ago
lpinsivy
commented
2 years ago Hi @tlierdotfr,
What is the size of your centreon_storage database?
tlierdotfr
commented
2 years ago Hi @lpinsivy , thanks for your reply.
Our DB backup Full file is about 1.6Go.
And you can find below the information about DB Statistics on Centreon Admin page :
lpinsivy
commented
2 years ago How often do you make a full backup?
During the full backup, MySQL is stoped to make a mysqldump.
It look like Centreon Broker can't reconnect by itself and you need to restart the process. We will deliver soon a new version of Centreon Broker to improve reconnection.
Regards,
tlierdotfr
commented
2 years ago We have let the default parameters for Centreon backup, so a backup full every Sunday :
But the issue seems also to occur during DIFF Backups. For instance, in previous logs, the issue occured on Monday 3rd of January
lpinsivy
commented
2 years ago We know this issue and we have an internal ticket MON-11846.
We will make a fix asap.
Can you give us your filesystem description using "$ df -h"
Regards,
tlierdotfr
commented
2 years ago Here it is :
Filesystem Size Used Avail Use% Mounted on
devtmpfs 1.9G 0 1.9G 0% /dev
tmpfs 1.9G 0 1.9G 0% /dev/shm
tmpfs 1.9G 185M 1.7G 10% /run
tmpfs 1.9G 0 1.9G 0% /sys/fs/cgroup
/dev/mapper/centos_centreon--central-root 20G 3.0G 16G 16% /
/dev/sda1 969M 152M 751M 17% /boot
/dev/mapper/centos_centreon--central-var_log 9.8G 395M 8.9G 5% /var/log
/dev/mapper/centos_centreon--central-var_lib_mysql 16G 7.3G 7.7G 49% /var/lib/mysql
/dev/mapper/centos_centreon--central-var_lib_centreon 6.8G 3.9G 2.6G 60% /var/lib/centreon
/dev/mapper/centos_centreon--central-var_cache_centreon_backup 4.8G 3.7G 879M 82% /var/cache/centreon/backup
/dev/mapper/centos_centreon--central-var_lib_centreon--broker 4.8G 20M 4.6G 1% /var/lib/centreon-broker
tmpfs 379M 0 379M 0% /run/user/0
BUG REPORT INFORMATION
Prerequisites
Versions
For the RPM based systems
Operating System
Browser used
Additional environment details (AWS):
Description
Every few days, our Centreon platform seems to be frozen. Every pollers are RED and every Services and Host are Unknown. Although all perfdata are still OK. It's only services/host status that are not anymore updated.
It seems to occur sometimes after the Centreon backup process (at 3h30 in the morning).
Each time, we have to manually restart CBD process in order to get everything back to normal.
Logs
centreon-engine logs => OK events are still getting on Central
centreon-broker logs
HERE is the issue: When we have the problem here is what the LOG looks like : It seems to occur after the backup process.
When we DO NOT have the problem here is what the LOG looks like :
centreon gorgone logs
=> Looks OK.
Centreon backup logs
Additional relevant information (e.g. frequency, ...)
It occurs once every few days (5/10 days).