• Thirunarayanan Balathandayuthapani's avatar
    MDEV-21550 Assertion `!table->fts->in_queue' failed in fts_optimize_remove_table · a134ec37
    Thirunarayanan Balathandayuthapani authored
    Problem:
    =======
      The problem is that InnoDB doesn't add the table in fts slots if drop table fails. InnoDB marks the table is in fts slots while processing sync message. So the consecutive alter statement assumes that table is in queue and tries to remove it. But InnoDB can't find the table in fts_slots.
    
    Solution:
    =========
      i)  Removal of in_queue in fts_t while processing the fts sync message.
      ii) Add the table to fts_slots when drop table fails.
    a134ec37
misc_debug.test 1.9 KB