{"action":"created","issue":{"url":"https://api.github.com/repos/ibmdb/node-ibm_db/issues/307","repository_url":"https://api.github.com/repos/ibmdb/node-ibm_db","labels_url":"https://api.github.com/repos/ibmdb/node-ibm_db/issues/307/labels{/name}","comments_url":"https://api.github.com/repos/ibmdb/node-ibm_db/issues/307/comments","events_url":"https://api.github.com/repos/ibmdb/node-ibm_db/issues/307/events","html_url":"https://github.com/ibmdb/node-ibm_db/issues/307","id":254858781,"number":307,"title":"Expecting FIFO in Pool.open, but it is 1 second penalty box and connection stealing instead.","user":{"login":"vjmp","id":7085,"avatar_url":"https://avatars1.githubusercontent.com/u/7085?v=4","gravatar_id":"","url":"https://api.github.com/users/vjmp","html_url":"https://github.com/vjmp","followers_url":"https://api.github.com/users/vjmp/followers","following_url":"https://api.github.com/users/vjmp/following{/other_user}","gists_url":"https://api.github.com/users/vjmp/gists{/gist_id}","starred_url":"https://api.github.com/users/vjmp/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/vjmp/subscriptions","organizations_url":"https://api.github.com/users/vjmp/orgs","repos_url":"https://api.github.com/users/vjmp/repos","events_url":"https://api.github.com/users/vjmp/events{/privacy}","received_events_url":"https://api.github.com/users/vjmp/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2017-09-03T07:27:41Z","updated_at":"2017-09-05T08:26:28Z","closed_at":null,"author_association":"NONE","body":"https://github.com/ibmdb/node-ibm_db/blob/f11897ca749af89dce2fa59b420ba2851bb420a2/lib/odbc.js#L1484-L1503\r\n\r\n- I was very suprised to see 1000 millisecond \"penalty box\" for caller who comes in when all connections are in use.\r\n- I was expecting to get into some kind of FIFO queue and civil waiting\r\n- In this model, new requests coming in can steal released connections from those that are already waiting\r\n- 1000 milliseconds is very long time to wait, and if we should have response for user in less than 300ms (UX responsivenes of UIs) then single wait in connection pool breaks that [should this be more like 20ms and in queue]\r\n- and if timeout is like 30 seconds, and there is burst of connection ativity during that time, waiting caller has only 30 times to try their luck before they timeout\r\n- and each waiting call gets separate interval\r\n- Please tell me that I have interpreted this wrong!\r\n- And if this is actually as I describe it above, it is very severe issue IMHO and should be fixed ASAP (it might also explain some other issues raised)"},"comment":{"url":"https://api.github.com/repos/ibmdb/node-ibm_db/issues/comments/327107213","html_url":"https://github.com/ibmdb/node-ibm_db/issues/307#issuecomment-327107213","issue_url":"https://api.github.com/repos/ibmdb/node-ibm_db/issues/307","id":327107213,"user":{"login":"bimalkjha","id":11818648,"avatar_url":"https://avatars0.githubusercontent.com/u/11818648?v=4","gravatar_id":"","url":"https://api.github.com/users/bimalkjha","html_url":"https://github.com/bimalkjha","followers_url":"https://api.github.com/users/bimalkjha/followers","following_url":"https://api.github.com/users/bimalkjha/following{/other_user}","gists_url":"https://api.github.com/users/bimalkjha/gists{/gist_id}","starred_url":"https://api.github.com/users/bimalkjha/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bimalkjha/subscriptions","organizations_url":"https://api.github.com/users/bimalkjha/orgs","repos_url":"https://api.github.com/users/bimalkjha/repos","events_url":"https://api.github.com/users/bimalkjha/events{/privacy}","received_events_url":"https://api.github.com/users/bimalkjha/received_events","type":"User","site_admin":false},"created_at":"2017-09-05T08:26:28Z","updated_at":"2017-09-05T08:26:28Z","author_association":"OWNER","body":"Ok. I'll reduce it soon. Thanks."}}
{"actor":{"display_login":"bimalkjha"}}