Skip to main content
Solved

Centreon Central not running and last uptate status in yellow

  • March 25, 2025
  • 4 replies
  • 330 views
J
Forum|alt.badge.img+1

Hello Guys,

I’ve passed the last 24 hours reading related topics to my problem, but none of the fix worked for me. Let me explain.

I have a free version of Centreon, runing on Almalinux 9.5 on a sandbox hyper-v. This is my first mistake, it’s not backed up !

It was runing smoothly until yesterday when I uptated from 24.10.4 to 24.10.5. Since then, Central il not running in Poller menu and last update status is in yellow at the date/hour I did the update yesterday :

As well as the following error in the ressources status screen :

Except that, everyting is running fine. I have all my hosts and services in the configuration menu.

CBD, Centengine and Gorgoned are running. I restarted the services, and the server itself. But still can’t come back to running state.

I’m not very expert in linux, so I struggle a bit to go over the logs at 11:17am on 24th march (last update of the Central).

Thank you for your help :)

Best answer by ponchoh

Ok here we go, with this in mind:

central-broker-master.log :

[sql] [error] connection .... fail to connect: Unknown column 'flapping' in 'SET'
[sql] [error] mysql_connection: Unknown column 'flapping' in 'SET'

if so:

UPDATE centreon.informations SET value="24.10.3" WHERE value="24.10.5" ;

then

mv /var/lib/centreon/installs/install-24.10.5-* /usr/share/centreon/www/install

then go to your webpage to do an upgrade. As usual, have a backup.

🤞⛑

    4 replies

    A
    Forum|alt.badge.img+11

    Can you run a “manual” export of the configuration by selecting the central poller and select the “export configuration” option and share if anything seem throwing errors ?

     

    J
    Forum|alt.badge.img+1
    • jmo4001
    • Author
    • Steward *
    • March 25, 2025

    Thank you for your reply.
     

    I forgot to mention in my first post that I’ve already done that.

    There’s no error, either with reload or restart method :

    Regards

    ponchoh
    Centreonian
    Forum|alt.badge.img+14
    • ponchoh
    • Centreonian
    • Answer
    • March 25, 2025

    Ok here we go, with this in mind:

    central-broker-master.log :

    [sql] [error] connection .... fail to connect: Unknown column 'flapping' in 'SET'
    [sql] [error] mysql_connection: Unknown column 'flapping' in 'SET'

    if so:

    UPDATE centreon.informations SET value="24.10.3" WHERE value="24.10.5" ;

    then

    mv /var/lib/centreon/installs/install-24.10.5-* /usr/share/centreon/www/install

    then go to your webpage to do an upgrade. As usual, have a backup.

    🤞⛑

    J
    Forum|alt.badge.img+1
    • jmo4001
    • Author
    • Steward *
    • March 26, 2025

    Thanks ponchoh, you nailed it !

     

    Indeed I had this error :

     

    I’ve followed your tips and manage to get my Central running again :

     

    Thank you very much 😊

      Terms & ConditionsCookie settingsAccessibility statement