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?

gefragt vor einem Jahr100 Aufrufe
Keine Antworten

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen