search

Shopify / lhm

Online MySQL schema migrations
BSD 3-Clause "New" or "Revised" License
183 stars 24 forks source link

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

Open broksonic21 opened 4 months ago

broksonic21 commented 4 months ago

After upgrading to 4.2.2 with https://github.com/Shopify/lhm/pull/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

coding-chimp commented 4 months ago

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?