Resolved MariaDB upgrade disaster

[Vinod Vyas]

I tried to upgrade MariaDB to 10.2 on Plesk with CentOS 7. And it is now a disaster situation. Can I downgrade to MariaDB 10.1 or or uninstall mariaDB 10.2. Please help.

I realized later that I should have upgraded to 10.1 only. I used this link for help during installation How to upgrade MySQL/MariaDB on Linux

After installation, the services did not start. Though I was able to start / stop mysql services but MarioDB was giving this error:

Sep 24 18:00:41 foo.net mysqld[23744]: 2017-09-24 18:00:41 140495576860800 [Note] InnoDB: Starting shutdown...
Sep 24 18:00:41 foo.net mysqld[23744]: 2017-09-24 18:00:41 140495576860800 [ERROR] Plugin 'InnoDB' init function returned error.
Sep 24 18:00:41 foo.net mysqld[23744]: 2017-09-24 18:00:41 140495576860800 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
Sep 24 18:00:41 foo.net mysqld[23744]: 2017-09-24 18:00:41 140495576860800 [Note] Plugin 'FEEDBACK' is disabled.
Sep 24 18:00:41 foo.net mysqld[23744]: 2017-09-24 18:00:41 140495576860800 [ERROR] Unknown/unsupported storage engine: InnoDB
Sep 24 18:00:41 foo.net mysqld[23744]: 2017-09-24 18:00:41 140495576860800 [ERROR] Aborting
Sep 24 18:00:41 foo.net systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE
Sep 24 18:00:41 foo.net systemd[1]: Failed to start MariaDB database server.
Sep 24 18:00:41 foo.net systemd[1]: Unit mariadb.service entered failed state.
Sep 24 18:00:41 foo.net systemd[1]: mariadb.service failed.

Now Plesk front end also stopped. I tried Plesk repair ALL / installation / DB / mysql but no luck. There are error like this:

Checking MySQL database servers
DB query failed: SQLSTATE[HY000]: General error: 1 Can't create/write to file '/var/tmp/#sql_7fb4_0.MAI' (Errcode: 2), query was: DESCRIBE `ServiceNodes`
The database structure is corrupted. You can try to repair it with "plesk repair installation" and "plesk repair db".

Repair databases on available servers
DB query failed: SQLSTATE[HY000]: General error: 1 Can't create/write to file '/var/tmp/#sql_7fb4_0.MAI' (Errcode: 2), query was: DESCRIBE `data_bases`
The database structure is corrupted. You can try to repair it with "plesk repair installation" and "plesk repair db".

Repair database users on available servers
DB query failed: SQLSTATE[HY000]: General error: 1 Can't create/write to file '/var/tmp/#sql_7fb4_0.MAI' (Errcode: 2), query was: DESCRIBE `db_users`
The database structure is corrupted. You can try to repair it with "plesk repair installation" and "plesk repair db".

The front end of Plesk gives this error in browser:
ERROR: Plesk\Exception\Database: DB query failed: SQLSTATE[HY000]: General error: 1 Can't create/write to file '/var/tmp/#sql_7fb4_0.MAI' (Errcode: 2), query was: DESCRIBE `sessions`

Additionally, an exception has occurred while trying to report this error: Zend_Exception
No entry is registered for key 'translate' (Mysql.php:53)

 

[virtubox]

Hello,
from the error logs you have, it seems MariaDB cannot write in the folder /var/tmp.
Check if the folder exist and the permissions.

 

[Vinod Vyas]

Thanks Virtubox

The permissions were all correct. Folder also existed.

One thing I realized is that MySQL to MariaDB is not that simple as claimed by them.

Finally, left with no choice but to reinstall everything again.

 

[UFHH01]

Hi Vinod Vyas,

I tried to upgrade MariaDB to 10.2 on Plesk with CentOS 7

Pls. note, that BEFORE you manually upgrade a software on your server, pls. make sure, that the actual to be used version is currently supported by Plesk.

=> Software Requirements for Plesk

Quoted from the above link:

Database servers and tools:​

• MySQL 5.1 - 5.7
• MySQL community edition 5.5, 5.6, 5.7
• PostgreSQL 8.4-9.5
• MariaDB 5.5, 10.0, 10.1

In addition, pls. note that

Though I was able to start / stop mysql services

.. doesn't actually point to a RUNNING service, after you used a START - command. Pls. try to inspect your log, to investigate, if your db - server has starting issues:

...
Sep 24 18:00:41 foo.net systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE
Sep 24 18:00:41 foo.net systemd[1]: Failed to start MariaDB database server.
Sep 24 18:00:41 foo.net systemd[1]: Unit mariadb.service entered failed state.
Sep 24 18:00:41 foo.net systemd[1]: mariadb.service failed.

This points directly to the fact, that your db - server isn't running... but you are certainly as well able to check it with for example:

ps aux | grep mysql

or/and

service mysql status