Solved

MBI - rebuild db freeze / hang ...

A
Userlevel 1
Badge +8

Hi,

I rebuild my MBI DB, and the "process" - now is freeze / hang ...  , since 10 Houre's

Server reboot / all Service running , found no issue

disk space is ok

 

# /usr/share/centreon-bi/bin/centreonBIETL -r

 

2023-06-08 09:40:00 - INFO - [SCHEDULER][DIMENSIONS] >>>>>>> start

wait And Wait .…

 

thanks

andreas

 

icon

Best answer by Thibault 15 June 2023, 10:40

View original

12 replies

C
Rank
Userlevel 5
Badge +14

hello

you will probably need to contact the support and open a case, I know there are commands and other way to get things back in order

(like this “concept” article that will tell you how to rebuild when you are missing data : Concepts | Centreon Documentation )

 

when I had some issue I was asked to check these commands 

systemctl status cbis -l/usr/share/centreon-bi/tools/diagnostic.sh/usr/share/centreon-bi/etl/centreonbiMonitoring.pl --db-content

but as the database was locked there was no output on the last one, and the 2nd one was hanging after displaying a bit of information (all due to a bugged “drop database” from mariadb, a bit of nighmare to fix)

 

try running these 3 commands (they are just diagnotiscs) and if you get stuck, then you have a mariadb problem and you will need to fix that before

 

Centreon Lord Commander - https://www.centreon.com/centreon-community/
A
Userlevel 1
Badge +8

Hi,

 

thanks

 

diagnostic.sh - All OK , all green .

I have submitted a support request (08/06/2023) but have not received a response yet.

 

Thibault
Rank
Userlevel 3
Badge +5

Hi,

You probably have a “template loop” (a template inheriting from itself) in your Centreon configuration.

A
Userlevel 1
Badge +8

him when i run this task

 

/usr/share/centreon-bi/etl/dimensionsBuilder_legacy.pl -r --log-level=debug

 

loop in

 

[Thu Jun 15 09:56:51 2023] [DEBUG] MySQL query : SELECT service_id, service_template_model_stm_id FROM service WHERE service_register = '0' and service_id=13402


[Thu Jun 15 09:56:51 2023] [DEBUG] MySQL query : SELECT sc.sc_id, sc_name FROM service_categories sc, service_categories_relation scr WHERE service_service_id = 13402 AND sc.sc_id = scr.sc_id


[Thu Jun 15 09:56:51 2023] [DEBUG] MySQL query : SELECT service_id, service_template_model_stm_id FROM service WHERE service_register = '0' and service_id=13402


[Thu Jun 15 09:56:51 2023] [DEBUG] MySQL query : SELECT sc.sc_id, sc_name FROM service_categories sc, service_categories_relation scr WHERE service_service_id = 13402 AND sc.sc_id = scr.sc_id


[Thu Jun 15 09:56:51 2023] [DEBUG] MySQL query : SELECT service_id, service_template_model_stm_id FROM service WHERE service_register = '0' and service_id=13402


[Thu Jun 15 09:56:51 2023] [DEBUG] MySQL query : SELECT sc.sc_id, sc_name FROM service_categories sc, service_categories_relation scr WHERE service_service_id = 13402 AND sc.sc_id = scr.sc_id

Thibault
Rank
Userlevel 3
Badge +5

Yep, definitely looks like it.

You can spot the related service by setting its ID in the configuration page URL:

http(s)://x.x.x.x/centreon/main.php?p=60201&o=c&service_id=13402

 

 

A
Userlevel 1
Badge +8

i checked the service

 

centreon-plugin-Cloud-Azure-Management-Resource-Api

Cloud-Azure-Management-Resource-Items-Api-custom

 

i deleted the service check ( was only one )

 

now i checked the mbi - rebuild again

A
Userlevel 1
Badge +8

i rebuild again

 

same error

 

[Thu Jun 15 11:51:57 2023] [DEBUG] MySQL query : SELECT service_id, service_template_model_stm_id FROM service WHERE service_register = '0' and service_id=13402


[Thu Jun 15 11:51:57 2023] [DEBUG] MySQL query : SELECT sc.sc_id, sc_name  FROM service_categories sc, service_categories_relation scr WHERE service_service_id = 13402 AND sc.sc_id = scr.sc_id


[Thu Jun 15 11:51:57 2023] [DEBUG] MySQL query : SELECT service_id, service_template_model_stm_id FROM service WHERE service_register = '0' and service_id=13402


[Thu Jun 15 11:51:57 2023] [DEBUG] MySQL query : SELECT sc.sc_id, sc_name  FROM service_categories sc, service_categories_relation scr WHERE service_service_id = 13402 AND sc.sc_id = scr.sc_id


[Thu Jun 15 11:51:57 2023] [DEBUG] MySQL query : SELECT service_id, service_template_model_stm_id FROM service WHERE service_register = '0' and service_id=13402

 

A
Userlevel 1
Badge +8

In Centreon, i export the config again, and restart the monitoring engine

 

test again

A
Userlevel 1
Badge +8

now it is running :)))) the rebuild

Thibault
Rank
Userlevel 3
Badge +5

Nice 👍

Can you please set the topic as “resolved”, so it would help other users facing the same issue.

Thanks !

A
Userlevel 1
Badge +8

Hello, I can not find the button "Resolve" 🙄

Fabrix
Rank
Userlevel 5
Badge +11

Under each post, you'll find the magical "Best Answer" button. Locate the post that truly saved your day and give it a sweet click to mark it as the ultimate solution to your problem. By doing so, you'll be spreading the love and helping fellow watchers who stumble upon the same issue. Thanks @ahartung, but also @christophe.niel-ACT and @Thibault 

 

Here to help you enjoy your experience on The Watch ¯\_ (ツ) _/¯

Reply


Terms & ConditionsCookie settings