Failure - ECONNRESET when running long SQL using Tedious Driver on Node.js 12.6+

[palczewski]

Node-mssql/Tedious will generate the following error when running a long SQL string on Node.js 12.6+
RequestError: Connection lost - write ECONNRESET

Expected behaviour:

Should execute successfully

Actual behaviour:

RequestError: Connection lost - write ECONNRESET

Recommended resolution

Please see:
tediousjs/tedious#923

Tedious needs to be upgraded to a newer version

Software versions

• NodeJS: 12.13.0
• node-mssql: 4.3.7
• SQL Server: 14

[willmorgan]

You could try upgrading to 6.0.0 which uses a much newer version.

[frco9]

@willmorgan, v6.0.0 is still in beta is it safe to use ?

[jtsmedley]

Ditto this issue with MSSQL v5.1.0

[willmorgan]

@frco9

v6.0.0 is still in beta is it safe to use ?

Your issue states that upgrading Tedious is necessary; 6.0.0 has that newer version, so maybe try and see if that works?

The beta is not inherently unstable but might have some extra functionality added or further bugs fixed.

[baiganhong]

Recently I ran into same error with Node 12.13 on MSSQL module 5.1 when I run a long update statement with parameterizing more than 53 fields, but when I reduced to 52 fields, it succeeds. In addition, now my workaround is using non-parameterized update statement string. That is OK.
BTW, there is no problem with Node 10.16.

[dhensby]

There is no specific node 12 support at this time and the tedious version required is not supported in v5, you must use v6.

[Schroet]

So guys, any ideas what to do ?

[dhensby]

Use v6 of the lib