{"action":"created","issue":{"url":"https://api.github.com/repos/influxdb/influxdb/issues/3781","labels_url":"https://api.github.com/repos/influxdb/influxdb/issues/3781/labels{/name}","comments_url":"https://api.github.com/repos/influxdb/influxdb/issues/3781/comments","events_url":"https://api.github.com/repos/influxdb/influxdb/issues/3781/events","html_url":"https://github.com/influxdb/influxdb/issues/3781","id":102267335,"number":3781,"title":"[0.9.3-rc1] Data disappears, replaced with a single point every 9 to 20 minutes","user":{"login":"gerrickw","id":656611,"avatar_url":"https://avatars.githubusercontent.com/u/656611?v=3","gravatar_id":"","url":"https://api.github.com/users/gerrickw","html_url":"https://github.com/gerrickw","followers_url":"https://api.github.com/users/gerrickw/followers","following_url":"https://api.github.com/users/gerrickw/following{/other_user}","gists_url":"https://api.github.com/users/gerrickw/gists{/gist_id}","starred_url":"https://api.github.com/users/gerrickw/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gerrickw/subscriptions","organizations_url":"https://api.github.com/users/gerrickw/orgs","repos_url":"https://api.github.com/users/gerrickw/repos","events_url":"https://api.github.com/users/gerrickw/events{/privacy}","received_events_url":"https://api.github.com/users/gerrickw/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/influxdb/influxdb/milestones/42","html_url":"https://github.com/influxdb/influxdb/milestones/0.9.3","labels_url":"https://api.github.com/repos/influxdb/influxdb/milestones/42/labels","id":1172851,"number":42,"title":"0.9.3","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":6,"closed_issues":61,"state":"open","created_at":"2015-06-19T18:25:31Z","updated_at":"2015-08-25T21:51:02Z","due_on":"2015-08-20T07:00:00Z","closed_at":null},"comments":35,"created_at":"2015-08-21T00:25:32Z","updated_at":"2015-08-26T13:33:47Z","closed_at":"2015-08-25T20:27:05Z","body":"This is slightly hard to explain, but mainly data is disappearing every 10-20 minutes.  I am entering data every 10 seconds using a variety of metric names with different tags on the same field and suddenly 10-20 minutes of data will disappear.  The exception being a slight tick exactly at around the 9-14 to 20 minute mark where the 10 seconds metric is seen.  It appears when more data the interval seems to be around 10ish minutes.  20 minutes when less data.\r\n\r\nQuery:\r\nSELECT last(value) FROM \"requests\" WHERE \"colo\" = 'aaa' AND \"pool\" = 'zzz' AND \"x\" = '001' AND \"y\" = '001' and time > now() - 10m GROUP BY time(10s)\r\n\r\nThis query will show:\r\n2015-08-20T23:42:20Z\t1183\r\n2015-08-20T23:42:30Z\t1071\r\n2015-08-20T23:42:40Z\t993\r\n2015-08-20T23:42:50Z \t 1002\r\n2015-08-20T23:43:00Z \t 1083\r\n2015-08-20T23:43:10Z\t  1044\r\n2015-08-20T23:43:20Z\t 1029\r\n2015-08-20T23:43:30Z\t  1099\r\n2015-08-20T23:43:40Z\t  1102\r\n2015-08-20T23:43:50Z\t  1054\r\n... 10 minutes later\r\n\r\n015-08-20T23:42:20Z\r\n2015-08-20T23:42:30Z\r\n2015-08-20T23:42:40Z\r\n2015-08-20T23:42:50Z\r\n2015-08-20T23:43:00Z\t1083\r\n2015-08-20T23:43:10Z\r\n2015-08-20T23:43:20Z\r\n2015-08-20T23:43:30Z\r\n2015-08-20T23:43:40Z\r\n2015-08-20T23:43:50Z\r\n...\r\n2015-08-20T23:54:40Z\r\n2015-08-20T23:54:50Z\r\n2015-08-20T23:55:00Z\r\n2015-08-20T23:55:10Z \t976\r\n2015-08-20T23:55:20Z\t1103\r\n2015-08-20T23:55:30Z\t1030\r\n2015-08-20T23:55:40Z\t1087\r\n2015-08-20T23:55:50Z\t956\r\n2015-08-20T23:56:00Z\r\n\r\nSHOW RETENTION POLICIES ON db\r\nname\tduration\treplicaN\tdefault\r\ndefault\t\"0\"\t1\ttrue\r\n\r\nExample of inputs: \r\n - This format will be used on all servers with different names of latency/requests/networking/etc\r\n - During a 10 second period all metrics will be pulled and reported.  So the same int epochs for all metrics every 10s.\r\n\r\nrequests,colo=aaa,pool=zzz,prehostname=server-,x=021,y=027 value=1003 1440114198\r\nrequests,colo=aaa,pool=zzz,prehostname=server-,x=021,y=028 value=906 1440114198\r\nrequests,colo=aaa,pool=zzz,prehostname=server-,x=021,y=029 value=1151 1440114198\r\nrequests,colo=aaa,pool=zzz,prehostname=server-,x=021,y=030 value=1009 1440114198\r\nrequests,colo=aaa,pool=zzz,prehostname=server-,x=021,y=031 value=1001 1440114198\r\nrequests,colo=aaa,pool=zzz,prehostname=server-,x=021,y=032 value=1108 1440114198\r\n\r\nA few notes:\r\n - This was happening on rc1, wiped completely and installed latest master today, but is still happening.\r\n - Config is default.\r\n - Confirmed isn't on my client side making sure I am not overwriting the value.\r\n\r\nExample of one of the pool of servers from grafana (10 seconds metrics were reported and shown when earlier in the time period):\r\n![example-of-datapoints](https://cloud.githubusercontent.com/assets/656611/9398728/3884156e-475f-11e5-9ae5-72779479ed3f.png)\r\n\r\nAs a note, I confirmed this isn't a grafana issue as the same happens when querying with the query above.\r\n\r\nLet me know if more needs to be known.  Hard to know where to start explaining."},"comment":{"url":"https://api.github.com/repos/influxdb/influxdb/issues/comments/135022385","html_url":"https://github.com/influxdb/influxdb/issues/3781#issuecomment-135022385","issue_url":"https://api.github.com/repos/influxdb/influxdb/issues/3781","id":135022385,"user":{"login":"s1m0","id":9857995,"avatar_url":"https://avatars.githubusercontent.com/u/9857995?v=3","gravatar_id":"","url":"https://api.github.com/users/s1m0","html_url":"https://github.com/s1m0","followers_url":"https://api.github.com/users/s1m0/followers","following_url":"https://api.github.com/users/s1m0/following{/other_user}","gists_url":"https://api.github.com/users/s1m0/gists{/gist_id}","starred_url":"https://api.github.com/users/s1m0/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/s1m0/subscriptions","organizations_url":"https://api.github.com/users/s1m0/orgs","repos_url":"https://api.github.com/users/s1m0/repos","events_url":"https://api.github.com/users/s1m0/events{/privacy}","received_events_url":"https://api.github.com/users/s1m0/received_events","type":"User","site_admin":false},"created_at":"2015-08-26T13:33:47Z","updated_at":"2015-08-26T13:33:47Z","body":"Installed rc3 last night. Checked various measurements and found data that had been missing has reappeared so there was no data loss which is good news. Thanks for the quick fix!"}}