I am having an issue where the librenms.log files are growing like crazy. When I tail the log, there is an entry:
[2019-04-17 07:41:36] production.ERROR: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away (SQL: INSERT IGNORE INTO sensors
(poller_type
,sensor_class
,device_id
,sensor_oid
,sensor_index
,sensor_type
,sensor_descr
,sensor_divisor
,sensor_multiplier
,sensor_limit
,sensor_limit_low
,sensor_current
,entPhysicalIndex
,entPhysicalIndex_measured
) VALUES (snmp,temperature,12,.1.3.6.1.4.1.9.9.91.1.1.1.1.4.2106,2106,cisco-entity-sensor, - Te2/0/
35 Module ,100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000
Then the zeros repeat basically forever
-rw-rw-r-- 1 librenms librenms 47444716313 Apr 18 07:46 librenms.log
librenms@librenms:/opt/librenms/logs$ ./daily.sh
-bash: ./daily.sh: No such file or directory
librenms@librenms:/opt/librenms/logs$ cd …
librenms@librenms:/opt/librenms$ ./daily.sh
Updating to latest codebase OK
Updating Composer packages OK
Updating SQL-Schema OK
Updating submodules OK
Cleaning up DB OK
Fetching notifications OK
Caching PeeringDB data OK
librenms@librenms:/opt/librenms$ ./validate.php
Component | Version |
---|---|
LibreNMS | 1.50-47-gd5ea3d4 |
DB Schema | 2019_02_10_220000_add_dates_to_fdb (132) |
PHP | 7.3.4-1+ubuntu16.04.1+deb.sury.org+3 |
MySQL | 10.0.38-MariaDB-0ubuntu0.16.04.1 |
RRDTool | 1.5.5 |
SNMP | NET-SNMP 5.7.3 |
====================================
[OK] Composer Version: 1.8.5
[OK] Dependencies up-to-date.
[OK] Database connection successful
[OK] Database schema correct
librenms@librenms:/opt/librenms$