Unable to upgrade MySQL from 5.7.44 to 8.x

While trying to upgrade my MySQL from 5.7.44 to 8.x, I am getting the following error:

17. Schema inconsistencies resulting from file removal or corruption: Following tables show signs that either table datadir directory or frm file was removed/corrupted. Please check server logs, examine datadir to detect the issue and fix it before upgrade mytable - present in INFORMATION_SCHEMA's INNODB_SYS_TABLES table but missing from TABLES table

I tried to use some solutions mentioned on repost and stackoverflow like: https://repost.aws/questions/QUPC7D-_ZuTgCZSLALluxW9g/need-help-in-upgrading-the-aurora-mysql-5-7-to-mysql-8-urgent https://repost.aws/questions/QUNKcZd0MBSPmyPcCJanyKSQ/aurora-upgrade-2-to-3-mysql-5-7-to-8-0-schemainconsistencycheck

However, when I run the suggested query to find corrupted tables, I cannot find any table with the pattern '%#sql%' or '%#%'

select * from information_schema.innodb_sys_tables where name like '%#%';

Does anyone have any other possible solution?