Ospf3 module polling problem

Zach_Underwood · 1 March 2025 12:21

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

PipoCanaja · 2 March 2025 20:16

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

Zach_Underwood · 3 March 2025 01:00

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

PipoCanaja · 3 March 2025 09:11

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

github.com/librenms/librenms

Ospfv3 module - column type still wrong

master ← PipoCanaja-patch-4

opened 09:13AM - 03 Mar 25 UTC

PipoCanaja

+2 -2

Fix the fix ... DO NOT DELETE THE UNDERLYING TEXT #### Please note > P…lease read this information carefully. You can run `./lnms dev:check` to check your code before submitting. - [ ] Have you followed our [code guidelines?](https://docs.librenms.org/Developing/Code-Guidelines/) - [ ] If my Pull Request does some changes/fixes/enhancements in the WebUI, I have inserted a screenshot of it. - [ ] If my Pull Request makes discovery/polling/yaml changes, I have added/updated [test data](https://docs.librenms.org/Developing/os/Test-Units/). #### Testers If you would like to test this pull request then please run: `./scripts/github-apply <pr_id>`, i.e `./scripts/github-apply 5926` After you are done testing, you can remove the changes with `./scripts/github-remove`. If there are schema changes, you can ask on discord how to revert.

PipoCanaja · 3 March 2025 13:11

2nd fix merged. Please test and let us know

Zach_Underwood · 3 March 2025 15:43

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

PipoCanaja · 3 March 2025 17:12

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.

Zach_Underwood · 3 March 2025 17:47

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.

Zach_Underwood · 13 March 2025 16:30

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

PipoCanaja · 19 March 2025 18:18

Ok. Then please try this :
snmpwalk -OUneb <device_IP_addr> -c <community> -v 2c .
And send me the link of the resulting text (using a direct message cause it may contain sensitive data you don’t want to expose publicly.
That will allow me to simulate your device and hopefully create a fix for it.

Zach_Underwood · 20 March 2025 11:20

Thanks I have sent you a DM with link to the full snmp walk dump.

zagosch_61526 · 27 March 2025 08:35

Hello.

I’m having the same issue after updating from 25.1.0 to 25.3.0. On my cisco devices i get; Error polling ospfv3 module. Check log file for more details.

I see the fix of fix applied in the ospfv3.php file, but still getting this error after the update to 25.3.0.

bokkepoot · 28 April 2025 12:36

I’m having the same issue as well, since 25.1, currently on 25.4.0-46-g23eb7df8f with DB schema 2025_04_15_122034_laravel_11_fix_types

Ospf3 module polling problem

librenms@librenms:~$ ./validate.php

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

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