I am experiencing locks on the
catalog_product_entity table when uploading a lot of products in a short period.
SQLSTATE[HY000]:General error: 1205 Lock wait timeout exceeded; try restarting transaction. query was:
UPDATE catalot_product_entity SET row_id=?...etc
We've traced it back to a previous job running which updates a particular product, and then another job with the same product runs at the same time that scheduled indexing is running (and obviously refreshing indexes for previous load - It looks like the indexer might lock a series of rows while updating, haven't looked in to how it works).
I've confirmed that products that are in the current job have been recently updated in a previous job - although at times 10 minutes earlier.
Has anyone found a solution or workaround for this issue, or anyone have any suggestions?