Mssql Node intermittent timeout - ERROR: Failed to connect to in 15000ms

Describe the problem/error/question

I can normally connect and have success on queries on MSSQL but very frequently ( I mean if I run more than once a node or even on the first run) , i have intermittent error with timeout on the query mssql node. There is nothing that can help on the console output from n8n or even on MSSQL logs. All the other applications that connect on the server works fine. I

What is the error message (if any)?

ERROR: Failed to connect to in 15000ms



ConnectionError: Failed to connect to in 15000ms
    at connectListener (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/node_modules/mssql/lib/tedious/connection-pool.js:78:17)
    at Connection.onConnect (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/node_modules/tedious/src/connection.ts:1763:9)
    at Object.onceWrapper (node:events:632:26)
    at Connection.emit (node:events:517:28)
    at Connection.emit (node:domain:489:12)
    at Connection.emit (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/node_modules/tedious/src/connection.ts:1906:18)
    at Connection.connectTimeout (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/node_modules/tedious/src/connection.ts:2092:10)
    at Timeout._onTimeout (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/node_modules/tedious/src/connection.ts:2044:12)
    at listOnTimeout (node:internal/timers:569:17)
    at processTimers (node:internal/timers:512:7)


Execute node



Credential to connect with




=SELECT * FROM TitulosAtraso WHERE codcli = {{ $json[“codcli”] }} ORDER BY vctori ASC

(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)

Share the output returned by the last node

Information on your n8n setup

  • n8n version: Version 1.15.2

  • Database (default: SQLite): PostgreSQL

  • n8n EXECUTIONS_PROCESS setting (default: own, main): default

  • Running n8n via (Docker, npm, n8n cloud, desktop app): Docker

  • Operating system: MAC OSX Sonoma

Here, the output from docker console

Hey @Rodrigo_Carvalhaes,

It might be worth adding a retry under the node settings, The error itself looks like a standard timeout issue so there are not really a lot of things that can be done outside of just trying again.

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