Skip to main content

Hi,
I used all the steps for the Centreon upgrade https://docs.centreon.com/fr/docs/upgrade/upgrade-from-19-10/
No error appeared when applying the patch during the update via the web interface

Although the poller is restarted manually after the migration, it does not work properly.
In the log files, there is an error in /var/log/centreon-broker/central-broker-master.log :

[2022-11-14T13:23:14.301+01:00] [sql] [error] error while loading caches: unified_sql: could not fetch index list from data DB: mysql: result at index 7 should be a boolean, the current value is ''
[2022-11-14T13:23:14.301+01:00] [core] [error] failover: global error: unified_sql: could not fetch index list from data DB: mysql: result at index 7 should be a boolean, the current value is ''

This error is not specific enough to find out what the problem is.
Do you have an idea?

Hi, have you solved this problem? Because I have the same problem!
Thanks

Hi,

Have you checked the sql logs ? (/var/log/centreon/sql-error.log)

I would also suggest to check your broker configuration as there as been some major changes between 19.10 and 22.10 versions and try to export the configuration again.

Hi,

The sql logs is empty
I compare the central-broker.json with an other Centreon in 22.04 version, the file is same except the password of course

Hi, your error looks like something we have already seen.

Can you try this query?

use centreon_storage;
update index_data set special = '0' where special <> '1';

Then: 

systemctl restart cbd

 

It’s a perfect solution, it’s works

Thanks a lot

I’m glad to read that, but actually it should have been fixed by a SQL migration script published in the centreon-web 22.04.4 release.

I’m a bit concerned that in your case the bug hit again..

Hello, this also worked for me!
Thanks regards

Reply


Terms & ConditionsCookie settings