Vinod Vyas
New Pleskian
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)
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)