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?

posta un anno fa100 visualizzazioni
Nessuna risposta

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande