Showing results for 
Search instead for 
Did you mean: 

Error reindex Product EAV


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



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 , -



Hope it helps !

if issue solved,Click Kudos & Accept as Solution