cancel
Showing results for 
Search instead for 
Did you mean: 

Cannot Reindex After Upgrade To 2.4.2 SQLSTATE[HY000]: General error: 1478

Cannot Reindex After Upgrade To 2.4.2 SQLSTATE[HY000]: General error: 1478

After upgrading to 2.4.2 I cannot reindex 

 

Category Products

Product Categories

 

I get this error - 

 

Category Products index process unknown error:
SQLSTATE[HY000]: General error: 1478 InnoDB: Tablespace `innodb_system` cannot contain TEMPORARY tables., query was: CREATE TEMPORARY TABLE IF NOT EXISTS `catalog_category_product_index_store1_tmp` LIKE `catalog_category_product_index_store1`
Product Categories index process unknown error:
SQLSTATE[HY000]: General error: 1478 InnoDB: Tablespace `innodb_system` cannot contain TEMPORARY tables., query was: CREATE TEMPORARY TABLE IF NOT EXISTS `catalog_category_product_index_store1_tmp` LIKE `catalog_category_product_index_store1`
Catalog Rule Product index has been rebuilt successfully in 00:00:00

 

Any Clues Greatly Received.

 

Thanks!