How to fix Whoops, looks like something went wrong

after update
device ports not showing
erorr Whoops, looks like something went wrong. Check your librenms.log.

librenms@threesa:~$ ./validate.php

Component Version
LibreNMS 24.6.0-23-g8ac1e9a40 (2024-06-25T19:32:16+05:30)
DB Schema 2024_04_29_183605_custom_maps_drop_background_suffix_and_background_version (294)
PHP 8.1.2-1ubuntu2.18
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.7.7
[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] 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 unavailable
[OK] rrdtool version ok
[OK] Connected to rrdcached

Check you Nginx Config for /run/php link up with php file

other device is properly working but some huaweie devices port option not showing

Hardware

S6730-H48X6C

Operating System

Huawei VRP 5.170 (V200R020C10SPC500)

If you bring up the error page, what is the error in the librenms.log file?

I cleared all logs, opened the LibreNMS web page, clicked on a device, and then on ports. After that, I got this error: { Whoops, looks like something went wrong. Check your librenms.log. } If I click on a single port from the device overview on the home page, the graph and all details for that port are shown properly. However, an error appears when I click on the ‘all ports’ option. This issue did not occur before updating to LibreNMS version 24.1; it started after the update."

please check my librenms.log file logs
help me to fix this thank you in advance

SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column ‘ifInBroadcastPkts_rate’ at row 1 (Connection: mysql, SQL: UPDATE ports_statistics set ifInNUcastPkts=0,ifInNUcastPkts_prev=954008,ifInNUcastPkts_rate=0,ifInNUcastPkts_delta=0,ifOutNUcastPkts=0,ifOutNUcastPkts_prev=468432,ifOutNUcastPkts_rate=0,ifOutNUcastPkts_delta=0,ifInDiscards=842085681,ifInDiscards_prev=959853617,ifInDiscards_rate=0,ifInDiscards_delta=0,ifOutDiscards=3068762700,ifOutDiscards_prev=3068762700,ifOutDiscards_rate=0,ifOutDiscards_delta=0,ifInUnknownProtos=0,ifInUnknownProtos_prev=0,ifInUnknownProtos_rate=0,ifInUnknownProtos_delta=0,ifInBroadcastPkts=11665630354215010465,ifInBroadcastPkts_prev=0,ifInBroadcastPkts_rate=2.9657144813038E+16,ifInBroadcastPkts_delta=9223372036854775807,ifOutBroadcastPkts=4295454208,ifOutBroadcastPkts_prev=0,ifOutBroadcastPkts_rate=13811749.864952,ifOutBroadcastPkts_delta=4295454208,ifInMulticastPkts=691489734657,ifInMulticastPkts_prev=0,ifInMulticastPkts_rate=2223439661.2765,ifInMulticastPkts_delta=691489734657,ifOutMulticastPkts=11665638208131344924,ifOutMulticastPkts_prev=0,ifOutMulticastPkts_rate=2.9657144813038E+16,ifOutMulticastPkts_delta=9223372036854775807 WHERE port_id = 53149) (Connection: dbFacile, SQL: UPDATE ports_statistics set ifInNUcastPkts=0,ifInNUcastPkts_prev=954008,ifInNUcastPkts_rate=0,ifInNUcastPkts_delta=0,ifOutNUcastPkts=0,ifOutNUcastPkts_prev=468432,ifOutNUcastPkts_rate=0,ifOutNUcastPkts_delta=0,ifInDiscards=842085681,ifInDiscards_prev=959853617,ifInDiscards_rate=0,ifInDiscards_delta=0,ifOutDiscards=3068762700,ifOutDiscards_prev=3068762700,ifOutDiscards_rate=0,ifOutDiscards_delta=0,ifInUnknownProtos=0,ifInUnknownProtos_prev=0,ifInUnknownProtos_rate=0,ifInUnknownProtos_delta=0,ifInBroadcastPkts=11665630354215010465,ifInBroadcastPkts_prev=0,ifInBroadcastPkts_rate=2.9657144813038E+16,ifInBroadcastPkts_delta=9223372036854775807,ifOutBroadcastPkts=4295454208,ifOutBroadcastPkts_prev=0,ifOutBroadcastPkts_rate=13811749.864952,ifOutBroadcastPkts_delta=4295454208,ifInMulticastPkts=691489734657,ifInMulticastPkts_prev=0,ifInMulticastPkts_rate=2223439661.2765,ifInMulticastPkts_delta=691489734657,ifOutMulticastPkts=11665638208131344924,ifOutMulticastPkts_prev=0,ifOutMulticastPkts_rate=2.9657144813038E+16,ifOutMulticastPkts_delta=9223372036854775807 WHERE port_id = 53149)#0 /opt/librenms/includes/polling/ports.inc.php(936): dbUpdate()
#1 /opt/librenms/LibreNMS/Modules/LegacyModule.php(114): include(‘…’)
#2 /opt/librenms/LibreNMS/Poller.php(176): LibreNMS\Modules\LegacyModule->poll()
#3 /opt/librenms/LibreNMS/Poller.php(103): LibreNMS\Poller->pollModules()
#4 /opt/librenms/app/Console/Commands/DevicePoll.php(45): LibreNMS\Poller->poll()
#5 /opt/librenms/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\Console\Commands\DevicePoll->handle()
#6 /opt/librenms/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container{closure}()
#7 /opt/librenms/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#8 /opt/librenms/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#9 /opt/librenms/vendor/laravel/framework/src/Illuminate/Container/Container.php(662): Illuminate\Container\BoundMethod::call()
#10 /opt/librenms/vendor/laravel/framework/src/Illuminate/Console/Command.php(211): Illuminate\Container\Container->call()
#11 /opt/librenms/vendor/symfony/console/Command/Command.php(326): Illuminate\Console\Command->execute()
#12 /opt/librenms/vendor/laravel/framework/src/Illuminate/Console/Command.php(181): Symfony\Component\Console\Command\Command->run()
#13 /opt/librenms/vendor/symfony/console/Application.php(1096): Illuminate\Console\Command->run()
#14 /opt/librenms/vendor/symfony/console/Application.php(324): Symfony\Component\Console\Application->doRunCommand()
#15 /opt/librenms/vendor/symfony/console/Application.php(175): Symfony\Component\Console\Application->doRun()
#16 /opt/librenms/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(201): Symfony\Component\Console\Application->run()
#17 /opt/librenms/app/Console/Kernel.php(66): Illuminate\Foundation\Console\Kernel->handle()
#18 /opt/librenms/lnms(40): App\Console\Kernel->handle()
#19 {main}
SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column ‘ifInBroadcastPkts_rate’ at row 1 (Connection: mysql, SQL: UPDATE ports_statistics set ifInNUcastPkts=0,ifInNUcastPkts_prev=954008,ifInNUcastPkts_rate=0,ifInNUcastPkts_delta=0,ifOutNUcastPkts=0,ifOutNUcastPkts_prev=468432,ifOutNUcastPkts_rate=0,ifOutNUcastPkts_delta=0,ifInDiscards=842085681,ifInDiscards_prev=959853617,ifInDiscards_rate=0,ifInDiscards_delta=0,ifOutDiscards=3068762700,ifOutDiscards_prev=3068762700,ifOutDiscards_rate=0,ifOutDiscards_delta=0,ifInUnknownProtos=0,ifInUnknownProtos_prev=0,ifInUnknownProtos_rate=0,ifInUnknownProtos_delta=0,ifInBroadcastPkts=11665630354215010465,ifInBroadcastPkts_prev=0,ifInBroadcastPkts_rate=2.9657144813038E+16,ifInBroadcastPkts_delta=9223372036854775807,ifOutBroadcastPkts=4295454208,ifOutBroadcastPkts_prev=0,ifOutBroadcastPkts_rate=13811749.864952,ifOutBroadcastPkts_delta=4295454208,ifInMulticastPkts=691489734657,ifInMulticastPkts_prev=0,ifInMulticastPkts_rate=2223439661.2765,ifInMulticastPkts_delta=691489734657,ifOutMulticastPkts=11665638208131344924,ifOutMulticastPkts_prev=0,ifOutMulticastPkts_rate=2.9657144813038E+16,ifOutMulticastPkts_delta=9223372036854775807 WHERE port_id = 53150) (Connection: dbFacile, SQL: UPDATE ports_statistics set ifInNUcastPkts=0,ifInNUcastPkts_prev=954008,ifInNUcastPkts_rate=0,ifInNUcastPkts_delta=0,ifOutNUcastPkts=0,ifOutNUcastPkts_prev=468432,ifOutNUcastPkts_rate=0,ifOutNUcastPkts_delta=0,ifInDiscards=842085681,ifInDiscards_prev=959853617,ifInDiscards_rate=0,ifInDiscards_delta=0,ifOutDiscards=3068762700,ifOutDiscards_prev=3068762700,ifOutDiscards_rate=0,ifOutDiscards_delta=0,ifInUnknownProtos=0,ifInUnknownProtos_prev=0,ifInUnknownProtos_rate=0,ifInUnknownProtos_delta=0,ifInBroadcastPkts=11665630354215010465,ifInBroadcastPkts_prev=0,ifInBroadcastPkts_rate=2.9657144813038E+16,ifInBroadcastPkts_delta=9223372036854775807,ifOutBroadcastPkts=4295454208,ifOutBroadcastPkts_prev=0,ifOutBroadcastPkts_rate=13811749.864952,ifOutBroadcastPkts_delta=4295454208,ifInMulticastPkts=691489734657,ifInMulticastPkts_prev=0,ifInMulticastPkts_rate=2223439661.2765,ifInMulticastPkts_delta=691489734657,ifOutMulticastPkts=11665638208131344924,ifOutMulticastPkts_prev=0,ifOutMulticastPkts_rate=2.9657144813038E+16,ifOutMulticastPkts_delta=9223372036854775807 WHERE port_id = 53150)#0 /opt/librenms/includes/polling/ports.inc.php(936): dbUpdate()
#1 /opt/librenms/LibreNMS/Modules/LegacyModule.php(114): include(‘…’)
#2 /opt/librenms/LibreNMS/Poller.php(176): LibreNMS\Modules\LegacyModule->poll()
#3 /opt/librenms/LibreNMS/Poller.php(103): LibreNMS\Poller->pollModules()
#4 /opt/librenms/app/Console/Commands/DevicePoll.php(45): LibreNMS\Poller->poll()
#5 /opt/librenms/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\Console\Commands\DevicePoll->handle()
#6 /opt/librenms/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container{closure}()
#7 /opt/librenms/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#8 /opt/librenms/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#9 /opt/librenms/vendor/laravel/framework/src/Illuminate/Container/Container.php(662): Illuminate\Container\BoundMethod::call()
#10 /opt/librenms/vendor/laravel/framework/src/Illuminate/Console/Command.php(211): Illuminate\Container\Container->call()
#11 /opt/librenms/vendor/symfony/console/Command/Command.php(326): Illuminate\Console\Command->execute()
#12 /opt/librenms/vendor/laravel/framework/src/Illuminate/Console/Command.php(181): Symfony\Component\Console\Command\Command->run()
#13 /opt/librenms/vendor/symfony/console/Application.php(1096): Illuminate\Console\Command->run()
#14 /opt/librenms/vendor/symfony/console/Application.php(324): Symfony\Component\Console\Application->doRunCommand()
#15 /opt/librenms/vendor/symfony/console/Application.php(175): Symfony\Component\Console\Application->doRun()
#16 /opt/librenms/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(201): Symfony\Component\Console\Application->run()
#17 /opt/librenms/app/Console/Kernel.php(66): Illuminate\Foundation\Console\Kernel->handle()
#18 /opt/librenms/lnms(40): App\Console\Kernel->handle()
Missing required parameter for [Route: device] [URI: device/{device}/{tab?}/{vars?}] [Missing parameter: device]. {“view”:{“view”:“/opt/librenms/resources/views/components/device-link.blade.php”,“data”:},“userId”:1,“exception”:“[object] (Spatie\LaravelIgnition\Exceptions\ViewException(code: 0): Missing required parameter for [Route: device] [URI: device/{device}/{tab?}/{vars?}] [Missing parameter: device]. at /opt/librenms/vendor/laravel/framework/src/Illuminate/Routing/Exceptions/UrlGenerationException.php:35)
[previous exception] [object] (Illuminate\Routing\Exceptions\UrlGenerationException(code: 0): Missing required parameter for [Route: device] [URI: device/{device}/{tab?}/{vars?}] [Missing parameter: device]. at /opt/librenms/vendor/laravel/framework/src/Illuminate/Routing/Exceptions/UrlGenerationException.php:35)”}

SQLSTATE[22003]: Numeric value out of range , indicates that one or more values being inserted or updated in your database exceed the maximum allowed size for the corresponding columns in the database schema. Specifically, the error mentions ifInBroadcastPkts_rate and ifOutMulticastPkts_rate columns having values that are too large for their defined data types.”

Jump into mysql and run the following in the librenms database: DESCRIBE ports_statistics;

See if ifInBroadcastPkts_rate and ifOutMulticastPkts_rate are listed in there and what their values are. might need to modify these values

after im run following commands its fixed working properly thank you

cd /opt/librenms
git pull
./scripts/composer_wrapper.php install --no-dev
./lnms migrate
./validate.php

1 Like