mysql - GTID 一致性 : CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context

Question

我的 Magento 版本是 2.2.3。我们使用的是第二代 Google Cloud SQL 实例。

运行索引命令时遇到错误

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

Answer 1

遵循 Magento 2 Issue Tracker 中发布的问题，我能够通过使用以下命令禁用二进制日志记录来消除此错误:

gcloud sql instances patch [INSTANCE_NAME] --no-enable-bin-log

---

您还可以在创建 Cloud SQL 实例时从 Web 控制台禁用二进制日志记录:

1. Expand "Show Configuration Options"
2. Expand "Enable auto backups and high availability"
3. Uncheck "Enable binary logging"

这意味着您目前无法使用 Magento 2 社区版实现高可用性 MySQL 实例(使用 Google Cloud SQL)。

您可以跟踪 issue 12124 的状态更新。