Skip to main content
Solved

After upgrade from 19.10 to 22.10 the poller not running

  • November 16, 2022
  • 7 replies
  • 775 views
J
Forum|alt.badge.img+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?

Best answer by omercier

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

 

7 replies

M
Forum|alt.badge.img
  • MartinW
  • Steward *
  • November 17, 2022

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

A
Centreonian
Forum|alt.badge.img+3
  • ALaunois
  • Centreonian
  • November 17, 2022

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.

J
Forum|alt.badge.img+1
  • jegacefr
  • Author
  • Steward *
  • November 21, 2022

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

omercier
Centreonian
Forum|alt.badge.img+13
  • omercier
  • Centreonian
  • Answer
  • November 21, 2022

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

 

I love it when a plan comes together!
J
M
J
Forum|alt.badge.img+1
  • jegacefr
  • Author
  • Steward *
  • November 21, 2022

It’s a perfect solution, it’s works

Thanks a lot

omercier
omercier
Centreonian
Forum|alt.badge.img+13
  • omercier
  • Centreonian
  • November 21, 2022

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

I love it when a plan comes together!
M
Forum|alt.badge.img
  • MartinW
  • Steward *
  • November 22, 2022

Hello, this also worked for me!
Thanks regards

Terms & ConditionsCookie settingsAccessibility statement