Some multiple-table DMLs intermittently are not working on MySQL versions 8.0.30+ with query insights enabled.

The issue with Google Cloud SQL has been resolved for all affected users as of Wednesday, 2023-11-29 13:55 US/Pacific. We thank you for your patience while we worked on resolving the issue.

Summary: Some multiple-table DMLs intermittently are not working on MySQL versions 8.0.30+ with query insights enabled. Description: Our engineers and support teams continue to work on the mitigation identified. We understand that this issue has impacted your ability to access and use our services, we deeply appreciate your patience and cooperation while we work towards resolving the issue in hand. At the current rate of progress, we expect to complete the mitigation work by Wednesday, 2023-11-29 14:00 US/Pacific. We will provide more information by Wednesday, 2023-11-29 14:00 US/Pacific. We sincerely apologize for any inconvenience and troubles being caused at this time. Diagnosis: Some multiple-table DMLs intermittently don't work on Cloud SQL MySQL versions 8.0.30+ with query insights enabled. A multiple-table DML is a DML affecting more than one table, for example “UPDATE tableA join tableB ON Workaround: Customers using multiple-table DMLs and having query insights enabled, can disable query plans i.e. set the query_plans_per_minute to 0 by following the steps described below: https://cloud.google.com/sql/docs/mysql/using-query-insights#gcloud If tags are enabled, then insights-config-record-application-tags also need to be disabled.

Summary: Some multiple-table DMLs intermittently don't work on MySQL versions 8.0.30+ with query insights enabled. Description: Mitigation work is currently underway by our engineering team. We do not have an ETA for mitigation at this point. We will provide more information by Tuesday, 2023-11-28 10:00 US/Pacific. Diagnosis: Some multiple-table DMLs intermittently don't work on Cloud SQL MySQL versions 8.0.30+ with query insights enabled. A multiple-table DML is a DML affecting more than one table, for example “UPDATE tableA join tableB ON Workaround: Customers using multiple-table DMLs and having query insights enabled, can disable query plans i.e. set the query_plans_per_minute to 0 by following the steps described below: https://cloud.google.com/sql/docs/mysql/using-query-insights#gcloud If tags are enabled, then insights-config-record-application-tags also need to be disabled.

Summary: Some multiple-table DMLs intermittently don't work on MySQL versions 8.0.30+ with query insights enabled. Description: We are investigating a potential issue with Google Cloud SQL. We will provide more information by Monday, 2023-11-27 10:00 US/Pacific. Diagnosis: Some multiple-table DMLs intermittently don't work on Cloud SQL MySQL versions 8.0.30+ with query insights enabled. A multiple-table DML is a DML affecting more than one table, for example “UPDATE tableA join tableB ON Workaround: Customers using multiple-table DMLs and having query insights enabled, can disable query plans i.e. set the query_plans_per_minute to 0 by following the steps described below: https://cloud.google.com/sql/docs/mysql/using-query-insights#gcloud If tags are enabled, then insights-config-record-application-tags also need to be disabled.

Summary: Some multiple-table DMLs intermittently don't work on MySQL versions 8.0.30+ with query insights enabled. Description: We are investigating a potential issue with Google Cloud SQL. We will provide more information by Monday, 2023-11-27 09:00 US/Pacific. Diagnosis: Some multiple-table DMLs intermittently don't work on Cloud SQL MySQL versions 8.0.30+ with query insights enabled. A multiple-table DML is a DML affecting more than one table, for example “UPDATE tableA join tableB ON Workaround: Customers using multiple-table DMLs and having query insights enabled, can disable query plans i.e. set the query_plans_per_minute to 0 by following the steps described below: https://cloud.google.com/sql/docs/mysql/using-query-insights#gcloud If tags are enabled, then insights-config-record-application-tags also need to be disabled.

Summary: Some multiple-table DMLs intermittently don't work on MySQL versions 8.0.30+ with query insights enabled. Description: We are investigating a potential issue with Google Cloud SQL. We will provide more information by Monday, 2023-11-27 07:00 US/Pacific. Diagnosis: Some multiple-table DMLs intermittently don't work on Cloud SQL MySQL versions 8.0.30+ with query insights enabled. A multiple-table DML is a DML affecting more than one table, for example “UPDATE tableA join tableB ON Workaround: Customers using multiple-table DMLs and having query insights enabled, can disable query plans i.e. set the query_plans_per_minute to 0 by following the steps described below: https://cloud.google.com/sql/docs/mysql/using-query-insights#gcloud If tags are enabled, then insights-config-record-application-tags also need to be disabled.