{"action":"created","issue":{"url":"https://api.github.com/repos/influxdata/influxdb/issues/9636","repository_url":"https://api.github.com/repos/influxdata/influxdb","labels_url":"https://api.github.com/repos/influxdata/influxdb/issues/9636/labels{/name}","comments_url":"https://api.github.com/repos/influxdata/influxdb/issues/9636/comments","events_url":"https://api.github.com/repos/influxdata/influxdb/issues/9636/events","html_url":"https://github.com/influxdata/influxdb/issues/9636","id":308963314,"number":9636,"title":"[bug] drop/delete terribly slow","user":{"login":"lukaszgryglicki","id":2469783,"avatar_url":"https://avatars2.githubusercontent.com/u/2469783?v=4","gravatar_id":"","url":"https://api.github.com/users/lukaszgryglicki","html_url":"https://github.com/lukaszgryglicki","followers_url":"https://api.github.com/users/lukaszgryglicki/followers","following_url":"https://api.github.com/users/lukaszgryglicki/following{/other_user}","gists_url":"https://api.github.com/users/lukaszgryglicki/gists{/gist_id}","starred_url":"https://api.github.com/users/lukaszgryglicki/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lukaszgryglicki/subscriptions","organizations_url":"https://api.github.com/users/lukaszgryglicki/orgs","repos_url":"https://api.github.com/users/lukaszgryglicki/repos","events_url":"https://api.github.com/users/lukaszgryglicki/events{/privacy}","received_events_url":"https://api.github.com/users/lukaszgryglicki/received_events","type":"User","site_admin":false},"labels":[{"id":491812597,"url":"https://api.github.com/repos/influxdata/influxdb/labels/area/storage","name":"area/storage","color":"fbca04","default":false},{"id":90754336,"url":"https://api.github.com/repos/influxdata/influxdb/labels/performance","name":"performance","color":"006b75","default":false}],"state":"open","locked":false,"assignee":{"login":"benbjohnson","id":118015,"avatar_url":"https://avatars2.githubusercontent.com/u/118015?v=4","gravatar_id":"","url":"https://api.github.com/users/benbjohnson","html_url":"https://github.com/benbjohnson","followers_url":"https://api.github.com/users/benbjohnson/followers","following_url":"https://api.github.com/users/benbjohnson/following{/other_user}","gists_url":"https://api.github.com/users/benbjohnson/gists{/gist_id}","starred_url":"https://api.github.com/users/benbjohnson/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/benbjohnson/subscriptions","organizations_url":"https://api.github.com/users/benbjohnson/orgs","repos_url":"https://api.github.com/users/benbjohnson/repos","events_url":"https://api.github.com/users/benbjohnson/events{/privacy}","received_events_url":"https://api.github.com/users/benbjohnson/received_events","type":"User","site_admin":false},"assignees":[{"login":"benbjohnson","id":118015,"avatar_url":"https://avatars2.githubusercontent.com/u/118015?v=4","gravatar_id":"","url":"https://api.github.com/users/benbjohnson","html_url":"https://github.com/benbjohnson","followers_url":"https://api.github.com/users/benbjohnson/followers","following_url":"https://api.github.com/users/benbjohnson/following{/other_user}","gists_url":"https://api.github.com/users/benbjohnson/gists{/gist_id}","starred_url":"https://api.github.com/users/benbjohnson/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/benbjohnson/subscriptions","organizations_url":"https://api.github.com/users/benbjohnson/orgs","repos_url":"https://api.github.com/users/benbjohnson/repos","events_url":"https://api.github.com/users/benbjohnson/events{/privacy}","received_events_url":"https://api.github.com/users/benbjohnson/received_events","type":"User","site_admin":false}],"milestone":null,"comments":9,"created_at":"2018-03-27T13:13:40Z","updated_at":"2018-03-29T15:58:41Z","closed_at":null,"author_association":"NONE","body":"### Bug report\r\n\r\nInflux version: **v1.5.1**\r\nOS version: **Ubuntu Linux 17.04**\r\n\r\n__Steps to reproduce:__\r\n1. Have a big database with > 20000 series\r\n2. Try to execute `drop series from /{{regexp_pattern}}/`.\r\n3. or try to execute `drop measurement /{{regexp_pattern}}/`.\r\n4. or try to execute `delete from /{{regexp_pattern}}/`.\r\n\r\nIt will take > 30 minutes.\r\n\r\n__Expected behavior:__ \r\n1. Well deleting data should take miliseconds?\r\n2. Or there should be some special command modifier that will do it fast (I think this is becaus esome influx DB cleaning stuff). And there should be another comment to execute this \"long\" part manually, so for example I can delete ton of series and run cleanup process manually (to reclaim space) from a cron job or something like this."},"comment":{"url":"https://api.github.com/repos/influxdata/influxdb/issues/comments/377283274","html_url":"https://github.com/influxdata/influxdb/issues/9636#issuecomment-377283274","issue_url":"https://api.github.com/repos/influxdata/influxdb/issues/9636","id":377283274,"user":{"login":"lukaszgryglicki","id":2469783,"avatar_url":"https://avatars2.githubusercontent.com/u/2469783?v=4","gravatar_id":"","url":"https://api.github.com/users/lukaszgryglicki","html_url":"https://github.com/lukaszgryglicki","followers_url":"https://api.github.com/users/lukaszgryglicki/followers","following_url":"https://api.github.com/users/lukaszgryglicki/following{/other_user}","gists_url":"https://api.github.com/users/lukaszgryglicki/gists{/gist_id}","starred_url":"https://api.github.com/users/lukaszgryglicki/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lukaszgryglicki/subscriptions","organizations_url":"https://api.github.com/users/lukaszgryglicki/orgs","repos_url":"https://api.github.com/users/lukaszgryglicki/repos","events_url":"https://api.github.com/users/lukaszgryglicki/events{/privacy}","received_events_url":"https://api.github.com/users/lukaszgryglicki/received_events","type":"User","site_admin":false},"created_at":"2018-03-29T15:58:41Z","updated_at":"2018-03-29T15:58:41Z","author_association":"NONE","body":"I'll duouble check tomorrow then but fast question:\r\nCan I backup database named A into some file and then restore into database named B?\r\nWhat I need to do\r\n- Assume I have to regenerate database A (calculations are slow, takes hours, data is generated from complex set of postgres SQLs)\r\n- I'm generating new influx datamase A_temp\r\n- If success then I want to rename A_temp to A (overwriting original A).\r\n- If there is an error with A_temp generation, A remains intact and A_temp (broken) is dropped.\r\n\r\nCopy A_temp to A should be orders of magnitude faster than just generating A (to avoid downtime).\r\n"}}
{"actor":{"display_login":"lukaszgryglicki"}}