2.3.3 Error on Catalog Search Index

[imahler]

Have been dealing with this error for a few days now and unsure of how to move forward on it. Every time I run a reindex on the site I get the following error:

"Catalog Search indexer process unknown error:

[1064] index catalogsearch_fulltext_scope1: does not support DELETE (enabled=0) [ DELETE FROM catalogsearch_fulltext_scope1 WHERE id > 0]"

I’ve tried resetting the indexes and running them fresh again, checking who owns the definers/triggers thinking it was related to ownership. But all are owned by the same user. Table is blank, and does’t populate any information either.

Anyone have any ideas?

Error logs are clean, so i’m unsure of how to troubleshoot the issue currently.

[markdh1]

Clean install or is this a migration from Magento 1.x?

[imahler]

Migration from 1.9

I actually found a fix. The change logs table was massive. Once I truncated that the site was able to reindex no problem

[kishor_magento]

I am getting the same error, Can you please add the full workaround that how you resolved the error.