Tentei atualizar meu servidor MariaDB de 10.3 para 10.11.7 em minha máquina virtual CentOS Stream.
Usei as seguintes afirmações:
curl -LsS https://r.mariadb.com/downloads/mariadb_repo_setup | sudo bash -s -- --mariadb-server-version="mariadb-10.11"
sudo yum update mariadb-server
sudo systemctl restart mariadb
E isso está me dando os seguintes erros ao usar systemctl status mariadb.service:
May 13 10:32:34 Dev-DB mariadbd[1158171]: 2024-05-13 10:32:34 0 [ERROR] InnoDB: No valid checkpoint was found; the log was created with MariaDB 10.3.28.
May 13 10:32:34 Dev-DB mariadbd[1158171]: 2024-05-13 10:32:34 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
May 13 10:32:34 Dev-DB mariadbd[1158171]: 2024-05-13 10:32:34 0 [Note] InnoDB: Starting shutdown...
May 13 10:32:34 Dev-DB mariadbd[1158171]: 2024-05-13 10:32:34 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
May 13 10:32:34 Dev-DB mariadbd[1158171]: 2024-05-13 10:32:34 0 [Note] Plugin 'FEEDBACK' is disabled.
May 13 10:32:34 Dev-DB mariadbd[1158171]: 2024-05-13 10:32:34 0 [ERROR] Unknown/unsupported storage engine: InnoDB
May 13 10:32:34 Dev-DB mariadbd[1158171]: 2024-05-13 10:32:34 0 [ERROR] Aborting
May 13 10:32:34 Dev-DB systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
May 13 10:32:34 Dev-DB systemd[1]: mariadb.service: Failed with result 'exit-code'.
May 13 10:32:34 Dev-DB systemd[1]: Failed to start MariaDB 10.11.7 database server.
Usando journalctl -xeestou obtendo a seguinte saída:
May 13 10:32:34 Dev-DB mariadbd[1158171]: 2024-05-13 10:32:34 0 [ERROR] InnoDB: Obtaining redo log encryption key version 1 failed (4294967295). Maybe the key or the required encryption key management plugin was not found.
May 13 10:32:34 Dev-DB mariadbd[1158171]: 2024-05-13 10:32:34 0 [ERROR] InnoDB: Reading checkpoint encryption info failed.
May 13 10:32:34 Dev-DB mariadbd[1158171]: 2024-05-13 10:32:34 0 [ERROR] InnoDB: Obtaining redo log encryption key version 1 failed (4294967295). Maybe the key or the required encryption key management plugin was not found.
May 13 10:32:34 Dev-DB mariadbd[1158171]: 2024-05-13 10:32:34 0 [ERROR] InnoDB: Reading checkpoint encryption info failed.
May 13 10:32:34 Dev-DB mariadbd[1158171]: 2024-05-13 10:32:34 0 [ERROR] InnoDB: No valid checkpoint was found; the log was created with MariaDB 10.3.28.
May 13 10:32:34 Dev-DB mariadbd[1158171]: 2024-05-13 10:32:34 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
May 13 10:32:34 Dev-DB mariadbd[1158171]: 2024-05-13 10:32:34 0 [Note] InnoDB: Starting shutdown...
May 13 10:32:34 Dev-DB mariadbd[1158171]: 2024-05-13 10:32:34 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
May 13 10:32:34 Dev-DB mariadbd[1158171]: 2024-05-13 10:32:34 0 [Note] Plugin 'FEEDBACK' is disabled.
May 13 10:32:34 Dev-DB mariadbd[1158171]: 2024-05-13 10:32:34 0 [ERROR] Unknown/unsupported storage engine: InnoDB
May 13 10:32:34 Dev-DB mariadbd[1158171]: 2024-05-13 10:32:34 0 [ERROR] Aborting
Eu tentei as soluções deste tópico Obtendo o erro "O registro do plug-in 'InnoDB' como um STORAGE ENGINE falhou" ao iniciar o MySQL : Até agora eu tentei:
- renomear/mover os arquivos ib_logfile0 e ib_logfile1
- innodb_force_recovery = 1
Ambas as opções não resolveram meu problema.
Como faço para resolver esse problema?