Hello,
I have renamed table to another database:
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.
$ 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:
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