From e863502d368c7559af04f6b87f89d06b2e20b850 Mon Sep 17 00:00:00 2001 From: Aaron Hay Date: Fri, 4 May 2018 13:51:42 -0400 Subject: [PATCH] Update mysql configuration file to change sql_mode Aggregated query without group by results errors when performing LCM actions unless the sql_mode value is changed. Change-Id: I91c6ef71f22d32cf401a5113ae4e28e1ab554bb6 Issue-ID: APPC-878 Signed-off-by: Aaron Hay --- kubernetes/common/mysql/templates/configmap.yaml | 2 ++ 1 file changed, 2 insertions(+) diff --git a/kubernetes/common/mysql/templates/configmap.yaml b/kubernetes/common/mysql/templates/configmap.yaml index ff127e48cd..d8c29fb551 100644 --- a/kubernetes/common/mysql/templates/configmap.yaml +++ b/kubernetes/common/mysql/templates/configmap.yaml @@ -23,12 +23,14 @@ data: master.cnf: | # Apply this config only on the master. [mysqld] + sql_mode = "NO_ENGINE_SUBSTITUTION" log-bin [localpathprefix] master slave.cnf: | # Apply this config only on slaves. [mysqld] + sql_mode = "NO_ENGINE_SUBSTITUTION" super-read-only [localpathprefix] slave -- 2.16.6