Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.6.12
-
None
-
Rocky Linux 8
Description
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=""
Attachments
Issue Links
- duplicates
-
MDEV-28915 mysql_upgrade fails due to old_mode="", with "Cannot load from mysql.proc. The table is probably corrupted"
- Closed