mysql slave replication status empty result set and check_mk error
Posted by: A S Raghav Naidu Mangineni
Date: August 21, 2018 01:19AM

Can someone help me understand the cause for below error. The slave status returned is an empty set and the check_mk plugin crashes with the below error when trying to monitor the replication status. Many thanks for your help in advance.


command run on mysql server to produce output:
mysql --defaults-extra-file=$mycnf -s \
-e "SELECT '<<<mysql_slave>>>' ; show slave status\G"



Mysql output:
mysql> SELECT '<<<mysql_slave>>>' ; show slave status\G
+-------------------+
| <<<mysql_slave>>> |
+-------------------+
| <<<mysql_slave>>> |
+-------------------+
1 row in set (0.00 sec)

Empty set (0.00 sec)


Message on monitoring server:
Checkoutput:
Check output: check failed - please submit a crash report!
Check_MK Version: 1.2.6p15
Date: 2018-08-07 11:33:45
Host: xxx.yyy.sys
Service: MySQL DB Slave
Check type: mysql_slave
Item: None
Parameters: {}
Traceback (most recent call last):
File "/omd/sites/file1.sys", line 1118, in do_all_checks_on_host
File "/omd/sites/file1.sys", line 4563, in check_mysql_slave
KeyError: 'Slave_IO_Running'

Options: ReplyQuote




Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.