I've got a multi-website setup on Magento 2.2.5, and my issue is that when I update a configurable product variations price, it shows that new price for all variations on that website.
I've looked in the catalog_product_index_price and everything looks correct in there after updating the product, the per-configuration prices for that website / customer group are right, its just showing incorrectly in the interface.
If I manually run "bin/magento indexer:reindex" the prices then show correctly on the product page, so this leads me to believe that there is a problem with the cron jobs. I removed the -v from the main line in crontab so I could view the log, and I'm not getting any errors of any kind. Cron job now looks like :
* * * * * /usr/bin/php7.0 /var/www/html/magento2/bin/magento cron:run >> /var/www/html/magento2/var/log/magento.cron.log
* * * * * /usr/bin/php7.0 /var/www/html/magento2/update/cron.php >> /var/www/html/magento2/var/log/update.cron.log
* * * * * /usr/bin/php7.0 /var/www/html/magento2/bin/magento setup:cron:run >> /var/www/html/magento2/var/log/setup.cron.log
I do have some pending items in mysql for cron_schedule, but I don't think anything there is a problem
mysql> select count(*), job_code from cron_schedule where status = 'pending' group by job_code;
+----------+-----------------------------------------------+
| count(*) | job_code |
+----------+-----------------------------------------------+
| 1 | amazon_payments_process_queued_refunds |
| 7 | bulk_cleanup |
| 3 | catalog_event_status_checker |
| 1 | catalog_product_attribute_value_synchronize |
| 7 | catalog_product_frontend_actions_flush |
| 7 | catalog_product_outdated_price_values_cleanup |
| 8 | consumers_runner |
| 3 | flush_preview_quotas |
| 1 | get_amazon_authorization_updates |
| 1 | get_amazon_capture_updates |
| 3 | indexer_reindex_all_invalid |
| 3 | indexer_update_all_views |
| 3 | magento_newrelicreporting_cron |
| 1 | newsletter_send_all |
| 7 | outdated_authentication_failures_cleanup |
| 7 | sales_grid_order_async_insert |
| 7 | sales_grid_order_creditmemo_async_insert |
| 7 | sales_grid_order_invoice_async_insert |
| 7 | sales_grid_order_shipment_async_insert |
| 7 | sales_send_order_creditmemo_emails |
| 7 | sales_send_order_emails |
| 7 | sales_send_order_invoice_emails |
| 7 | sales_send_order_shipment_emails |
| 3 | staging_apply_version |
| 3 | staging_remove_updates |
| 3 | staging_synchronize_entities_period |
+----------+-----------------------------------------------+
Is there anything I can do to debug / fix this, or should I create another cron job that manually runs the indexer every 5 minutes?
