Zend certified PHP/Magento developer

Magento 2.4.6 P3 On-schedule price indexers stuck in “working” status

We recently updated the Magento version from 2.4.3 to 2.4.6 p3. After the upgrade, we are encountering an issue specifically with the price index. Manually, it works fine.

When someone updates price data in bulk, or there is a price update using code, or any bulk product status changes using CSV import, the cron job is unable to finish the price index. It consistently shows a working status with backlog product items. However, if we run the indexer reset command from the console, the indexer starts working automatically using cron.

Does anyone have an idea on how to fix this issue?

Any help would be appreciated.

Thank you.