Cannot activate any webhook in Production

Joachim_Brindeau · October 27, 2023, 5:33am

Hello!

So I have a major issue on my install which is that I cannot activate a simple webhook.
I tried troubleshooting and created a long post (which I flagged for deletion) the other day about errors in my loops but now I have targeted my main issue below and I will explain it much more clearly.

Describe the problem/error/question

I have created two simple workflows.
The N8N install is running in queue mode with a main node and two workers.

Calling a workflow

Receiving the webhook

What is the error message (if any)?

Unknown column ‘ExecutionEntity.data’ in ‘field list’

What really troubles me if that it works just fine in test mode:

I am happy to pay anyone who can fix it for me.
Thank you very much

EDIT

I keep troubleshooting and found out that calling the webhook with zero data using curl in terminal gives the same error.
Just found out it’s the same for automatic triggers (tested with Notion) so anything but activation with click.

Information on your n8n setup

n8n version: 1.11.1
Database (default: SQLite):
n8n EXECUTIONS_PROCESS setting (default: own, main): Queue mode
Running n8n via (Docker, npm, n8n cloud, desktop app): Docker
Operating system:

Jon · October 27, 2023, 7:20am

Hey @Joachim_Brindeau,

Can you share your docker configuration? It sounds like it could just be a config issue.

Joachim_Brindeau · October 27, 2023, 8:35am

version: "3.7"

services:
  caddy:
    image: caddy:latest
    restart: unless-stopped
    ports:
      - "80:80"
      - "443:443"
    volumes:
      - ${DATA_FOLDER}/caddy_data:/data
      - ${DATA_FOLDER}/caddy_config:/config
      - ${DATA_FOLDER}/caddy_config/Caddyfile:/etc/caddy/Caddyfile
  n8n:
    image: n8nio/n8n
    restart: always
    ports:
      - 5678:5678
    environment:
      - N8N_BASIC_AUTH_ACTIVE=true
      - N8N_BASIC_AUTH_USER
      - N8N_BASIC_AUTH_PASSWORD
      - N8N_HOST=${SUBDOMAIN}.${DOMAIN_NAME}
      - N8N_PORT=5678
      - N8N_PROTOCOL=https
      - NODE_ENV=production
      - WEBHOOK_URL=https://${SUBDOMAIN}.${DOMAIN_NAME}/
      - GENERIC_TIMEZONE=${GENERIC_TIMEZONE}
      - DB_TYPE=mysqldb
      - DB_MYSQLDB_PASSWORD=${MYSQL_ROOT_PASSWORD}
      - DB_MYSQLDB_HOST=mysql
      - EXECUTIONS_MODE=queue
      - QUEUE_BULL_REDIS_HOST=redis
    volumes:
      - ${DATA_FOLDER}/local_files:/files
      - ${DATA_FOLDER}/.n8n:/home/node/.n8n
  mysql:
    image: mysql:8.0
    restart: always
    environment:
      - MYSQL_DATABASE=n8n
      - MYSQL_ROOT_PASSWORD=${MYSQL_ROOT_PASSWORD}
    volumes:
      - mysql:/var/lib/mysql
    ports:
      - 3306:3306

  redis:
    image: 'redis'
    restart: always
    ports:
      - '6379:6379'

volumes:
  caddy_data:
    external: true
  caddy_config:
  mysql:

This is what I have, I did not set up the docker but I have access to the system.
Thanks a lot for your help

Jon · October 27, 2023, 10:49am

Hey @Joachim_Brindeau,

Why are you running in queue mode if you don’t have any workers? I would change your compose file to the below which removes redis and queue mode, I would also recommend using Postgres as we will be removing MySQL support and I suspect this is a fairly new install so it would be easier to do that now rather than later.

version: "3.7"

services:
  caddy:
    image: caddy:latest
    restart: unless-stopped
    ports:
      - "80:80"
      - "443:443"
    volumes:
      - ${DATA_FOLDER}/caddy_data:/data
      - ${DATA_FOLDER}/caddy_config:/config
      - ${DATA_FOLDER}/caddy_config/Caddyfile:/etc/caddy/Caddyfile
  n8n:
    image: n8nio/n8n
    restart: always
    ports:
      - 5678:5678
    environment:
      - N8N_HOST=${SUBDOMAIN}.${DOMAIN_NAME}
      - N8N_PORT=5678
      - N8N_PROTOCOL=https
      - NODE_ENV=production
      - WEBHOOK_URL=https://${SUBDOMAIN}.${DOMAIN_NAME}/
      - GENERIC_TIMEZONE=${GENERIC_TIMEZONE}
      - DB_TYPE=mysqldb
      - DB_MYSQLDB_PASSWORD=${MYSQL_ROOT_PASSWORD}
      - DB_MYSQLDB_HOST=mysql
      - EXECUTIONS_MODE=main
    volumes:
      - ${DATA_FOLDER}/local_files:/files
      - ${DATA_FOLDER}/.n8n:/home/node/.n8n
  mysql:
    image: mysql:8.0
    restart: always
    environment:
      - MYSQL_DATABASE=n8n
      - MYSQL_ROOT_PASSWORD=${MYSQL_ROOT_PASSWORD}
    volumes:
      - mysql:/var/lib/mysql
    ports:
      - 3306:3306

volumes:
  caddy_data:
    external: true
  caddy_config:
  mysql:

Joachim_Brindeau · October 27, 2023, 10:54am

Thank you for looking into it.
I have two worker instances.

I guess there is a mistake coz it was working fine in queue mode at scale before my colleague upgraded everything to v1.

My colleague is out at the moment. If anyone know its way around queue mode I can pay to reconfigure the workers properly in AWS (I have access to the console for each of the instances).

(I need queue mode because the workflow I build needs to enrich thousands of rows asap)

Jon · October 27, 2023, 11:04am

Hey @Joachim_Brindeau,

Do you have the full configuration that includes the workers?

Joachim_Brindeau · October 27, 2023, 11:39am

Is that supposed to be the same docker-compose.yml file?
I am not a dev so kind of lost with how the docker launches the workers.

Jon · October 27, 2023, 1:04pm

Hey @Joachim_Brindeau,

It all depends on the system configuration, It may be in a different compose file if there are different servers running. You may need to get in touch with whoever manages your n8n environment for you to assist.

Joachim_Brindeau · October 29, 2023, 6:03am

Hey Jon,
We exported all credentials and workflow and my colleague reinstalled cleanly.
Guess initially something went wrong in the upgrade because now it works.
We took the opportunity to move onto Postgres too.
Thank you for the advice

Joachim_Brindeau · October 30, 2023, 7:04am

Damned.
The error now happens from time to time, no changes, I just rerun the trigger workflow and it works.
Odd.

Jon · October 30, 2023, 7:33am

Hey @Joachim_Brindeau,

Any chance we can get the full config and the output of the worker node logs?

Joachim_Brindeau · October 31, 2023, 5:59pm

Unfortunately I don’t know where that is stored, I will have to wait for my colleague to get back to me.
None of the Notion page triggers work either (testing them works).
Thanks for your help!

Jon · November 1, 2023, 7:24am

Hey @Joachim_Brindeau,

The Notion trigger should be polling rather than webhook so I would expect that to work, Which error did you get when enabling the worklfow? It sounds like we either have a bug here or there is a configuration issue either way we really need to get that configuration so we can work out what is going on.

Joachim_Brindeau · November 1, 2023, 7:32am

Hi Jon,

It’s always the same error.
When executing manually it works as you can see in the history, but if it’s automatic I get this:

It’s not even showing any data in the first node.
Available all day today if I can help troubleshooting!

Thanks again

Joachim_Brindeau · November 1, 2023, 7:37am

Hmm and sometimes it works …

Absolutely zero changes to the setup, it seems to be quite random.

Jon · November 1, 2023, 8:15am

If you can get us the config we can take a look, Random would suggest there could be a worker or something not configured correctly.

Joachim_Brindeau · November 1, 2023, 8:19am

So this is what I retrieved:

 GNU nano 6.2                                                                                       docker-compose.yml                                                                                                
version: "3.7"

services:
  caddy:
    image: caddy:latest
    restart: unless-stopped
    ports:
      - "80:80"
      - "443:443"
    volumes:
      - ${DATA_FOLDER}/caddy_data:/data
      - ${DATA_FOLDER}/caddy_config:/config
      - ${DATA_FOLDER}/caddy_config/Caddyfile:/etc/caddy/Caddyfile
  n8n:
    image: n8nio/n8n
    restart: always
    ports:
      - 5678:5678
    environment:
      - N8N_BASIC_AUTH_ACTIVE=true
      - N8N_BASIC_AUTH_USER
      - N8N_BASIC_AUTH_PASSWORD
      - N8N_HOST=${SUBDOMAIN}.${DOMAIN_NAME}
      - N8N_PORT=5678
      - N8N_PROTOCOL=https
      - NODE_ENV=production
      - WEBHOOK_URL=https://${SUBDOMAIN}.${DOMAIN_NAME}/
      - GENERIC_TIMEZONE=${GENERIC_TIMEZONE}
      - DB_TYPE=postgresdb
      - DB_POSTGRESDB_HOST=postgres
      - DB_POSTGRESDB_DATABASE=n8n
      - DB_POSTGRESDB_USER=n8n
      - DB_POSTGRESDB_PASSWORD=${POSTGRES_PASSWORD}
      - EXECUTIONS_MODE=queue
      - QUEUE_BULL_REDIS_HOST=redis
#      - N8N_LOG_LEVEL=debug
    volumes:
      - ${DATA_FOLDER}/local_files:/files
      - ${DATA_FOLDER}/.n8n:/home/node/.n8n

  redis:
    image: 'redis'
    restart: always
    ports:
      - '6379:6379'
  postgres:
    image: postgres:latest
    restart: always
    environment:
      - POSTGRES_DB=n8n
      - POSTGRES_USER=n8n
      - POSTGRES_PASSWORD=${POSTGRES_PASSWORD}
    volumes:
      - postgres:/var/lib/postgresql/data
    ports:
      - 5432:5432

volumes:
  caddy_data:
    external: true
  caddy_config:
  mysql:
  postgres:

Is this what you expect as logs ?

I am not a dev at all but I used the find command to locate logs, I emptied them and now generated new ones.

Main log:

  GNU nano 6.2                                                                      ./home/ubuntu/n8n-docker-caddy/.n8n/n8nEventLog.log                                                                                
{"__type":"$$EventMessageConfirm","confirm":"3b2ee134-22e0-471f-8a82-8b4a3b082686","ts":"2023-11-01T09:06:31.595+01:00","source":{"id":"0","name":"eventBus"}}
{"__type":"$$EventMessageNode","id":"9a217136-5ce9-4797-870f-0a587d159f73","ts":"2023-11-01T09:06:31.607+01:00","eventName":"n8n.node.started","message":"n8n.node.started","payload":{"executionId":"15934","nodeName>
{"__type":"$$EventMessageConfirm","confirm":"9a217136-5ce9-4797-870f-0a587d159f73","ts":"2023-11-01T09:06:31.612+01:00","source":{"id":"0","name":"eventBus"}}
{"__type":"$$EventMessageNode","id":"95d5accf-3e58-4387-a42c-bcbfffb587e3","ts":"2023-11-01T09:06:31.612+01:00","eventName":"n8n.node.finished","message":"n8n.node.finished","payload":{"executionId":"15934","nodeNa>
{"__type":"$$EventMessageConfirm","confirm":"95d5accf-3e58-4387-a42c-bcbfffb587e3","ts":"2023-11-01T09:06:31.612+01:00","source":{"id":"0","name":"eventBus"}}
{"__type":"$$EventMessageNode","id":"0b9e1500-856f-4468-9062-08c64183e2de","ts":"2023-11-01T09:06:31.612+01:00","eventName":"n8n.node.started","message":"n8n.node.started","payload":{"executionId":"15934","nodeName>
{"__type":"$$EventMessageConfirm","confirm":"0b9e1500-856f-4468-9062-08c64183e2de","ts":"2023-11-01T09:06:31.612+01:00","source":{"id":"0","name":"eventBus"}}
{"__type":"$$EventMessageNode","id":"fedbf1c0-1492-494b-b082-4536ab123457","ts":"2023-11-01T09:06:31.885+01:00","eventName":"n8n.node.finished","message":"n8n.node.finished","payload":{"executionId":"15934","nodeNa>
{"__type":"$$EventMessageConfirm","confirm":"fedbf1c0-1492-494b-b082-4536ab123457","ts":"2023-11-01T09:06:31.885+01:00","source":{"id":"0","name":"eventBus"}}
{"__type":"$$EventMessageNode","id":"6b4d3635-4f7d-441d-a55c-7864043c6d32","ts":"2023-11-01T09:06:31.885+01:00","eventName":"n8n.node.started","message":"n8n.node.started","payload":{"executionId":"15934","nodeName>
{"__type":"$$EventMessageConfirm","confirm":"6b4d3635-4f7d-441d-a55c-7864043c6d32","ts":"2023-11-01T09:06:31.886+01:00","source":{"id":"0","name":"eventBus"}}
{"__type":"$$EventMessageNode","id":"164fd440-914e-458e-aa38-49f3f538a7da","ts":"2023-11-01T09:06:31.952+01:00","eventName":"n8n.node.finished","message":"n8n.node.finished","payload":{"executionId":"15934","nodeNa>
{"__type":"$$EventMessageConfirm","confirm":"164fd440-914e-458e-aa38-49f3f538a7da","ts":"2023-11-01T09:06:31.952+01:00","source":{"id":"0","name":"eventBus"}}
{"__type":"$$EventMessageNode","id":"27e48eca-122a-49ff-abc9-b7a7eac4a538","ts":"2023-11-01T09:06:31.952+01:00","eventName":"n8n.node.started","message":"n8n.node.started","payload":{"executionId":"15934","nodeName>
{"__type":"$$EventMessageConfirm","confirm":"27e48eca-122a-49ff-abc9-b7a7eac4a538","ts":"2023-11-01T09:06:31.952+01:00","source":{"id":"0","name":"eventBus"}}
{"__type":"$$EventMessageNode","id":"9ff95bb1-143e-4c29-9e7e-5cff430243cc","ts":"2023-11-01T09:06:31.953+01:00","eventName":"n8n.node.finished","message":"n8n.node.finished","payload":{"executionId":"15934","nodeNa>
{"__type":"$$EventMessageConfirm","confirm":"9ff95bb1-143e-4c29-9e7e-5cff430243cc","ts":"2023-11-01T09:06:31.953+01:00","source":{"id":"0","name":"eventBus"}}
{"__type":"$$EventMessageNode","id":"d1b5b83d-e992-47f7-963d-f2e6b524feab","ts":"2023-11-01T09:06:31.953+01:00","eventName":"n8n.node.started","message":"n8n.node.started","payload":{"executionId":"15934","nodeName>
{"__type":"$$EventMessageConfirm","confirm":"d1b5b83d-e992-47f7-963d-f2e6b524feab","ts":"2023-11-01T09:06:31.954+01:00","source":{"id":"0","name":"eventBus"}}
{"__type":"$$EventMessageNode","id":"31386172-3685-4686-b3bb-cbc526fae587","ts":"2023-11-01T09:06:32.364+01:00","eventName":"n8n.node.finished","message":"n8n.node.finished","payload":{"executionId":"15934","nodeNa>
{"__type":"$$EventMessageConfirm","confirm":"31386172-3685-4686-b3bb-cbc526fae587","ts":"2023-11-01T09:06:32.364+01:00","source":{"id":"0","name":"eventBus"}}
{"__type":"$$EventMessageWorkflow","id":"ef83d389-e32b-4d62-b7cc-61fb0e273b34","ts":"2023-11-01T09:06:32.373+01:00","eventName":"n8n.workflow.success","message":"n8n.workflow.success","payload":{"executionId":"1593>
{"__type":"$$EventMessageConfirm","confirm":"ef83d389-e32b-4d62-b7cc-61fb0e273b34","ts":"2023-11-01T09:06:32.373+01:00","source":{"id":"0","name":"eventBus"}}
{"__type":"$$EventMessageNode","id":"4da55cf5-f043-4b98-86da-8beb5fd0fbcd","ts":"2023-11-01T09:06:32.373+01:00","eventName":"n8n.node.finished","message":"n8n.node.finished","payload":{"executionId":"15925","nodeNa>
{"__type":"$$EventMessageConfirm","confirm":"4da55cf5-f043-4b98-86da-8beb5fd0fbcd","ts":"2023-11-01T09:06:32.373+01:00","source":{"id":"0","name":"eventBus"}}
{"__type":"$$EventMessageNode","id":"2f54ea6e-f7db-403d-a365-016d6256f4af","ts":"2023-11-01T09:06:32.374+01:00","eventName":"n8n.node.started","message":"n8n.node.started","payload":{"executionId":"15925","nodeName>
{"__type":"$$EventMessageConfirm","confirm":"2f54ea6e-f7db-403d-a365-016d6256f4af","ts":"2023-11-01T09:06:32.374+01:00","source":{"id":"0","name":"eventBus"}}
{"__type":"$$EventMessageNode","id":"207ccdæ23-1adb-4bc6-8098-27d29e07c973","ts":"2023-11-01T09:06:32.375+01:00","eventName":"n8n.node.finished","message":"n8n.node.finished","payload":{"executionId":"15925","nodeNa>
{"__type":"$$EventMessageConfirm","confirm":"207ccd23-1adb-4bc6-8098-27d29e07c973","ts":"2023-11-01T09:06:32.375+01:00","source":{"id":"0","name":"eventBus"}}
{"__type":"$$EventMessageNode","id":"f84f01a3-51d5-4d98-b05d-91669b84eee4","ts":"2023-11-01T09:06:32.375+01:00","eventName":"n8n.node.started","message":"n8n.node.started","payload":{"executionId":"15925","nodeName>
{"__type":"$$EventMessageConfirm","confirm":"f84f01a3-51d5-4d98-b05d-91669b84eee4","ts":"2023-11-01T09:06:32.375+01:00","source":{"id":"0","name":"eventBus"}}
{"__type":"$$EventMessageNode","id":"1c2bb063-131a-4479-8439-eca37497695f","ts":"2023-11-01T09:06:32.378+01:00","eventName":"n8n.node.finished","message":"n8n.node.finished","payload":{"executionId":"15925","nodeNa>
{"__type":"$$EventMessageConfirm","confirm":"1c2bb063-131a-4479-8439-eca37497695f","ts":"2023-11-01T09:06:32.378+01:00","source":{"id":"0","name":"eventBus"}}
{"__type":"$$EventMessageNode","id":"3de53e97-81a3-4e01-8215-7ca2816ddd8d","ts":"2023-11-01T09:06:32.378+01:00","eventName":"n8n.node.started","message":"n8n.node.started","payload":{"executionId":"15925","nodeName>
{"__type":"$$EventMessageConfirm","confirm":"3de53e97-81a3-4e01-8215-7ca2816ddd8d","ts":"2023-11-01T09:06:32.379+01:00","source":{"id":"0","name":"eventBus"}}
{"__type":"$$EventMessageWorkflow","id":"f68e307f-bac1-412c-b3c6-84b38ca65b9d","ts":"2023-11-01T09:06:32.402+01:00","eventName":"n8n.workflow.started","message":"n8n.workflow.started","payload":{"executionId":"1593>
{"__type":"$$EventMessageConfirm","confirm":"f68e307f-bac1-412c-b3c6-84b38ca65b9d","ts":"2023-11-01T09:06:32.406+01:00","source":{"id":"0","name":"eventBus"}}
{"__type":"$$EventMessageNode","id":"b20359f7-9450-428b-a0b3-f22e7fd407f5","ts":"2023-11-01T09:06:32.417+01:00","eventName":"n8n.node.started","message":"n8n.node.started","payload":{"executionId":"15936","nodeName>
{"__type":"$$EventMessageConfirm","confirm":"b20359f7-9450-428b-a0b3-f22e7fd407f5","ts":"2023-11-01T09:06:32.417+01:00","source":{"id":"0","name":"eventBus"}}
{"__type":"$$EventMessageNode","id":"29a58243-c975-4e3f-8378-888b83fba827","ts":"2023-11-01T09:06:32.418+01:00","eventName":"n8n.node.finished","message":"n8n.node.finished","payload":{"executionId":"15936","nodeNa>
{"__type":"$$EventMessageConfirm","confirm":"29a58243-c975-4e3f-8378-888b83fba827","ts":"2023-11-01T09:06:32.418+01:00","source":{"id":"0","name":"eventBus"}}
{"__type":"$$EventMessageNode","id":"2e6f48da-8b2a-4632-9423-a5793152adaf","ts":"2023-11-01T09:06:32.418+01:00","eventName":"n8n.node.started","message":"n8n.node.started","payload":{"executionId":"15936","nodeName>
{"__type":"$$EventMessageConfirm","confirm":"2e6f48da-8b2a-4632-9423-a5793152adaf","ts":"2023-11-01T09:06:32.418+01:00","source":{"id":"0","name":"eventBus"}}
{"__type":"$$EventMessageWorkflow","id":"8179e452-ff33-4f70-8d9f-fbac583725ba","ts":"2023-11-01T09:06:32.867+01:00","eventName":"n8n.workflow.crashed","message":"n8n.workflow.crashed","payload":{"executionId":"1593>
{"__type":"$$EventMessageConfirm","confirm":"8179e452-ff33-4f70-8d9f-fbac583725ba","ts":"2023-11-01T09:06:32.867+01:00","source":{"id":"0","name":"eventBus"}}
{"__type":"$$EventMessageWorkflow","id":"5ee3f6f8-de54-4b21-9989-d837bf99c75d","ts":"2023-11-01T09:06:32.872+01:00","eventName":"n8n.workflow.failed","message":"n8n.workflow.failed","payload":{"executionId":"15937">
{"__type":"$$EventMessageConfirm","confirm":"5ee3f6f8-de54-4b21-9989-d837bf99c75d","ts":"2023-11-01T09:06:32.872+01:00","source":{"id":"0","name":"eventBus"}}
{"__type":"$$EventMessageNode","id":"e7408e3a-48f5-4305-b78d-83040497ffbf","ts":"2023-11-01T09:06:38.152+01:00","eventName":"n8n.node.finished","message":"n8n.node.finished","payload":{"executionId":"15936","nodeNa>
{"__type":"$$EventMessageConfirm","confirm":"e7408e3a-48f5-4305-b78d-83040497ffbf","ts":"2023-11-01T09:06:38.152+01:00","source":{"id":"0","name":"eventBus"}}
{"__type":"$$EventMessageNode","id":"bfa34181-187a-4815-99c6-7a1994ecf2cc","ts":"2023-11-01T09:06:38.152+01:00","eventName":"n8n.node.started","message":"n8n.node.started","payload":{"executionId":"15936","nodeName>
{"__type":"$$EventMessageConfirm","confirm":"bfa34181-187a-4815-99c6-7a1994ecf2cc","ts":"2023-11-01T09:06:38.152+01:00","source":{"id":"0","name":"eventBus"}}
{"__type":"$$EventMessageNode","id":"13b6f72e-1ad6-49d3-a6f0-f1521bad2ad2","ts":"2023-11-01T09:06:38.241+01:00","eventName":"n8n.node.finished","message":"n8n.node.finished","payload":{"executionId":"15936","nodeNa>
{"__type":"$$EventMessageConfirm","confirm":"13b6f72e-1ad6-49d3-a6f0-f1521bad2ad2","ts":"2023-11-01T09:06:38.241+01:00","source":{"id":"0","name":"eventBus"}}
{"__type":"$$EventMessageNode","id":"529ebc6e-5703-46c7-9c58-9c26f795bde1","ts":"2023-11-01T09:06:38.241+01:00","eventName":"n8n.node.started","message":"n8n.node.started","payload":{"executionId":"15936","nodeName>
{"__type":"$$EventMessageConfirm","confirm":"529ebc6e-5703-46c7-9c58-9c26f795bde1","ts":"2023-11-01T09:06:38.242+01:00","source":{"id":"0","name":"eventBus"}}
{"__type":"$$EventMessageNode","id":"ed9b3ecd-0e74-4ef5-bb0d-17eafc7d09d0","ts":"2023-11-01T09:06:38.242+01:00","eventName":"n8n.node.finished","message":"n8n.node.finished","payload":{"executionId":"15936","nodeNa>
{"__type":"$$EventMessageConfirm","confirm":"ed9b3ecd-0e74-4ef5-bb0d-17eafc7d09d0","ts":"2023-11-01T09:06:38.242+01:00","source":{"id":"0","name":"eventBus"}}
{"__type":"$$EventMessageNode","id":"98f1df0d-4900-45ae-b8c7-01fb5d21e943","ts":"2023-11-01T09:06:38.242+01:00","eventName":"n8n.node.started","message":"n8n.node.started","payload":{"executionId":"15936","nodeName>
{"__type":"$$EventMessageConfirm","confirm":"98f1df0d-4900-45ae-b8c7-01fb5d21e943","ts":"2023-11-01T09:06:38.242+01:00","source":{"id":"0","name":"eventBus"}}
{"__type":"$$EventMessageNode","id":"ff710837-eba8-4f34-ad75-23743f556c89","ts":"2023-11-01T09:06:38.665+01:00","eventName":"n8n.node.finished","message":"n8n.node.finished","payload":{"executionId":"15936","nodeNa>
{"__type":"$$EventMessageConfirm","confirm":"ff710837-eba8-4f34-ad75-23743f556c89","ts":"2023-11-01T09:06:38.666+01:00","source":{"id":"0","name":"eventBus"}}
{"__type":"$$EventMessageWorkflow","id":"7894a07c-d29b-4fc5-bbdd-4a3ae812dced","ts":"2023-11-01T09:06:38.681+01:00","eventName":"n8n.workflow.success","message":"n8n.workflow.success","payload":{"executionId":"1593>
{"__type":"$$EventMessageConfirm","confirm":"7894a07c-d29b-4fc5-bbdd-4a3ae812dced","ts":"2023-11-01T09:06:38.681+01:00","source":{"id":"0","name":"eventBus"}}
{"__type":"$$EventMessageNode","id":"94b2d810-793b-4c53-9857-995bc28de6d0","ts":"2023-11-01T09:06:38.681+01:00","eventName":"n8n.node.finished","message":"n8n.node.finished","payload":{"executionId":"15925","nodeNa>
{"__type":"$$EventMessageConfirm","confirm":"94b2d810-793b-4c53-9857-995bc28de6d0","ts":"2023-11-01T09:06:38.681+01:00","source":{"id":"0","name":"eventBus"}}
{"__type":"$$EventMessageWorkflow","id":"1eebb5ff-9bb0-4b0e-942c-93277ccfc7d6","ts":"2023-11-01T09:06:39.728+01:00","eventName":"n8n.workflow.failed","message":"n8n.workflow.failed","payload":{"executionId":"15925">
{"__type":"$$EventMessageConfirm","confirm":"1eebb5ff-9bb0-4b0e-942c-93277ccfc7d6","ts":"2023-11-01T09:06:39.728+01:00","source":{"id":"0","name":"eventBus"}}

worker log:

  GNU nano 6.2                            ./var/lib/docker/overlay2/83d333cba187b246d8936cdd21adf7f3e0a507def463711807a448f2d817e8ae/merged/home/node/.n8n/n8nEventLog-worker.log                                      
{"__type":"$$EventMessageWorkflow","id":"831f6ff7-6ae5-42c7-915f-55e05b7170bd","ts":"2023-11-01T04:06:17.572-04:00","eventName":"n8n.workflow.started","message":"n8n.workflow.started","payload":{"executionId":"1592>
{"__type":"$$EventMessageConfirm","confirm":"831f6ff7-6ae5-42c7-915f-55e05b7170bd","ts":"2023-11-01T04:06:17.574-04:00","source":{"id":"0","name":"eventBus"}}
{"__type":"$$EventMessageNode","id":"3d5f1b87-f278-43fe-99f0-30d29eabf2e9","ts":"2023-11-01T04:06:17.574-04:00","eventName":"n8n.node.started","message":"n8n.node.started","payload":{"executionId":"15928","nodeName>
{"__type":"$$EventMessageConfirm","confirm":"3d5f1b87-f278-43fe-99f0-30d29eabf2e9","ts":"2023-11-01T04:06:17.574-04:00","source":{"id":"0","name":"eventBus"}}
{"__type":"$$EventMessageNode","id":"b98c9413-ef39-4e1c-b282-d95735ce8c5f","ts":"2023-11-01T04:06:17.574-04:00","eventName":"n8n.node.finished","message":"n8n.node.finished","payload":{"executionId":"15928","nodeNa>
{"__type":"$$EventMessageConfirm","confirm":"b98c9413-ef39-4e1c-b282-d95735ce8c5f","ts":"2023-11-01T04:06:17.574-04:00","source":{"id":"0","name":"eventBus"}}
{"__type":"$$EventMessageNode","id":"9d4fd7b3-e8ee-4f98-ad02-08cab0275185","ts":"2023-11-01T04:06:17.576-04:00","eventName":"n8n.node.started","message":"n8n.node.started","payload":{"executionId":"15928","nodeName>
{"__type":"$$EventMessageConfirm","confirm":"9d4fd7b3-e8ee-4f98-ad02-08cab0275185","ts":"2023-11-01T04:06:17.576-04:00","source":{"id":"0","name":"eventBus"}}
{"__type":"$$EventMessageNode","id":"53a1158a-644c-4e8b-a39e-9ca112cf30c1","ts":"2023-11-01T04:06:17.822-04:00","eventName":"n8n.node.finished","message":"n8n.node.finished","payload":{"executionId":"15928","nodeNa>
{"__type":"$$EventMessageConfirm","confirm":"53a1158a-644c-4e8b-a39e-9ca112cf30c1","ts":"2023-11-01T04:06:17.824-04:00","source":{"id":"0","name":"eventBus"}}
{"__type":"$$EventMessageNode","id":"ec532847-622f-450e-bd4f-6568ed07092e","ts":"2023-11-01T04:06:17.824-04:00","eventName":"n8n.node.started","message":"n8n.node.started","payload":{"executionId":"15928","nodeName>
{"__type":"$$EventMessageConfirm","confirm":"ec532847-622f-450e-bd4f-6568ed07092e","ts":"2023-11-01T04:06:17.824-04:00","source":{"id":"0","name":"eventBus"}}
{"__type":"$$EventMessageNode","id":"152e81f8-24de-457d-8d2a-96a22bea02da","ts":"2023-11-01T04:06:17.825-04:00","eventName":"n8n.node.finished","message":"n8n.node.finished","payload":{"executionId":"15928","nodeNa>
{"__type":"$$EventMessageConfirm","confirm":"152e81f8-24de-457d-8d2a-96a22bea02da","ts":"2023-11-01T04:06:17.825-04:00","source":{"id":"0","name":"eventBus"}}
{"__type":"$$EventMessageNode","id":"cc12f9d0-713b-41a0-b20d-d8cdff56ce3d","ts":"2023-11-01T04:06:17.825-04:00","eventName":"n8n.node.started","message":"n8n.node.started","payload":{"executionId":"15928","nodeName>
{"__type":"$$EventMessageConfirm","confirm":"cc12f9d0-713b-41a0-b20d-d8cdff56ce3d","ts":"2023-11-01T04:06:17.825-04:00","source":{"id":"0","name":"eventBus"}}
{"__type":"$$EventMessageNode","id":"124a5ec8-2b26-4fd0-9774-9724bfb81150","ts":"2023-11-01T04:06:17.826-04:00","eventName":"n8n.node.finished","message":"n8n.node.finished","payload":{"executionId":"15928","nodeNa>
{"__type":"$$EventMessageConfirm","confirm":"124a5ec8-2b26-4fd0-9774-9724bfb81150","ts":"2023-11-01T04:06:17.826-04:00","source":{"id":"0","name":"eventBus"}}
{"__type":"$$EventMessageNode","id":"51f2a8e2-ae40-46c4-bc94-cd4241a3c569","ts":"2023-11-01T04:06:17.826-04:00","eventName":"n8n.node.started","message":"n8n.node.started","payload":{"executionId":"15928","nodeName>
{"__type":"$$EventMessageConfirm","confirm":"51f2a8e2-ae40-46c4-bc94-cd4241a3c569","ts":"2023-11-01T04:06:17.826-04:00","source":{"id":"0","name":"eventBus"}}
{"__type":"$$EventMessageNode","id":"7398248b-642a-410b-8062-b2245d6d2b4b","ts":"2023-11-01T04:06:17.827-04:00","eventName":"n8n.node.finished","message":"n8n.node.finished","payload":{"executionId":"15928","nodeNa>
{"__type":"$$EventMessageConfirm","confirm":"7398248b-642a-410b-8062-b2245d6d2b4b","ts":"2023-11-01T04:06:17.827-04:00","source":{"id":"0","name":"eventBus"}}
{"__type":"$$EventMessageNode","id":"37ed3c3d-e6e9-4860-b547-bdbc8071b024","ts":"2023-11-01T04:06:17.827-04:00","eventName":"n8n.node.started","message":"n8n.node.started","payload":{"executionId":"15928","nodeName>
{"__type":"$$EventMessageConfirm","confirm":"37ed3c3d-e6e9-4860-b547-bdbc8071b024","ts":"2023-11-01T04:06:17.827-04:00","source":{"id":"0","name":"eventBus"}}
{"__type":"$$EventMessageNode","id":"e48f28d2-b8d1-4904-a40a-31876487284f","ts":"2023-11-01T04:06:17.828-04:00","eventName":"n8n.node.finished","message":"n8n.node.finished","payload":{"executionId":"15928","nodeNa>
{"__type":"$$EventMessageConfirm","confirm":"e48f28d2-b8d1-4904-a40a-31876487284f","ts":"2023-11-01T04:06:17.828-04:00","source":{"id":"0","name":"eventBus"}}
{"__type":"$$EventMessageWorkflow","id":"21eb30e9-7c0a-452a-ad58-8855626671ba","ts":"2023-11-01T04:06:17.835-04:00","eventName":"n8n.workflow.success","message":"n8n.workflow.success","payload":{"executionId":"1592>
{"__type":"$$EventMessageConfirm","confirm":"21eb30e9-7c0a-452a-ad58-8855626671ba","ts":"2023-11-01T04:06:17.837-04:00","source":{"id":"0","name":"eventBus"}}
{"__type":"$$EventMessageWorkflow","id":"5b00c697-44db-47cd-953c-451c7481b3eb","ts":"2023-11-01T04:06:24.429-04:00","eventName":"n8n.workflow.started","message":"n8n.workflow.started","payload":{"executionId":"1593>
{"__type":"$$EventMessageConfirm","confirm":"5b00c697-44db-47cd-953c-451c7481b3eb","ts":"2023-11-01T04:06:24.431-04:00","source":{"id":"0","name":"eventBus"}}
{"__type":"$$EventMessageNode","id":"7ec43b76-4bba-4f0a-9900-5127056b4d8e","ts":"2023-11-01T04:06:24.432-04:00","eventName":"n8n.node.started","message":"n8n.node.started","payload":{"executionId":"15930","nodeName>
{"__type":"$$EventMessageConfirm","confirm":"7ec43b76-4bba-4f0a-9900-5127056b4d8e","ts":"2023-11-01T04:06:24.432-04:00","source":{"id":"0","name":"eventBus"}}
{"__type":"$$EventMessageNode","id":"50060360-d4ef-4b28-b1ff-b3addfbf1862","ts":"2023-11-01T04:06:24.432-04:00","eventName":"n8n.node.finished","message":"n8n.node.finished","payload":{"executionId":"15930","nodeNa>
{"__type":"$$EventMessageConfirm","confirm":"50060360-d4ef-4b28-b1ff-b3addfbf1862","ts":"2023-11-01T04:06:24.432-04:00","source":{"id":"0","name":"eventBus"}}
{"__type":"$$EventMessageNode","id":"cabb5436-39a5-4059-9a83-31cf5fc56dda","ts":"2023-11-01T04:06:24.432-04:00","eventName":"n8n.node.started","message":"n8n.node.started","payload":{"executionId":"15930","nodeName>
{"__type":"$$EventMessageConfirm","confirm":"cabb5436-39a5-4059-9a83-31cf5fc56dda","ts":"2023-11-01T04:06:24.432-04:00","source":{"id":"0","name":"eventBus"}}
{"__type":"$$EventMessageNode","id":"0e6bac77-ecee-4f95-8af6-a299c6849ba5","ts":"2023-11-01T04:06:24.650-04:00","eventName":"n8n.node.finished","message":"n8n.node.finished","payload":{"executionId":"15930","nodeNa>
{"__type":"$$EventMessageConfirm","confirm":"0e6bac77-ecee-4f95-8af6-a299c6849ba5","ts":"2023-11-01T04:06:24.653-04:00","source":{"id":"0","name":"eventBus"}}
{"__type":"$$EventMessageNode","id":"e3dbfe78-9edd-4fc8-9b50-78ab3615d2c1","ts":"2023-11-01T04:06:24.653-04:00","eventName":"n8n.node.started","message":"n8n.node.started","payload":{"executionId":"15930","nodeName>
{"__type":"$$EventMessageConfirm","confirm":"e3dbfe78-9edd-4fc8-9b50-78ab3615d2c1","ts":"2023-11-01T04:06:24.653-04:00","source":{"id":"0","name":"eventBus"}}
{"__type":"$$EventMessageNode","id":"7403ad2c-3390-4dd5-9fa8-c1fd4429f58a","ts":"2023-11-01T04:06:24.653-04:00","eventName":"n8n.node.finished","message":"n8n.node.finished","payload":{"executionId":"15930","nodeNa>
{"__type":"$$EventMessageConfirm","confirm":"7403ad2c-3390-4dd5-9fa8-c1fd4429f58a","ts":"2023-11-01T04:06:24.653-04:00","source":{"id":"0","name":"eventBus"}}
{"__type":"$$EventMessageNode","id":"319fc5c6-52c9-4d2a-bf50-92e0143317fd","ts":"2023-11-01T04:06:24.653-04:00","eventName":"n8n.node.started","message":"n8n.node.started","payload":{"executionId":"15930","nodeName>
{"__type":"$$EventMessageConfirm","confirm":"319fc5c6-52c9-4d2a-bf50-92e0143317fd","ts":"2023-11-01T04:06:24.653-04:00","source":{"id":"0","name":"eventBus"}}
{"__type":"$$EventMessageNode","id":"31ddaeee-470d-430c-a6ed-7f202e89e37c","ts":"2023-11-01T04:06:24.654-04:00","eventName":"n8n.node.finished","message":"n8n.node.finished","payload":{"executionId":"15930","nodeNa>
{"__type":"$$EventMessageConfirm","confirm":"31ddaeee-470d-430c-a6ed-7f202e89e37c","ts":"2023-11-01T04:06:24.654-04:00","source":{"id":"0","name":"eventBus"}}
{"__type":"$$EventMessageNode","id":"d88cba23-49a3-49a9-beaa-a637640944e8","ts":"2023-11-01T04:06:24.654-04:00","eventName":"n8n.node.started","message":"n8n.node.started","payload":{"executionId":"15930","nodeName>
{"__type":"$$EventMessageConfirm","confirm":"d88cba23-49a3-49a9-beaa-a637640944e8","ts":"2023-11-01T04:06:24.654-04:00","source":{"id":"0","name":"eventBus"}}
{"__type":"$$EventMessageNode","id":"70ec7b15-587b-4f81-894a-3551108326b6","ts":"2023-11-01T04:06:24.655-04:00","eventName":"n8n.node.finished","message":"n8n.node.finished","payload":{"executionId":"15930","nodeNa>
{"__type":"$$EventMessageConfirm","confirm":"70ec7b15-587b-4f81-894a-3551108326b6","ts":"2023-11-01T04:06:24.655-04:00","source":{"id":"0","name":"eventBus"}}
{"__type":"$$EventMessageNode","id":"e65fada5-3164-4d95-9924-7a1f2001866f","ts":"2023-11-01T04:06:24.655-04:00","eventName":"n8n.node.started","message":"n8n.node.started","payload":{"executionId":"15930","nodeName>
{"__type":"$$EventMessageConfirm","confirm":"e65fada5-3164-4d95-9924-7a1f2001866f","ts":"2023-11-01T04:06:24.655-04:00","source":{"id":"0","name":"eventBus"}}
{"__type":"$$EventMessageNode","id":"895f8cc5-c42e-4e17-bb12-42bba45ff5c6","ts":"2023-11-01T04:06:24.656-04:00","eventName":"n8n.node.finished","message":"n8n.node.finished","payload":{"executionId":"15930","nodeNa>
{"__type":"$$EventMessageConfirm","confirm":"895f8cc5-c42e-4e17-bb12-42bba45ff5c6","ts":"2023-11-01T04:06:24.656-04:00","source":{"id":"0","name":"eventBus"}}
{"__type":"$$EventMessageWorkflow","id":"5011ff69-1897-47de-a67c-47df8b5d8734","ts":"2023-11-01T04:06:24.664-04:00","eventName":"n8n.workflow.success","message":"n8n.workflow.success","payload":{"executionId":"1593>
{"__type":"$$EventMessageConfirm","confirm":"5011ff69-1897-47de-a67c-47df8b5d8734","ts":"2023-11-01T04:06:24.667-04:00","source":{"id":"0","name":"eventBus"}}
{"__type":"$$EventMessageWorkflow","id":"ffffd2df-4037-45d4-8337-6b2107f30167","ts":"2023-11-01T04:06:30.758-04:00","eventName":"n8n.workflow.started","message":"n8n.workflow.started","payload":{"executionId":"1593>
{"__type":"$$EventMessageConfirm","confirm":"ffffd2df-4037-45d4-8337-6b2107f30167","ts":"2023-11-01T04:06:30.760-04:00","source":{"id":"0","name":"eventBus"}}
{"__type":"$$EventMessageNode","id":"fa48e47d-c9e7-4530-bb28-53248d2c0961","ts":"2023-11-01T04:06:30.760-04:00","eventName":"n8n.node.started","message":"n8n.node.started","payload":{"executionId":"15933","nodeName>
{"__type":"$$EventMessageConfirm","confirm":"fa48e47d-c9e7-4530-bb28-53248d2c0961","ts":"2023-11-01T04:06:30.760-04:00","source":{"id":"0","name":"eventBus"}}
{"__type":"$$EventMessageNode","id":"09d752f6-292b-43c1-a9bb-c56fc9ce183d","ts":"2023-11-01T04:06:30.760-04:00","eventName":"n8n.node.finished","message":"n8n.node.finished","payload":{"executionId":"15933","nodeNa>
{"__type":"$$EventMessageConfirm","confirm":"09d752f6-292b-43c1-a9bb-c56fc9ce183d","ts":"2023-11-01T04:06:30.760-04:00","source":{"id":"0","name":"eventBus"}}
{"__type":"$$EventMessageNode","id":"ce01ab97-5802-48d4-9703-162fb964a5ca","ts":"2023-11-01T04:06:30.760-04:00","eventName":"n8n.node.started","message":"n8n.node.started","payload":{"executionId":"15933","nodeName>
{"__type":"$$EventMessageConfirm","confirm":"ce01ab97-5802-48d4-9703-162fb964a5ca","ts":"2023-11-01T04:06:30.760-04:00","source":{"id":"0","name":"eventBus"}}
{"__type":"$$EventMessageNode","id":"585d9152-0d55-4f0b-80bd-f42544684cbc","ts":"2023-11-01T04:06:30.970-04:00","eventName":"n8n.node.finished","message":"n8n.node.finished","payload":{"executionId":"15933","nodeNa>
{"__type":"$$EventMessageConfirm","confirm":"585d9152-0d55-4f0b-80bd-f42544684cbc","ts":"2023-11-01T04:06:30.973-04:00","source":{"id":"0","name":"eventBus"}}
{"__type":"$$EventMessageNode","id":"ad8595da-728e-4067-b60a-efb125aa9329","ts":"2023-11-01T04:06:30.973-04:00","eventName":"n8n.node.started","message":"n8n.node.started","payload":{"executionId":"15933","nodeName>
{"__type":"$$EventMessageConfirm","confirm":"ad8595da-728e-4067-b60a-efb125aa9329","ts":"2023-11-01T04:06:30.973-04:00","source":{"id":"0","name":"eventBus"}}

If I knew where or what the config file of the worker is, I could probably find it !
Does the above help?

Jon · November 1, 2023, 8:26am

We still need that worker config, The event log is probably less useful than the docker logs for the container.

Joachim_Brindeau · November 1, 2023, 9:48am

I sent you the result of docker inspect via DM, but my colleague just said the worker is simply run using

docker run --name n8n-queue -p 5679:5678 docker.n8n.io/n8nio/n8n worker

Thank you again for your help in troubleshooting this

Jon · November 1, 2023, 10:12am

Hey @Joachim_Brindeau,

If the worker is being launched with that command it isn’t working correctly as it would need to point to the n8n database and redis. I would recommend checking the documentation to make sure everything is set up correctly.