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?

답변 없음

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인