Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error on filter failed executions on update to n8n version 0.204.0 #4729

Closed
dannyeuu opened this issue Nov 25, 2022 · 3 comments
Closed

Error on filter failed executions on update to n8n version 0.204.0 #4729

dannyeuu opened this issue Nov 25, 2022 · 3 comments

Comments

@dannyeuu
Copy link

Describe the bug
On Workflow executions, after update n8n to version 0.204.0 with Postgres and Docker Compose, and trying to filter for workflow execution failed, this error occurs:
Screenshot from 2022-11-25 10-15-52

Screenshot from 2022-11-25 10-15-33

Environment (please complete the following information):

  • OS: Debian 11
  • n8n Version: 0.204.0
  • Node.js Version - Docker
  • Database system: PostgreSQL 11
  • Operation mode: own

Additional context

withpostgres-postgres-1  | 2022-11-25 13:13:40.825 UTC [49] ERROR:  invalid input syntax for type timestamp: "{"_type":"isNull","_useParameter":false,"_multipleParameters":false}"
withpostgres-postgres-1  | 2022-11-25 13:13:40.825 UTC [49] STATEMENT:  SELECT COUNT(1) AS "cnt" FROM "public"."execution_entity" "ExecutionEntity" WHERE ("ExecutionEntity"."workflowId" IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) AND "ExecutionEntity"."finished" = $11 AND "ExecutionEntity"."waitTill" = $12 AND NOT(0=1)
@csuermann
Copy link
Contributor

Hi @dannyeuu,
Thank you for reporting this issue and apologies for the delay in getting back to you. Our team is currently working on a fix and we'll update you here once we have released it.

@janober janober added the Upcoming Release Will be part of the upcoming release label Dec 9, 2022
@janober
Copy link
Member

janober commented Dec 9, 2022

Fix got merged and will be released soon.

@janober janober closed this as completed Dec 9, 2022
@janober
Copy link
Member

janober commented Dec 12, 2022

Fix got released with n8n@0.207.0

@janober janober removed the Upcoming Release Will be part of the upcoming release label Dec 12, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants