hi, Hello, first of all, excuse my English as I speak Spanish. I’m commenting on my case to see if someone can give me some information on how to solve it. I have a CentOS 8 with LibreNMS and a MariaDB 10.3 database.
./validate.php
Component |
Version |
LibreNMS |
22.9.0-3-g06c361c2b |
DB Schema |
2022_09_03_091314_update_ports_adsl_table_with_defaults (246) |
PHP |
7.4.33 |
Python |
3.6.8 |
Database |
MariaDB 10.3.28-MariaDB |
RRDTool |
1.7.0 |
SNMP |
5.8 |
I was migrating to an Ubuntu 24.04 with MariaDB 10.11.11.
SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘vendor_ouis’ already exists (Connection: mysql, SQL: creat
e table vendor_ouis
(id
bigint unsigned not null auto_increment primary key, vendor
varchar(255) not null, oui
var
char(255) not null) default character set utf8mb4 collate ‘utf8mb4_unicode_ci’)
In Connection.php line 568:
SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘vendor_ouis’ already exists
./validate.php
Component |
Version |
LibreNMS |
25.4.0-102-ge7d6532dc (2025-05-06T09:31:09-03:00) |
DB Schema |
2023_05_12_071412_devices_expand_timetaken_doubles (253) |
PHP |
8.3.6 |
Python |
3.12.3 |
Database |
MariaDB 10.11.11-MariaDB-0ubuntu0.24.04.2 |
RRDTool |
1.7.2 |
SNMP |
5.9.4.pre2 |
When I try to transfer the information from MariaDB 10.3 to MariaDB 10.11.11, I get an error about a table “vendor_oui” which does not exist in MariaDB 10.3. Is there any way to fix this?
best resgard
Drop the table vendor_oui (this table only contains ephemeral data any way) then run migrations again and it should succeed.
1 Like
hi, The table was deleted however another problem appeared
./lnms migrate
APPLICATION IN PRODUCTION.
┌ Are you sure you want to run this command? ──────────────────â”
│ Yes │
└──────────────────────────────────────────────────────────────┘
INFO Running migrations.
2022_08_15_084506_add_rrd_type_to_sensors_table … 13.41ms DONE
2022_08_15_084507_add_rrd_type_to_wireless_sensors_table … 19.18ms DONE
2023_03_14_130653_migrate_empty_user_funcs_to_null … 2.92ms DONE
2023_04_12_174529_modify_ports_table … 221.32ms DONE
2023_04_26_185850_change_vminfo_vmw_vm_guest_o_s_nullable … 16.74ms DONE
2023_04_27_164904_update_slas_opstatus_tinyint … 57.63ms DONE
2023_05_12_071412_devices_expand_timetaken_doubles … 136.80ms DONE
2023_06_02_230406_create_vendor_oui_table … 10.79ms DONE
2023_06_18_195618_create_bouncer_tables … 81.90ms DONE
2023_06_18_201914_migrate_level_to_roles … 1.07ms FAIL
In Connection.php line 822:
SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘title’ in ‘INSERT INTO’ (Connection: mysql, SQL: insert into role s
(name
, title
) values (admin, Admin), (global-read, Global Read), (user, User))
In MySqlConnection.php line 47:
SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘title’ in ‘INSERT INTO’
Best Regards
Perhaps take a new dump of your old database.
Otherwise you probably need to keep going though tables to correct them.