Bug #94367 Remove leftover intermediate tablespace files during upgrade from 5.7 to 8.0
Submitted: 17 Feb 2019 11:35 Modified: 10 May 2019 5:14
Reporter: Sivert Sørumgård Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Data Dictionary Severity:S3 (Non-critical)
Version:8.0.17 OS:Any
Assigned to: CPU Architecture:Any

[17 Feb 2019 11:35] Sivert Sørumgård 
Description:
After an upgrade from 5.7 to 8.0, intermediate tablespace files innodb_*_stats_backup57.ibd are left in the data directory. These should be removed upon successful completion of upgrade. There are no corresponding tables in the server, it's just the tablespace files that are left.

See also bug#24433980.

How to repeat:
Upgrade from 5.7 to 8.0.x. List files in subdirectory 'mysql' of the data directory.

Suggested fix:
Remove intermediate tablespace files upon successful completion of upgrade from 5.7.
[10 May 2019 5:14] Erlend Dahl 
Fixed in 8.0.16:

Bug#29365552 LEFTOVER SYSTEM TABLES AFTER 5.7 => 8.0 IN-PLACE UPGRADE