WC_CATEGORY_LOOKUP damaged

  • Hi,

    we recently updated to Woocommerce 4.5 (now on 4.5.2) and one of our tables “wc_category_lookup” gets repeatedly damaged somehow.

    The first time this happened we only found out because our site gave us a database connection error.

    Deleting the table was not possible so we needed to create a new database and restore this one table from an older backup.

    The table is now damaged again but our site is still up.

    Where there any major changes to the category lookup part of WooCommerce? What does it do?

    Thanks for any help!

Viewing 1 replies (of 1 total)
  • Thread Starter Jonathan

    (@formbench)

    Upon further investigation there seems to be a problem with the ALTER command. This is the error I get when the table is not readable anymore:

    | 123456 | dbName | localhost | userName | Query | 12345 | Waiting for table metadata lock | ALTER TABLE wp_wc_category_lookup CHANGE COLUMN category_tree_id category_tree_id BIGINT UNSIGNE | 0.000 |

    This error happens everything our hosting provider tries to do a database dump, it will repeat until in the morning the multiplied processes are all killed.

    Any idea why the database dump would do that to the system?

Viewing 1 replies (of 1 total)
  • The topic ‘WC_CATEGORY_LOOKUP damaged’ is closed to new replies.