cancel
Showing results for 
Search instead for 
Did you mean: 

Configurable product indexing not working

Configurable product indexing not working

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?