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

[Rodrigo_Carvalhaes]

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 10.31.10.11:1433 in 15000ms

Details

Stack

ConnectionError: Failed to connect to 10.31.10.11:1433 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)

titulos

Execute node

Parameters

Docs

Credential to connect with

Operation

Query

1

=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

[Jon]

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.