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?

已提問 1 年前檢視次數 100 次
沒有答案

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南