Error reindex Product EAV

[guilhermetb]

I am using vps google and google cloud sql

Debian 9, CE 2.2.4, template cigar of PlazaThemes

Error is occurring:

php bin/magento indexer:reindex

Product Price index has been rebuilt successfully in 00:00:00
SQLSTATE[HY000]: General error: 1787 Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions., 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

[Manthan Dave · Accepted solution]

Hi @guilhermetb

I think this is known issue , someone as already reported and get solved on github , here i am sharing links for the same , - https://github.com/magento/magento2/issues/12124

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

Hope it helps !