MySQL Errors

Hi All,

We’re running the daily build of LibreNMS, and we’re seeing issues in the librenms.log file like so -

2018-03-21 13:12:19 MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘LIMIT 1’ at line 1 ( LIMIT 1)
2018-03-21 13:12:20 MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘LIMIT 1’ at line 1 ( LIMIT 1)
2018-03-21 13:12:20 MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘LIMIT 1’ at line 1 ( LIMIT 1)
2018-03-21 13:12:20 MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘LIMIT 1’ at line 1 ( LIMIT 1)
2018-03-21 13:12:21 MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘LIMIT 1’ at line 1 ( LIMIT 1)

====================================

Component Version
LibreNMS 1.37-83-g607a7f8
DB Schema 246
PHP 7.0.28-0ubuntu0.16.04.1
MySQL 10.0.34-MariaDB-0ubuntu0.16.04.1
RRDTool 1.5.5
SNMP NET-SNMP 5.7.3

====================================

[OK] Composer Version: 1.6.3
[OK] Dependencies up-to-date.
[OK] Database connection successful
[OK] Database schema correct
[WARN] Some devices have not been polled in the last 5 minutes. You may have performance issues.
[FIX] Check your poll log and see: http://docs.librenms.org/Support/Performance/
Devices:

and 26 more…
[FAIL] Some devices have not completed their polling run in 5 minutes, this will create gaps in data.
[FIX] Check your poll log and see: http://docs.librenms.org/Support/Performance/
Devices:
cap01
[FAIL] Discovery has not completed in the last 24 hours.
[FIX] Check the cron job to make sure it is running and using discovery-wrapper.py

We’re monitoring around 500 devices (mixed Cisco Router, Juniper EX) via the install on a VM which has 220GB Disk, 16GB memory, and 8xvCPU. About 250 devices were added last weekend, and before that we didn’t have any problems, however, over the last few days, the CPU has been maxed at 100% almost constantly with MySQL consuming the most CPU. We originally had 4vCPU, but this was increased.

Are the syntax errors linked, does anyone think, or is the issue separate?

Cheers
Andy

Looks like a bad group or alert rule. Check them over to make sure they are valid.

1 Like

Hi laf,

Thanks a lot for the prompt response.

You were correct, it was actually both. Group rule with a typo (several in-fact, as we have over 170 groups), and a processor alert rule which wasn’t written right.

Much appreciated for the pointers. 8 cores now with 1.7, 1.6, 1.6 load average, and memory use down from 16G to about 6.

Cheers
Andy