Troubleshooting Common MariaDB/MySQL Upgrade Issues

Question

What are some of the most common challenges and solutions when upgrading MariaDB/MySQL?

Answer

To give you a more detailed overview, we've summarized the four most common causes and their solutions in the following Knowledge Base articles.

• Migration or backup failed: mysqldump: Got error: 145 – Plesk
  • Database table corruption
• Plesk inaccessible: ERROR: Zend_Db_Adapter_Exception: SQLSTATE[HY000] [2002] Connection refused – Plesk
  • MySQL directory is absent so the system cannot create PID file for the service on startup
• MySQL error on the server with Plesk: Could not increase number of max_open_files to more than 16384 – Plesk
  • Hard limit of the process exceeded the number set for open files limit
• Plesk inaccessible: ERROR: Zend_Db_Adapter_Exception: SQLSTATE[HY000] [2002] Connection refused – Plesk
  • MySQL directory is absent so the system cannot create PID file for the service on startup

Note: Each MariaDB upgrade is unique and may require different solutions. Always refer to the official MariaDB documentation and consult a database administrator if you encounter any problems during the upgrade process.