Skip to main content
Solved

After upgrade from 19.10 to 22.10 the poller not running

  • Nov 16, 2022 3:10 PM UTC
  • 7 replies
  • 824 views
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

 

View original

7 replies

Forum|alt.badge.img
  • MartinW
  • Steward *
  • Nov 17, 2022 12:16 PM UTC

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

Centreonian
Forum|alt.badge.img+3
  • ALaunois
  • Centreonian
  • Nov 17, 2022 5:11 PM UTC

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.

Forum|alt.badge.img+1
  • jegacefr
  • Author
  • Steward *
  • Nov 21, 2022 7:49 AM UTC

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+15
  • omercier
  • Centreonian
  • Answer
  • Nov 21, 2022 12:03 PM UTC

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!
    Forum|alt.badge.img+1
    • jegacefr
    • Author
    • Steward *
    • Nov 21, 2022 12:32 PM UTC

    It’s a perfect solution, it’s works

    Thanks a lot

      omercier
      Centreonian
      Forum|alt.badge.img+15
      • omercier
      • Centreonian
      • Nov 21, 2022 12:47 PM UTC

      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!
      Forum|alt.badge.img
      • MartinW
      • Steward *
      • Nov 22, 2022 10:43 AM UTC

      Hello, this also worked for me!
      Thanks regards

      Terms & ConditionsAccessibility statement