{"action":"created","issue":{"url":"https://api.github.com/repos/influxdata/influxdb/issues/7252","repository_url":"https://api.github.com/repos/influxdata/influxdb","labels_url":"https://api.github.com/repos/influxdata/influxdb/issues/7252/labels{/name}","comments_url":"https://api.github.com/repos/influxdata/influxdb/issues/7252/comments","events_url":"https://api.github.com/repos/influxdata/influxdb/issues/7252/events","html_url":"https://github.com/influxdata/influxdb/issues/7252","id":174570422,"number":7252,"title":"partitioned results","user":{"login":"r0bj","id":1297747,"avatar_url":"https://avatars.githubusercontent.com/u/1297747?v=3","gravatar_id":"","url":"https://api.github.com/users/r0bj","html_url":"https://github.com/r0bj","followers_url":"https://api.github.com/users/r0bj/followers","following_url":"https://api.github.com/users/r0bj/following{/other_user}","gists_url":"https://api.github.com/users/r0bj/gists{/gist_id}","starred_url":"https://api.github.com/users/r0bj/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/r0bj/subscriptions","organizations_url":"https://api.github.com/users/r0bj/orgs","repos_url":"https://api.github.com/users/r0bj/repos","events_url":"https://api.github.com/users/r0bj/events{/privacy}","received_events_url":"https://api.github.com/users/r0bj/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2016-09-01T16:37:49Z","updated_at":"2016-09-01T16:58:46Z","closed_at":"2016-09-01T16:58:46Z","body":"### Bug report\r\n\r\n__System info:__\r\ninfluxdb: 1.0.0~rc1\r\nOS: ubuntu 14.04\r\n\r\n__Steps to reproduce:__\r\n\r\nhost1 data:\r\n```\r\n> SELECT last(\"used\") FROM \"mem\" WHERE \"host\" =~ /^(memcache-s1)$/ AND \"dc\" =~ /SJC$/ AND time > 1472687966s and time < 1472688024s GROUP BY time(10s), \"host\", \"dc\" fill(0)\r\n\r\nname: mem\r\ntags: dc=SJC, host=memcache-s1\r\ntime   \t\t\tlast\r\n----   \t\t\t----\r\n1472687960000000000    \t0\r\n1472687970000000000    \t25384742912\r\n1472687980000000000    \t25384648704\r\n1472687990000000000    \t25386901504\r\n1472688000000000000    \t25385308160\r\n1472688010000000000    \t25389359104\r\n1472688020000000000    \t25392300032\r\n```\r\n\r\nhost2 data:\r\n```\r\n> SELECT last(\"used\") FROM \"mem\" WHERE \"host\" =~ /^(memcache-s2)$/ AND \"dc\" =~ /SJC$/ AND time > 1472687966s and time < 1472688024s GROUP BY time(10s), \"host\", \"dc\" fill(0)\r\n\r\nname: mem\r\ntags: dc=SJC, host=memcache-s2\r\ntime   \t\t\tlast\r\n----   \t\t\t----\r\n1472687960000000000    \t0\r\n1472687970000000000    \t59788009472\r\n1472687980000000000    \t59793158144\r\n1472687990000000000    \t59789357056\r\n1472688000000000000    \t59788029952\r\n1472688010000000000    \t59787685888\r\n1472688020000000000    \t59786649600\r\n```\r\n\r\nSo far so good.\r\nBut combining those two hosts within regex I'm getting:\r\n```\r\n> SELECT last(\"used\") FROM \"mem\" WHERE \"host\" =~ /^(memcache-s1|memcache-s2)$/ AND \"dc\" =~ /SJC$/ AND time > 1472687966s and time < 1472688024s GROUP BY time(10s), \"host\", \"dc\" fill(0)\r\nname: mem\r\ntags: dc=SJC, host=memcache-s1\r\ntime   \t\t\tlast\r\n----   \t\t\t----\r\n1472687960000000000    \t0\r\n1472687970000000000    \t25384742912\r\n1472687980000000000    \t25384648704\r\n1472687990000000000    \t25386901504\r\n1472688000000000000    \t0\r\n1472688010000000000    \t0\r\n1472688020000000000    \t0\r\n\r\nname: mem\r\ntags: dc=SJC, host=memcache-s2\r\ntime   \t\t\tlast\r\n----   \t\t\t----\r\n1472687960000000000    \t0\r\n1472687970000000000    \t59788009472\r\n1472687980000000000    \t59793158144\r\n1472687990000000000    \t59789357056\r\n1472688000000000000    \t0\r\n1472688010000000000    \t0\r\n1472688020000000000    \t0\r\n\r\nname: mem\r\ntags: dc=SJC, host=memcache-s1\r\ntime   \t\t\tlast\r\n----   \t\t\t----\r\n1472687960000000000    \t0\r\n1472687970000000000    \t0\r\n1472687980000000000    \t0\r\n1472687990000000000    \t0\r\n1472688000000000000    \t25385308160\r\n1472688010000000000    \t25389359104\r\n1472688020000000000    \t25392300032\r\n\r\nname: mem\r\ntags: dc=SJC, host=memcache-s2\r\ntime   \t\t\tlast\r\n----   \t\t\t----\r\n1472687960000000000    \t0\r\n1472687970000000000    \t0\r\n1472687980000000000    \t0\r\n1472687990000000000    \t0\r\n1472688000000000000    \t59788029952\r\n1472688010000000000    \t59787685888\r\n1472688020000000000    \t59786649600\r\n```\r\n\r\nSomehow data are split into four hosts.\r\nPloting graph with those results is giving strange results as we can expect.\r\n\r\nIs there any rational explanation behind this?"},"comment":{"url":"https://api.github.com/repos/influxdata/influxdb/issues/comments/244143218","html_url":"https://github.com/influxdata/influxdb/issues/7252#issuecomment-244143218","issue_url":"https://api.github.com/repos/influxdata/influxdb/issues/7252","id":244143218,"user":{"login":"jsternberg","id":1212129,"avatar_url":"https://avatars.githubusercontent.com/u/1212129?v=3","gravatar_id":"","url":"https://api.github.com/users/jsternberg","html_url":"https://github.com/jsternberg","followers_url":"https://api.github.com/users/jsternberg/followers","following_url":"https://api.github.com/users/jsternberg/following{/other_user}","gists_url":"https://api.github.com/users/jsternberg/gists{/gist_id}","starred_url":"https://api.github.com/users/jsternberg/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jsternberg/subscriptions","organizations_url":"https://api.github.com/users/jsternberg/orgs","repos_url":"https://api.github.com/users/jsternberg/repos","events_url":"https://api.github.com/users/jsternberg/events{/privacy}","received_events_url":"https://api.github.com/users/jsternberg/received_events","type":"User","site_admin":false},"created_at":"2016-09-01T16:58:46Z","updated_at":"2016-09-01T16:58:46Z","body":"Duplicate of #7220. We reverted the change that caused this and rc2 should be fine. Thanks!"}}
{"actor":{"display_login":"jsternberg"}}