# Orphan InnoDB entries after renaming table

**URL:** https://forums.percona.com/t/orphan-innodb-entries-after-renaming-table/6779
**Category:** Percona XtraDB Cluster 5.x
**Created:** [January 8, 2019, 2:26am UTC](https://forums.percona.com/t/orphan-innodb-entries-after-renaming-table/6779 "2019-01-08T02:26:50Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![msutic](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/msutic/32/4218_2.png) [@msutic](https://forums.percona.com/u/msutic)
#### Post date: [January 8, 2019, 2:26am UTC](https://forums.percona.com/t/orphan-innodb-entries-after-renaming-table/6779/1 "2019-01-08T02:26:50Z")

</div>

Hello,

I have renamed table to another database:

```auto
mysql> create database test_rename;
Query OK, 1 row affected (0.00 sec)

mysql> rename table test.pages to test_rename.pages;
Query OK, 0 rows affected (0.00 sec)

```

Then uninstalled existing 5.6.41 version and installed performed installation of 5.7 version.

```auto
$ sudo apt-get remove percona-xtrabackup* percona-xtradb-cluster*
$ sudo apt-get install percona-xtradb-cluster-57

```

In error log I receive ERRORS for orphan entries:

```auto
2019-01-07T21:42:21.105554Z 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.
2019-01-07T21:42:21.105631Z 0 [ERROR] InnoDB: The error means the system cannot find the path specified.
2019-01-07T21:42:21.105785Z 0 [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.
2019-01-07T21:42:21.105886Z 0 [ERROR] InnoDB: Cannot open datafile for read-only: './test/pages.ibd' OS error: 71

```

Everything seems to be OK with the table.

Is this expected behavior (to receive such errors) when you rename table to another database?

Thank you for the answer.

Best regards,  
Marko
