Skip to main content

My root partition is full and I have tried with archive log files and I dropped some of the old database partitions using below commands to clear some space with help of chatgpt.

Now Pollar is down and showing the database issue

“ALTER TABLE log_archive_service DROP PARTITION 

p20231220, p20231221, p20231222, p20231223, p20231224, p20231225, p20231226, p20231227, p20231228, 

p20231229, p20231230, p20231231;”

I checked the logs “cat /var/log/centreon-broker/central-broker-master.log  | grep 'error'”

<2024-12-23T13:18:03.411-05:00] .sql] 5error] mysql_connection: Table 'centreon_storage.data_bin' doesn't exist

<2024-12-23T13:18:03.411-05:00] .sql] 5error] connection 0x7fdcd0020fb0 fail to connect: Table 'centreon_storage.data_bin' doesn't exist

<2024-12-23T13:18:13.412-05:00] .sql] 5error] mysql_connection: Table 'centreon_storage.data_bin' doesn't exist

<2024-12-23T13:18:13.412-05:00] .sql] 5error] connection 0x7fdcd0020fb0 fail to connect: Table 'centreon_storage.data_bin' doesn't exist
 

Does your data_bin exist?

 

MariaDB  (none)]> desc centreon_storage.data_bin;
+-----------+---------------------------+------+-----+---------+-------+
| Field     | Type                      | Null | Key | Default | Extra |
+-----------+---------------------------+------+-----+---------+-------+
| id_metric | int(11)                   | YES  | MUL | NULL    |       |
| ctime     | int(11)                   | YES  |     | NULL    |       |
| value     | float                     | YES  |     | NULL    |       |
| status    | enum('0','1','2','3','4') | YES  |     | NULL    |       |
+-----------+---------------------------+------+-----+---------+-------+
4 rows in set (0.001 sec)

 

Reply


Terms & ConditionsCookie settings