{"action":"created","issue":{"url":"https://api.github.com/repos/pipelinedb/pipelinedb/issues/1728","repository_url":"https://api.github.com/repos/pipelinedb/pipelinedb","labels_url":"https://api.github.com/repos/pipelinedb/pipelinedb/issues/1728/labels{/name}","comments_url":"https://api.github.com/repos/pipelinedb/pipelinedb/issues/1728/comments","events_url":"https://api.github.com/repos/pipelinedb/pipelinedb/issues/1728/events","html_url":"https://github.com/pipelinedb/pipelinedb/issues/1728","id":197079210,"number":1728,"title":"Drop stream&continuous view  problem.","user":{"login":"sangli00","id":3765918,"avatar_url":"https://avatars.githubusercontent.com/u/3765918?v=3","gravatar_id":"","url":"https://api.github.com/users/sangli00","html_url":"https://github.com/sangli00","followers_url":"https://api.github.com/users/sangli00/followers","following_url":"https://api.github.com/users/sangli00/following{/other_user}","gists_url":"https://api.github.com/users/sangli00/gists{/gist_id}","starred_url":"https://api.github.com/users/sangli00/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sangli00/subscriptions","organizations_url":"https://api.github.com/users/sangli00/orgs","repos_url":"https://api.github.com/users/sangli00/repos","events_url":"https://api.github.com/users/sangli00/events{/privacy}","received_events_url":"https://api.github.com/users/sangli00/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2016-12-22T02:15:50Z","updated_at":"2016-12-22T03:00:25Z","closed_at":null,"body":"\r\nI test create continuous view .\r\n\r\ncreate stream str(x bigint,y text,z timestamp);\r\n\r\npipeline=# create table t(x text);\r\ninsert into t select 'create continuous view cv_'||generate_series(1,2000)||' as select x,y,z from str;';\r\n\r\ncopy t to '/home/pipeline/a.csv';\r\n\\i /home/pipeline/a.csv;\r\nERROR:  maximum number of continuous queries exceeded\r\n\r\nOne stream  target continuous view just 1000?\r\n\r\n\r\nI try to drop stream&cv\r\n\r\npipeline is corrupted...\r\n\r\ndrop cascades to continuous view cv_73\r\nand 923 other objects (see server log for list)\r\n\r\nserver closed the connection unexpectedly\r\n\tThis probably means the server terminated abnormally\r\n\tbefore or while processing the request.\r\nThe connection to the server was lost. Attempting reset: Failed.\r\n!>\r\n!> \\q \r\n\r\n\r\n\r\ndetail log:\r\n12575 LOG:  database system is ready to accept connections\r\n12576 LOG:  continuous query scheduler started\r\n12577 LOG:  starting continuous query processes for database: \"pipeline\"\r\n12578 LOG:  autovacuum launcher started\r\n12579 LOG:  continuous query process \"combiner0 [pipeline]\" running with pid 69843\r\n12580 LOG:  continuous query process \"worker0 [pipeline]\" running with pid 69844\r\n12581 LOG:  backend pid is 69850\r\n12582 LOG:  server process (PID 69850) was terminated by signal 9: Killed\r\n12583 DETAIL:  Failed process was running: drop stream str cascade;\r\n"},"comment":{"url":"https://api.github.com/repos/pipelinedb/pipelinedb/issues/comments/268706513","html_url":"https://github.com/pipelinedb/pipelinedb/issues/1728#issuecomment-268706513","issue_url":"https://api.github.com/repos/pipelinedb/pipelinedb/issues/1728","id":268706513,"user":{"login":"usmanm","id":853039,"avatar_url":"https://avatars.githubusercontent.com/u/853039?v=3","gravatar_id":"","url":"https://api.github.com/users/usmanm","html_url":"https://github.com/usmanm","followers_url":"https://api.github.com/users/usmanm/followers","following_url":"https://api.github.com/users/usmanm/following{/other_user}","gists_url":"https://api.github.com/users/usmanm/gists{/gist_id}","starred_url":"https://api.github.com/users/usmanm/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/usmanm/subscriptions","organizations_url":"https://api.github.com/users/usmanm/orgs","repos_url":"https://api.github.com/users/usmanm/repos","events_url":"https://api.github.com/users/usmanm/events{/privacy}","received_events_url":"https://api.github.com/users/usmanm/received_events","type":"User","site_admin":false},"created_at":"2016-12-22T03:00:25Z","updated_at":"2016-12-22T03:00:25Z","body":"PipelineDB currently has a hard limit on the number of continuous queries, which is 1023 I believe. I will look at your query and see why it's making the server crash though."}}
{"actor":{"display_login":"usmanm"}}