MySQL General error 1787 when reindexing

[maxagaz]

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.

[Sunil Patel]

@maxagaz

please check

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

[maxagaz]

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

[Sunil Patel]

@maxagaz

cab you please check GTID Consistency disabledor not?

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

If enable then disable it.

[maxagaz]

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 ?

[Sunil Patel]

@maxagaz

i don't think possible per db wise.

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

Magento does not support  enforce_gtid_consistency

[maxagaz · Accepted solution]

Problem fixed by this module:

https://github.com/bangerkuwranger/Magento-2-GTID-Safe-URL-Rewrite-Tables