{"action":"created","issue":{"url":"https://api.github.com/repos/oracle/node-oracledb/issues/350","repository_url":"https://api.github.com/repos/oracle/node-oracledb","labels_url":"https://api.github.com/repos/oracle/node-oracledb/issues/350/labels{/name}","comments_url":"https://api.github.com/repos/oracle/node-oracledb/issues/350/comments","events_url":"https://api.github.com/repos/oracle/node-oracledb/issues/350/events","html_url":"https://github.com/oracle/node-oracledb/issues/350","id":132232862,"number":350,"title":"NJS-032 Under Load","user":{"login":"jeffm13","id":5143994,"avatar_url":"https://avatars.githubusercontent.com/u/5143994?v=3","gravatar_id":"","url":"https://api.github.com/users/jeffm13","html_url":"https://github.com/jeffm13","followers_url":"https://api.github.com/users/jeffm13/followers","following_url":"https://api.github.com/users/jeffm13/following{/other_user}","gists_url":"https://api.github.com/users/jeffm13/gists{/gist_id}","starred_url":"https://api.github.com/users/jeffm13/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jeffm13/subscriptions","organizations_url":"https://api.github.com/users/jeffm13/orgs","repos_url":"https://api.github.com/users/jeffm13/repos","events_url":"https://api.github.com/users/jeffm13/events{/privacy}","received_events_url":"https://api.github.com/users/jeffm13/received_events","type":"User","site_admin":false},"labels":[{"id":161714391,"url":"https://api.github.com/repos/oracle/node-oracledb/labels/question","name":"question","color":"cc317c","default":true}],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":22,"created_at":"2016-02-08T19:17:01Z","updated_at":"2016-12-08T22:38:54Z","closed_at":"2016-02-12T21:25:52Z","body":"We're running into a NJS-032 (Connection cannot be released because a database call is in progress) issue when running Oracledb under load in production.  We have been able to reproduce the problem using JMeter on a test environment as well (although making it reproducible outside our own environment will probably not be easy). \n\nOur setup is as follows: \n- Node.js version 5.4.0\n- Node.js server running node-oracledb 1.6.0 against an 11g database on a remote server.\n- Connection pool size of 100 connections.  Reproduced on test environment with a connection pool size of 10 connections.\n- Single query that executes a custom PL/SQL function.  This is the only thing executed by the server.  The function executes and query returns in less than 1 second. autoCommit is implicitly set. \n- Function takes a 200 character string (VARCHAR2) as a parameter, and returns a 200 character string (VARCHAR2) as output.  \n- All node-oracledb interaction (oracle.createPool, pool.getConnection, connection.execute, and connection.release) wrapped with Bluebird promises. \n- Production OS is CentOS 6.6, also reproduced on Windows. \n\nGenerally, the flow is: \n1. Retrieve connection. \n2. Execute function. \n3. Release connection. \n\nThe problem is that some condition is causing connection.release to return NJS-032 after step #2 has been successfully completed.  If I ignore the problem, I eventually run out of connections.  Of course, if I throw the error, the process terminates, only to recur an hour, two, or three in the future. \n\nAny hints? \n"},"comment":{"url":"https://api.github.com/repos/oracle/node-oracledb/issues/comments/265877187","html_url":"https://github.com/oracle/node-oracledb/issues/350#issuecomment-265877187","issue_url":"https://api.github.com/repos/oracle/node-oracledb/issues/350","id":265877187,"user":{"login":"aralroca","id":13313058,"avatar_url":"https://avatars.githubusercontent.com/u/13313058?v=3","gravatar_id":"","url":"https://api.github.com/users/aralroca","html_url":"https://github.com/aralroca","followers_url":"https://api.github.com/users/aralroca/followers","following_url":"https://api.github.com/users/aralroca/following{/other_user}","gists_url":"https://api.github.com/users/aralroca/gists{/gist_id}","starred_url":"https://api.github.com/users/aralroca/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/aralroca/subscriptions","organizations_url":"https://api.github.com/users/aralroca/orgs","repos_url":"https://api.github.com/users/aralroca/repos","events_url":"https://api.github.com/users/aralroca/events{/privacy}","received_events_url":"https://api.github.com/users/aralroca/received_events","type":"User","site_admin":false},"created_at":"2016-12-08T22:38:54Z","updated_at":"2016-12-08T22:38:54Z","body":"Ok @cjbj 👍  I put [here](https://github.com/oracle/node-oracledb/issues/566) 🙂"}}
{"actor":{"display_login":"aralroca"}}