Problems in the migration --> mariadb 10.3 a 10.11.11

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.