Bug #94367 Remove leftover intermediate tablespace files during upgrade from 5.7 to 8.0
Submitted: 17 Feb 11:35 Modified: 10 May 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 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 5:14] Erlend Dahl
Fixed in 8.0.16:

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