Hi @MutedJam, I have created a test n8n project to show where the issue is. This is exactly what is happening in my main instance.
Please see this 5 min video where I explain how to reproduce the issue: wooden-lunchroom _ Railway - 17 October 2023 (the link expires in 48 hours, let me know if you need me to re-upload it).
Main deployment log:
2023-10-17T17:23:47.261Z | debug | License init complete "{ file: 'start.js', function: 'init' }"
2023-10-17T17:23:47.265Z | debug | Binary data service init complete "{ file: 'start.js', function: 'init' }"
2023-10-17T17:23:47.266Z | debug | External hooks init complete "{ file: 'start.js', function: 'init' }"
2023-10-17T17:23:47.269Z | debug | External secrets init complete "{ file: 'start.js', function: 'init' }"
2023-10-17T17:23:48.150Z | debug | Wait tracker querying database for waiting executions "{ file: 'WaitTracker.js', function: 'getWaitingExecutions' }"
2023-10-17T17:23:49.290Z | debug | Initialising Redis client of type client(bull) connection with host: containers-us-west-72.railway.app and port: 6821 "{ file: 'RedisServiceHelper.js', function: 'getRedisStandardClient' }"
2023-10-17T17:23:49.292Z | debug | Initialising Redis client of type subscriber(bull) connection with host: containers-us-west-72.railway.app and port: 6821 "{ file: 'RedisServiceHelper.js', function: 'getRedisStandardClient' }"
2023-10-17T17:23:49.512Z | debug | No key pair files found, generating new pair using type: ed25519 "{\n file: 'sourceControlPreferences.service.ee.js',\n function: 'setPreferences'\n}"
2023-10-17T17:23:49.592Z | debug | Initializing event bus... "{ file: 'MessageEventBus.js', function: 'initialize' }"
2023-10-17T17:23:49.596Z | debug | Initializing event writer "{ file: 'MessageEventBus.js', function: 'initialize' }"
2023-10-17T17:23:49.603Z | debug | Checking for unsent event messages "{ file: 'MessageEventBus.js', function: 'initialize' }"
2023-10-17T17:23:49.604Z | debug | Start logging into /home/node/.n8n/n8nEventLog.log "{ file: 'MessageEventBus.js', function: 'initialize' }"
2023-10-17T17:23:49.604Z | debug | MessageEventBus initialized "{ file: 'MessageEventBus.js', function: 'initialize' }"
Version: 1.9.3
2023-10-17T17:23:49.606Z | debug | Server ID: main-3368V2xdiky5Ed8s "{ file: 'Server.js', function: 'start' }"
2023-10-17T17:23:49.644Z [Rudder] debug: in flush
2023-10-17T17:23:49.644Z [Rudder] debug: batch size is 1
2023-10-17T17:23:49.648Z [Rudder] debug: no existing flush timer, creating new one
2023-10-17T17:23:49.847Z | info | ================================ "{ file: 'ActiveWorkflowRunner.js', function: 'init' }"
2023-10-17T17:23:49.847Z | info | Start Active Workflows: "{ file: 'ActiveWorkflowRunner.js', function: 'init' }"
2023-10-17T17:23:49.847Z | info | ================================ "{ file: 'ActiveWorkflowRunner.js', function: 'init' }"
2023-10-17T17:23:49.847Z | info | - Webhook 1 (ID: H7ZjPCOW5KG6AbHY) "{ file: 'ActiveWorkflowRunner.js', function: 'init' }"
2023-10-17T17:23:49.848Z | debug | Initializing active workflow "Webhook 1" (startup) "{\n workflowName: 'Webhook 1',\n workflowId: 'H7ZjPCOW5KG6AbHY',\n file: 'ActiveWorkflowRunner.js',\n function: 'init'\n}"
2023-10-17T17:23:49.954Z | verbose | Successfully started workflow "Webhook 1" "{\n workflowName: 'Webhook 1',\n workflowId: 'H7ZjPCOW5KG6AbHY',\n file: 'ActiveWorkflowRunner.js',\n function: 'init'\n}"
2023-10-17T17:23:49.954Z | info | => Started "{ file: 'ActiveWorkflowRunner.js', function: 'init' }"
2023-10-17T17:23:49.954Z | info | - Cron 1 (ID: ENbhnkacIHcy42Qs) "{ file: 'ActiveWorkflowRunner.js', function: 'init' }"
2023-10-17T17:23:49.954Z | debug | Initializing active workflow "Cron 1" (startup) "{\n workflowName: 'Cron 1',\n workflowId: 'ENbhnkacIHcy42Qs',\n file: 'ActiveWorkflowRunner.js',\n function: 'init'\n}"
2023-10-17T17:23:49.963Z | verbose | Successfully activated workflow "Cron 1" "{\n workflowId: 'ENbhnkacIHcy42Qs',\n workflowName: 'Cron 1',\n file: 'ActiveWorkflowRunner.js',\n function: 'add'\n}"
2023-10-17T17:23:49.967Z | verbose | Successfully started workflow "Cron 1" "{\n workflowName: 'Cron 1',\n workflowId: 'ENbhnkacIHcy42Qs',\n file: 'ActiveWorkflowRunner.js',\n function: 'init'\n}"
2023-10-17T17:23:49.967Z | info | => Started "{ file: 'ActiveWorkflowRunner.js', function: 'init' }"
2023-10-17T17:23:49.967Z | verbose | Finished initializing active workflows (startup) "{ file: 'ActiveWorkflowRunner.js', function: 'init' }"
Editor is now accessible via:
http://localhost:5678/
2023-10-17T17:24:09.648Z [Rudder] debug: in flush
2023-10-17T17:24:09.649Z [Rudder] debug: cancelling existing timer...
2023-10-17T17:24:09.649Z [Rudder] debug: cancelling existing flushTimer...
2023-10-17T17:24:09.649Z [Rudder] debug: batch size is 1
2023-10-17T17:24:29.838Z [Rudder] debug: in flush
2023-10-17T17:24:29.839Z [Rudder] debug: cancelling existing timer...
2023-10-17T17:24:29.839Z [Rudder] debug: queue is empty, nothing to flush
2023-10-17T17:24:48.150Z | debug | Wait tracker querying database for waiting executions "{ file: 'WaitTracker.js', function: 'getWaitingExecutions' }"
2023-10-17T17:24:49.975Z | debug | Received trigger for workflow "Cron 1" "{ file: 'ActiveWorkflowRunner.js', function: 'returnFunctions.emit' }"
Log after re-deployment triggering webhook from postman when it wasn’t working and then deactivated, and reactivated, and then worked:
2023-10-17T17:48:10.481Z [Rudder] debug: in flush
2023-10-17T17:48:10.481Z [Rudder] debug: cancelling existing flushTimer...
2023-10-17T17:48:10.481Z [Rudder] debug: batch size is 2
2023-10-17T17:48:10.661Z | debug | Received trigger for workflow "Cron 1" "{ file: 'ActiveWorkflowRunner.js', function: 'returnFunctions.emit' }"
Started with job ID: 30 (Execution ID: 30)
2023-10-17T17:48:15.734Z | debug | Skipping execution data for execution 30 since there are no PostExecutionPromise. "{ file: 'WorkflowRunner.js' }"
2023-10-17T17:48:24.162Z | debug | Received webhook "POST" for path "c113e417-fe01-432e-afd4-d1081d02d263" "{ file: 'ActiveWorkflowRunner.js', function: 'executeWebhook' }"
2023-10-17T17:48:30.853Z [Rudder] debug: in flush
2023-10-17T17:48:30.853Z [Rudder] debug: cancelling existing timer...
2023-10-17T17:48:30.853Z [Rudder] debug: queue is empty, nothing to flush
2023-10-17T17:48:50.638Z | debug | Received webhook "POST" for path "c113e417-fe01-432e-afd4-d1081d02d263" "{ file: 'ActiveWorkflowRunner.js', function: 'executeWebhook' }"
2023-10-17T17:48:51.519Z | debug | Received webhook "POST" for path "c113e417-fe01-432e-afd4-d1081d02d263" "{ file: 'ActiveWorkflowRunner.js', function: 'executeWebhook' }"
2023-10-17T17:48:52.335Z | debug | Received webhook "POST" for path "c113e417-fe01-432e-afd4-d1081d02d263" "{ file: 'ActiveWorkflowRunner.js', function: 'executeWebhook' }"
2023-10-17T17:49:03.888Z | debug | Received webhook "POST" for path "c113e417-fe01-432e-afd4-d1081d02d263" "{ file: 'ActiveWorkflowRunner.js', function: 'executeWebhook' }"
2023-10-17T17:49:08.342Z | debug | Wait tracker querying database for waiting executions "{ file: 'WaitTracker.js', function: 'getWaitingExecutions' }"
2023-10-17T17:49:09.081Z | debug | Received webhook "POST" for path "c113e417-fe01-432e-afd4-d1081d02d263" "{ file: 'ActiveWorkflowRunner.js', function: 'executeWebhook' }"
2023-10-17T17:49:10.653Z | debug | Received trigger for workflow "Cron 1" "{ file: 'ActiveWorkflowRunner.js', function: 'returnFunctions.emit' }"
Started with job ID: 31 (Execution ID: 31)
2023-10-17T17:49:15.693Z | debug | Skipping execution data for execution 31 since there are no PostExecutionPromise. "{ file: 'WorkflowRunner.js' }"
2023-10-17T17:49:31.979Z | verbose | Updating versionId for workflow H7ZjPCOW5KG6AbHY for user a6359be7-ef2b-4df0-95dc-0d5d1a43f20d after saving "{\n previousVersionId: '9f441ba9-c1ca-49d8-b824-01517010e3e1',\n newVersionId: '0a190b24-f499-4bf4-83f5-54a68ca98e9f',\n file: 'workflows.services.js',\n function: 'update'\n}"
2023-10-17T17:49:32.020Z [Rudder] debug: no existing flush timer, creating new one
2023-10-17T17:49:36.319Z | verbose | Updating versionId for workflow H7ZjPCOW5KG6AbHY for user a6359be7-ef2b-4df0-95dc-0d5d1a43f20d after saving "{\n previousVersionId: '0a190b24-f499-4bf4-83f5-54a68ca98e9f',\n newVersionId: '7558623a-cdff-4120-aaf3-ecdd6c18a8d5',\n file: 'workflows.services.js',\n function: 'update'\n}"
2023-10-17T17:49:41.799Z | debug | Received webhook "POST" for path "c113e417-fe01-432e-afd4-d1081d02d263" "{ file: 'ActiveWorkflowRunner.js', function: 'executeWebhook' }"
Started with job ID: 32 (Execution ID: 32)
2023-10-17T17:49:41.863Z | verbose | Started execution of workflow "Webhook 1" from webhook with execution ID 32 "{\n executionId: '32',\n file: 'WebhookHelpers.js',\n function: 'executeWebhook'\n}"
2023-10-17T17:49:46.886Z | debug | Skipping execution data for execution 32 since there are no PostExecutionPromise. "{ file: 'WorkflowRunner.js' }"
2023-10-17T17:49:52.020Z [Rudder] debug: batch size is 2
Dockerfile:
FROM n8nio/n8n:latest
ARG PGPASSWORD
ARG PGHOST
ARG PGPORT
ARG PGDATABASE
ARG PGUSER
ARG ENCRYPTION_KEY
ENV DB_TYPE=postgresdb
ENV DB_POSTGRESDB_DATABASE=$PGDATABASE
ENV DB_POSTGRESDB_HOST=$PGHOST
ENV DB_POSTGRESDB_PORT=$PGPORT
ENV DB_POSTGRESDB_USER=$PGUSER
ENV DB_POSTGRESDB_PASSWORD=$PGPASSWORD
ENV N8N_ENCRYPTION_KEY=$ENCRYPTION_KEY
CMD ["n8n" "start"]
Hope it helps,
Thanks.