Where can I read about this problem? I want to figure out how to fix
What is the error message (if any)?
Failed execution
There was a problem executing the
workflow:
“job stalled more than
max Stalled Count”
Please share the workflow
{
"meta": {
"instanceId": "c9ac854275bfa2e08489d3d201c3050a1e6dea7b42b40663bd83f030a9efa2a3"
},
"nodes": [
{
"parameters": {
"operation": "executeQuery",
"query": "=SELECT *\nFROM \"users\" INNER JOIN channels ON channels.\"chatId\" = \"users\".\"chatId\"\nWHERE \"users\".\"status\" = '1' AND \"users\".\"chatId\" = '{{$node[\"Set\"].json[\"channelId\"]}}'",
"additionalFields": {}
},
"name": "select users",
"type": "n8n-nodes-base.postgres",
"typeVersion": 1,
"position": [
1040,
300
],
"notesInFlow": true,
"id": "f9a15307-69ec-4dd0-82ef-c6d8e3785133",
"alwaysOutputData": false,
"retryOnFail": true,
"credentials": {
"postgres": {
"id": "50",
"name": "tracker"
}
}
},
{
"parameters": {
"triggerTimes": {
"item": [
{
"mode": "everyWeek",
"hour": 6,
"weekday": "5"
}
]
}
},
"id": "0704732d-3d04-4a2f-81a5-60e20de19670",
"name": "Cron",
"type": "n8n-nodes-base.cron",
"typeVersion": 1,
"position": [
600,
300
]
},
{
"parameters": {
"requestMethod": "POST",
"url": "=https://api.telegram.org/bot{{$items(\"Set\")[0].json[\"token\"]}}/sendMessage",
"options": {
"batchInterval": 100,
"batchSize": 1,
"useQueryString": true
},
"bodyParametersUi": {
"parameter": [
{
"name": "chat_id",
"value": "={{$node[\"select users\"].json[\"userId\"]}}"
},
{
"name": "text",
"value": "=-----?"
},
{
"name": "reply_markup",
"value": "={\"inline_keyboard\":[[{\"text\":\"✅ \",\"callback_data\":\"r2{{$node[\"select users\"].json[\"chatId\"]}}\"}],[{\"text\":\"⏸\",\"callback_data\":\"r1{{$node[\"select users\"].json[\"chatId\"]}}\"}],[{\"text\":\"---",\"callback_data\":\"r0{{$node[\"select users\"].json[\"chatId\"]}}\"}]]}"
},
{
"name": "parse_mode",
"value": "Markdown"
},
{
"name": "disable_web_page_preview",
"value": "True"
}
]
}
},
"name": "HTTP Request1",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 1,
"position": [
1240,
300
],
"retryOnFail": false,
"waitBetweenTries": 5000,
"maxTries": 5,
"id": "3583d50d-d480-4098-930c-4a627bdfce23",
"continueOnFail": true
},
{
"parameters": {
"values": {
"string": [
{
"name": "token",
"value": "----"
},
{
"name": "supportLink",
"value": "https://t.me/sudnik"
},
{
"name": "welcomeMessage",
"value": "=---"
},
{
"name": "welcomeMessageUsernameNotExist",
"value": "=---"
},
{
"name": "welcomeMessageUsernameAdded",
"value": "=---."
}
],
"number": [
{
"name": "adminId",
"value": -1001229874701
},
{
"name": "channelId",
"value": -1001700527084
},
{
"name": "moderationPeriod",
"value": 25
},
{
"name": "logChatId",
"value": 1096005889
}
]
},
"options": {}
},
"id": "e6bc43a7-18ee-4a0e-86a4-290899f63b26",
"name": "Set",
"type": "n8n-nodes-base.set",
"typeVersion": 1,
"position": [
820,
300
]
}
],
"connections": {
"select users": {
"main": [
[
{
"node": "HTTP Request1",
"type": "main",
"index": 0
}
]
]
},
"Cron": {
"main": [
[
{
"node": "Set",
"type": "main",
"index": 0
}
]
]
},
"Set": {
"main": [
[
{
"node": "select users",
"type": "main",
"index": 0
}
]
]
}
}
}
Information on your n8n setup
- 190
- postgreSQL
- main, workerA, workerB
- web app