search

centreon / centreon-dsm

Dynamic Service Monitoring
4 stars 7 forks source link

DSM stops displaying alerts #49

Open lordtaki opened 5 years ago

lordtaki commented 5 years ago

BUG REPORT INFORMATION

Prerequisites

Versions

centreon-2.8.26-3.el7.centos.noarch centreon-dsm-client-2.1.2-1.el7.centos.noarch centreon-dsm-server-2.1.2-1.el7.centos.noarch

Operating System

Red Hat Enterprise Linux Server release 7.2 (Maipo)

Description

Alerts handled by DSM are not displayed any more. But they are inserted in MySQL.

Steps to Reproduce

Happened after switching from one node to another in VCS. DSM daemon was up and running.

In centreon-dsm.log:

2019-03-06 17:50:17 - [II] [Daemon] Error when connecting to database centreon : Lost connection to MySQL server during query

2019-03-06 17:50:19 - [II] [Daemon] Error when connecting to database centreon : Can't connect to MySQL server on '10.60.21.209' (111 "Connection refused")

2019-03-06 17:50:21 - [II] [Daemon] Error when connecting to database centreon : Can't connect to MySQL server on '10.60.21.209' (111 "Connection refused")

2019-03-06 17:50:23 - [II] [Daemon] Error when connecting to database centreon : Can't connect to MySQL server on '10.60.21.209' (111 "Connection refused")

2019-03-06 17:50:25 - [II] [Daemon] Error when connecting to database centreon : Can't connect to MySQL server on '10.60.21.209' (111 "Connection refused")

2019-03-06 17:50:27 - [II] [Daemon] Error when connecting to database centreon : Can't connect to MySQL server on '10.60.21.209' (111 "Connection refused")

2019-03-06 17:50:29 - [II] [Daemon] Error when connecting to database centreon : Can't connect to MySQL server on '10.60.21.209' (111 "Connection refused")

2019-03-06 17:50:31 - [II] [Daemon] Error when connecting to database centreon : Can't connect to MySQL server on '10.60.21.209' (111 "Connection refused")

2019-03-06 17:50:33 - [II] [Daemon] Error when getting drop and perfdata properties : Table 'centreon.cfg_ndo2db' doesn't exist 2019-03-06 17:50:33 - [II] [Daemon] Error when connecting to database : Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2 "No such file or directory")

2019-03-06 17:50:34 - [II] [client] Insert Alarm for host ...... 2019-03-06 17:50:35 - [II] [Daemon] Error when getting drop and perfdata properties : Table 'centreon.cfg_ndo2db' doesn't exist 2019-03-06 17:50:35 - [II] [Daemon] Error when connecting to database : Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2 "No such file or directory")

2019-03-06 17:50:36 - [II] [client] Insert Alarm for host ...... 2019-03-06 17:50:37 - [II] [Daemon] Error when getting drop and perfdata properties : Table 'centreon.cfg_ndo2db' doesn't exist

Describe the received result

Describe the expected result

Additional relevant information (e.g. frequency, ...)

The MySQL cluster (VCS) switched to another node at 17:49:35 and was back available at 17:50:35

Restarting the daemon solved the issue.

In centreon-dsm.log:

2019-03-08 13:28:35 - [II] [Daemon] Error when getting drop and perfdata properties : Table 'centreon.cfg_ndo2db' doesn't exist 2019-03-08 13:28:35 - [II] [Daemon] Error when connecting to database : Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2 "No such file or directory")

2019-03-08 13:28:36 - [II] [Daemon] Receiving order to stop... 2019-03-08 13:28:36 - [EE] [Daemon] MySQL server has gone away 2019-03-08 13:28:36 - [II] [Daemon] Error:MySQL server has gone away

2019-03-08 13:29:09 - [II] [Daemon] Starting DSMD 2019-03-08 13:29:12 - [II] [Daemon] Send external command : [1552051752] CHANGE_CUSTOM_SVC_VAR;......

lpinsivy commented 5 years ago

update to DSM 2.2.2