Mysql Database upgrade from 5.7 to 8 gives error regarding forum plugin tables

[dineshmob]

Hi,

I am upgrading MySQL 5.7 to MySQL 8.x on AWS Aurora and during upgrade it’s giving following upgrade precheck errors for forum tables. Can you please take a look and help me as it is blocking me to upgrade MySQL version.

Table Name: forum_posts

Error 1: The auxiliary tables of FTS indexes on the table ‘invlive.wi1605p_forum_posts’ are created in system table-space due to https://bugs.mysql.com/bug.php?id=72132. In MySQL8.0, DDL queries executed on this table shall cause database unavailability. To avoid that, drop and recreate all the FTS indexes on the table or rebuild the table using ALTER TABLE query before the upgrade.”

Table Name: forum_topics

Error 2: The auxiliary tables of FTS indexes on the table ‘invlive.wi1605p_forum_topics’ are created in system table-space due to https://bugs.mysql.com/bug.php?id=72132. In MySQL8.0, DDL queries executed on this table shall cause database unavailability. To avoid that, drop and recreate all the FTS indexes on the table or rebuild the table using ALTER TABLE query before the upgrade.

Here are the version i am using:

WordPress. 6.6.1

Mysql: 5.7 to 8.x(Upgrading)

Asgaros Forum: 2.9.0

Thanks

Dinesh