Hi ,
While trying to update the schema as part of upgrading temporal server , we are seeing below error.
024-07-09T14:01:15.013+0530 DEBUG Schema Dirs: [v1.9 v1.10 v1.11] {“logging-call-at”: “updatetask.go:210”}
2024-07-09T14:01:15.013+0530 ERROR Unable to update SQL schema. {“error”: “error processing manifest for version v1.9:readfile v1.9\manifest.json: invalid argument”, “logging-call-at”: “handler.go:78”}
Do not see any issue with manifest file.
Any help is appreciated.
We are seeing the same issue. But on v1.0. Did you figure it out?
I’m also just starting out and testing out the temporal-sql-tool to see how it works and I experience the same thing on PostgreSQL version 16.1 updating from v1.9 to any higher version following the README in the Github repository temporal/tools/sql/README.md at main · temporalio/temporal .
I would be really curious if this schema update doesn’t work, what are the alternatives if there are updates to the schema that I want to deploy?
Seems to have been a problem with the released software, see SQL tool update-schema not working on windows · Issue #7454 · temporalio/temporal. I updated from v1.27.1 to 1.28.1 and the update schema worked as expected.