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

Node red crashed due to an sql error #89

Open objt-la opened 6 months ago

objt-la commented 6 months ago

Node red crashed because of the following error. Please make sure that node-red does not crash in this case.

RequestError: Transaction (Process ID 84) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. at handleError (/usr/src/node-red/node_modules/mssql/lib/tedious/request.js:388:15) at Connection.emit (node:events:527:28) at Connection.emit (/usr/src/node-red/node_modules/tedious/lib/connection.js:1071:18) at Parser. (/usr/src/node-red/node_modules/tedious/lib/connection.js:1176:12) at Parser.emit (node:events:527:28) at Readable. (/usr/src/node-red/node_modules/tedious/lib/token/token-stream-parser.js:27:14) at Readable.emit (node:events:527:28) at addChunk (node:internal/streams/readable:315:12) at readableAddChunk (node:internal/streams/readable:289:9) at Readable.push (node:internal/streams/readable:228:10) at next (node:internal/streams/from:98:31) at runMicrotasks () at processTicksAndRejections (node:internal/process/task_queues:96:5) { code: 'EREQUEST', originalError: Error: Transaction (Process ID 84) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. at handleError (/usr/src/node-red/node_modules/mssql/lib/tedious/request.js:386:19) at Connection.emit (node:events:527:28) at Connection.emit (/usr/src/node-red/node_modules/tedious/lib/connection.js:1071:18) at Parser. (/usr/src/node-red/node_modules/tedious/lib/connection.js:1176:12) at Parser.emit (node:events:527:28) at Readable. (/usr/src/node-red/node_modules/tedious/lib/token/token-stream-parser.js:27:14) at Readable.emit (node:events:527:28) at addChunk (node:internal/streams/readable:315:12) at readableAddChunk (node:internal/streams/readable:289:9) at Readable.push (node:internal/streams/readable:228:10) at next (node:internal/streams/from:98:31) at runMicrotasks () at processTicksAndRejections (node:internal/process/task_queues:96:5) { info: ErrorMessageToken { name: 'ERROR', event: 'errorMessage', number: 1205, state: 52, class: 13, message: 'Transaction (Process ID 84) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.', serverName: 'ARGDBSQL', procName: '', lineNumber: 1 } },