Skip to main content
Question

[MBI] ERROR - Login error [code: '450'] [message: 'Timeout reached']

  • 12 July 2023
  • 1 reply
  • 413 views

cesinhaleal
Forum|alt.badge.img+3

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

Forum|alt.badge.img+8
  • Steward **
  • September 23, 2024

Were you able to fix this? If yes, then how?


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings