We’re running 22.10 and for the 2nd time in 8 months, our partition is nearly full
[root]# df -h /var/lib/mysql
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/centos_centreon--central-var_lib_mysql 94G 87G 3.3G 97% /var/lib/mysql
We restarted the system and run yum updates daily
[root]# rpm -qa | grep centreon | egrep -v "(plugin|pack|widget)"
centreon-common-22.10.11-1.el7.noarch
centreon-broker-cbmod-22.10.4-1.el7.x86_64
centreon-gorgoned-selinux-0.0.4-1.x86_64
centreon-auto-discovery-server-22.10.2-1.el7.noarch
centreon-pp-manager-22.10.0-6.el7.centos.noarch
centreon-broker-22.10.4-1.el7.x86_64
centreon-release-22.10-1.el7.centos.noarch
centreon-engine-22.10.4-1.el7.x86_64
centreon-central-22.10.11-1.el7.noarch
centreon-license-manager-common-22.10.1-1.el7.noarch
centreon-broker-core-22.10.4-1.el7.x86_64
centreon-connector-ssh-22.10.4-1.el7.x86_64
centreon-22.10.11-1.el7.noarch
centreon-common-selinux-0.0.11-1.x86_64
centreon-engine-extcommands-22.10.4-1.el7.x86_64
centreon-web-22.10.11-1.el7.noarch
centreon-nrpe3-daemon-4.0.3-0.el7.centos.x86_64
centreon-gorgone-22.10.2-1.el7.noarch
centreon-connector-perl-22.10.4-1.el7.x86_64
centreon-database-22.10.11-1.el7.noarch
centreon-engine-daemon-22.10.4-1.el7.x86_64
centreon-poller-22.10.11-1.el7.noarch
centreon-business-release-21.10-5.el8.noarch
centreon-trap-22.10.11-1.el7.noarch
centreon-web-selinux-0.0.8-1.x86_64
centreon-connector-22.10.4-1.el7.x86_64
centreon-broker-selinux-0.0.6-1.x86_64
centreon-clib-22.10.4-1.el7.x86_64
centreon-gorgone-centreon-config-22.10.2-1.el7.noarch
centreon-perl-libs-22.10.11-1.el7.noarch
centreon-broker-cbd-22.10.4-1.el7.x86_64
centreon-engine-selinux-0.0.10-1.x86_64
centreon-license-manager-22.10.1-1.el7.noarch
centreon-broker-storage-22.10.4-1.el7.x86_64
[root@finie-monitoring ~]#
I ran the following commands which I ran in the past as we had an issue with DATA_BIN in the past but that didn’t help
[root]# /usr/bin/php /usr/share/centreon/bin/centreon-partitioning.php -m data_bin
[Wed, 02 Aug 23 10:40:06 +0100] PARTITIONING STARTED
[Wed, 02 Aug 23 10:40:06 +0100] Table data_bin is already partitioned
[Wed, 02 Aug 23 10:40:06 +0100] PARTITIONING EXITED
[root]# /usr/bin/php /usr/share/centreon/cron/centreon-partitioning.php
[Wed, 02 Aug 23 10:40:14 +0100] PARTITIONING STARTED
[Wed, 02 Aug 23 10:40:14 +0100] PARTITIONING COMPLETED
[root]# /usr/bin/php /usr/share/centreon/cron/centstorage_purge.php
[Wed, 02 Aug 23 10:40:23 +0100] PURGE STARTED
[Wed, 02 Aug 23 10:40:23 +0100] Purging table data_bin...
[Wed, 02 Aug 23 10:40:23 +0100] Table data_bin purged
[Wed, 02 Aug 23 10:40:23 +0100] Purging table logs...
[Wed, 02 Aug 23 10:40:23 +0100] Table logs purged
[Wed, 02 Aug 23 10:40:23 +0100] Purging table log_archive_host...
[Wed, 02 Aug 23 10:40:23 +0100] Table log_archive_host purged
[Wed, 02 Aug 23 10:40:23 +0100] Purging table log_archive_service...
[Wed, 02 Aug 23 10:40:23 +0100] Table log_archive_service purged
[Wed, 02 Aug 23 10:40:23 +0100] Purging index_data...
[Wed, 02 Aug 23 10:40:23 +0100] index_data purged
[Wed, 02 Aug 23 10:40:23 +0100] Purging log_action_modification...
[Wed, 02 Aug 23 10:40:24 +0100] log_action_modification purged
[Wed, 02 Aug 23 10:40:24 +0100] PURGE COMPLETED
[root]#
Not sure where to start from there.
