Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Setup upgrade works more than 15 minutes during installing module #457

Open
ihor-sviziev opened this issue Nov 3, 2018 · 4 comments
Open

Comments

@ihor-sviziev
Copy link
Contributor

Issue Description

Preconditions

1. Magento CE 2.2.6 with ~1 million of existing orders + the ~2 millions of quotes in quotes table
2. mc-magento2 1.0.30

Steps to reproduce

1. Install module
2. run `php bin/magento setup:upgrade`

Actual and Expected result

Setup upgrade process should run just few minutes

Additional information

This issue appears because during installing module execution altering tables of "quote", "sales_order" and "sales_order_grid" tables, as result - it takes more than 5 minutes just to execute one alter table command.

How it can be avoided - do not add any columns to orders and quotes tables, instead - use own tables and select data from them when needed.

@gonzaloebiz
Copy link
Collaborator

Thanks

@onepack
Copy link

onepack commented Sep 29, 2019

This is not fixed.
After install the whole site is not responding for a long time and I also see the quote and order table altered by the MC module!
mailchimp_abandonedcart_flag, mailchimp_campaign_id, mailchimp_flag and mailchimp_landing_page are added.

@onepack
Copy link

onepack commented Sep 29, 2019

@ihor-sviziev, can it be you installed via composer? There is a general bug that updating via composer can disable all cache types. This will make the shop malfunction.
After using composer I nowadays always check the cache:status.
This was my problem in this case after installing mailchimp.

@ihor-sviziev
Copy link
Contributor Author

ihor-sviziev commented Sep 30, 2019

Hi @onepack,
You just descrived two issues - issue that mailchimp module updating quite big tables - orders and quotes that causes long downtime, this is what should be fixed in mailchimp module. Second issue - following magento/magento2#17634, it’s magento issue and it have to be fixed separately

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants