WEBHOOK_URL doesn't appear to be working after upgrade

Questions
1

Describe the issue/error/question

After upgrading to the latest version from 0.175 (i think). The WEBHOOK_URL doesn’t appear to work anymore. I am running n8n with the pm2 service on Ubuntu. I noticed if I run n8n start via the command line then the webhook shows my subdomain.domain.tld but if I run pm2 start n8n it has localhost:5678 for the domain.

Note that webhooks still work to the domain.tld if they were created prior to this issue. Webhooks newly created do not seem to register with domain.tld

WEBHOOK_URL and N8N_EDITOR_BASE_URL are set like

WEBHOOK_URL="https://sub.domain.com"
N8N_EDITOR_BASE_URL="https://sub.domain.com"

What is the error message (if any)?

Webhooks show localhost:5678

Here is a log file while running n8n start from the command line:

Log File 
$ n8n start
Initializing n8n process
n8n ready on 0.0.0.0, port 5678
Version: 0.199.0
 ================================
   Start Active Workflows:
 ================================
   - Cartonization (ID: 5)
     => Started
   - Customer Item Report (ID: 6)
     => Started
   - Back Up Your n8n Workflows To Github (ID: 10)
     => Started
   - Fundraiser - Cartonization (ID: 11)
     => Started

Editor is now accessible via:
http://localhost:5678/

Press "o" to open in Browser.
ERROR RESPONSE
ResponseError: The requested webhook "POST xxxxx-25ed-4d9a-ab84-768d2d0e3cf6" is not registered.
    at TestWebhooks.callTestWebhook (/home/ubuntu/.nvm/versions/node/v16.15.0/lib/node_modules/n8n/dist/src/TestWebhooks.js:25:23)
    at /home/ubuntu/.nvm/versions/node/v16.15.0/lib/node_modules/n8n/dist/src/Server.js:966:52
    at Layer.handle [as handle_request] (/home/ubuntu/.nvm/versions/node/v16.15.0/lib/node_modules/n8n/node_modules/express/lib/router/layer.js:95:5)
    at next (/home/ubuntu/.nvm/versions/node/v16.15.0/lib/node_modules/n8n/node_modules/express/lib/router/route.js:144:13)
    at next (/home/ubuntu/.nvm/versions/node/v16.15.0/lib/node_modules/n8n/node_modules/express/lib/router/route.js:140:7)
    at next (/home/ubuntu/.nvm/versions/node/v16.15.0/lib/node_modules/n8n/node_modules/express/lib/router/route.js:140:7)
    at next (/home/ubuntu/.nvm/versions/node/v16.15.0/lib/node_modules/n8n/node_modules/express/lib/router/route.js:140:7)
    at next (/home/ubuntu/.nvm/versions/node/v16.15.0/lib/node_modules/n8n/node_modules/express/lib/router/route.js:140:7)
    at next (/home/ubuntu/.nvm/versions/node/v16.15.0/lib/node_modules/n8n/node_modules/express/lib/router/route.js:140:7)
    at next (/home/ubuntu/.nvm/versions/node/v16.15.0/lib/node_modules/n8n/node_modules/express/lib/router/route.js:140:7)
    at next (/home/ubuntu/.nvm/versions/node/v16.15.0/lib/node_modules/n8n/node_modules/express/lib/router/route.js:140:7)
    at next (/home/ubuntu/.nvm/versions/node/v16.15.0/lib/node_modules/n8n/node_modules/express/lib/router/route.js:140:7)
    at next (/home/ubuntu/.nvm/versions/node/v16.15.0/lib/node_modules/n8n/node_modules/express/lib/router/route.js:140:7)
    at next (/home/ubuntu/.nvm/versions/node/v16.15.0/lib/node_modules/n8n/node_modules/express/lib/router/route.js:140:7)
    at next (/home/ubuntu/.nvm/versions/node/v16.15.0/lib/node_modules/n8n/node_modules/express/lib/router/route.js:140:7)
    at next (/home/ubuntu/.nvm/versions/node/v16.15.0/lib/node_modules/n8n/node_modules/express/lib/router/route.js:140:7)
    at next (/home/ubuntu/.nvm/versions/node/v16.15.0/lib/node_modules/n8n/node_modules/express/lib/router/route.js:140:7)
    at next (/home/ubuntu/.nvm/versions/node/v16.15.0/lib/node_modules/n8n/node_modules/express/lib/router/route.js:140:7)
    at next (/home/ubuntu/.nvm/versions/node/v16.15.0/lib/node_modules/n8n/node_modules/express/lib/router/route.js:140:7)
    at next (/home/ubuntu/.nvm/versions/node/v16.15.0/lib/node_modules/n8n/node_modules/express/lib/router/route.js:140:7)
    at next (/home/ubuntu/.nvm/versions/node/v16.15.0/lib/node_modules/n8n/node_modules/express/lib/router/route.js:140:7)
    at next (/home/ubuntu/.nvm/versions/node/v16.15.0/lib/node_modules/n8n/node_modules/express/lib/router/route.js:140:7) {
  errorCode: 404,
  httpStatusCode: 404,
  hint: "Click the 'Execute workflow' button on the canvas, then try again. (In test mode, the webhook only works for one call after you click this button)"
}
ERROR RESPONSE
ResponseError: The requested webhook "POST xxxxx-25ed-4d9a-ab84-768d2d0e3cf6" is not registered.
    at TestWebhooks.callTestWebhook (/home/ubuntu/.nvm/versions/node/v16.15.0/lib/node_modules/n8n/dist/src/TestWebhooks.js:25:23)
    at /home/ubuntu/.nvm/versions/node/v16.15.0/lib/node_modules/n8n/dist/src/Server.js:966:52
    at Layer.handle [as handle_request] (/home/ubuntu/.nvm/versions/node/v16.15.0/lib/node_modules/n8n/node_modules/express/lib/router/layer.js:95:5)
    at next (/home/ubuntu/.nvm/versions/node/v16.15.0/lib/node_modules/n8n/node_modules/express/lib/router/route.js:144:13)
    at next (/home/ubuntu/.nvm/versions/node/v16.15.0/lib/node_modules/n8n/node_modules/express/lib/router/route.js:140:7)
    at next (/home/ubuntu/.nvm/versions/node/v16.15.0/lib/node_modules/n8n/node_modules/express/lib/router/route.js:140:7)
    at next (/home/ubuntu/.nvm/versions/node/v16.15.0/lib/node_modules/n8n/node_modules/express/lib/router/route.js:140:7)
    at next (/home/ubuntu/.nvm/versions/node/v16.15.0/lib/node_modules/n8n/node_modules/express/lib/router/route.js:140:7)
    at next (/home/ubuntu/.nvm/versions/node/v16.15.0/lib/node_modules/n8n/node_modules/express/lib/router/route.js:140:7)
    at next (/home/ubuntu/.nvm/versions/node/v16.15.0/lib/node_modules/n8n/node_modules/express/lib/router/route.js:140:7)
    at next (/home/ubuntu/.nvm/versions/node/v16.15.0/lib/node_modules/n8n/node_modules/express/lib/router/route.js:140:7)
    at next (/home/ubuntu/.nvm/versions/node/v16.15.0/lib/node_modules/n8n/node_modules/express/lib/router/route.js:140:7)
    at next (/home/ubuntu/.nvm/versions/node/v16.15.0/lib/node_modules/n8n/node_modules/express/lib/router/route.js:140:7)
    at next (/home/ubuntu/.nvm/versions/node/v16.15.0/lib/node_modules/n8n/node_modules/express/lib/router/route.js:140:7)
    at next (/home/ubuntu/.nvm/versions/node/v16.15.0/lib/node_modules/n8n/node_modules/express/lib/router/route.js:140:7)
    at next (/home/ubuntu/.nvm/versions/node/v16.15.0/lib/node_modules/n8n/node_modules/express/lib/router/route.js:140:7)
    at next (/home/ubuntu/.nvm/versions/node/v16.15.0/lib/node_modules/n8n/node_modules/express/lib/router/route.js:140:7)
    at next (/home/ubuntu/.nvm/versions/node/v16.15.0/lib/node_modules/n8n/node_modules/express/lib/router/route.js:140:7)
    at next (/home/ubuntu/.nvm/versions/node/v16.15.0/lib/node_modules/n8n/node_modules/express/lib/router/route.js:140:7)
    at next (/home/ubuntu/.nvm/versions/node/v16.15.0/lib/node_modules/n8n/node_modules/express/lib/router/route.js:140:7)
    at next (/home/ubuntu/.nvm/versions/node/v16.15.0/lib/node_modules/n8n/node_modules/express/lib/router/route.js:140:7)
    at next (/home/ubuntu/.nvm/versions/node/v16.15.0/lib/node_modules/n8n/node_modules/express/lib/router/route.js:140:7) {
  errorCode: 404,
  httpStatusCode: 404,
  hint: "Click the 'Execute workflow' button on the canvas, then try again. (In test mode, the webhook only works for one call after you click this button)"
}
query is slow: SELECT DISTINCT "distinctAlias"."User_id" as "ids_User_id" FROM (SELECT "User"."id" AS "User_id", "User"."email" AS "User_email", "User"."firstName" AS "User_firstName", "User"."lastName" AS "User_lastName", "User"."password" AS "User_password", "User"."resetPasswordToken" AS "User_resetPasswordToken", "User"."resetPasswordTokenExpiration" AS "User_resetPasswordTokenExpiration", "User"."personalizationAnswers" AS "User_personalizationAnswers", "User"."settings" AS "User_settings", "User"."createdAt" AS "User_createdAt", "User"."updatedAt" AS "User_updatedAt", "User"."apiKey" AS "User_apiKey", "User"."globalRoleId" AS "User_globalRoleId", "User__globalRole"."id" AS "User__globalRole_id", "User__globalRole"."name" AS "User__globalRole_name", "User__globalRole"."scope" AS "User__globalRole_scope", "User__globalRole"."createdAt" AS "User__globalRole_createdAt", "User__globalRole"."updatedAt" AS "User__globalRole_updatedAt" FROM "user" "User" LEFT JOIN "role" "User__globalRole" ON "User__globalRole"."id"="User"."globalRoleId") "distinctAlias" ORDER BY "User_id" ASC LIMIT 1
execution time: 1003
/home/ubuntu/.nvm/versions/node/v16.15.0/lib/node_modules/n8n/node_modules/typeorm/error/TypeORMError.js:9
        var _this = _super.call(this, message) || this;
                           ^

QueryFailedError: SQLITE_BUSY: database is locked
    at QueryFailedError.TypeORMError [as constructor] (/home/ubuntu/.nvm/versions/node/v16.15.0/lib/node_modules/n8n/node_modules/typeorm/error/TypeORMError.js:9:28)
    at new QueryFailedError (/home/ubuntu/.nvm/versions/node/v16.15.0/lib/node_modules/n8n/node_modules/typeorm/error/QueryFailedError.js:13:28)
    at Statement.handler (/home/ubuntu/.nvm/versions/node/v16.15.0/lib/node_modules/n8n/node_modules/typeorm/driver/sqlite/SqliteQueryRunner.js:117:38)
    at Statement.replacement (/home/ubuntu/.nvm/versions/node/v16.15.0/lib/node_modules/n8n/node_modules/sqlite3/lib/trace.js:25:27)
    at Statement.replacement (/home/ubuntu/.nvm/versions/node/v16.15.0/lib/node_modules/n8n/node_modules/sqlite3/lib/trace.js:25:27) {
  query: 'SELECT DISTINCT "distinctAlias"."User_id" as "ids_User_id" FROM (SELECT "User"."id" AS "User_id", "User"."email" AS "User_email", "User"."firstName" AS "User_firstName", "User"."lastName" AS "User_lastName", "User"."password" AS "User_password", "User"."resetPasswordToken" AS "User_resetPasswordToken", "User"."resetPasswordTokenExpiration" AS "User_resetPasswordTokenExpiration", "User"."personalizationAnswers" AS "User_personalizationAnswers", "User"."settings" AS "User_settings", "User"."createdAt" AS "User_createdAt", "User"."updatedAt" AS "User_updatedAt", "User"."apiKey" AS "User_apiKey", "User"."globalRoleId" AS "User_globalRoleId", "User__globalRole"."id" AS "User__globalRole_id", "User__globalRole"."name" AS "User__globalRole_name", "User__globalRole"."scope" AS "User__globalRole_scope", "User__globalRole"."createdAt" AS "User__globalRole_createdAt", "User__globalRole"."updatedAt" AS "User__globalRole_updatedAt" FROM "user" "User" LEFT JOIN "role" "User__globalRole" ON "User__globalRole"."id"="User"."globalRoleId") "distinctAlias" ORDER BY "User_id" ASC LIMIT 1',
  parameters: [],
  driverError: Error: SQLITE_BUSY: database is locked
  --> in Statement#all([], [Function: replacement])
      at Database.<anonymous> (/home/ubuntu/.nvm/versions/node/v16.15.0/lib/node_modules/n8n/node_modules/sqlite3/lib/sqlite3.js:88:19)
      at Database.<anonymous> (/home/ubuntu/.nvm/versions/node/v16.15.0/lib/node_modules/n8n/node_modules/sqlite3/lib/sqlite3.js:20:19)
      at SqliteQueryRunner.<anonymous> (/home/ubuntu/.nvm/versions/node/v16.15.0/lib/node_modules/n8n/node_modules/typeorm/driver/sqlite/SqliteQueryRunner.js:95:85)
      at step (/home/ubuntu/.nvm/versions/node/v16.15.0/lib/node_modules/n8n/node_modules/typeorm/node_modules/tslib/tslib.js:144:27)
      at Object.next (/home/ubuntu/.nvm/versions/node/v16.15.0/lib/node_modules/n8n/node_modules/typeorm/node_modules/tslib/tslib.js:125:57)
      at /home/ubuntu/.nvm/versions/node/v16.15.0/lib/node_modules/n8n/node_modules/typeorm/node_modules/tslib/tslib.js:118:75
      at new Promise (<anonymous>)
      at __awaiter (/home/ubuntu/.nvm/versions/node/v16.15.0/lib/node_modules/n8n/node_modules/typeorm/node_modules/tslib/tslib.js:114:16)
      at execute (/home/ubuntu/.nvm/versions/node/v16.15.0/lib/node_modules/n8n/node_modules/typeorm/driver/sqlite/SqliteQueryRunner.js:86:78)
      at SqliteQueryRunner.<anonymous> (/home/ubuntu/.nvm/versions/node/v16.15.0/lib/node_modules/n8n/node_modules/typeorm/driver/sqlite/SqliteQueryRunner.js:139:46)
      at step (/home/ubuntu/.nvm/versions/node/v16.15.0/lib/node_modules/n8n/node_modules/typeorm/node_modules/tslib/tslib.js:144:27)
      at Object.next (/home/ubuntu/.nvm/versions/node/v16.15.0/lib/node_modules/n8n/node_modules/typeorm/node_modules/tslib/tslib.js:125:57)
      at fulfilled (/home/ubuntu/.nvm/versions/node/v16.15.0/lib/node_modules/n8n/node_modules/typeorm/node_modules/tslib/tslib.js:115:62) {
    errno: 5,
    code: 'SQLITE_BUSY',
    __augmented: true
  },
  errno: 5,
  code: 'SQLITE_BUSY',
  __augmented: true
}

Information on your n8n setup

  • n8n version: 0.199.0
  • Database: SQLite
  • Running: main
  • Running: npm (with pm2)
  • OS: Ubuntu 22.04 LTS
  • Node: 16.15.0 (via NVM)
  • NPM: 8.19.2
2

Hey @cgsmith,

It looks the issue is with PM2 not picking up the environment variables. Can you confirm how you have set the env options in PM2 and can you also check that PM2 has picked up the options?

3 Likes
3

PM2 was definitely the issue with the env vars.

Running pm2 restart n8n --update-env corrected this issue.

2 Likes
4

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