Cannot Reset LSNs, Tablespace Not Found When Restoring TTS Backup
(Doc ID 2113086.1)
Last updated on MARCH 08, 2017
Applies to:MySQL Enterprise Backup - Version 3.9 and later
Information in this document applies to any platform.
Restoring from a backup taken with MEB and the --use-tts parameter results in an error:
mysqlbackup: ERROR: mysql query: 'ALTER TABLE 'dbName'.'tableName' IMPORT TABLESPACE': Internal error: Cannot reset LSNs in table '"dbName"."tableName"' : Tablespace not found
The MySQL error log contains statements like:
InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
[ERROR] InnoDB: Trying to import a tablespace, but could not open the tablespace file ./dbName/tableName.ibd
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
|This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.|