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
[email protected]:~$ ./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