When I click on ports: Whoops, looks like something went wrong. Check your librenms.log

When I click on ports I get: Whoops, looks like something went wrong. Check your librenms.log.

validate shows:

Component Version
LibreNMS 24.7.0-21-ge45dd59f7 (2024-07-26T08:26:04-05:00)
DB Schema 2024_07_19_120719_update_ports_stack_table (296)
PHP 8.1.27
Python 3.9.2
Database MariaDB 10.5.23-MariaDB-0+deb11u1
RRDTool 1.7.2
SNMP 5.9
===========================================

[OK] Composer Version: 2.7.7
[OK] Dependencies up-to-date.
[OK] Database connection successful
[WARN] Your database schema has extra migrations (2024_07_19_120719_update_ports_stack_table). If you just switched to the stable release from the daily release, your database is in between releases and this will be resolved with the next release.
[OK] SQL Server meets minimum requirements
[OK] lower_case_table_names is enabled
[OK] MySQL engine is optimal
[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
[OK] rrd_dir is writable
[OK] rrdtool version ok

Error in log:
SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘port_id_high’ in ‘where clause’ (Connection: mysql, SQL: select * from ports_stack where device_id = 166 and (port_id_high = 15577 or port_id_low = 15577)) {“userId”:2,“exception”:“[object] (Illuminate\Database\QueryException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘port_id_high’ in ‘where clause’ (Connection: mysql, SQL: select * from ports_stack where device_id = 166 and (port_id_high = 15577 or port_id_low = 15577)) at /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php:829)
[previous exception] [object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘port_id_high’ in ‘where clause’ at /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php:423)”}

When asking for help and support, please provide as much information as possible. This should include:

  • Steps to reproduce an issue.
  • The output of ./validate.php

If it’s an issue with the WebUI then please consider including a screenshot and the browser version you are using.

If you are having troubles with discovery/polling include the pastebin output of:

./discovery.php -h HOSTNAME -d | ./pbin.sh
./poller.php -h HOSTNAME -r -f -d | ./pbin.sh

If you need to post any text longer than a few lines, please use a pastebin service such as https://p.libren.ms using non-expiring pastes.

Ok sorry I may have posted early. I ran validate when issue first happened. everything check out fine. I then went ahead an ran daily.sh It ran without issue but did not fix issue. I re ran the validate and what I post in this was the new result. I made this post to forum and while waiting a response I ran the daily.sh again. This time took a little longer. When it finished it validated without warning. I can now click on ports without issue. wierd.

I’ll make a note for others. I had the same issue on 4 installations of librenms this morning. I already fixed 2 by running validate (had to fix multiple issues on one server and nothing on the second) and then ran daily.sh and that resolved it on both servers.

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.