No active polling method, no active python wrapper pollers, MySQL server has gone away

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

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.