Magento 2.1.3 all products not displaying after upgrade from 2.1.2

[adityag186]

Preconditions

1. MAgento 2.1.3
2. Since website has been upgraded, products are not showing correctly.

Steps to reproduce

1. Go to www.atlanticbooks.com.
2. Select Subjects.
3. Select Business Management.

Expected result

1. 4706 products should be displayed

Actual result

1. Only 500 products are being displayed

[grischunya]

I have the same error after reindex console.
If I add 1 new product it is added and displayed but after manual re-indexing - 500 products again

[perry3181]

Same problem in 2.0.11 #7948

[ndsina]

Same problem 2.1.3EE.
After investigation found, that the 'selectsByRange' method(\Magento\Framework\DB\Adapter\Pdo\Mysql.php) works incorrectly.

[adityag186]

Do you know the fix for the issue?

[ndsina]

I've just rewritten the 'isRangingNeeded' method(vendor/magento/module-catalog/Model/Indexer/Category/Product/AbstractAction.php) to return false, but it is temporary solution, I am looking for correct one.

[adityag186]

Please update me if a permanent solution is released. Thanks.

[ndsina]

Ok

[perry3181]

Hello @adityag186, I just go to your store, seems you already fixed the issue.
Could you let me know how to fix it? Thanks!

[lennartbee]

@ndsina Thanks, this works perfect for now

[perry3181]

@lennartbee, I also tried rewrite 'isRangingNeeded' method to return false. But it's not work for me.

[lennartbee]

@perry3181 is your magento crun running? Try reindexing manually also
php bin/magento indexer:reindex

[perry3181]

@lennartbee Yes, I tried rewrite and then reindex manually, but it still not work for me.
But I found that if any item changed to "Out of Stock", it will becomes visible in frontend category.

[refaelgold]

@ndsina you save my life! thanks!!!

[siment]

Duplicate: #8018

[shuaiZend]

@ndsina fixed,thank you for share.

[xmav]

I’m closing this issue because it is a duplicate. Please reopen this issue as needed.
#8018