Discovery issues

Help
1

I discovered in librenms.log the following error, which appears often:

[2026-06-28T00:16:32][ERROR] SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column ‘remote_version’ at row 1 (Connection: mysql, Host: 192.168.30.171, Port: 3306, Database:
librenms, SQL: UPDATE links set local_device_id=944,remote_platform=cisco WS-C4506-E,remote_version=Cisco IOS Software, IOS-XE Software, Catalyst 4500 L3 Switch Software (cat4500es8-UNIVE
RSALK9-M), Version 03.08.08.E RELEASE SOFTWARE (fc3)
Technical Support: http://www.cisco.com/techsupport
Copyright (c) 1986-2019 by Cisco Systems, Inc.
Compiled Fri 15-Mar-19 10:22 by prod_rel_team,remote_device_id=4102,remote_port_id=947838 WHERE id = 190577) (Connection: dbFacile, SQL: UPDATE links set local_device_id=944,remote_plat form=cisco WS-C4506-E,remote_version=Cisco IOS Software, IOS-XE Software, Catalyst 4500 L3 Switch Software (cat4500es8-UNIVERSALK9-M), Version 03.08.08.E RELEASE SOFTWARE (fc3)
Technical Support: http://www.cisco.com/techsupport
Copyright (c) 1986-2019 by Cisco Systems, Inc.
Compiled Fri 15-Mar-19 10:22 by prod_rel_team,remote_device_id=4102,remote_port_id=947838 WHERE id = 190577)#0 /data/librenms/includes/discovery/functions.inc.php(234): dbUpdate()
#1 /data/librenms/includes/discovery/discovery-protocols.inc.php(84): discover_link()
#2 /data/librenms/LibreNMS/Modules/LegacyModule.php(83): include(‘…’)
#3 /data/librenms/app/Jobs/DiscoverDevice.php(130): LibreNMS\Modules\LegacyModule->discover()
#4 /data/librenms/app/Jobs/DiscoverDevice.php(55): App\Jobs\DiscoverDevice->discoverModules()
#5 /data/librenms/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\Jobs\DiscoverDevice->handle()
#6 /data/librenms/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\Container\BoundMethod::Illuminate\Container{closure}()
#7 /data/librenms/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(96): Illuminate\Container\Util::unwrapIfClosure()
#8 /data/librenms/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\Container\BoundMethod::callBoundMethod()
#9 /data/librenms/vendor/laravel/framework/src/Illuminate/Container/Container.php(799): Illuminate\Container\BoundMethod::call()
#10 /data/librenms/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(129): Illuminate\Container\Container->call()
#11 /data/librenms/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Bus\Dispatcher->Illuminate\Bus{closure}()
#12 /data/librenms/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(137): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}()
#13 /data/librenms/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(133): Illuminate\Pipeline\Pipeline->then()
#14 /data/librenms/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(136): Illuminate\Bus\Dispatcher->dispatchNow()
#15 /data/librenms/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Queue\CallQueuedHandler->Illuminate\Queue{closure}()
#16 /data/librenms/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(137): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}()
#17 /data/librenms/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(129): Illuminate\Pipeline\Pipeline->then()
#18 /data/librenms/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(70): Illuminate\Queue\CallQueuedHandler->dispatchThroughMiddleware()
#19 /data/librenms/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(102): Illuminate\Queue\CallQueuedHandler->call()
#20 /data/librenms/vendor/laravel/framework/src/Illuminate/Queue/SyncQueue.php(131): Illuminate\Queue\Jobs\Job->fire()
#21 /data/librenms/vendor/laravel/framework/src/Illuminate/Queue/SyncQueue.php(111): Illuminate\Queue\SyncQueue->executeJob()
#22 /data/librenms/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(246): Illuminate\Queue\SyncQueue->push()
#23 /data/librenms/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(230): Illuminate\Bus\Dispatcher->pushCommandToQueue()
#24 /data/librenms/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(98): Illuminate\Bus\Dispatcher->dispatchToQueue()
#25 /data/librenms/app/PerDeviceProcess.php(78): Illuminate\Bus\Dispatcher->dispatchSync()
#26 /data/librenms/app/Console/Commands/DeviceDiscover.php(76): App\PerDeviceProcess->run()
#27 /data/librenms/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\Console\Commands\DeviceDiscover->handle()
#28 /data/librenms/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\Container\BoundMethod::Illuminate\Container{closure}()
#29 /data/librenms/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(96): Illuminate\Container\Util::unwrapIfClosure()
#30 /data/librenms/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\Container\BoundMethod::callBoundMethod()
#31 /data/librenms/vendor/laravel/framework/src/Illuminate/Container/Container.php(799): Illuminate\Container\BoundMethod::call()
#32 /data/librenms/vendor/laravel/framework/src/Illuminate/Console/Command.php(211): Illuminate\Container\Container->call()
#33 /data/librenms/vendor/symfony/console/Command/Command.php(341): Illuminate\Console\Command->execute()
#34 /data/librenms/vendor/laravel/framework/src/Illuminate/Console/Command.php(180): Symfony\Component\Console\Command\Command->run()
#35 /data/librenms/vendor/symfony/console/Application.php(1117): Illuminate\Console\Command->run()
#36 /data/librenms/vendor/symfony/console/Application.php(356): Symfony\Component\Console\Application->doRunCommand()
#37 /data/librenms/vendor/symfony/console/Application.php(195): Symfony\Component\Console\Application->doRun()
#38 /data/librenms/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(198): Symfony\Component\Console\Application->run()
#39 /data/librenms/lnms(35): Illuminate\Foundation\Console\Kernel->handle()
#40 {main}

I am not sure when this started because logs are rotated every day and keep for a week.

A manual discovery works fine. There are also discovers in the log with no problems. Probably this is correlated to the cisco node with the large data for the remote_version column.

===========================================

Component Version
LibreNMS 26.6.1 (2026-06-17T16:28:19+02:00)
DB Schema 2026_06_09_000000_change_vsz_to_big_int_processes_table (390)
PHP 8.2.26
Python 3.9.2
Database MariaDB 10.5.19-MariaDB-0+deb11u2
RRDTool 1.7.2
SNMP 5.9
===========================================

[OK] Composer Version: 2.10.1
[OK] Dependencies up-to-date.
[OK] Database Connected
[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 is enabled
[OK] Locks are functional
[OK] Python wrapper cron entry is not present
[OK] Redis is functional
[WARN] IPv6 is disabled on your server, you will not be able to add IPv6 devices.
[INFO] Checking RRD files took too long, check skipped. You can run lnms maintenance:rrd-step all to check and fix all rrd files.
[OK] rrdtool version ok
[OK] Connected to rrdcached