{"action":"created","issue":{"url":"https://api.github.com/repos/pipelinedb/pipelinedb/issues/1738","repository_url":"https://api.github.com/repos/pipelinedb/pipelinedb","labels_url":"https://api.github.com/repos/pipelinedb/pipelinedb/issues/1738/labels{/name}","comments_url":"https://api.github.com/repos/pipelinedb/pipelinedb/issues/1738/comments","events_url":"https://api.github.com/repos/pipelinedb/pipelinedb/issues/1738/events","html_url":"https://github.com/pipelinedb/pipelinedb/issues/1738","id":199563582,"number":1738,"title":"Deadlock while INSERTing lots of data","user":{"login":"hedayat","id":497092,"avatar_url":"https://avatars.githubusercontent.com/u/497092?v=3","gravatar_id":"","url":"https://api.github.com/users/hedayat","html_url":"https://github.com/hedayat","followers_url":"https://api.github.com/users/hedayat/followers","following_url":"https://api.github.com/users/hedayat/following{/other_user}","gists_url":"https://api.github.com/users/hedayat/gists{/gist_id}","starred_url":"https://api.github.com/users/hedayat/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hedayat/subscriptions","organizations_url":"https://api.github.com/users/hedayat/orgs","repos_url":"https://api.github.com/users/hedayat/repos","events_url":"https://api.github.com/users/hedayat/events{/privacy}","received_events_url":"https://api.github.com/users/hedayat/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":6,"created_at":"2017-01-09T14:22:30Z","updated_at":"2017-01-11T20:44:04Z","closed_at":"2017-01-09T19:20:59Z","body":"I have a CV with (step_factor = 1, sw = '30 mins'). I use it's output stream in a transform to feed another stream. CVs can be created over the latter, but this problems even occurs when there are no CVs on the latter stream.\r\nI do lots of INSERTs each one have 500 rows. Having this load for awhile, e.g. 30 minutes, pipelinedb keeps up with my INSERTs, then it starts to lag behind for a few minutes, and suddenly one of my INSERTs block. Nothing happens anymore, no new data is inserted and CPU usages drop considerably. \r\n\r\nI created another view with larger sw to see if it has any different behavior, but it doesn't. When blocked, I tried to DROP this second view but it becomes 'waiting'. So, effectively something is locked forever.\r\n"},"comment":{"url":"https://api.github.com/repos/pipelinedb/pipelinedb/issues/comments/271988354","html_url":"https://github.com/pipelinedb/pipelinedb/issues/1738#issuecomment-271988354","issue_url":"https://api.github.com/repos/pipelinedb/pipelinedb/issues/1738","id":271988354,"user":{"login":"hedayat","id":497092,"avatar_url":"https://avatars.githubusercontent.com/u/497092?v=3","gravatar_id":"","url":"https://api.github.com/users/hedayat","html_url":"https://github.com/hedayat","followers_url":"https://api.github.com/users/hedayat/followers","following_url":"https://api.github.com/users/hedayat/following{/other_user}","gists_url":"https://api.github.com/users/hedayat/gists{/gist_id}","starred_url":"https://api.github.com/users/hedayat/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hedayat/subscriptions","organizations_url":"https://api.github.com/users/hedayat/orgs","repos_url":"https://api.github.com/users/hedayat/repos","events_url":"https://api.github.com/users/hedayat/events{/privacy}","received_events_url":"https://api.github.com/users/hedayat/received_events","type":"User","site_admin":false},"created_at":"2017-01-11T20:44:04Z","updated_at":"2017-01-11T20:44:04Z","body":"I'm going to provide that, but it's slightly complicated (and might need some permissions too).  I'll try to provide you with more info but it'll take some time to provide something usable by you and as simple as possible."}}
{"actor":{"display_login":"hedayat"}}