Workflows on workspaces failing
Hi,
I am self hosting v1.1.1 and I'm using multiple workspaces.
Workflows are working as expected on my primary workspace, but when I try to run a workflow on any other workspace I get the toast message in the UI 'An error occurred.' Looking at the db container logs I see this error
[42524] ERROR: invalid input value for enum workspace_5eogcnhvg0ht12x9i45sd8c2k."workflowRun_status_enum": "ENQUEUED"
[42524] CONTEXT: unnamed portal parameter $3 = '...'
[42524] STATEMENT: INSERT INTO "workspace_5eogcnhvg0ht12x9i45sd8c2k"."workflowRun"("state", "searchVector", "name", "startedAt", "endedAt", "status", "createdBySource", "createdByWorkspaceMemberId", "createdByName", "createdByContext", "output", "context", "position", "id", "createdAt", "updatedAt", "deletedAt", "workflowVersionId", "workflowId") VALUES ($1, DEFAULT, $2, DEFAULT, DEFAULT, $3, DEFAULT, DEFAULT, DEFAULT, DEFAULT, $4, $5, $6, $7, DEFAULT, DEFAULT, DEFAULT, $8, $9) RETURNING "state", "searchVector", "name", "startedAt", "endedAt", "status", "createdBySource", "createdByWorkspaceMemberId", "createdByName", "createdByContext", "output", "context", "position", "id", "createdAt", "updatedAt", "deletedAt"
In the server container I see this error
ERROR [ExceptionsHandler] invalid input value for enum workspace_7qchiqkd7f5gsfseq65ejiwpg."workflowRun_status_enum": "ENQUEUED"
Any help would be greatly appreciated.
Thanks
Chris
11 Replies
Hey Chris what's your workspace where workflows fails version ? ( default.core.workspace.version )
Hi Chris, I think I might have had the same issue here: https://discord.com/channels/1130383047699738754/1130386664812982322/threads/1393061817001050212
Unfortunately I was not able to find a solution and rolled back to v1.0.x . I will let you know if I find a solution
sorry for the delay in replying. The 3 workspaces I have are all on v1.1.1
I have reverted back to v1.0.2 and workflows are working as expected on all workspaces. Thanks
Hi @whitewhaleone, thank you for sharing. We are aware of that issue and we are investigating. Keeping you informed!
Hi, thanks for the update @thomast. I see @Rob has managed to resolve the issue to migrate. Do you know if there is an migration path I can take to move from v1.0.2? Thanks
Hi @whitewhaleone, issue should be solved if you upgrade to 1.2
Thanks, can I do a direct migration to 1.2 or do I need to run the migration plan through all the intermediate releases between 1.0.2 and 1.2?
You will have to go through intermediate releases. See https://twenty.com/developers/section/self-hosting/upgrade-guide#general-guidelines
Thanks a million for the product and all your help
Hi, I have tried to run the upgrade path from 1.0.2 -> 1.2.1. I haven't been successful..
My upgrade path
v1.0.2 -> v1.0.3 all was good v1.0.3 -> v1.1.0 workflow issue showed up again v1.1.0 -> v1.1.1 workflow issue still occurred v1.1.1 -> v1.2.0 unable to log in with local account or SSO v1.2.0 -> v1.2.1 unable to log in with local account or SSO I've attached the errors I am seeing in docker. I am currently on v1.2.1 Any help is greatly appreciated
v1.0.2 -> v1.0.3 all was good v1.0.3 -> v1.1.0 workflow issue showed up again v1.1.0 -> v1.1.1 workflow issue still occurred v1.1.1 -> v1.2.0 unable to log in with local account or SSO v1.2.0 -> v1.2.1 unable to log in with local account or SSO I've attached the errors I am seeing in docker. I am currently on v1.2.1 Any help is greatly appreciated
Hey @whitewhaleone after the upgrade what are your workspace versions please ?
It seems like they did upgraded correctly, as 2fa has been introduced in latest version
Also no need to checkout a version patch, only minor to minor