Solved

After upgrade from 19.10 to 22.10 the poller not running

  • 16 November 2022
  • 7 replies
  • 178 views

Badge +1

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?

icon

Best answer by omercier 21 November 2022, 13:03

View original

7 replies

Badge

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

Badge +3

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.

Badge +1

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

Userlevel 3
Badge +11

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 

 

Badge +1

It’s a perfect solution, it’s works

Thanks a lot

Userlevel 3
Badge +11

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..

Badge

Hello, this also worked for me!
Thanks regards

Reply