I recently noticed that polling hasn’t been running properly for about 10 days. When I manually run the poller-wrapper
/opt/librenms/cronic /opt/librenms/poller-wrapper.py 16
I receive the following output
Cronic detected failure or error output for the command:
/opt/librenms/poller-wrapper.py 16
RESULT CODE: 1
ERROR OUTPUT:
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 713, in _write_bytes
self._sock.sendall(data)
ConnectionResetError: [Errno 104] Connection reset by peer
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/opt/librenms/poller-wrapper.py", line 57, in <module>
wrapper.wrapper(
File "/opt/librenms/LibreNMS/wrapper.py", line 557, in wrapper
cursor = db_connection.query(query)
File "/opt/librenms/LibreNMS/__init__.py", line 299, in query
cursor.execute(query, args)
File "/usr/lib/python3/dist-packages/pymysql/cursors.py", line 170, in execute
result = self._query(query)
File "/usr/lib/python3/dist-packages/pymysql/cursors.py", line 328, in _query
conn.query(q)
File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 516, in query
self._execute_command(COMMAND.COM_QUERY, sql)
File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 771, in _execute_command
self._write_bytes(packet)
File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 716, in _write_bytes
raise err.OperationalError(
pymysql.err.OperationalError: (2006, "MySQL server has gone away (ConnectionResetError(104, 'Connection reset by peer'))")
The SQL database seems generally fine: I’m able to connect to it without issues and it produced no errors when I ran a mysqlcheck.
Output from validate.php
librenms@LibreNMS:~$ ./validate.php
====================================
Component | Version
--------- | -------
LibreNMS | 22.9.0
DB Schema | 2022_09_03_091314_update_ports_adsl_table_with_defaults (246)
PHP | 7.4.30
Python | 3.9.2
Database | MariaDB 10.5.15-MariaDB-0+deb11u1-log
RRDTool | 1.7.2
SNMP | 5.9
====================================
[OK] Composer Version: 2.4.2
[OK] Dependencies up-to-date.
[OK] Database connection successful
[OK] Database Schema is current
[OK] SQL Server meets minimum requirements
[OK] lower_case_table_names is enabled
[OK] MySQL engine is optimal
[OK]
[OK] Database schema correct
[OK] MySQl and PHP time match
[WARN] PHP version 8.1 is the minimum supported version as of September, 2022. We recommend you update PHP to a supported version (8.1 suggested) to continue to receive updates. If you do not update PHP, LibreNMS will continue to function but stop receiving bug fixes and updates.
[FAIL] No active polling method detected
[OK] Dispatcher Service not detected
[OK] Locks are functional
[FAIL] No active python wrapper pollers found
[OK] Redis is unavailable
[OK] rrdtool version ok
[OK] Connected to rrdcached