Bug #85972 Encryption enabled message for abandoned #sql-2402_4.ibd file
Submitted: 17 Apr 2017 10:52 Modified: 8 May 2017 15:12
Reporter: Shahriyar Rzayev Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S3 (Non-critical)
Version:8.0.1 OS:Linux
Assigned to: CPU Architecture:Any

[17 Apr 2017 10:52] Shahriyar Rzayev 
Description:
Hi dear all,

If you try to encrypt table and kill the server during this process you will like have an .ibd file as described here:

https://bugs.mysql.com/bug.php?id=80183

But the weird thing is the message about this tablespace file:

2017-04-17T08:49:03.445242Z 1 [Note] InnoDB: Read encryption metadata from ./sbtest/#sql-2402_4.ibd successfully, encryption of this tablespace enabled.
2017-04-17T08:49:03.445579Z 1 [Note] InnoDB: Read encryption metadata from ./sbtest/sbtest1.ibd successfully, encryption of this tablespace enabled.

It is not clear why we need to enable encryption for this #sql-2402_4.ibd  tablespace.

How to repeat:
See description.
[20 Apr 2017 16:18] MySQL Verification Team 
Hi!

Have you created a table with ENCRYPTION='Y' ???

If that is a case, then this bug is practically a duplicate of #80183, but only with different version.

If you have not used that option and loaded a plugin, then, it is a documentation issue.
[8 May 2017 8:59] Shahriyar Rzayev 
Yes it seems to be practically duplicate of my previous report.
[8 May 2017 15:12] MySQL Verification Team 
Duplicate of #80183.