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.

Symptoms

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

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms