Hello, I come across this plugin when I wanted to move away from an old perl plugin we use today. Overall this plugin is very good 😊 But I think I found an issues with thresholds when I want to alert on a decreased value range. It seems to trigger the alert just fine but warning and critical thresholds just display: 0.00000. If I change to an increased value range the threshold is displayed correctly. I’m using check_mysql_query v2.2 (monitoring-plugins 2.2) on Ubuntu (downloaded with apt install )
See examples below: Threshold show 0 if I want to alert when a value drops below x check_mysql_query -d table1 -H localhost -u test -p test -q "select count(*) from test2;" -w 10: -c 5: QUERY OK: select count(*) from test2;' returned 23.000000 | result=23.000000;0.000000;0.000000; check_mysql_query -d table1 -H localhost -u test -p test -q "select count(*) from test2;" -w 40: -c 5: QUERY WARNING: select count(*) from test2;' returned 23.000000 | result=23.000000;0.000000;0.000000; check_mysql_query -d table1 -H localhost -u test -p test -q "select count(*) from test2;" -w 60: -c 50: QUERY CRITICAL: select count(*) from test2;' returned 32.000000 | result=32.000000;0.000000;0.000000; Thresholds works fine if I want to alert on a value goes above x check_mysql_query -d table1 -H localhost -u test -p test -q "select count(*) from test2;" -w :100: -c :150 QUERY OK: select count(*) from test2;;' returned 54.000000 | result=54.000000;100.000000;150.000000; check_mysql_query -d table1 -H localhost -u test -p test -q "select count(*) from test2;" -w :40 -c :20 QUERY CRITICAL: select count(*) from test2;' returned 32.000000 | result=32.000000;40.000000;20.000000; Are you aware of this issue or do you know if the is it fixed in a later version? Or maybe I’m doing something wrong? Kind Regards Pär Segelström
