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 SourceForge.net 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

Hi,

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.

Thanks.
waqark3389
 
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: https://github.com/nagios-plugins/nagio ... 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.
Use Perforce? Check out our Nagios integration: https://swarm.workshop.perforce.com/pro ... -p4nagios/
dwhitfield
Former Nagios Staff
 
Posts: 4568
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 4 guests