Sintomas

• O MySQL falha ao iniciar.

• As seguintes mensagens de erro aparecem nos logs /var/log/mysql/error.logou /var/log/mariadb/mariadb.log:

  InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880 bytes
  InnoDB: than specified in the .cnf file 0 536870912 bytes!
  [ERROR] Plugin 'InnoDB' init function returned error.
  [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

  ---

  [ERROR] InnoDB: Upgrade after a crash is not supported. This redo log was created before MariaDB 10.2.2. Please follow the instructions at https://mariadb.com/kb/en/library/upgrading/
  [ERROR] InnoDB: Plugin initialization aborted with error Generic error
  [Note] InnoDB: Starting shutdown...
  [ERROR] Plugin 'InnoDB' init function returned error.
  [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
  [Note] Plugin 'FEEDBACK' is disabled.
  [ERROR] Unknown/unsupported storage engine: InnoDB
  [ERROR] Aborting

• Erros como abaixo podem ser mostrados ao executar a verificação do MySQL:

  # mysqlcheck -uadmin -p`cat /etc/psa/.psa.shadow ` -A
  ...
  wordpress_terms
  Error : Unknown table engine 'InnoDB'
  error : Corrupt
  wordpress_usermeta
  Error : Unknown table engine 'InnoDB'
  error : Corrupt
  wordpress_users
  Error : Unknown table engine 'InnoDB'
  error : Corrupt

• O Plesk não está acessível com o seguinte erro em um navegador:

  ERROR: Zend_Db_Statement_Exception: SQLSTATE[42000]: Syntax error or access violation: 1286 Unknown table engine 'InnoDB' (Pdo.php:234)

Causa

Os arquivos InnoDB ib_logfile0e ib_logfile1estão corrompidos.

Resolução

1. Conecte-se a um servidor Plesk via SSH .

2. Pare o servidor MySQL/Mariadb:

   # service mysql stop || service mariadb stop || service mysqld stop

3. Renomeie os arquivos ib_logfile corrompidos:

   # mv /var/lib/mysql/ib_logfile0 /var/lib/mysql/ib_logfile0.bak
   # mv /var/lib/mysql/ib_logfile1 /var/lib/mysql/ib_logfile1.bak

4. Inicie o servidor MySQL/Mariadb:

   # service mysql start || service mariadb start || service mysqld start