Error when updating lightsail database MySQL

The error you're encountering during the upgrade of your Lightsail MySQL database from version 5.7.44 to MySQL 8 is not a common issue directly related to the upgrade process itself. The "Got packets out of order" message is typically a network-related error rather than a database compatibility issue.

However, upgrading a MySQL database from 5.7 to 8.0 is a major version upgrade that can introduce incompatibilities. While you've run the MySQL update checker without errors, there might still be underlying issues that need to be addressed.

Here are some steps you can take to troubleshoot and potentially resolve the issue:

1. Check your network connectivity: Ensure that your connection to the Lightsail instance is stable and not experiencing any intermittent issues.

2. Review your database for potential incompatibilities: Even if the update checker didn't show errors, there might be specific structures or data in your database that are incompatible with MySQL 8.0. Look for things like:

   • Reserved keywords that might now conflict with MySQL 8.0
   • Deprecated features or syntax that are no longer supported
   • Routines or stored procedures that might need updating

3. Check for any invalid characters in table or column comments: Sometimes, invalid UTF-8 characters in comments can cause issues during upgrades.

4. Consider creating a test database: Before upgrading your production database, create a copy and attempt the upgrade on this test instance. This allows you to identify and resolve issues without risking your live data.

5. Review the Lightsail database logs: Check for any additional error messages or warnings that might provide more context about the upgrade failure.

6. Ensure you have sufficient resources: The upgrade process can be resource-intensive. Make sure your Lightsail instance has enough CPU and memory to handle the upgrade.

If you continue to experience issues after trying these steps, you may need to contact AWS Support for further assistance. They can provide more detailed guidance based on your specific database configuration and the exact nature of the error you're encountering.

Remember, major version upgrades can be complex, so it's crucial to have a solid backup and a rollback plan in place before attempting the upgrade.

Sources
Upgrade the major version of a Lightsail database - Amazon Lightsail
Error when upgrading AWS Aurora MYSQL from 5.7 to MYSQL 8.0.32 | AWS re:Post
Amazon Aurora MySQL version 2 (with MySQL 5.7 compatibility) to version 3 (with MySQL 8.0 compatibility) upgrade checklist, Part 1 | AWS Database Blog