cancel
Showing results for 
Search instead for 
Did you mean: 

MySQL General error 1787 when reindexing

SOLVED

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