{"action":"created","issue":{"url":"https://api.github.com/repos/pivotalsoftware/quickstep/issues/70","repository_url":"https://api.github.com/repos/pivotalsoftware/quickstep","labels_url":"https://api.github.com/repos/pivotalsoftware/quickstep/issues/70/labels{/name}","comments_url":"https://api.github.com/repos/pivotalsoftware/quickstep/issues/70/comments","events_url":"https://api.github.com/repos/pivotalsoftware/quickstep/issues/70/events","html_url":"https://github.com/pivotalsoftware/quickstep/issues/70","id":139047660,"number":70,"title":"Deadlock Caused by makeRoomForBlock","user":{"login":"cramja","id":5708822,"avatar_url":"https://avatars.githubusercontent.com/u/5708822?v=3","gravatar_id":"","url":"https://api.github.com/users/cramja","html_url":"https://github.com/cramja","followers_url":"https://api.github.com/users/cramja/followers","following_url":"https://api.github.com/users/cramja/following{/other_user}","gists_url":"https://api.github.com/users/cramja/gists{/gist_id}","starred_url":"https://api.github.com/users/cramja/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cramja/subscriptions","organizations_url":"https://api.github.com/users/cramja/orgs","repos_url":"https://api.github.com/users/cramja/repos","events_url":"https://api.github.com/users/cramja/events{/privacy}","received_events_url":"https://api.github.com/users/cramja/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/pivotalsoftware/quickstep/labels/bug","name":"bug","color":"fc2929"}],"state":"open","locked":false,"assignee":{"login":"hbdeshmukh","id":3750801,"avatar_url":"https://avatars.githubusercontent.com/u/3750801?v=3","gravatar_id":"","url":"https://api.github.com/users/hbdeshmukh","html_url":"https://github.com/hbdeshmukh","followers_url":"https://api.github.com/users/hbdeshmukh/followers","following_url":"https://api.github.com/users/hbdeshmukh/following{/other_user}","gists_url":"https://api.github.com/users/hbdeshmukh/gists{/gist_id}","starred_url":"https://api.github.com/users/hbdeshmukh/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hbdeshmukh/subscriptions","organizations_url":"https://api.github.com/users/hbdeshmukh/orgs","repos_url":"https://api.github.com/users/hbdeshmukh/repos","events_url":"https://api.github.com/users/hbdeshmukh/events{/privacy}","received_events_url":"https://api.github.com/users/hbdeshmukh/received_events","type":"User","site_admin":false},"milestone":null,"comments":10,"created_at":"2016-03-07T18:00:24Z","updated_at":"2016-03-14T16:27:39Z","closed_at":null,"body":"I was running SSB queries this past weekend and noticed that some of them would hang indefinitely. \r\n\r\nTo reproduce the issue:\r\n\r\n1.  Use either a debug or production build of quickstep.\r\n\r\n2. Use a large number of worker threads and the default buffer pool size. On the Quickstep box, this looks like: `./quickstep_cli_shell --num_workers=80 --printing_enabled=false`\r\n\r\n3. I have a large (6gb) `lineorder` table from SSB already loaded into a shared folder on the Quickstep box if  you would like to use it.\r\n\r\n```shell\r\n$QS=your_qs_cli_shell\r\ncd /home/spehlmann/shared\r\n$QS --storage_path=qs_data\r\n```\r\nNow type this a bunch of times. It should hang on the 4-5th repetition. \r\n```SQL\r\nSELECT COUNT(*) FROM lineorder;\r\n```\r\n\r\n**Notes:**\r\n- Running this in script cannot reproduce the issue. As in, giving a bunch of `COUNT` queries to quickstep from a single file like `$QS < count.sql` will not reproduce the issue.\r\n- Using less workers or a larger buffer pool eliminates the issue."},"comment":{"url":"https://api.github.com/repos/pivotalsoftware/quickstep/issues/comments/196398287","html_url":"https://github.com/pivotalsoftware/quickstep/issues/70#issuecomment-196398287","issue_url":"https://api.github.com/repos/pivotalsoftware/quickstep/issues/70","id":196398287,"user":{"login":"cramja","id":5708822,"avatar_url":"https://avatars.githubusercontent.com/u/5708822?v=3","gravatar_id":"","url":"https://api.github.com/users/cramja","html_url":"https://github.com/cramja","followers_url":"https://api.github.com/users/cramja/followers","following_url":"https://api.github.com/users/cramja/following{/other_user}","gists_url":"https://api.github.com/users/cramja/gists{/gist_id}","starred_url":"https://api.github.com/users/cramja/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cramja/subscriptions","organizations_url":"https://api.github.com/users/cramja/orgs","repos_url":"https://api.github.com/users/cramja/repos","events_url":"https://api.github.com/users/cramja/events{/privacy}","received_events_url":"https://api.github.com/users/cramja/received_events","type":"User","site_admin":false},"created_at":"2016-03-14T16:27:39Z","updated_at":"2016-03-14T16:27:39Z","body":"@jianqiao Made a PR, will begin commenting there instead of on this issue."}}