AWS Lightsail - instance down after maintenance

From your description and error logs, it seems like the problem is with your MySQL database, more specifically with the InnoDB storage engine. The error messages indicate that there is a discrepancy between your database and the log files, which suggests that your database might be corrupt.

InnoDB has a built-in mechanism for recovery in such situations, which you can use by adding or changing a line in your my.cnf file. Here's how you can do it:

1. SSH into your Lightsail instance.

2. Open the MySQL configuration file. For Bitnami instances, the path would typically be /opt/bitnami/mysql/my.cnf. You can open it with a text editor like nano or vi:

   sudo nano /opt/bitnami/mysql/my.cnf

3. Look for a line that starts with innodb_force_recovery and change its value to 1. If such a line does not exist, add it under the [mysqld] section:

   [mysqld]
   innodb_force_recovery = 1

4. Save the changes and exit the text editor. If you're using nano, you can do this by pressing Ctrl+X, then Y to confirm that you want to save the changes, and finally Enter to confirm the file name.

5. Restart the MySQL service:

   sudo /opt/bitnami/ctlscript.sh restart mysql

After this, try accessing your WordPress site again. If it's still not working, you can try increasing the innodb_force_recovery value up to 6. However, please note that the higher the recovery mode, the higher the risk of losing data. Therefore, it's recommended to keep a backup of your data.

You can read more in the MySQL documentation: Forcing InnoDB Recovery

If the answer is helpful, please click "Accept Answer" and upvote it.