Hello,
Is it normal ELT can be so long in this step:
Mon Oct 9 11:13:10 2023] [INFO] Getting host properties from Centreon database
[Mon Oct 9 11:13:27 2023] [INFO] Updating host dimension in Centstorage
[Mon Oct 9 11:13:30 2023] [INFO] Getting hostgroup properties from Centreon database
[Mon Oct 9 11:13:30 2023] [INFO] Updating hostgroup dimension in Centstorage
[Mon Oct 9 11:13:30 2023] [INFO] Getting hostcategories properties from Centreon database
[Mon Oct 9 11:13:30 2023] [INFO] Updating hostcategories dimension in Centstorage
[Mon Oct 9 11:13:30 2023] [INFO] Getting servicecategories properties from Centreon database
[Mon Oct 9 11:13:30 2023] [INFO] Updating servicecategories dimension in Centstorage
[Mon Oct 9 11:13:30 2023] [INFO] Getting service properties from Centreon database
Since last log, I have no treatment based on command show processlist in centreon mbi server:
show processlist \G;
*************************** 1. row ***************************
Id: 1909
User: root
Host: localhost
db: NULL
Command: Query
Time: 0
State: init
Info: show processlist
Progress: 0.000
*************************** 2. row ***************************
Id: 2038
User: centreonbi
Host: localhost:40278
db: centreon
Command: Sleep
Time: 0
State:
Info: NULL
Progress: 0.000
*************************** 3. row ***************************
Id: 2039
User: centreonbi
Host: localhost:40280
db: centreon_storage
Command: Sleep
Time: 972
State:
Info: NULL
Progress: 0.000
3 rows in set (0.000 sec)
ps -ef say that my process is yet present but in sleep mode
root 22433 22432 0 10:10 ? 00:00:00 /bin/sh -c /usr/share/centreon-bi//bin/centreonBIETL -d >> /var/log/centreon-bi//centreo
root 22434 22433 0 10:10 ? 00:00:00 /bin/bash /usr/share/centreon-bi//bin/centreonBIETL -d
root 23015 22434 77 11:13 ? 00:13:25 perl -w /usr/share/centreon-bi//etl/dimensionsBuilder.pl -d
I don’t know if it normal