Magento 2.3.0 No Linked Stock Found

[grealo]

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

[grealo · Accepted solution]

hi folks

Just to let you know I have resolved the issue.

It looks like someone amended Stores > Inventory > Stocks to have a single website Sales Channel, when there were other sites on the multi-store setup (even though we only use one site).  I selected all the other sites and saved, reindex, and cleared cache and the issue resolved.

thanks

Paul