Skip to content

@engcom-Hotel Reproduced #39206 issue in 2.4.7-p1 #39530

Open
@senthilengg

Description

@senthilengg

@engcom-Hotel I am able to reproduce the same issue in 2.4.7-p1.

Steps to Reproduce

  1. Change Encryption Key from Admin
  2. Remove the old encryption key from app/etc/env.php and Save
  3. Check the indexer_state, note down the updated at for all the rows
  4. Run setup upgrade. You can found out that indexer status was updated and hash values are changed
  5. In case of hash change customer_flat_grid data will be refreshed

Here is the indexer status from my local before and after

Screenshot 2025-01-10 at 11 19 54 AM

I would suggest re-open the issue

Originally posted by @senthilengg in #39206 (comment)

Activity

m2-assistant

m2-assistant commented on Jan 10, 2025

@m2-assistant

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.


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.

changed the title [-]@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[/+] on Jan 10, 2025
added 2 commits that reference this issue on Jan 14, 2025

Fix for issue magento#39530 to avoid regenerating admin grid flat table

e881f57
added a commit that references this issue on Jan 14, 2025

Merge pull request #1 from senthilengg/senthilengg-patch-for-github-i…

bd605cd
self-assigned this
on Jan 15, 2025
m2-assistant

m2-assistant commented on Jan 15, 2025

@m2-assistant

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: 👇

  • 1. Verify that issue has all the required information. (Preconditions, Steps to reproduce, Expected result, Actual result).
    2. Verify that issue has a meaningful description and provides enough information to reproduce the issue.
    3. Add Area: XXXXX label to the ticket, indicating the functional areas it may be related to.
    4. Verify that the issue is reproducible on 2.4-develop branch
    Details- If the issue is reproducible on 2.4-develop branch, please, add the label Reproduced 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!
    5. Add label Issue: Confirmed once verification is complete.
    6. Make sure that automatic system confirms that report has been added to the backlog.
engcom-Hotel

engcom-Hotel commented on Jan 15, 2025

@engcom-Hotel
Contributor

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:

Image

After running bin/magento s:up && bin/magento cache:clean:

Image

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

senthilengg commented on Jan 15, 2025

@senthilengg
Author

@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

Loading
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    Status

    Pull Request In Progress

    Milestone

    No milestone

    Relationships

    None yet

      Participants

      @senthilengg@engcom-Bravo@engcom-Hotel@github-jira-sync-bot@magento-ct-gh-projects-svc

      Issue actions

        @engcom-Hotel Reproduced #39206 issue in 2.4.7-p1 · Issue #39530 · magento/magento2