{"action":"created","issue":{"url":"https://api.github.com/repos/influxdb/influxdb/issues/2450","labels_url":"https://api.github.com/repos/influxdb/influxdb/issues/2450/labels{/name}","comments_url":"https://api.github.com/repos/influxdb/influxdb/issues/2450/comments","events_url":"https://api.github.com/repos/influxdb/influxdb/issues/2450/events","html_url":"https://github.com/influxdb/influxdb/issues/2450","id":71911816,"number":2450,"title":"Select does not get recent data","user":{"login":"yogeswaran","id":6502513,"avatar_url":"https://avatars.githubusercontent.com/u/6502513?v=3","gravatar_id":"","url":"https://api.github.com/users/yogeswaran","html_url":"https://github.com/yogeswaran","followers_url":"https://api.github.com/users/yogeswaran/followers","following_url":"https://api.github.com/users/yogeswaran/following{/other_user}","gists_url":"https://api.github.com/users/yogeswaran/gists{/gist_id}","starred_url":"https://api.github.com/users/yogeswaran/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yogeswaran/subscriptions","organizations_url":"https://api.github.com/users/yogeswaran/orgs","repos_url":"https://api.github.com/users/yogeswaran/repos","events_url":"https://api.github.com/users/yogeswaran/events{/privacy}","received_events_url":"https://api.github.com/users/yogeswaran/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/influxdb/influxdb/labels/2%20-%20Working","name":"2 - Working","color":"CCCCCC"},{"url":"https://api.github.com/repos/influxdb/influxdb/labels/category/performance","name":"category/performance","color":"006b75"}],"state":"open","locked":false,"assignee":{"login":"otoolep","id":536312,"avatar_url":"https://avatars.githubusercontent.com/u/536312?v=3","gravatar_id":"","url":"https://api.github.com/users/otoolep","html_url":"https://github.com/otoolep","followers_url":"https://api.github.com/users/otoolep/followers","following_url":"https://api.github.com/users/otoolep/following{/other_user}","gists_url":"https://api.github.com/users/otoolep/gists{/gist_id}","starred_url":"https://api.github.com/users/otoolep/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/otoolep/subscriptions","organizations_url":"https://api.github.com/users/otoolep/orgs","repos_url":"https://api.github.com/users/otoolep/repos","events_url":"https://api.github.com/users/otoolep/events{/privacy}","received_events_url":"https://api.github.com/users/otoolep/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/influxdb/influxdb/milestones/34","html_url":"https://github.com/influxdb/influxdb/milestones/0.9.0","labels_url":"https://api.github.com/repos/influxdb/influxdb/milestones/34/labels","id":875135,"number":34,"title":"0.9.0","description":"","creator":{"login":"otoolep","id":536312,"avatar_url":"https://avatars.githubusercontent.com/u/536312?v=3","gravatar_id":"","url":"https://api.github.com/users/otoolep","html_url":"https://github.com/otoolep","followers_url":"https://api.github.com/users/otoolep/followers","following_url":"https://api.github.com/users/otoolep/following{/other_user}","gists_url":"https://api.github.com/users/otoolep/gists{/gist_id}","starred_url":"https://api.github.com/users/otoolep/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/otoolep/subscriptions","organizations_url":"https://api.github.com/users/otoolep/orgs","repos_url":"https://api.github.com/users/otoolep/repos","events_url":"https://api.github.com/users/otoolep/events{/privacy}","received_events_url":"https://api.github.com/users/otoolep/received_events","type":"User","site_admin":false},"open_issues":9,"closed_issues":123,"state":"open","created_at":"2014-11-21T03:38:20Z","updated_at":"2015-05-21T20:19:24Z","due_on":null,"closed_at":null},"comments":39,"created_at":"2015-04-29T15:43:03Z","updated_at":"2015-05-22T15:00:51Z","closed_at":null,"body":"We are running influxdb version  0.9.0-rc28, when there is not much load 'select' works fine but when we ingest ~5000 data points per second, 'select' query returns old data points and not the recent ones.\r\n\r\nHere is an example of a data point that is being ingested, following metric is ingested every 30 seconds:\r\n```json\r\n   {\"database\":\"collectd\",\r\n    \"retentionPolicy\":\"collectdPolicy\",\r\n    \"points\":[{\r\n       \"name\":\"aggregation.cpu\",\r\n       \"timestamp\":1430321509,\r\n       \"precision\":\"s\",\r\n       \"fields\":{\"value\":6597},\r\n       \"tags\":{\r\n          \"host\":\"MyHost1\",\r\n          \"plugin_instance\":\"cpu-average\",\r\n          \"type_instance\":\"idle\"\r\n          }\r\n     }]\r\n    }\r\n```\r\n\r\n**Note**: epoch 1430321509 is Apr 29 15:31:49 UTC 2015, so expectation is that select returns all data points until 15:31:49\r\n\r\n\r\nHere is the output from select query (SELECT value FROM \"aggregation.cpu\" WHERE host='MyHost1' AND plugin_instance='cpu-average' AND type_instance='idle')\r\n```json\r\n   \"results\": [\r\n        {\r\n            \"series\": [\r\n                {\r\n                    \"name\": \"aggregation.cpu\",\r\n                    \"columns\": [\r\n                        \"time\",\r\n                        \"value\"\r\n                    ],\r\n                    \"values\": [\r\n                        [\r\n                            \"2015-04-29T13:00:34Z\",\r\n                            29215\r\n                        ],\r\n\r\n .... \r\n ....\r\n ....\r\n                        [\r\n                            \"2015-04-29T15:18:18Z\",\r\n                            17588\r\n                        ]\r\n                    ]\r\n                }\r\n            ]\r\n        }\r\n    ]\r\n}\r\n```\r\n\r\nThough data points are ingested every 30 seconds, select query returns data points only up to 15:18:18 and not getting any values from 15:18:18 to 15:31:49\r\n"},"comment":{"url":"https://api.github.com/repos/influxdb/influxdb/issues/comments/104682415","html_url":"https://github.com/influxdb/influxdb/issues/2450#issuecomment-104682415","issue_url":"https://api.github.com/repos/influxdb/influxdb/issues/2450","id":104682415,"user":{"login":"jmcook","id":1637905,"avatar_url":"https://avatars.githubusercontent.com/u/1637905?v=3","gravatar_id":"","url":"https://api.github.com/users/jmcook","html_url":"https://github.com/jmcook","followers_url":"https://api.github.com/users/jmcook/followers","following_url":"https://api.github.com/users/jmcook/following{/other_user}","gists_url":"https://api.github.com/users/jmcook/gists{/gist_id}","starred_url":"https://api.github.com/users/jmcook/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jmcook/subscriptions","organizations_url":"https://api.github.com/users/jmcook/orgs","repos_url":"https://api.github.com/users/jmcook/repos","events_url":"https://api.github.com/users/jmcook/events{/privacy}","received_events_url":"https://api.github.com/users/jmcook/received_events","type":"User","site_admin":false},"created_at":"2015-05-22T15:00:51Z","updated_at":"2015-05-22T15:00:51Z","body":"So disregard my last post. I let it run overnight, I woke up and it looks to be running well. So it does seem to be IO related, but the behavior still does seem strange, it's not trying very hard to write."}}