Hi there,
I have a problem with the daily script "/usr/share/centreon-bi/bin/centreonBIETL"
Show error: ERROR - Login error rcode: '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 - FSCHEDULER] >>>>>>> start
2023-07-12 09:32:47 - INFO - FSCHEDULER]UIMPORT] >>>>>>> start
2023-07-12 09:32:47 - INFO - FCREATE] Deleting table ahosts]
2023-07-12 09:32:47 - INFO - FCREATE] Add table ahosts]
2023-07-12 09:32:47 - INFO - FCREATE] Deleting table amod_bam_reporting_kpi]
2023-07-12 09:32:47 - INFO - FCREATE] Add table amod_bam_reporting_kpi]
2023-07-12 09:32:47 - INFO - FCREATE] Deleting table ainstances]
2023-07-12 09:32:47 - INFO - FCREATE] Add table ainstances]
2023-07-12 09:32:47 - INFO - FCREATE] Deleting table amod_bam_reporting_bv]
2023-07-12 09:32:47 - INFO - FCREATE] Add table amod_bam_reporting_bv]
2023-07-12 09:32:49 - INFO - FLOAD] import table ainstances]
2023-07-12 09:32:49 - INFO - FLOAD] import table amod_bam_reporting_kpi]
2023-07-12 09:32:49 - INFO - FPARTITIONS] Add partition t20230712] on table adata_bin]
2023-07-12 09:32:49 - INFO - FCREATE] Deleting table adowntimes]
2023-07-12 09:32:49 - INFO - FCREATE] Add table adowntimes]
2023-07-12 09:32:49 - INFO - FCREATE] Deleting table amod_bam_reporting_kpi_events]
2023-07-12 09:32:49 - INFO - FCREATE] Add table amod_bam_reporting_kpi_events]
2023-07-12 09:32:49 - INFO - FLOAD] import table amod_bam_reporting_bv]
2023-07-12 09:32:49 - INFO - FCREATE] Deleting table ametrics]
2023-07-12 09:32:49 - INFO - FCREATE] Add table ametrics]
2023-07-12 09:32:52 - INFO - FCREATE] Deleting table aindex_data]
2023-07-12 09:32:52 - INFO - FCREATE] Add table aindex_data]
2023-07-12 09:32:52 - INFO - FCREATE] Deleting table amod_bam_reporting_ba]
2023-07-12 09:32:52 - INFO - FCREATE] Add table amod_bam_reporting_ba]
2023-07-12 09:32:52 - INFO - FCREATE] Deleting table ahoststateevents]
2023-07-12 09:32:52 - INFO - FCREATE] Add table ahoststateevents]
2023-07-12 09:32:52 - INFO - FINDEXING] Deleting index nPRIMARY KEY] on table ahoststateevents]
2023-07-12 09:32:52 - INFO - FINDEXING] Deleting index nhost_id] on table ahoststateevents]
2023-07-12 09:32:52 - INFO - FINDEXING] Deleting index nstart_time] on table ahoststateevents]
2023-07-12 09:32:52 - INFO - FINDEXING] Deleting index nend_time] on table ahoststateevents]
2023-07-12 09:32:52 - INFO - FINDEXING] Adding index nin_downtime, start_time, end_time] on table ahoststateevents]
2023-07-12 09:32:52 - INFO - FINDEXING] Adding index nend_time] on table ahoststateevents]
2023-07-12 09:32:52 - INFO - FCREATE] Deleting table amod_bam_reporting_ba_availabilities]
2023-07-12 09:32:52 - INFO - FCREATE] Add table amod_bam_reporting_ba_availabilities]
2023-07-12 09:32:52 - INFO - FCREATE] Deleting table amod_bam_reporting_timeperiods]
2023-07-12 09:32:52 - INFO - FCREATE] Add table amod_bam_reporting_timeperiods]
2023-07-12 09:32:52 - INFO - FCREATE] Deleting table aservicestateevents]
2023-07-12 09:32:52 - INFO - FCREATE] Add table aservicestateevents]
2023-07-12 09:32:52 - INFO - FINDEXING] Deleting index nPRIMARY KEY] on table aservicestateevents]
2023-07-12 09:32:52 - INFO - FINDEXING] Deleting index nhost_id] on table aservicestateevents]
2023-07-12 09:32:52 - INFO - FINDEXING] Deleting index nstart_time] on table aservicestateevents]
2023-07-12 09:32:52 - INFO - FINDEXING] Deleting index nend_time] on table aservicestateevents]
2023-07-12 09:32:52 - INFO - FINDEXING] Adding index nin_downtime, start_time, end_time] on table aservicestateevents]
2023-07-12 09:32:52 - INFO - FINDEXING] Adding index nend_time] on table aservicestateevents]
2023-07-12 09:32:52 - INFO - FINDEXING] Adding index nhost_id, service_id, start_time, end_time, ack_time, state, last_update] on table aservicestateevents]
2023-07-12 09:32:52 - INFO - FCREATE] Deleting table amod_bam_reporting_ba_events]
2023-07-12 09:32:52 - INFO - FCREATE] Add table amod_bam_reporting_ba_events]
2023-07-12 09:32:52 - INFO - FCREATE] Deleting table amod_bam_reporting_relations_ba_kpi_events]
2023-07-12 09:32:52 - INFO - FCREATE] Add table amod_bam_reporting_relations_ba_kpi_events]
2023-07-12 09:32:52 - INFO - FLOAD] import table amod_bam_reporting_ba]
2023-07-12 09:32:52 - INFO - FCREATE] Deleting table amod_bam_reporting_ba_events_durations]
2023-07-12 09:32:52 - INFO - FCREATE] Add table amod_bam_reporting_ba_events_durations]
2023-07-12 09:32:52 - INFO - FLOAD] import table ahosts]
2023-07-12 09:32:52 - INFO - FLOAD] import table amod_bam_reporting_ba_availabilities]
2023-07-12 09:32:52 - INFO - FLOAD] import table amod_bam_reporting_kpi_events]
2023-07-12 09:32:54 - INFO - FLOAD] import table aindex_data]
2023-07-12 09:32:54 - INFO - FLOAD] import table amod_bam_reporting_ba_events]
2023-07-12 09:32:54 - INFO - FLOAD] import table amod_bam_reporting_ba_events_durations]
2023-07-12 09:32:54 - INFO - FLOAD] import table acentreon_acl]
2023-07-12 09:32:56 - INFO - FLOAD] import table ahoststateevents]
2023-07-12 09:32:56 - INFO - FCREATE] Deleting table aacknowledgements]
2023-07-12 09:32:56 - INFO - FCREATE] Add table aacknowledgements]
2023-07-12 09:32:56 - INFO - FCREATE] Deleting table amod_bam_reporting_relations_ba_bv]
2023-07-12 09:32:56 - INFO - FCREATE] Add table amod_bam_reporting_relations_ba_bv]
2023-07-12 09:32:56 - INFO - FLOAD] import table amod_bam_reporting_relations_ba_bv]
2023-07-12 09:32:58 - INFO - FLOAD] import table adowntimes]
2023-07-12 09:32:58 - INFO - FLOAD] import table aacknowledgements]
2023-07-12 09:33:02 - INFO - FLOAD] import table ahost 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 rcode: '450'] 5message: 'Timeout reached']
Yesterday ended normally:
2023-07-11 09:30:09 - INFO - NSCHEDULER] >>>>>>> start
2023-07-11 09:30:09 - INFO - NSCHEDULER]DIMPORT] >>>>>>> start
2023-07-11 09:30:13 - INFO - NCREATE] Deleting table thosts]
2023-07-11 09:30:13 - INFO - NCREATE] Add table thosts]
2023-07-11 09:30:13 - INFO - NCREATE] Deleting table tmod_bam_reporting_kpi]
2023-07-11 09:30:13 - INFO - NCREATE] Add table tmod_bam_reporting_kpi]
2023-07-11 09:30:18 - INFO - NCREATE] Deleting table thoststateevents]
2023-07-11 09:30:18 - INFO - NCREATE] Add table thoststateevents]
2023-07-11 09:30:18 - INFO - NINDEXING] Deleting index iPRIMARY KEY] on table thoststateevents]
2023-07-11 09:30:18 - INFO - NINDEXING] Deleting index ihost_id] on table thoststateevents]
2023-07-11 09:30:18 - INFO - NINDEXING] Deleting index istart_time] on table thoststateevents]
2023-07-11 09:30:18 - INFO - NINDEXING] Deleting index iend_time] on table thoststateevents]
2023-07-11 09:30:18 - INFO - NINDEXING] Adding index iin_downtime, start_time, end_time] on table thoststateevents]
2023-07-11 09:30:18 - INFO - NINDEXING] Adding index iend_time] on table thoststateevents]
2023-07-11 09:30:18 - INFO - NCREATE] Deleting table tmod_bam_reporting_ba_events]
2023-07-11 09:30:18 - INFO - NCREATE] Add table tmod_bam_reporting_ba_events]
2023-07-11 09:30:18 - INFO - NPARTITIONS] Add partition i20230711] on table tdata_bin]
2023-07-11 09:30:18 - INFO - NCREATE] Deleting table tdowntimes]
2023-07-11 09:30:18 - INFO - NCREATE] Add table tdowntimes]
2023-07-11 09:30:18 - INFO - NCREATE] Deleting table tmod_bam_reporting_kpi_events]
2023-07-11 09:30:18 - INFO - NCREATE] Add table tmod_bam_reporting_kpi_events]
2023-07-11 09:30:18 - INFO - NCREATE] Deleting table tservicestateevents]
2023-07-11 09:30:18 - INFO - NCREATE] Add table tservicestateevents]
2023-07-11 09:30:18 - INFO - NINDEXING] Deleting index iPRIMARY KEY] on table tservicestateevents]
2023-07-11 09:30:18 - INFO - NINDEXING] Deleting index ihost_id] on table tservicestateevents]
2023-07-11 09:30:18 - INFO - NINDEXING] Deleting index istart_time] on table tservicestateevents]
2023-07-11 09:30:18 - INFO - NINDEXING] Deleting index iend_time] on table tservicestateevents]
2023-07-11 09:30:18 - INFO - NINDEXING] Adding index iin_downtime, start_time, end_time] on table tservicestateevents]
2023-07-11 09:30:18 - INFO - NINDEXING] Adding index iend_time] on table tservicestateevents]
2023-07-11 09:30:18 - INFO - NINDEXING] Adding index ihost_id, service_id, start_time, end_time, ack_time, state, last_update] on table tservicestateevents]
2023-07-11 09:30:18 - INFO - NCREATE] Deleting table tmod_bam_reporting_ba_events_durations]
2023-07-11 09:30:18 - INFO - NCREATE] Add table tmod_bam_reporting_ba_events_durations]
2023-07-11 09:30:18 - INFO - NCREATE] Deleting table tinstances]
2023-07-11 09:30:18 - INFO - NCREATE] Add table tinstances]
2023-07-11 09:30:20 - INFO - NCREATE] Deleting table tmod_bam_reporting_bv]
2023-07-11 09:30:20 - INFO - NCREATE] Add table tmod_bam_reporting_bv]
2023-07-11 09:30:20 - INFO - NCREATE] Deleting table tmetrics]
2023-07-11 09:30:20 - INFO - NCREATE] Add table tmetrics]
2023-07-11 09:30:20 - INFO - NLOAD] import table thosts]
2023-07-11 09:30:20 - INFO - NLOAD] import table tmod_bam_reporting_kpi]
2023-07-11 09:30:20 - INFO - NLOAD] import table tinstances]
2023-07-11 09:30:20 - INFO - NCREATE] Deleting table tmod_bam_reporting_ba]
2023-07-11 09:30:20 - INFO - NCREATE] Add table tmod_bam_reporting_ba]
2023-07-11 09:30:20 - INFO - NCREATE] Deleting table tindex_data]
2023-07-11 09:30:20 - INFO - NCREATE] Add table tindex_data]
2023-07-11 09:30:22 - INFO - NCREATE] Deleting table tmod_bam_reporting_timeperiods]
2023-07-11 09:30:22 - INFO - NCREATE] Add table tmod_bam_reporting_timeperiods]
2023-07-11 09:30:24 - INFO - NCREATE] Deleting table tmod_bam_reporting_ba_availabilities]
2023-07-11 09:30:24 - INFO - NCREATE] Add table tmod_bam_reporting_ba_availabilities]
2023-07-11 09:30:24 - INFO - NLOAD] import table tmod_bam_reporting_ba_events]
2023-07-11 09:30:26 - INFO - NCREATE] Deleting table tmod_bam_reporting_relations_ba_kpi_events]
2023-07-11 09:30:26 - INFO - NCREATE] Add table tmod_bam_reporting_relations_ba_kpi_events]
2023-07-11 09:30:26 - INFO - NLOAD] import table tmod_bam_reporting_ba_events_durations]
2023-07-11 09:30:26 - INFO - NLOAD] import table tmod_bam_reporting_kpi_events]
2023-07-11 09:30:28 - INFO - NLOAD] import table tmod_bam_reporting_timeperiods]
2023-07-11 09:30:30 - INFO - NLOAD] import table tmod_bam_reporting_relations_ba_kpi_events]
2023-07-11 09:30:30 - INFO - NLOAD] import table thoststateevents]
2023-07-11 09:30:30 - INFO - NLOAD] import table tmod_bam_reporting_bv]
2023-07-11 09:30:34 - INFO - NLOAD] import table tdowntimes]
2023-07-11 09:30:36 - INFO - NLOAD] import table tindex_data]
2023-07-11 09:30:56 - INFO - NLOAD] import table tmetrics]
2023-07-11 09:31:04 - INFO - NLOAD] import table tcentreon_acl]
2023-07-11 09:31:08 - INFO - NCREATE] Deleting table tacknowledgements]
2023-07-11 09:31:08 - INFO - NCREATE] Add table tacknowledgements]
2023-07-11 09:31:08 - INFO - NCREATE] Deleting table tmod_bam_reporting_relations_ba_bv]
2023-07-11 09:31:08 - INFO - NCREATE] Add table tmod_bam_reporting_relations_ba_bv]
2023-07-11 09:31:08 - INFO - NLOAD] import table tmod_bam_reporting_relations_ba_bv]
2023-07-11 09:31:16 - INFO - NLOAD] import table tacknowledgements]
2023-07-11 09:31:18 - INFO - NLOAD] import table thost 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 - NLOAD] import table tservicestateevents]
2023-07-11 09:32:16 - INFO - NLOAD] import table tmod_bam_reporting_ba_availabilities]
2023-07-11 09:40:57 - INFO - NLOAD] partition i20230711] on table tdata_bin]
2023-07-11 09:40:57 - INFO - NLOAD] import table tmod_bam_reporting_ba]
2023-07-11 09:40:57 - INFO - NSCHEDULER]DIMPORT] <<<<<<< end