Loss of some graphics after update 23.10.0

Help
22

I believe it doesn’t have directly to do with your issue and error messages.
As example I get the following errors in the log file from some of my devices which i didnt’t get earlier.

SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column ‘ifOutBroadcastPkts_rate’ at row 1 (Connection: mysql, SQL: UPDATE ports_statistics set ifInNUcastPkts=0,ifInNUcastPkts_prev=0,ifInNUcastPkts_rate=0,ifInNUcastPkts_delta=0,ifOutNUcastPkts=0,ifOutNUcastPkts_prev=0,ifOutNUcastPkts_rate=0,ifOutNUcastPkts_delta=0,ifInDiscards=0,ifInDiscards_prev=0,ifInDiscards_rate=0,ifInDiscards_delta=0,ifOutDiscards=0,ifOutDiscards_prev=0,ifOutDiscards_rate=0,ifOutDiscards_delta=0,ifInUnknownProtos=0,ifInUnknownProtos_prev=0,ifInUnknownProtos_rate=0,ifInUnknownProtos_delta=0,ifInBroadcastPkts=18446744073709408415,ifInBroadcastPkts_prev=18446744073709551576,ifInBroadcastPkts_rate=0,ifInBroadcastPkts_delta=0,ifOutBroadcastPkts=18446744073709544204,ifOutBroadcastPkts_prev=2,ifOutBroadcastPkts_rate=2.9373796295716E+16,ifOutBroadcastPkts_delta=9223372036854775805,ifInMulticastPkts=212439,ifInMulticastPkts_prev=53,ifInMulticastPkts_rate=676.38853503185,ifInMulticastPkts_delta=212386,ifOutMulticastPkts=7415,ifOutMulticastPkts_prev=1,ifOutMulticastPkts_rate=23.611464968153,ifOutMulticastPkts_delta=7414 WHERE port_id = 9556) (Connection: dbFacile, SQL: UPDATE ports_statistics set ifInNUcastPkts=0,ifInNUcastPkts_prev=0,ifInNUcastPkts_rate=0,ifInNUcastPkts_delta=0,ifOutNUcastPkts=0,ifOutNUcastPkts_prev=0,ifOutNUcastPkts_rate=0,ifOutNUcastPkts_delta=0,ifInDiscards=0,ifInDiscards_prev=0,ifInDiscards_rate=0,ifInDiscards_delta=0,ifOutDiscards=0,ifOutDiscards_prev=0,ifOutDiscards_rate=0,ifOutDiscards_delta=0,ifInUnknownProtos=0,ifInUnknownProtos_prev=0,ifInUnknownProtos_rate=0,ifInUnknownProtos_delta=0,ifInBroadcastPkts=18446744073709408415,ifInBroadcastPkts_prev=18446744073709551576,ifInBroadcastPkts_rate=0,ifInBroadcastPkts_delta=0,ifOutBroadcastPkts=18446744073709544204,ifOutBroadcastPkts_prev=2,ifOutBroadcastPkts_rate=2.9373796295716E+16,ifOutBroadcastPkts_delta=9223372036854775805,ifInMulticastPkts=212439,ifInMulticastPkts_prev=53,ifInMulticastPkts_rate=676.38853503185,ifInMulticastPkts_delta=212386,ifOutMulticastPkts=7415,ifOutMulticastPkts_prev=1,ifOutMulticastPkts_rate=23.611464968153,ifOutMulticastPkts_delta=7414 WHERE port_id = 9556)#0 /opt/librenms/includes/polling/ports.inc.php(935): 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(44): 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(208): 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(178): Symfony\Component\Console\Command\Command->run()
#13 /opt/librenms/vendor/symfony/console/Application.php(1081): Illuminate\Console\Command->run()
#14 /opt/librenms/vendor/symfony/console/Application.php(320): Symfony\Component\Console\Application->doRunCommand()
#15 /opt/librenms/vendor/symfony/console/Application.php(174): 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}

my version:

librenms@ubuntu-librenms:~$ ./validate.php

Component Version
LibreNMS 23.11.0 (2023-11-17T03:57:41+01:00)
DB Schema 2023_11_04_125846_packages_increase_name_column_length (273)
PHP 8.1.25
Python 3.8.10
Database MariaDB 10.6.16-MariaDB-1:10.6.16+maria~ubu2004
RRDTool 1.7.2
SNMP 5.8
===========================================

[OK] Composer Version: 2.6.5
[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] Active pollers found
[OK] Dispatcher Service not detected
[OK] Locks are functional
[OK] Python poller wrapper is polling

23

I have the same error (23.11) with the following characters  and Ã. Both translate to errors:

Invalid datetime format: 1366 Incorrect string value: ‘\xA01 via…’ for column librenms.eventlog.message at row 1 at /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php:580)"}

and

Invalid datetime format: 1366 Incorrect string value: ‘\xC3’ for column librenms.eventlog.message at row 1 at /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php:580)"}

24

Hi,

I noticed this same issue on my librenms, first seen 19/2 -24.

SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\xE4tverk...' for column `librenms`.`eventlog`.`message` at row 1
(Connection: mysql, SQL: insert into
`eventlog` (`reference`, `type`, `datetime`, `severity`, `message`, `username`, `device_id`)
values (1000, interface, 2024-03-31 10:20:14, 3, type: anslutning till lokalt nätverk* 6-npcap packet driver -> anslutning till lokalt n�tverk* 6-npcap packet driver, , 14))

And for port_descr_type:

SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\xE4tverk...' for column `librenms`.`ports`.`port_descr_type` at row 1

(Connection: mysql, SQL:
UPDATE `ports` set 
`ifAdminStatus`=up, `ifAdminStatus_prev`=?, `ifOperStatus_prev`=up,
`ifMtu`=1500, `ifSpeed_prev`=0, `ifConnectorPresent`=false,
`port_descr_type`=anslutning till lokalt n�tverk* 6-npcap packet driver,
`port_descr_descr`=NPCAP, `port_descr_notes`=NPCAP,
`ifInOctets`=0, `ifInOctets_prev`=0, `ifOutOctets`=0, `ifOutOctets_prev`=0,
`ifInErrors`=0, `ifInErrors_prev`=0, `ifOutErrors`=0, `ifOutErrors_prev`=0,
`ifInUcastPkts`=0, `ifInUcastPkts_prev`=0, `ifOutUcastPkts`=0, `ifOutUcastPkts_prev`=0,
`poll_time`=1712145015, `poll_prev`=?,`poll_period`=1712145015
WHERE `port_id` = 1036)

(Connection: dbFacile, SQL: UPDATE `ports` set
`ifAdminStatus`=up, `ifAdminStatus_prev`=?, `ifOperStatus_prev`=up,
`ifMtu`=1500, `ifSpeed_prev`=0, `ifConnectorPresent`=false,
`port_descr_type`=anslutning till lokalt n�tverk* 6-npcap packet driver, 
`port_descr_descr`=NPCAP, `port_descr_notes`=NPCAP, 
`ifInOctets`=0,`ifInOctets_prev`=0,`ifOutOctets`=0,`ifOutOctets_prev`=0,
`ifInErrors`=0,`ifInErrors_prev`=0,`ifOutErrors`=0,`ifOutErrors_prev`=0,
`ifInUcastPkts`=0,`ifInUcastPkts_prev`=0,`ifOutUcastPkts`=0,`ifOutUcastPkts_prev`=0,
`poll_time`=1712145015,`poll_prev`=?,`poll_period`=1712145015
WHERE `port_id` = 1036)

I can wrap them in utf8_encode() so the polling goes through (i.e. doesn’t crash) but then my eventlog gets spammed with

type: anslutning till lokalt nätverk* 6-npcap packet driver -> anslutning till lokalt nätverk* 6-npcap packet driver
type: anslutning till lokalt nätverk* 7-npcap packet driver -> anslutning till lokalt nätverk* 7-npcap packet driver
type: anslutning till lokalt nätverk* 8-npcap packet driver -> anslutning till lokalt nätverk* 8-npcap packet driver

every time it does a poll.

My current librenms setup:

===========================================
Component | Version
--------- | -------
LibreNMS  | 24.3.0 (2024-04-01T17:18:44+02:00)
DB Schema | 2021_02_09_122930_migrate_to_utf8mb4 (290)
PHP       | 8.1.27
Python    | 3.9.2
Database  | MariaDB 10.4.21-MariaDB-1:10.4.21+maria~buster-log
RRDTool   | 1.7.2
SNMP      | 5.9
===========================================

[OK]    Composer Version: 2.7.2
[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]    Active pollers found
[OK]    Dispatcher Service not detected
[OK]    Locks are functional
[OK]    Python poller wrapper is polling
[OK]    Redis is unavailable
[WARN]  IPv6 is disabled on your server, you will not be able to add IPv6 devices.
[OK]    rrd_dir is writable
[OK]    rrdtool version ok