I’ve tried to upgrade Opennebula from 5.8 to 5.10 in my test environment.
I did the packages upgrade and run onedb fsck.
According your documentation I got a message “Table and database charset (utf8, latin1) differs” and run the command:
ALTER DATABASE opennebula CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
The error message repeated.
I saw that you mentioted system_attributes table in the documentation and converted it:
ALTER TABLE opennebula."system_attributes" CONVERT TO CHARACTER SET utf8mb4;
onedb upgrade and
onedb fsck finished without any errors.
My question: Is it correct to change only table (system_attributes)? Because I had the similar issue during upgrade to 5.8 with vm_pool table
Versions of the related components and OS (frontend, hypervisors, VMs): Opennebula 5.10, Ubuntu 18.04 LTS, Mariadb 10.4.8+maria~bionic