Skip to content

RDS MySQL Aurora DB Upgrade failed. Error logs contains weird errors.

0

Hello there,

We tried to upgrade MySQL DB from 5.7.12(aurora 2.11.5) to 8.0.32(aurora 3.05.2).

"serverAddress": "/tmp%2Fmysql.sock",
"serverVersion": "5.7.12-log - MySQL Community Server (GPL)",
"targetVersion": "8.0.32",
"auroraServerVersion": "2.11.5",
"auroraTargetVersion": "3.05.2",
"outfilePath": "/rdsdbdata/tmp/PreChecker.log",

We received total of 37 errors. First error is:

{
    "id": "partitionedTablesInSharedTablespaceCheck",
    "title": "Usage of partitioned tables in shared tablespaces",
    "status": "ERROR",
    "description": "Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)",
    "documentationLink": "https://dev.mysql.com/doc/refman/8.0/en/mysql-nutshell.html#mysql-nutshell-removals"
}

And subsequent checks have failed and none of them are passed. One of the error is:

{
    "id": "circularDirectoryCheck",
    "title": "Circular directory references in tablespace data file paths",
    "status": "ERROR",
    "description": "Not connected",
    "documentationLink": "https://dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.html#upgrade-innodb-changes"
}

As you can see, very first error description is Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) And then subsequent precheck error description is Not connected. Is it really a precheck error or connection error?

Thanks!

asked 2 years ago1K views
1 Answer
0

This error suggests a connection error to the MySQL server running on the Aurora instance. The precheck did not successfully complete and is usually caused by the instance running out of memory during the precheck process. Try changing the instance size to a larger instance with more memory and performing the Aurora version upgrade. You can then change the instance size to be smaller after the upgrade if the database load is low.

If you are unable to resolve this issue with an instance with more memory, please file a technical support case with all the details and our team will be happy to investigate further.

AWS
answered 2 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.