The size of the catalog is about 70k products.
When reindexing sometimes it turns out
Could not acquire lock for index:catalog_category_product and
Could not acquire lock for index:catalog_product_category or only stuck in
INSERT INTO catalog_category_product_index_store2_tmp ('category_id', 'product_id', 'position', 'i.. (I got this from
SHOW PROCESS LIST phpmyadmin).
there is no more detailed information about the error in the log files, Are there ways to get more detailed information about the error or stuck?