{"action":"created","issue":{"url":"https://api.github.com/repos/influxdb/influxdb/issues/4212","labels_url":"https://api.github.com/repos/influxdb/influxdb/issues/4212/labels{/name}","comments_url":"https://api.github.com/repos/influxdb/influxdb/issues/4212/comments","events_url":"https://api.github.com/repos/influxdb/influxdb/issues/4212/events","html_url":"https://github.com/influxdb/influxdb/issues/4212","id":108046709,"number":4212,"title":"[0.9.5-nightly-952f1d5] not all nodes have measurements in _internal database","user":{"login":"ecables","id":5559459,"avatar_url":"https://avatars.githubusercontent.com/u/5559459?v=3","gravatar_id":"","url":"https://api.github.com/users/ecables","html_url":"https://github.com/ecables","followers_url":"https://api.github.com/users/ecables/followers","following_url":"https://api.github.com/users/ecables/following{/other_user}","gists_url":"https://api.github.com/users/ecables/gists{/gist_id}","starred_url":"https://api.github.com/users/ecables/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ecables/subscriptions","organizations_url":"https://api.github.com/users/ecables/orgs","repos_url":"https://api.github.com/users/ecables/repos","events_url":"https://api.github.com/users/ecables/events{/privacy}","received_events_url":"https://api.github.com/users/ecables/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":18,"created_at":"2015-09-24T02:57:39Z","updated_at":"2015-10-03T04:49:48Z","closed_at":null,"body":"Just upgraded to 0.9.5-nightly-952f1d5, and I noticed that only one of the nodes has measurements in the _internal database.\r\n\r\ndb1:\r\n```\r\n$ /opt/influxdb/influx\r\nConnected to http://localhost:8086 version 0.9.5-nightly-952f1d5\r\nInfluxDB shell 0.9.5-nightly-952f1d5\r\n> use _internal\r\nUsing database _internal\r\n> show measurements\r\nname: measurements\r\n------------------\r\nname\r\ncluster\r\nengine\r\nhttpd\r\nruntime\r\nshard\r\nwal\r\n\r\n> SELECT mean(write_req) FROM monitor.httpd WHERE time > now() - 15m GROUP BY time(60s),hostname\r\nname: httpd\r\ntags: hostname=db1\r\ntime\t\t\tmean\r\n----\t\t\t----\r\n1443062340000000000\t605\r\n1443062400000000000\t606.8333333333334\r\n1443062460000000000\t611.3333333333334\r\n1443062520000000000\t613.5\r\n1443062580000000000\t618.1666666666666\r\n1443062640000000000\t620\r\n1443062700000000000\t626.1666666666666\r\n1443062760000000000\t630.8333333333334\r\n1443062820000000000\t633.3333333333334\r\n1443062880000000000\t637.6666666666666\r\n1443062940000000000\t640.8333333333334\r\n1443063000000000000\t642.3333333333334\r\n1443063060000000000\t645\r\n1443063120000000000\t647\r\n1443063180000000000\t651\r\n1443063240000000000\t655\r\n\r\n>\r\n```\r\n\r\ndb2:\r\n```\r\n$ /opt/influxdb/influx\r\nConnected to http://localhost:8086 version 0.9.5-nightly-952f1d5\r\nInfluxDB shell 0.9.5-nightly-952f1d5\r\n> use _internal\r\nUsing database _internal\r\n> SELECT mean(write_req) FROM monitor.httpd WHERE time > now() - 15m GROUP BY time(60s),hostname\r\n> show measurements\r\n>\r\n```\r\n\r\ndb3:\r\n```\r\n$ /opt/influxdb/influx\r\nConnected to http://localhost:8086 version 0.9.5-nightly-952f1d5\r\nInfluxDB shell 0.9.5-nightly-952f1d5\r\n> use _internal\r\nUsing database _internal\r\n> SELECT mean(write_req) FROM monitor.httpd WHERE time > now() - 15m GROUP BY time(60s),hostname\r\n> show measurements\r\n>\r\n```"},"comment":{"url":"https://api.github.com/repos/influxdb/influxdb/issues/comments/145200367","html_url":"https://github.com/influxdb/influxdb/issues/4212#issuecomment-145200367","issue_url":"https://api.github.com/repos/influxdb/influxdb/issues/4212","id":145200367,"user":{"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},"created_at":"2015-10-03T04:49:48Z","updated_at":"2015-10-03T04:49:48Z","body":"It may be related to the extra nodes on the cluster, which will hopefully be cleaned up by https://github.com/influxdb/influxdb/pull/4310"}}