Magento 2: Could not change indexers mode. Management помилка при індексуванні

Rom4ik Bom4ik

mg_mview_state

Could not change indexers mode 

Steps to reproduce

  1. Install Magento 2 EE on Amazon EC2, with MariaDB on Amazon RDS
  2. Go to index management
  3. Select all indexers
  4. Execute action “Update by schedule”

Expected result

  1. Mode changes for all 11 indexers

Actual result

  1. Error message appears: “We couldn’t change indexer(s)’ mode because of an error.”.

Can try to read this

https://github.com/magento/magento2/issues/4095

applied the custom parameter group with log_bin_trust_function_creators = 1, no more error to change the index mode.

BUT if u use CPanel u can’t do so…

(U need your hoster grant full grant rights 4 mysql, simply from mysqladmin u cann’t do that)

Decision was to change choise of index managment right there in the base in sql table @ mg_mview_state

about it  here

All works cool

https://mirasvit.com/blog/7-ways-to-improve-your-magento-2-site-speed.html

https://magento.stackexchange.com/questions/98332/how-to-update-magento2-using-composer

composer require magento/product-community-edition 2.0.5 --no-update
composer update
rm -rf var/di var/generation
php bin/magento cache:flush
php bin/magento setup:upgrade
php bin/magento setup:di:compile
php bin/magento indexer:reindex

Залишити відповідь