Magento2: Catalog Rule Product Index is not reindexing after save - "update on save" mode set

[lucas-santos-chaordic]

Preconditions

After editing a catalog rule, the rule is never applied, even the index mode for all the indexes are set to update on save. All the other indexes are workin as spected.

We also tested using a docker with a very clean instalation of version 2.1 and had the same issue

1. Running on AWS
2. PHP7
3. NGINX and PHP FPM
4. Using RDS

Steps to reproduce

It is easy to reproduce.

1. Set the indexes to update on save mode
2. Create a new catalog Rule
3. Save and apply the rule
4. You are going to receive a message saying that a reindex is required.
5. Go to the index page and see that the message is Reindex Required for an index using the update on save mode

Expected result

The index should be up to date (ready)

Actual result

the index is outdated

[brendanmckeown]

Also seeing this problem only with the "Catalog Rule Product" index, following the same steps above.

[lucas-santos-chaordic]

Yes... It only happens on "Catalog Rule Product" index. The others are working properly....

[smoskaluk]

@lucas-santos-chaordic Unfortunally, I was not able to reproduce this problem. Can you affirm that this issue is relevant for latest Magento 2 release?

[tycreate]

Currently Having the same issue
@smoskaluk @lucas-santos-chaordic @brendanmckeown
Any solutions?

[magento-engcom-team]

@lucas-santos-chaordic, thank you for your report.
We've created internal ticket(s) MAGETWO-76051 to track progress on the issue.

[thiagolima-bm]

I'm working on it #SQUASHTOBERFEST

[okorshenko]

Hi @thiagolima-bm could you please accept the invite on the GitHub?

[thiagolima-bm]

@okobchenko done :)

[r-bielawski]

distributed-cd

[magento-engcom-team]

@r-bielawski thank you for joining. Please accept team invitation here and self-assign the issue.

[magento-engcom-team]

@lucas-santos-chaordic Unfortunately we have to close this ticket now, as this seems to be an intended behavior at the moment.
Please refer to this comment for more information: https://github.com/magento/magento2/pull/11580#issuecomment-342506544

Thank you for collaboration.

[somnath12]

If anybody facing any issue regarding magento indexing you may contact [email protected]

[charles-tychons]

In my case, verified the cron_schuedule table, where many of the cron jobs are still in pending status.

So I just back up that table data and truncated.

The issue resolved and reindex worked "update on save" mode.

Using Magento 2.2.x