Issue with db violates not-null constraint

Describe the problem/error/question

not possible to save workflows, not possible to see exec log, literally my n8n instance is not functional;

What is the error message (if any)?

null value in column "id" of relation "workflow_entity" violates not-null constraint

Please share your workflow

doesn’t matter any workflowm

Share the output returned by the last node

Information on your n8n setup

  • n8n version:0.233.1
  • Database : pg 14
  • Running n8n via :Docker
  • Operating system: Ubuntu

I hit the same wall this morning while trying to create a new credential. I think that there was some change to the docker image as the latest tag was updated 21 hours ago. I managed to find out that it is a Postgres related error because log of this container shows more details apart from the same error that n8n shows. You are the only mention of this error so far.

There is also version 0.235.0 on docker hub, but on the other hand it is not on Github so I do not know what has changed. I might try backing the current container and updating to 0.235.0. There is also the new 1.0.0.

Hey @hismayilov,

Welcome to the community :tada:

Check out this post: Problem running workflow SQLITE_ERROR: table execution_entity has no column named data - #7 by Jon

I suspect you are seeing a similar issue, For now the best option is to manually set the n8n version in docker from latest to either 0.234.0 or 0.235.0

2 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.