You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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.
The text was updated successfully, but these errors were encountered:
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.
@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.
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
Issue Description
Preconditions
Steps to reproduce
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.
The text was updated successfully, but these errors were encountered: