check_mysql returning critical even when slave running

This forum is intended for the discussion of Nagios plugin development. Feature requests, patches, bug fixes, and all types of development-related discussions are welcome!

NOTE: The nagiosplug-devel mailing list has been deprecated in favor of this forum in order to expedite support and provide additional features not available on the old mailing list.

check_mysql returning critical even when slave running

Postby waqark3389 » Tue Dec 05, 2017 10:18 am

Name : nagios-plugins-mysql
Arch : x86_64
Version : 2.2.1
Release : 4git.el7


I am checking a mariadb slave via the following command:

/usr/lib64/nagios/plugins/check_mysql --check-slave -u root --warning 1000 -p......

This SOMETIMES is returning an exit code of 2 due to mariadb returning the following:

Slave IO: Preparing Slave SQL: Yes Seconds Behind Master: (null)

This is not an error and the slave is still actually running. I think the check is expecting YES and anything else is seen as a critical.

Is this a bug or am I using it incorrectly.

Posts: 1
Joined: Tue Dec 05, 2017 10:12 am

Re: check_mysql returning critical even when slave running

Postby dwhitfield » Tue Dec 05, 2017 3:38 pm

I was about to point you to github, but you seem to have already found it: ... issues/347

I did look over the thread and the code, and had another tech take a look too. Neither of us is C devs, but my hunch was you were using a new version of MariaDB, because what you were saying and the code seemed to match up. You seem to have come to that conclusion as well.

I can't speak authoritatively on what the devs will do, but I'd be shocked if we didn't support MariaDB 10.2 at some point.
Former Nagios Staff
Posts: 4569
Joined: Wed Sep 21, 2016 10:29 am
Location: NoLo, Minneapolis, MN

Return to Nagios Plugin Development

Who is online

Users browsing this forum: No registered users and 2 guests