I’m trying to self-host Temporal v1.29 using Helm. For both default and visibility databases I use MySQL 8.0.45. I get the following error in the manage-schema-visibility-store job:
ERROR Unable to update SQL schema. {“error”: “error executing statement: Error 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '“$.TemporalChangeVersion”),\n ADD COLUMN BinaryChecksums JSON ’ at line 3”, “logging-call-at”: “/home/runner/work/docker-builds/docker-builds/temporal/tools/sql/handler.go:53”}
Maybe a smart quote issue? In the source code they seem to be normal quotes though.
I’m trying to self-host Temporal v1.29 using Helm. For both default and visibility databases I use MySQL 8.0.45. I get the following error in the manage-schema-visibility-store job:
ERROR Unable to update SQL schema. {“error”: “error executing statement: Error 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '“$.TemporalChangeVersion”),\n ADD COLUMN BinaryChecksums JSON ’ at line 3”, “logging-call-at”: “/home/runner/work/docker-builds/docker-builds/temporal/tools/sql/handler.go:53”}
Maybe a smart quote issue? In the source code they seem to be normal quotes though.