mysql slave replication status empty result set and check_mk error

[A S Raghav Naidu Mangineni]

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'