Upgrade from MySQL 5.6 to 5.7 failed

0

Trying to upgrade from MySQL 5.6 to 5.7 on RDS.

PrePatchCompatibility.log includes:

1) MySQL 5.7 preupgrade check to catch orphan table issues
	For the following tables, either the datadir directory or frm file was removed or corrupted.
	More Information:
		https://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html

[table_schema, table_name]
name123, - Check the server logs or examine datadir to determine the issue and correct it before upgrading.

Per link provided:

SELECT * FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME LIKE '%#sql%';

There are three tables with names:

'tmp/#sql2d63_22106882_6'
'tmp/#sql2d63_22106882_7'
'name123/#sql-19eb_123727b27'

Per that link the process should be to manipulate .frm files in the file system - clearly that's not available in RDS though.

From other reading, tried to drop the table using:

USE name123;
DROP TABLE  `#mysql50##sql-19eb_123727b27`;

But that fails with:

Error Code: 1051. Unknown table 'name123.#mysql50##sql-19eb_123727b27'

Any ideas how to resolve?

asked a year ago89 views
No Answers

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.

Guidelines for Answering Questions