hi
We've been having this issue for a couple of weeks. The site has been online a couple of years, so we are unsure why this has occurred out of the blue.
Problem: we are getting the message ’no linked stock found’ when reindexing the pricing index. Products which display correctly in the Magento backend do not display on the category pages ( i expect this is due to the indexing issue).
The day this first occurred, there were a number of Serialization failures that occurred just prior to the 'no linked stock found' error - eg,
main.CRITICAL: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction, query was: INSERT INTO `catalog_product_index_price
main.CRITICAL: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction, query was: DELETE FROM `catalog_product_index_eav` WHERE (entity_id IN
main.CRITICAL: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction, query was: DELETE `index_price` FROM `catalog_product_index_price` AS `index_price` WHERE (index_price.entity_id IN
That's when the ’no linked stock’ messages started to appear in the Exceptions file -eg.
main.CRITICAL: No linked stock found {"exception":"[object] (Magento\\Framework\\Exception\\LocalizedException(code: 0): No linked stock found at /vendor/magento/module-catalog/Model/Indexer/Product/Price/Action/Rows.php:30,
main.CRITICAL: No linked stock found {"exception":"[object] (Magento\\Framework\\Exception\\LocalizedException(code: 0): No linked stock found at /vendor/magento/module-catalog/Model/Indexer/Product/Price/Action/Full.php:163
Hopefully someone can help point me in the right direction.
thanks
Paul
