cancel
Showing results for 
Search instead for 
Did you mean: 

Error reindex Product EAV

SOLVED
Highlighted

Error reindex Product EAV

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

 

1 REPLY

Re: Error reindex Product EAV

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 !

if issue solved,Click Kudos & Accept as Solution