Whoops, looks like something went wrong. Post mariadb 10.6 update

[Larry_Black]

Hey Librenms Community,

First off, thank you so much for all your work. I appreciate this community existing. I am running into a challenge with our current installation so let me provide the particulars first.

$ ./validate.php

Component	Version
LibreNMS	21.6.0-39-g784c19587
DB Schema	2021_25_01_0127_create_isis_adjacencies_table (211)
PHP	7.4.21
Python	3.6.9
MySQL	10.6.3-MariaDB-1:10.6.3+maria~bionic
RRDTool	1.7.0
SNMP	NET-SNMP 5.7.3

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

[OK] Composer Version: 2.1.3
[OK] Dependencies up-to-date.
[OK] Database connection successful
[OK] Database schema correct

$ ./daily.sh
Updating to latest codebase OK
Updating Composer packages OK
Updating SQL-Schema OK
Updating submodules OK
Cleaning up DB OK
Fetching notifications OK
Caching PeeringDB data OK
Caching Mac OUI data OK

https://p.libren.ms/view/d47e3624

Running on Ubuntu 18.04.5 LTS

This was after following directions to upgrade from mariadb 10.1. I have backups and can restore the vm if I need to.

Thanks for your help!

[rhinoau]

Would not expect those SQL errors in the paste about the Routers device group to break the interface - have tested locally by breaking mine. The same sorts of errors will show up with invalid alerts macros/sql etc. too.
Do you have other things in the logs other than that? Such as long Illuminate or laravel and ‘[stacktrace]’ anywhere?

Try something like: $ grep -A5 '\[stack' logs/librenms.log

If it really is that line causing it, we can find a way to fix it, but let’s not go sifting through the database until we need to

[Larry_Black]

Hi @rhinoau. Thank you for your time. As far as I can tell that is the meat of the log file. This is the output I get from the command you provided. I included my terminal just to ensure I didn’t make a mistake in the command.

Thanks again for your time!