{"action":"created","issue":{"url":"https://api.github.com/repos/influxdb/influxdb/issues/4354","labels_url":"https://api.github.com/repos/influxdb/influxdb/issues/4354/labels{/name}","comments_url":"https://api.github.com/repos/influxdb/influxdb/issues/4354/comments","events_url":"https://api.github.com/repos/influxdb/influxdb/issues/4354/events","html_url":"https://github.com/influxdb/influxdb/issues/4354","id":110199464,"number":4354,"title":"[tsm1] Data older than a few minutes is not showing up in queries","user":{"login":"KiNgMaR","id":438358,"avatar_url":"https://avatars.githubusercontent.com/u/438358?v=3","gravatar_id":"","url":"https://api.github.com/users/KiNgMaR","html_url":"https://github.com/KiNgMaR","followers_url":"https://api.github.com/users/KiNgMaR/followers","following_url":"https://api.github.com/users/KiNgMaR/following{/other_user}","gists_url":"https://api.github.com/users/KiNgMaR/gists{/gist_id}","starred_url":"https://api.github.com/users/KiNgMaR/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/KiNgMaR/subscriptions","organizations_url":"https://api.github.com/users/KiNgMaR/orgs","repos_url":"https://api.github.com/users/KiNgMaR/repos","events_url":"https://api.github.com/users/KiNgMaR/events{/privacy}","received_events_url":"https://api.github.com/users/KiNgMaR/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/influxdb/influxdb/labels/category/writes","name":"category/writes","color":"bfdadc"},{"url":"https://api.github.com/repos/influxdb/influxdb/labels/tsm","name":"tsm","color":"e11d21"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":7,"created_at":"2015-10-07T10:51:25Z","updated_at":"2015-10-09T06:25:03Z","closed_at":null,"body":"The new storage engine looks very promising so far. Memory usage is still going up non-stop (writing over UDP exclusively), but slower than before. Overall the system seems more stable and under much less pressure.\r\n\r\nHowever, after a few minutes, points that have been written and were previously showing up in queries disappear. All `WHERE time >= now() - 1h` queries only show data for approx. the last 2-10 minutes. This affects CQs and normal queries. It can even be reproduced using a simple `SELECT * FROM blah` query without any time constraints.\r\nThe data showing from this type of query behaves as follows: new points are appended and showing up. Then, every few minutes, the _starting point_ (i.e. the timestamp of the first point returned) moves some minutes into the future.\r\n\r\n* version 0.9.5-nightly-6f80d69\r\n* Fresh installation, clean databases...\r\n* No errors in the logs\r\n* Configuration -> https://gist.github.com/KiNgMaR/2f0ba7ca6af1f83f39bc\r\n* Stats -> https://gist.github.com/KiNgMaR/3e3db326ea87ab815bdb\r\n\r\nP.S. Thanks everyone, you're doing a great job!"},"comment":{"url":"https://api.github.com/repos/influxdb/influxdb/issues/comments/146768064","html_url":"https://github.com/influxdb/influxdb/issues/4354#issuecomment-146768064","issue_url":"https://api.github.com/repos/influxdb/influxdb/issues/4354","id":146768064,"user":{"login":"KiNgMaR","id":438358,"avatar_url":"https://avatars.githubusercontent.com/u/438358?v=3","gravatar_id":"","url":"https://api.github.com/users/KiNgMaR","html_url":"https://github.com/KiNgMaR","followers_url":"https://api.github.com/users/KiNgMaR/followers","following_url":"https://api.github.com/users/KiNgMaR/following{/other_user}","gists_url":"https://api.github.com/users/KiNgMaR/gists{/gist_id}","starred_url":"https://api.github.com/users/KiNgMaR/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/KiNgMaR/subscriptions","organizations_url":"https://api.github.com/users/KiNgMaR/orgs","repos_url":"https://api.github.com/users/KiNgMaR/repos","events_url":"https://api.github.com/users/KiNgMaR/events{/privacy}","received_events_url":"https://api.github.com/users/KiNgMaR/received_events","type":"User","site_admin":false},"created_at":"2015-10-09T06:25:03Z","updated_at":"2015-10-09T06:25:03Z","body":"I updated to the fresh nightly (bc569e82debd611c38bb9d749b067af92a17b50c) and the issue appears to be resolved for me. :smiley: However I browsed the commits and didn't find anything that struck me as related, so we probably have to keep an eye on it...\r\n\r\n@pkittenis can you also test with the fresh build?"}}