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