Ospf3 module polling problem

Help
1

arista EOS device
in the event log “Error polling ospfv3 module. Check log file for more details.”

Here is the log file

librenms@librenms:~$ ./validate.php

Component Version
LibreNMS 25.2.0-18-g4cfd5a886 (2025-02-28T04:09:23-05:00)
DB Schema 2025_01_20_125000_create_ospfv3_ports_table (319)
PHP 8.2.27
Python 3.10.12
Database MariaDB 10.6.18-MariaDB-0ubuntu0.22.04.1
RRDTool 1.7.2
SNMP 5.9.1
===========================================

[OK] Composer Version: 2.8.6
[OK] Dependencies up-to-date.
[OK] Database connection successful
[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] Database and column collations are correct
[OK] Database schema correct
[OK] MySQL and PHP time match
[OK] Distributed Polling setting is enabled globally
[OK] Connected to rrdcached
[OK] Active pollers found
[OK] Dispatcher Service not detected
[OK] Locks are functional
[OK] Python poller wrapper is polling
[OK] Redis is functional
[OK] rrdtool version ok
[OK] Connected to rrdcached
[WARN] Your local git contains modified files, this could prevent automatic updates.
[FIX]:
You can fix this with ./scripts/github-remove
Modified Files:
resources/views/layouts/menu.blade.php
[FAIL] We have found some files that are owned by a different user than ‘librenms’, this will stop you updating automatically and / or rrd files being updated causing graphs to fail.
[FIX]:
sudo chown -R librenms:librenms /opt/librenms
sudo setfacl -d -m g::rwx /opt/librenms/rrd /opt/librenms/logs /opt/librenms/bootstrap/cache/ /opt/librenms/storage/
sudo chmod -R ug=rwX /opt/librenms/rrd /opt/librenms/logs /opt/librenms/bootstrap/cache/ /opt/librenms/storage/
Files:
/opt/librenms/rrd/smokeping/__sortercache/data.lnmsFPing-1.storable
/opt/librenms/rrd/smokeping/__sortercache/data.lnmsFPing-0.storable
/opt/librenms/rrd/smokeping/network/10_248_147_50.rrd
/opt/librenms/rrd/smokeping/network/10_248_115_21.rrd
/opt/librenms/rrd/smokeping/network/10_248_147_40.rrd
/opt/librenms/rrd/smokeping/network/10_248_147_45.rrd
/opt/librenms/rrd/smokeping/network/10_248_147_60.rrd
/opt/librenms/rrd/smokeping/network/10_248_147_26.rrd
/opt/librenms/rrd/smokeping/network/10_248_147_55.rrd
/opt/librenms/rrd/smokeping/network/10_248_98_76.rrd
/opt/librenms/rrd/smokeping/network/10_248_115_23.rrd
/opt/librenms/rrd/smokeping/network/162_255_95_41.rrd
/opt/librenms/rrd/smokeping/network/10_248_115_22.rrd
/opt/librenms/rrd/smokeping/network/10_248_147_61.rrd

2

Hi @Zach_Underwood
Fix should come with PR #17215..

1 Like
3

I ran daily.sh to update, and I am still getting the same error

librenms@librenms:~$ ./validate.php 
===========================================
Component | Version
--------- | -------
LibreNMS  | 25.2.0-26-g6d572c921 (2025-03-02T18:14:18-05:00)
DB Schema | 2025_01_30_214311_create_ipv6_nd_table (320)
PHP       | 8.2.27
Python    | 3.10.12
Database  | MariaDB 10.6.18-MariaDB-0ubuntu0.22.04.1
RRDTool   | 1.7.2
SNMP      | 5.9.1
4

Hello
Still an error, but not the same. A typo. New PR on the way to fix the fix …

5

2nd fix merged. Please test and let us know

6

updated to
librenms@librenms:~$ ./validate.php

Component Version
LibreNMS 25.2.0-31-gc37e0afdc (2025-03-03T09:38:56-05:00)
DB Schema 2025_01_30_214311_create_ipv6_nd_table (320)
PHP 8.2.27
Python 3.10.12
Database MariaDB 10.6.18-MariaDB-0ubuntu0.22.04.1
RRDTool 1.7.2
SNMP 5.9.1
===========================================

but still hitting error

SQLSTATE[HY000]: General error: 1364 Field 'ospfv3AreaScopeLsaCksumSum' doesn't have a default value (Connection: mysql, SQL: insert into `ospfv3_areas` (`device_id`, `ospfv3AreaId`, `context_name`, `ospfv3AreaImportAsExtern`, `ospfv3AreaSpfRuns`, `ospfv3AreaBdrRtrCount`, `ospfv3AreaAsBdrRtrCount`, `ospfv3AreaScopeLsaCount`, `ospfv3AreaSummary`, `ospfv3AreaStubMetric`, `ospfv3AreaStubMetricType`) values (7873, 0, , importExternal, 765681, 3, 61, 134, sendAreaSummary, 0, ospfv3Metric)) {"exception":"[object] (Illuminate\\Database\\QueryException(code: HY000): SQLSTATE[HY000]: General error: 1364 Field 'ospfv3AreaScopeLsaCksumSum' doesn't have a default value (Connection: mysql, SQL: insert into `ospfv3_areas` (`device_id`, `ospfv3AreaId`, `context_name`, `ospfv3AreaImportAsExtern`, `ospfv3AreaSpfRuns`, `ospfv3AreaBdrRtrCount`, `ospfv3AreaAsBdrRtrCount`, `ospfv3AreaScopeLsaCount`, `ospfv3AreaSummary`, `ospfv3AreaStubMetric`, `ospfv3AreaStubMetricType`) values (7873, 0, , importExternal, 765681, 3, 61, 134, sendAreaSummary, 0, ospfv3Metric)) at /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php:829)
[previous exception] [object] (PDOException(code: HY000): SQLSTATE[HY000]: General error: 1364 Field 'ospfv3AreaScopeLsaCksumSum' doesn't have a default value at /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/MySqlConnection.php:45)"} 

and 

Next Illuminate\Database\QueryException: SQLSTATE[HY000]: General error: 1364 Field 'ospfv3AreaScopeLsaCksumSum' doesn't have a default value (Connection: mysql, SQL: insert into `ospfv3_areas` (`device_id`, `ospfv3AreaId`, `context_name`, `ospfv3AreaImportAsExtern`, `ospfv3AreaSpfRuns`, `ospfv3AreaBdrRtrCount`, `ospfv3AreaAsBdrRtrCount`, `ospfv3AreaScopeLsaCount`, `ospfv3AreaSummary`, `ospfv3AreaStubMetric`, `ospfv3AreaStubMetricType`) values (7873, 0, , importExternal, 765681, 3, 61, 134, sendAreaSummary, 0, ospfv3Metric)) in /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php:829

device os
Hardware: DCS-7060SX2-48YC6
OS Version: 4.30.3M

7

Is it a leftover from before the application of the 2nd fix, or do you see new lines coming in a each and every poll ?
The code "25.2.0-31-gc37e0afdc " is the expected one so I don’t see how ospfv3AreaScopeLsaCksumSum could be null. And I can’t reproduce your issue so I am a bit blind here.

9

after I updated I did a lnms device:po xxxx, I saw the error in the output,

I can share you my ssh session log over DM if you wish. It does not have passwords in but there are some IPs I dont want to share publicly.

1 Like
10

Running 25.2.0-54-g6a11c2eee and this is still ongoing problem.