Hi Team,

Currently I have one primary / replica server, installed with MariaDB 10.4.16 CS version..

Now I want to add two read replicas 10.6 ES version under 10.4 CS master server.. So I took mysqldump(backup) from 10.4 server and restored to 10.6 ES server..

Backup Command :

mysqldump -u root -p'xxx' --routines --events --triggers --master-data=2 --single-transaction --all-databases > fullbackup.sql

Restore Command :

mysql -u root -p'xxx' < fullbackup.sql

Then I ran mariadb-upgrade command.. It throws errors, here I attached complete upgrade logs..

Then I tried with commenting below three lines and I had the same errors,

#character-set-server=utf8mb4
#collation-server=utf8mb4_general_ci
#init-connect='SET NAMES utf8mb4'

I then tried "old_mode" to empty

old_mode=""

And mariadb-upgrade ran OK. Later I tried to uncomment the first 3 lines (character-set) and just keep old_mode="" it ran OK too..

character-set-server=utf8mb4
collation-server=utf8mb4_general_ci
init-connect='SET NAMES utf8mb4'
old_mode=""