{"action":"created","issue":{"url":"https://api.github.com/repos/sequelize/sequelize/issues/9069","repository_url":"https://api.github.com/repos/sequelize/sequelize","labels_url":"https://api.github.com/repos/sequelize/sequelize/issues/9069/labels{/name}","comments_url":"https://api.github.com/repos/sequelize/sequelize/issues/9069/comments","events_url":"https://api.github.com/repos/sequelize/sequelize/issues/9069/events","html_url":"https://github.com/sequelize/sequelize/issues/9069","id":298196816,"number":9069,"title":"Tables getting locked while using sequelize select query.","user":{"login":"JasimJamal","id":36619765,"avatar_url":"https://avatars3.githubusercontent.com/u/36619765?v=4","gravatar_id":"","url":"https://api.github.com/users/JasimJamal","html_url":"https://github.com/JasimJamal","followers_url":"https://api.github.com/users/JasimJamal/followers","following_url":"https://api.github.com/users/JasimJamal/following{/other_user}","gists_url":"https://api.github.com/users/JasimJamal/gists{/gist_id}","starred_url":"https://api.github.com/users/JasimJamal/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/JasimJamal/subscriptions","organizations_url":"https://api.github.com/users/JasimJamal/orgs","repos_url":"https://api.github.com/users/JasimJamal/repos","events_url":"https://api.github.com/users/JasimJamal/events{/privacy}","received_events_url":"https://api.github.com/users/JasimJamal/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-02-19T08:43:57Z","updated_at":"2018-02-19T08:46:21Z","closed_at":"2018-02-19T08:46:11Z","author_association":"NONE","body":"<!--\r\n\r\nPlease note this is an issue tracker, not a support forum.\r\nFor general questions, please use StackOverflow or Slack.\r\n\r\nFor bugs, please fill out the template below.\r\n\r\n-->\r\n\r\n## What are you doing?\r\n<!-- Post a minimal, self-contained code sample that reproduces the issue, including models and associations -->\r\n\r\n```js\r\n var clientConfig = {\r\n\r\n        getClientConfigId: function (req, callback) {\r\n            models.clientConfig.findAll({\r\n                raw: true,\r\n                where: {\r\n                    application: commonFunctions.getSourceApplication(req),\r\n                    client: commonFunctions.getClient(req),\r\n                    culture:commonFunctions.getCulture(req),\r\n                    lineofbusiness: commonFunctions.getlineOfBusiness(req),\r\n                    methodofpayment: commonFunctions.getMethodOfPayment(req)\r\n                }, attributes:[\"clientconfigid\"]\r\n\r\n            }).then(\r\n                clientConfig => {\r\n                    callback(null, clientConfig);\r\n                },\r\n                err => {\r\n                    callback(err, null);\r\n            }); \r\n        }\r\n    }\r\n```\r\n\r\n## What do you expect to happen?\r\nTables are getting locked. It is not happening on every hit. But sometimes when this query fires. We see that the tables get locked for hours and the application stuck. Is there some configuration that we are missing on. Help will be highly appreciated.\r\n\r\n## What is actually happening?\r\nWe are getting some data from database using the above code. Once in a blue moon we see that the tables gets locked. If we use normal SQL query it does not happens. We had tested this ample of time. It is happening due to sequelize. May be some configuration that we are missing on. \r\n\r\n"},"comment":{"url":"https://api.github.com/repos/sequelize/sequelize/issues/comments/366622324","html_url":"https://github.com/sequelize/sequelize/issues/9069#issuecomment-366622324","issue_url":"https://api.github.com/repos/sequelize/sequelize/issues/9069","id":366622324,"user":{"login":"JasimJamal","id":36619765,"avatar_url":"https://avatars3.githubusercontent.com/u/36619765?v=4","gravatar_id":"","url":"https://api.github.com/users/JasimJamal","html_url":"https://github.com/JasimJamal","followers_url":"https://api.github.com/users/JasimJamal/followers","following_url":"https://api.github.com/users/JasimJamal/following{/other_user}","gists_url":"https://api.github.com/users/JasimJamal/gists{/gist_id}","starred_url":"https://api.github.com/users/JasimJamal/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/JasimJamal/subscriptions","organizations_url":"https://api.github.com/users/JasimJamal/orgs","repos_url":"https://api.github.com/users/JasimJamal/repos","events_url":"https://api.github.com/users/JasimJamal/events{/privacy}","received_events_url":"https://api.github.com/users/JasimJamal/received_events","type":"User","site_admin":false},"created_at":"2018-02-19T08:46:21Z","updated_at":"2018-02-19T08:46:21Z","author_association":"NONE","body":"Duplicate"}}
{"actor":{"display_login":"JasimJamal"}}