When cataloginventory_stock_status is fully reindexed, the table is swapped with a copy for locking/performance reasons. However, due to this, any triggers set on this table are lost. This means the mview subcription for the vsbridge_product_indexer on this table becomes non-functional
Steps to reproduce:
Check that cataloginventory_stock_status has triggers (SHOW TRIGGERS LIKE 'cataloginventory_stock_status';)
Trigger full reindex of cataloginventory_stock index
Check that cataloginventory_stock_status has triggers, they should now be gone
I am unsure what the correct solution is here, maybe subscribing to index tables isn't the best solution here and we should subscribe to the cataloginventory_stock_item table instead, or find a clean way to ensure triggers are recreated
When cataloginventory_stock_status is fully reindexed, the table is swapped with a copy for locking/performance reasons. However, due to this, any triggers set on this table are lost. This means the mview subcription for the vsbridge_product_indexer on this table becomes non-functional
Steps to reproduce:
SHOW TRIGGERS LIKE 'cataloginventory_stock_status';
)I am unsure what the correct solution is here, maybe subscribing to index tables isn't the best solution here and we should subscribe to the cataloginventory_stock_item table instead, or find a clean way to ensure triggers are recreated