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
Solved! Go to Solution.
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
Hope it helps !