Upgrading to Mysql 8 Fail with orphan tables, workaround?

[tam huynh]

I'm trying to upgrade to Mysql 8 from 5.7.44 and get the following error, only see orphan temp tables in innodb_sys_tablespaces, how can I drop these table?
The mysqlshell precheck did not find any issues.


[ERROR] [MY-011006] [Server] Got error 197 from SE while migrating tablespaces.
SELECT * FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME LIKE '%#sql%';
Empty set (0.00 sec)



select * from information_schema.innodb_sys_tablespaces where name like '%%sql6b34_11a051_0%';
+---------+-----------------------+------+-------------+----------------------+-----------+---------------+------------+---------------+-----------+----------------+
| SPACE | NAME | FLAG | FILE_FORMAT | ROW_FORMAT | PAGE_SIZE | ZIP_PAGE_SIZE | SPACE_TYPE | FS_BLOCK_SIZE | FILE_SIZE | ALLOCATED_SIZE |
+---------+-----------------------+------+-------------+----------------------+-----------+---------------+------------+---------------+-----------+----------------+
| 2267944 | shm/#sql6b34_11a051_0 | 0 | Antelope | Compact or Redundant | 16384 | 0 | Single | 0 | 0 | 0 |
+---------+-----------------------+------+-------------+----------------------+-----------+---------------+------------+---------------+-----------+----------------+