search

bestlong / node-red-contrib-mssql-plus

A Node-RED node to read and write to Microsoft MS SQL Databases
MIT License
31 stars 18 forks source link

Crash on Amazon Ubuntu #70

Open softy2k opened 1 year ago

softy2k commented 1 year ago

Amazon Ubuntu 20.04.5 LTS with all updates NodeRed 3.0.2 NodeJs 16 (multiple versions tested, including 16.19.1) node-red-contrib-mssql-plus versions: v0.9.0, v0.9.1 (possibly even older, I haven't tested)

I have an API that has multiple SQLs in cascade (not very complicated, mostly SELECT). The manipulated data are simple texts of several tens of characters. Small things, nothing like photos or files. Only texts.

The maximum rate at which the API is called would be a maximum of 15 accesses per second.

Sometimes the SQL node fails. I don't know exactly why, possibly because there are too many queries per second. The only way to fix the problem is to restart NodeRed.

I also attached a log file: SqlCrashLog.txt

softy2k commented 1 year ago

Also, in SQL Node I have:

TDS Version: 7_4 Trust Certificate: No Connect Timeout: 15000 Request Timeout: 15000 Cancel Timeout: 5000 Max Pool Size: 5 JSON Support: No ARITHABORT: Yes