MySQL Bugs: #110633: Orphaned full-text indexes

Bug #110633	Orphaned full-text indexes
Submitted:	7 Apr 2023 5:20	Modified:	7 Apr 2023 11:55
Reporter:	John Carew	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	8.0.32	OS:	CentOS
Assigned to:		CPU Architecture:	Any

Description:
On both our dev and prod db servers; when querying the information_schema.INNODB_INDEXES view, it throws an error as shown below. It seems that a full text index is orphaned in the system, and there seems to be no way of cleaning it up. I will attach screenshots as well, showing the indexes showing up in other views as well.

SQL Error (1812): Tablespace is missing for table database/fts_000000000001e999_0000000000048c00_index_1.

How to repeat:
N/A

Suggested fix:
Need some way of telling mysql to clean up the orphaned FTS tablespaces & records located in other information_schema views.

Showing them in other tables

Attachment: Screenshot 2023-04-06 233907.png (image/png, text), 24.88 KiB.

Showing them in other tables

Attachment: Screenshot 2023-04-06 233559.png (image/png, text), 13.48 KiB.

Hi Mr. Carew,

Thank you for your bug report.

However, screenshot mean nothing to us. Those will not enable us to repeat the problem.

Not enough information was provided for us to be able to handle this bug. Please re-read the instructions at http://bugs.mysql.com/how-to-report.php 

If you can provide more information, feel free to add it to this bug and change the status back to 'Open'.  

You should provide us with a repeatable test case. This test case should consist of the set of SQL statements that will always lead to the errors that you are reporting. 

We can not proceed without such a test case.

Thank you for your interest in MySQL.