strongloop / loopback-connector-informix

LoopBack connector for IBM Informix
Other
2 stars 2 forks source link

Node crashes if setIsolationLevel fails #53

Closed tscnn closed 5 years ago

tscnn commented 6 years ago

Bug or feature request

Bug

Description/Steps to reproduce

We use Loopback 3 together with an Informix server. If a lot of create, update and delete request occur at the same time, our Informix server sometimes gives the following error and node crashes:

Sep 21 09:32:34 node[7626]: Error: [IBM][CLI Driver] CLI0126E Operation invalid at this time. SQLSTATE=HY011 Sep 21 09:32:34 node[7626]: at Error (native) Sep 21 09:32:34 node[7626]: at Database.setIsolationLevel (/node_modules/loopback-ibmdb/node_modules/ibm_db/lib/odbc.js:1151:21) Sep 21 09:32:34 node[7626]: at /node_modules/loopback-connector-informix/lib/transaction.js:61:22

I do not know the cause of the Informix error, but I think the crash of Node can be prevented.

Expected result

Node does not crash.

Additional information

node -e 'console.log(process.platform, process.arch, process.versions.node)'

linux x64 6.14.3

npm ls --prod --depth 0 | grep loopback

├── loopback@3.22.3 ├── loopback-boot@2.27.1 ├── loopback-component-explorer@4.3.1 ├── loopback-connector-informix@2.2.0 ├── loopback-include-through-mixin@1.1.1

stale[bot] commented 5 years ago

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

stale[bot] commented 5 years ago

This issue has been closed due to continued inactivity. Thank you for your understanding. If you believe this to be in error, please contact one of the code owners, listed in the CODEOWNERS file at the top-level of this repository.