cancel
Showing results for 
Search instead for 
Did you mean: 

MySQL General error 1787 when reindexing

SOLVED
   Did you know you can see the translated content as per your choice?

Translation is in progress. Please check again after few minutes.

MySQL General error 1787 when reindexing

How to fix the error below ?  

$ php bin/magento indexer:reindex
Design Config Grid index has been rebuilt successfully in 00:00:00
Customer Grid index is locked by another reindex process. Skipping.
Category Products index has been rebuilt successfully in 00:00:00
Product Categories index has been rebuilt successfully in 00:00:00
Product Price index has been rebuilt successfully in 00:00:00
SQLSTATE[HY000]: General error: 1787 When @@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1, the statements CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can be executed in a non-transactional context only, and require that AUTOCOMMIT = 1., query was: CREATE TEMPORARY TABLE IF NOT EXISTS `catalog_product_index_eav_temp` LIKE `catalog_product_index_eav_tmp`
Stock index has been rebuilt successfully in 00:00:00
Catalog Rule Product index has been rebuilt successfully in 00:00:00
Catalog Product Rule index has been rebuilt successfully in 00:00:00
Catalog Search index has been rebuilt successfully in 00:00:04

My server in on Ubuntu 16.04 with Mysql 5.7.19 and php 7.0.24.

 

1 ACCEPTED SOLUTION

Accepted Solutions

Re: MySQL General error 1787 when reindexing

6 REPLIES 6

Re: MySQL General error 1787 when reindexing

@maxagaz

 

please check

 

https://magento.stackexchange.com/questions/198330/magento-2-2-mysql-general-error-1787-when-reindex...

 


Problem solved? Click Kudos & Accept as Solution!
Sunil Patel
Magento 2 Certified Professional Developer & Frontend Developer

Re: MySQL General error 1787 when reindexing

This is my same question on stackexchange, but there's not yet any reply there either.

Re: MySQL General error 1787 when reindexing

@maxagaz

 

cab you please check GTID Consistency disabledor not?

 

https://avdeo.com/2014/03/27/enabling-gtid-in-mysql/

 

 

If enable then disable it.

 


Problem solved? Click Kudos & Accept as Solution!
Sunil Patel
Magento 2 Certified Professional Developer & Frontend Developer

Re: MySQL General error 1787 when reindexing

It is enabled but I can't disable it, it's on a shared database server. Is
there a way to clean the database manually from GTID stuffs ?

Re: MySQL General error 1787 when reindexing

@maxagaz

 

i don't think possible per db wise.

 

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

 

Magento does not support  enforce_gtid_consistency


Problem solved? Click Kudos & Accept as Solution!
Sunil Patel
Magento 2 Certified Professional Developer & Frontend Developer

Re: MySQL General error 1787 when reindexing