Mysql2::Error: ALGORITHM=INPLACE is not supported. Reason: InnoDB presently supports one FULLTEXT index creation at a time. Try ALGORITHM=COPY

Question

Mysql2::Error: ALGORITHM=INPLACE is not supported. Reason: InnoDB presently supports one FULLTEXT index creation at a time. Try ALGORITHM=COPY

Opened this issue 6 months ago · 1 comments

After upgrading to 4.2.2 with #160, we are getting errors vs MySQL 8.0 when running a clean environment, spinning up a DB clean with our full history of migrations :

Mysql2::Error: ALGORITHM=INPLACE is not supported. Reason: InnoDB presently supports one FULLTEXT index creation at a time. Try ALGORITHM=COPY

We had not seen this prior to 4.2.2

Answer 1 · 2024-06-11T09:31:09.000Z

I'm struggling to reproduce this issue. Can you please provide the code for the failing migration and the SHOW CREATE TABLE of the table that it is changing?