{"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":18,"closed_issues":103,"state":"open","created_at":"2014-11-21T03:38:20Z","updated_at":"2015-05-13T13:47:05Z","due_on":null,"closed_at":null},"comments":28,"created_at":"2015-04-29T15:43:03Z","updated_at":"2015-05-13T15:27:55Z","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/101715212","html_url":"https://github.com/influxdb/influxdb/issues/2450#issuecomment-101715212","issue_url":"https://api.github.com/repos/influxdb/influxdb/issues/2450","id":101715212,"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-13T15:27:55Z","updated_at":"2015-05-13T15:27:55Z","body":"I should also note I'm using ext4 with default options, which probably could stand to be tuned, but I hadn't gone there yet."}}