Error polling mpls module. Check log file for more details. - SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'mplsLspFromAddr' cannot be null

Help
1

Hello.
Today, I noticed that the MPLS tab on LibreNMS of our Nokia 7750 routers disappeared.
When I checked the log tab, an error saying Error polling mpls module. Check log file for more details. appears.
After checking librenms.log file, the file contains the following errors (the errors started at 2025-01-20T00:20:19 UTC)

%rError polling mpls module for x.x.x.x.%n ErrorException: Attempt to read property “svc_id” on null in /opt/librenms/LibreNMS/OS/Timos.php:589

%rError polling mpls module for x.x.x.x.%n PDOException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘mplsLspFromAddr’ cannot be null in /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php:612

Next Illuminate\Database\QueryException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘mplsLspFromAddr’ cannot be null (Connection: mysql, SQL: update mpls_lsps set mplsLspRowStatus = 1, mplsLspAdminState = 2, mplsLspOperState = 2, mplsLspFromAddr = ?, mplsLspToAddr = ?, mplsLspType = 2, mplsLspFastReroute = 1, mplsLspAge = 531265906, mplsLspTimeUp = 531240863, mplsLspLastTransition = 5312409 where lsp_id = 61) in /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php:829

It worked correctly for months, and this SQL error appeared all of a sudden.
Is anyone experiencing the same errors? Was there any change on the DB or validations?

Regards.

2

Hey Platinum1,

yes, we have the same problem. MPLS no longer works as well as it used to - it seems to hang. BGP is suddenly missing completely - despite poller etc. on enable. I set up a fresh Libre instance in the lab - same shit. I’m almost out of my mind and still have no solution. We still use a rendudantes monitoring from another vendor where BGP info is coming but that’s no solution… It’s generally slow.

Regards,

MS

3

I experience similar issue with MPLS on Nokia hardware, 7250IXR-s
Seems it have started on january 20th as you have pointed out.
7250 reports “error polling MPLS module” on every polling cycle (5 min)
We do have some 7210 SAS and no issues there

4

Hello,

Same problem here with 7750 and 7250 but only with new software release. A old 7750 unit has no problem to monitoring MPLS stuff.

5

hello guys is there any solution? i have sam issue on my 7750SR , for 10 same 7750sr it working, for some it does not work with the same error :frowning:

6

I created an issue on github about this.
Did you also started to experience this error around 20th of january?

7

actually i got this error ([2025-02-11T14:28:58][ERROR] %rError discovering mpls module for 10.25.0.1.%n PDOException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘mplsLspFromAddr’ cannot be null in /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/MySqlConnection.php:45)
on some of my 7750 sr , but for another routers had no that error

so I solve it by removing stirring from PHP confit
librenms/LibreNMS/Modules/Mpls.php file this 2 strings

if ($os instanceof MplsDiscovery) {
Log::info('MPLS LSPs: ');
ModuleModelObserver::observe(\App\Models\MplsLsp::class);
$lsps = $this->syncModels($os->getDevice(), ‘mplsLsps’, $os->discoverMplsLsps());

        Log::info('MPLS LSP Paths: ');
        ModuleModelObserver::observe(\App\Models\MplsLspPath::class);
        $paths = $this->syncModels($os->getDevice(), 'mplsLspPaths', $os->discoverMplsPaths($lsps));

after that discovery.php script works for the rest mpls moduls:
mpls lsp , and path modules is not nessessory for my