Hi there,
I have a problem with the daily script "/usr/share/centreon-bi/bin/centreonBIETL"
Show error: ERROR - Login error [code: '450'] [message: 'Timeout reached'].
Login credentials are ok.
Seems to work every other day.
I already tried to increase the values of "centreon.cnf"
connect_timeout=28800
innodb_lock_wait_timeout=28800
wait_timeout=28000
interactive_timeout=28800
Starts normally:
2023-07-12 09:32:47 - INFO - [SCHEDULER] >>>>>>> start
2023-07-12 09:32:47 - INFO - [SCHEDULER][IMPORT] >>>>>>> start
2023-07-12 09:32:47 - INFO - [CREATE] Deleting table [hosts]
2023-07-12 09:32:47 - INFO - [CREATE] Add table [hosts]
2023-07-12 09:32:47 - INFO - [CREATE] Deleting table [mod_bam_reporting_kpi]
2023-07-12 09:32:47 - INFO - [CREATE] Add table [mod_bam_reporting_kpi]
2023-07-12 09:32:47 - INFO - [CREATE] Deleting table [instances]
2023-07-12 09:32:47 - INFO - [CREATE] Add table [instances]
2023-07-12 09:32:47 - INFO - [CREATE] Deleting table [mod_bam_reporting_bv]
2023-07-12 09:32:47 - INFO - [CREATE] Add table [mod_bam_reporting_bv]
2023-07-12 09:32:49 - INFO - [LOAD] import table [instances]
2023-07-12 09:32:49 - INFO - [LOAD] import table [mod_bam_reporting_kpi]
2023-07-12 09:32:49 - INFO - [PARTITIONS] Add partition [20230712] on table [data_bin]
2023-07-12 09:32:49 - INFO - [CREATE] Deleting table [downtimes]
2023-07-12 09:32:49 - INFO - [CREATE] Add table [downtimes]
2023-07-12 09:32:49 - INFO - [CREATE] Deleting table [mod_bam_reporting_kpi_events]
2023-07-12 09:32:49 - INFO - [CREATE] Add table [mod_bam_reporting_kpi_events]
2023-07-12 09:32:49 - INFO - [LOAD] import table [mod_bam_reporting_bv]
2023-07-12 09:32:49 - INFO - [CREATE] Deleting table [metrics]
2023-07-12 09:32:49 - INFO - [CREATE] Add table [metrics]
2023-07-12 09:32:52 - INFO - [CREATE] Deleting table [index_data]
2023-07-12 09:32:52 - INFO - [CREATE] Add table [index_data]
2023-07-12 09:32:52 - INFO - [CREATE] Deleting table [mod_bam_reporting_ba]
2023-07-12 09:32:52 - INFO - [CREATE] Add table [mod_bam_reporting_ba]
2023-07-12 09:32:52 - INFO - [CREATE] Deleting table [hoststateevents]
2023-07-12 09:32:52 - INFO - [CREATE] Add table [hoststateevents]
2023-07-12 09:32:52 - INFO - [INDEXING] Deleting index [PRIMARY KEY] on table [hoststateevents]
2023-07-12 09:32:52 - INFO - [INDEXING] Deleting index [host_id] on table [hoststateevents]
2023-07-12 09:32:52 - INFO - [INDEXING] Deleting index [start_time] on table [hoststateevents]
2023-07-12 09:32:52 - INFO - [INDEXING] Deleting index [end_time] on table [hoststateevents]
2023-07-12 09:32:52 - INFO - [INDEXING] Adding index [in_downtime, start_time, end_time] on table [hoststateevents]
2023-07-12 09:32:52 - INFO - [INDEXING] Adding index [end_time] on table [hoststateevents]
2023-07-12 09:32:52 - INFO - [CREATE] Deleting table [mod_bam_reporting_ba_availabilities]
2023-07-12 09:32:52 - INFO - [CREATE] Add table [mod_bam_reporting_ba_availabilities]
2023-07-12 09:32:52 - INFO - [CREATE] Deleting table [mod_bam_reporting_timeperiods]
2023-07-12 09:32:52 - INFO - [CREATE] Add table [mod_bam_reporting_timeperiods]
2023-07-12 09:32:52 - INFO - [CREATE] Deleting table [servicestateevents]
2023-07-12 09:32:52 - INFO - [CREATE] Add table [servicestateevents]
2023-07-12 09:32:52 - INFO - [INDEXING] Deleting index [PRIMARY KEY] on table [servicestateevents]
2023-07-12 09:32:52 - INFO - [INDEXING] Deleting index [host_id] on table [servicestateevents]
2023-07-12 09:32:52 - INFO - [INDEXING] Deleting index [start_time] on table [servicestateevents]
2023-07-12 09:32:52 - INFO - [INDEXING] Deleting index [end_time] on table [servicestateevents]
2023-07-12 09:32:52 - INFO - [INDEXING] Adding index [in_downtime, start_time, end_time] on table [servicestateevents]
2023-07-12 09:32:52 - INFO - [INDEXING] Adding index [end_time] on table [servicestateevents]
2023-07-12 09:32:52 - INFO - [INDEXING] Adding index [host_id, service_id, start_time, end_time, ack_time, state, last_update] on table [servicestateevents]
2023-07-12 09:32:52 - INFO - [CREATE] Deleting table [mod_bam_reporting_ba_events]
2023-07-12 09:32:52 - INFO - [CREATE] Add table [mod_bam_reporting_ba_events]
2023-07-12 09:32:52 - INFO - [CREATE] Deleting table [mod_bam_reporting_relations_ba_kpi_events]
2023-07-12 09:32:52 - INFO - [CREATE] Add table [mod_bam_reporting_relations_ba_kpi_events]
2023-07-12 09:32:52 - INFO - [LOAD] import table [mod_bam_reporting_ba]
2023-07-12 09:32:52 - INFO - [CREATE] Deleting table [mod_bam_reporting_ba_events_durations]
2023-07-12 09:32:52 - INFO - [CREATE] Add table [mod_bam_reporting_ba_events_durations]
2023-07-12 09:32:52 - INFO - [LOAD] import table [hosts]
2023-07-12 09:32:52 - INFO - [LOAD] import table [mod_bam_reporting_ba_availabilities]
2023-07-12 09:32:52 - INFO - [LOAD] import table [mod_bam_reporting_kpi_events]
2023-07-12 09:32:54 - INFO - [LOAD] import table [index_data]
2023-07-12 09:32:54 - INFO - [LOAD] import table [mod_bam_reporting_ba_events]
2023-07-12 09:32:54 - INFO - [LOAD] import table [mod_bam_reporting_ba_events_durations]
2023-07-12 09:32:54 - INFO - [LOAD] import table [centreon_acl]
2023-07-12 09:32:56 - INFO - [LOAD] import table [hoststateevents]
2023-07-12 09:32:56 - INFO - [CREATE] Deleting table [acknowledgements]
2023-07-12 09:32:56 - INFO - [CREATE] Add table [acknowledgements]
2023-07-12 09:32:56 - INFO - [CREATE] Deleting table [mod_bam_reporting_relations_ba_bv]
2023-07-12 09:32:56 - INFO - [CREATE] Add table [mod_bam_reporting_relations_ba_bv]
2023-07-12 09:32:56 - INFO - [LOAD] import table [mod_bam_reporting_relations_ba_bv]
2023-07-12 09:32:58 - INFO - [LOAD] import table [downtimes]
2023-07-12 09:32:58 - INFO - [LOAD] import table [acknowledgements]
2023-07-12 09:33:02 - INFO - [LOAD] import table [host hostgroup_relation hostgroup hostcategories_relation hostcategories host_service_relation service service_categories service_categories_relation timeperiod mod_bi_options servicegroup mod_bi_options_centiles servicegroup_relation contact contactgroup_service_relation host_template_relation command contact_host_relation contactgroup_host_relation contactgroup contact_service_relation]
2023-07-12 09:34:01 - ERROR - Login error [code: '450'] [message: 'Timeout reached']
Yesterday ended normally:
2023-07-11 09:30:09 - INFO - [SCHEDULER] >>>>>>> start
2023-07-11 09:30:09 - INFO - [SCHEDULER][IMPORT] >>>>>>> start
2023-07-11 09:30:13 - INFO - [CREATE] Deleting table [hosts]
2023-07-11 09:30:13 - INFO - [CREATE] Add table [hosts]
2023-07-11 09:30:13 - INFO - [CREATE] Deleting table [mod_bam_reporting_kpi]
2023-07-11 09:30:13 - INFO - [CREATE] Add table [mod_bam_reporting_kpi]
2023-07-11 09:30:18 - INFO - [CREATE] Deleting table [hoststateevents]
2023-07-11 09:30:18 - INFO - [CREATE] Add table [hoststateevents]
2023-07-11 09:30:18 - INFO - [INDEXING] Deleting index [PRIMARY KEY] on table [hoststateevents]
2023-07-11 09:30:18 - INFO - [INDEXING] Deleting index [host_id] on table [hoststateevents]
2023-07-11 09:30:18 - INFO - [INDEXING] Deleting index [start_time] on table [hoststateevents]
2023-07-11 09:30:18 - INFO - [INDEXING] Deleting index [end_time] on table [hoststateevents]
2023-07-11 09:30:18 - INFO - [INDEXING] Adding index [in_downtime, start_time, end_time] on table [hoststateevents]
2023-07-11 09:30:18 - INFO - [INDEXING] Adding index [end_time] on table [hoststateevents]
2023-07-11 09:30:18 - INFO - [CREATE] Deleting table [mod_bam_reporting_ba_events]
2023-07-11 09:30:18 - INFO - [CREATE] Add table [mod_bam_reporting_ba_events]
2023-07-11 09:30:18 - INFO - [PARTITIONS] Add partition [20230711] on table [data_bin]
2023-07-11 09:30:18 - INFO - [CREATE] Deleting table [downtimes]
2023-07-11 09:30:18 - INFO - [CREATE] Add table [downtimes]
2023-07-11 09:30:18 - INFO - [CREATE] Deleting table [mod_bam_reporting_kpi_events]
2023-07-11 09:30:18 - INFO - [CREATE] Add table [mod_bam_reporting_kpi_events]
2023-07-11 09:30:18 - INFO - [CREATE] Deleting table [servicestateevents]
2023-07-11 09:30:18 - INFO - [CREATE] Add table [servicestateevents]
2023-07-11 09:30:18 - INFO - [INDEXING] Deleting index [PRIMARY KEY] on table [servicestateevents]
2023-07-11 09:30:18 - INFO - [INDEXING] Deleting index [host_id] on table [servicestateevents]
2023-07-11 09:30:18 - INFO - [INDEXING] Deleting index [start_time] on table [servicestateevents]
2023-07-11 09:30:18 - INFO - [INDEXING] Deleting index [end_time] on table [servicestateevents]
2023-07-11 09:30:18 - INFO - [INDEXING] Adding index [in_downtime, start_time, end_time] on table [servicestateevents]
2023-07-11 09:30:18 - INFO - [INDEXING] Adding index [end_time] on table [servicestateevents]
2023-07-11 09:30:18 - INFO - [INDEXING] Adding index [host_id, service_id, start_time, end_time, ack_time, state, last_update] on table [servicestateevents]
2023-07-11 09:30:18 - INFO - [CREATE] Deleting table [mod_bam_reporting_ba_events_durations]
2023-07-11 09:30:18 - INFO - [CREATE] Add table [mod_bam_reporting_ba_events_durations]
2023-07-11 09:30:18 - INFO - [CREATE] Deleting table [instances]
2023-07-11 09:30:18 - INFO - [CREATE] Add table [instances]
2023-07-11 09:30:20 - INFO - [CREATE] Deleting table [mod_bam_reporting_bv]
2023-07-11 09:30:20 - INFO - [CREATE] Add table [mod_bam_reporting_bv]
2023-07-11 09:30:20 - INFO - [CREATE] Deleting table [metrics]
2023-07-11 09:30:20 - INFO - [CREATE] Add table [metrics]
2023-07-11 09:30:20 - INFO - [LOAD] import table [hosts]
2023-07-11 09:30:20 - INFO - [LOAD] import table [mod_bam_reporting_kpi]
2023-07-11 09:30:20 - INFO - [LOAD] import table [instances]
2023-07-11 09:30:20 - INFO - [CREATE] Deleting table [mod_bam_reporting_ba]
2023-07-11 09:30:20 - INFO - [CREATE] Add table [mod_bam_reporting_ba]
2023-07-11 09:30:20 - INFO - [CREATE] Deleting table [index_data]
2023-07-11 09:30:20 - INFO - [CREATE] Add table [index_data]
2023-07-11 09:30:22 - INFO - [CREATE] Deleting table [mod_bam_reporting_timeperiods]
2023-07-11 09:30:22 - INFO - [CREATE] Add table [mod_bam_reporting_timeperiods]
2023-07-11 09:30:24 - INFO - [CREATE] Deleting table [mod_bam_reporting_ba_availabilities]
2023-07-11 09:30:24 - INFO - [CREATE] Add table [mod_bam_reporting_ba_availabilities]
2023-07-11 09:30:24 - INFO - [LOAD] import table [mod_bam_reporting_ba_events]
2023-07-11 09:30:26 - INFO - [CREATE] Deleting table [mod_bam_reporting_relations_ba_kpi_events]
2023-07-11 09:30:26 - INFO - [CREATE] Add table [mod_bam_reporting_relations_ba_kpi_events]
2023-07-11 09:30:26 - INFO - [LOAD] import table [mod_bam_reporting_ba_events_durations]
2023-07-11 09:30:26 - INFO - [LOAD] import table [mod_bam_reporting_kpi_events]
2023-07-11 09:30:28 - INFO - [LOAD] import table [mod_bam_reporting_timeperiods]
2023-07-11 09:30:30 - INFO - [LOAD] import table [mod_bam_reporting_relations_ba_kpi_events]
2023-07-11 09:30:30 - INFO - [LOAD] import table [hoststateevents]
2023-07-11 09:30:30 - INFO - [LOAD] import table [mod_bam_reporting_bv]
2023-07-11 09:30:34 - INFO - [LOAD] import table [downtimes]
2023-07-11 09:30:36 - INFO - [LOAD] import table [index_data]
2023-07-11 09:30:56 - INFO - [LOAD] import table [metrics]
2023-07-11 09:31:04 - INFO - [LOAD] import table [centreon_acl]
2023-07-11 09:31:08 - INFO - [CREATE] Deleting table [acknowledgements]
2023-07-11 09:31:08 - INFO - [CREATE] Add table [acknowledgements]
2023-07-11 09:31:08 - INFO - [CREATE] Deleting table [mod_bam_reporting_relations_ba_bv]
2023-07-11 09:31:08 - INFO - [CREATE] Add table [mod_bam_reporting_relations_ba_bv]
2023-07-11 09:31:08 - INFO - [LOAD] import table [mod_bam_reporting_relations_ba_bv]
2023-07-11 09:31:16 - INFO - [LOAD] import table [acknowledgements]
2023-07-11 09:31:18 - INFO - [LOAD] import table [host hostgroup_relation hostgroup hostcategories_relation hostcategories host_service_relation service service_categories service_categories_relation timeperiod mod_bi_options servicegroup mod_bi_options_centiles servicegroup_relation contact contactgroup_service_relation host_template_relation command contact_host_relation contactgroup_host_relation contactgroup contact_service_relation]
2023-07-11 09:32:14 - INFO - [LOAD] import table [servicestateevents]
2023-07-11 09:32:16 - INFO - [LOAD] import table [mod_bam_reporting_ba_availabilities]
2023-07-11 09:40:57 - INFO - [LOAD] partition [20230711] on table [data_bin]
2023-07-11 09:40:57 - INFO - [LOAD] import table [mod_bam_reporting_ba]
2023-07-11 09:40:57 - INFO - [SCHEDULER][IMPORT] <<<<<<< end