We have a working, well filled
sales_order_grid table. But those orders we add via custom integration do not show up there - or show up, but with a very long delay.
We found in the
cron_schedule table that three jobs are running:
sales_grid_order_shipment_async_insert - but they never finish.
Is there a way to re-synchronize the entire
sales_order_grid table? Would it re-fill if we truncate it? Or can we run the
sales_grid_order_async_insert manually? Is there an easy way to debug it?
Some answers to other questions refer to options that are only available in Magento2 developer mode, but do not apply to production mode.