{"action":"created","issue":{"url":"https://api.github.com/repos/influxdata/influxdb/issues/5507","repository_url":"https://api.github.com/repos/influxdata/influxdb","labels_url":"https://api.github.com/repos/influxdata/influxdb/issues/5507/labels{/name}","comments_url":"https://api.github.com/repos/influxdata/influxdb/issues/5507/comments","events_url":"https://api.github.com/repos/influxdata/influxdb/issues/5507/events","html_url":"https://github.com/influxdata/influxdb/issues/5507","id":130652233,"number":5507,"title":"[0.10.0-nightly] Derivatives grouped by time broken","user":{"login":"kjeacle","id":17023874,"avatar_url":"https://avatars.githubusercontent.com/u/17023874?v=3","gravatar_id":"","url":"https://api.github.com/users/kjeacle","html_url":"https://github.com/kjeacle","followers_url":"https://api.github.com/users/kjeacle/followers","following_url":"https://api.github.com/users/kjeacle/following{/other_user}","gists_url":"https://api.github.com/users/kjeacle/gists{/gist_id}","starred_url":"https://api.github.com/users/kjeacle/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kjeacle/subscriptions","organizations_url":"https://api.github.com/users/kjeacle/orgs","repos_url":"https://api.github.com/users/kjeacle/repos","events_url":"https://api.github.com/users/kjeacle/events{/privacy}","received_events_url":"https://api.github.com/users/kjeacle/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2016-02-02T11:18:41Z","updated_at":"2016-02-03T15:02:39Z","closed_at":null,"body":"In recent v0.10.0 nightly builds, querying derivatives grouped by time returns no results. This was working in early v0.10.0 builds but stopped somewhere around the first beta release.\r\n\r\nCurrently running 0.10.0.n1454400035-0 with TSM installed from dpkg -i influxdb_nightly_amd64.deb on Ubuntu server 15.10.\r\n\r\nDERIVATIVE queries work, and GROUP BY TIME queries work, but not together.\r\n\r\n```\r\n> select derivative(max(value)) from snmp_rx where host = 'router.domain.name' and type_instance = '1342177290' and time > now() - 6h GROUP by time(1h)\r\nname: snmp_rx\r\n-------------\r\ntime                    derivative\r\n1454389200000000000\r\n1454392800000000000\r\n1454396400000000000\r\n1454400000000000000\r\n1454403600000000000\r\n1454407200000000000\r\n```\r\n\r\nThe above query should return derivative values for the last six hours but returns nothing. The database is being populated by collectd. No changes on the collectd side or on the queries. The output stopped after an upgrade to a recently nightly."},"comment":{"url":"https://api.github.com/repos/influxdata/influxdb/issues/comments/179279888","html_url":"https://github.com/influxdata/influxdb/issues/5507#issuecomment-179279888","issue_url":"https://api.github.com/repos/influxdata/influxdb/issues/5507","id":179279888,"user":{"login":"rossmcdonald","id":4060903,"avatar_url":"https://avatars.githubusercontent.com/u/4060903?v=3","gravatar_id":"","url":"https://api.github.com/users/rossmcdonald","html_url":"https://github.com/rossmcdonald","followers_url":"https://api.github.com/users/rossmcdonald/followers","following_url":"https://api.github.com/users/rossmcdonald/following{/other_user}","gists_url":"https://api.github.com/users/rossmcdonald/gists{/gist_id}","starred_url":"https://api.github.com/users/rossmcdonald/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rossmcdonald/subscriptions","organizations_url":"https://api.github.com/users/rossmcdonald/orgs","repos_url":"https://api.github.com/users/rossmcdonald/repos","events_url":"https://api.github.com/users/rossmcdonald/events{/privacy}","received_events_url":"https://api.github.com/users/rossmcdonald/received_events","type":"User","site_admin":false},"created_at":"2016-02-03T15:02:39Z","updated_at":"2016-02-03T15:02:39Z","body":"@kjeacle Regarding:\r\n\r\n> what's the best option for collecting data from now on?\r\n\r\nThis was caused by a broken upgrade path that made it into one of the nightlies. In the cases we've seen, switching the ID back to 1 resolves the issue, though. Can you send us the output from a `SHOW SERVERS` run on this instance when the node ID is set to 3?\r\n\r\n@jwilder Do you have any ideas on a fix here?"}}