Open
Description
@engcom-Hotel I am able to reproduce the same issue in 2.4.7-p1.
Steps to Reproduce
- Change Encryption Key from Admin
- Remove the old encryption key from app/etc/env.php and Save
- Check the indexer_state, note down the updated at for all the rows
- Run setup upgrade. You can found out that indexer status was updated and hash values are changed
- In case of hash change customer_flat_grid data will be refreshed
Here is the indexer status from my local before and after

I would suggest re-open the issue
Originally posted by @senthilengg in #39206 (comment)
Metadata
Metadata
Assignees
Labels
Type
Projects
Status
Pull Request In Progress
Activity
m2-assistant commentedon Jan 10, 2025
Hi @senthilengg. Thank you for your report.
To speed up processing of this issue, make sure that the issue is reproducible on the vanilla Magento instance following Steps to reproduce.
@magento I am working on this
Join Magento Community Engineering Slack and ask your questions in #github channel.
⚠️ According to the Magento Contribution requirements, all issues must go through the Community Contributions Triage process. Community Contributions Triage is a public meeting.
🕙 You can find the schedule on the Magento Community Calendar page.
📞 The triage of issues happens in the queue order. If you want to speed up the delivery of your contribution, join the Community Contributions Triage session to discuss the appropriate ticket.
[-]@engcom-Hotel I am able to reproduce the same issue in 2.4.7-p1.[/-][+]@engcom-Hotel Reproduced #39206 issue in 2.4.7-p1[/+]Fix for issue magento#39530
Fix for issue magento#39530 to avoid regenerating admin grid flat table
Merge pull request #1 from senthilengg/senthilengg-patch-for-github-i…
m2-assistant commentedon Jan 15, 2025
Hi @engcom-Hotel. Thank you for working on this issue.
In order to make sure that issue has enough information and ready for development, please read and check the following instruction: 👇
Area: XXXXX
label to the ticket, indicating the functional areas it may be related to.2.4-develop
branchDetails
- If the issue is reproducible on2.4-develop
branch, please, add the labelReproduced on 2.4.x
.- If the issue is not reproducible, add your comment that issue is not reproducible and close the issue and stop verification process here!
Issue: Confirmed
once verification is complete.engcom-Hotel commentedon Jan 15, 2025
Hello @senthilengg,
Thanks for the report and collaboration!
We have tried to follow the mentioned steps and for us, the
indexer_state
has been updated:Previously it was something like below:
After running
bin/magento s:up && bin/magento cache:clean
:The
hash_config
is also updating. But it seems to us an intended behaviour please let us know the expected and actual result to understand more about the issue.Thanks
senthilengg commentedon Jan 15, 2025
@engcom-Hotel Its not only updating the hash of the indexer but also regenerate the whole grid data again. Assume a situation if you have 4 million customer data and the grid table got truncated and recreated then it introduces significant downtime for no use.
Ideally the encryption key should update the hash alone and not the grid data because there is no business need to do that and it creates a huge downtime for the merchants if they have million plus customers.
Expected Result : Hash should update on the indexer_state without regenerating the grid data.
Actual Result: Grid table getting truncated and getting recreated again for no reason.
36 remaining items