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