{"action":"created","issue":{"url":"https://api.github.com/repos/influxdata/influxdb/issues/6632","repository_url":"https://api.github.com/repos/influxdata/influxdb","labels_url":"https://api.github.com/repos/influxdata/influxdb/issues/6632/labels{/name}","comments_url":"https://api.github.com/repos/influxdata/influxdb/issues/6632/comments","events_url":"https://api.github.com/repos/influxdata/influxdb/issues/6632/events","html_url":"https://github.com/influxdata/influxdb/issues/6632","id":154955392,"number":6632,"title":"0.12.2 duplicated results for a measurement, possible query or storage issue","user":{"login":"ianlutzeigen","id":18043069,"avatar_url":"https://avatars.githubusercontent.com/u/18043069?v=3","gravatar_id":"","url":"https://api.github.com/users/ianlutzeigen","html_url":"https://github.com/ianlutzeigen","followers_url":"https://api.github.com/users/ianlutzeigen/followers","following_url":"https://api.github.com/users/ianlutzeigen/following{/other_user}","gists_url":"https://api.github.com/users/ianlutzeigen/gists{/gist_id}","starred_url":"https://api.github.com/users/ianlutzeigen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ianlutzeigen/subscriptions","organizations_url":"https://api.github.com/users/ianlutzeigen/orgs","repos_url":"https://api.github.com/users/ianlutzeigen/repos","events_url":"https://api.github.com/users/ianlutzeigen/events{/privacy}","received_events_url":"https://api.github.com/users/ianlutzeigen/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":19,"created_at":"2016-05-16T03:44:23Z","updated_at":"2016-07-19T02:07:16Z","closed_at":"2016-07-19T02:07:16Z","body":"\r\n### Bug report\r\nHi All, as requested here a bug report: https://groups.google.com/forum/?utm_medium=email&utm_source=footer#!msg/influxdb/t-Cq2TYngJA/2T0ljku6BQAJ\r\n\r\nAnd with the info repeated:\r\n There are no tags associated with this measurement, so any re-writes should overwrite the existing point.\r\n\r\nI am using tags on a meta data table (measurement) which is unrelated to this measurement.\r\n\r\n\r\n```\n> show tag keys\r\nname: EIGEN_META_DATA\r\n---------------------\r\ntagKey\r\nITEM_NAME\r\n\r\nname: METADATA\r\n--------------\r\ntagKey\r\ntag\r\n```\n\r\nSo using the CliTool:\r\n\r\n```\n> SELECT * FROM \"egtesta-c1\" WHERE time > 1451606400000ms AND time < 1451649600000ms ORDER BY time LIMIT 10001\r\nname: egtesta-c1\r\n----------------\r\ntime\t\t\tstatus\tvalue_EIGAI\r\n1451610000000000000\tOK\t5.995811366641718\r\n1451610000000000000\tOK\t5.995811366641718\r\n1451613600000000000\tOK\t-2.9888508672566587\r\n1451613600000000000\tOK\t-2.9888508672566587\r\n1451617200000000000\tOK\t25.077066449318792\r\n1451617200000000000\tOK\t25.077066449318792\r\n1451620800000000000\tOK\t31.851006703756894\r\n1451620800000000000\tOK\t31.851006703756894\r\n1451624400000000000\tOK\t9.170833664095454\r\n1451624400000000000\tOK\t9.170833664095454\r\n1451628000000000000\tOK\t26.800614221779156\r\n1451628000000000000\tOK\t26.800614221779156\r\n1451631600000000000\tOK\t5.511991831356866\r\n1451631600000000000\tOK\t5.511991831356866\r\n1451635200000000000\tOK\t-21.149676035207094\r\n1451635200000000000\tOK\t-21.149676035207094\r\n1451638800000000000\tOK\t-13.184388185819813\r\n1451638800000000000\tOK\t-13.184388185819813\r\n1451642400000000000\tOK\t-5.454241981957935\r\n1451642400000000000\tOK\t-5.454241981957935\r\n1451646000000000000\tOK\t-28.34448642251391\r\n1451646000000000000\tOK\t-28.34448642251391\r\n```\n\r\nNot every measurement is exhibiting this:\r\n\r\n\r```\n> SELECT * FROM generatedTag9_ANALOG limit 10\r\nname: generatedTag9_ANALOG\r\n--------------------------\r\ntime\t\t\tstatus\tvalue_EIGAI\r\n1451602800000000000\tOK\t91.63689704262038\r\n1451602805000000000\tOK\t91.62940625834233\r\n1451602810000000000\tOK\t91.62244134904466\r\n1451602815000000000\tOK\t91.61600244732924\r\n1451602820000000000\tOK\t91.61008967578343\r\n1451602825000000000\tOK\t91.6047031469779\r\n1451602830000000000\tOK\t91.5998429634644\r\n1451602835000000000\tOK\t91.59550921777381\r\n```\n\r\nI am wondering if there is crosstalk between databases created in influx? I have definitely seen measurements show up on the Internal database (not on this version, yet), and disappear again.\r\n\r\n\r\nI have made a backup of the data files (just copying .influxdb folder (I'm on OSX)) to another location); I will shortly blow this db away  (upgrade to v13?) (duplicates break our api), but I have a backup should you need it for diagnosis.\r\n\r\nCheers!\r\nIan\r"},"comment":{"url":"https://api.github.com/repos/influxdata/influxdb/issues/comments/233511319","html_url":"https://github.com/influxdata/influxdb/issues/6632#issuecomment-233511319","issue_url":"https://api.github.com/repos/influxdata/influxdb/issues/6632","id":233511319,"user":{"login":"jwilder","id":219935,"avatar_url":"https://avatars.githubusercontent.com/u/219935?v=3","gravatar_id":"","url":"https://api.github.com/users/jwilder","html_url":"https://github.com/jwilder","followers_url":"https://api.github.com/users/jwilder/followers","following_url":"https://api.github.com/users/jwilder/following{/other_user}","gists_url":"https://api.github.com/users/jwilder/gists{/gist_id}","starred_url":"https://api.github.com/users/jwilder/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jwilder/subscriptions","organizations_url":"https://api.github.com/users/jwilder/orgs","repos_url":"https://api.github.com/users/jwilder/repos","events_url":"https://api.github.com/users/jwilder/events{/privacy}","received_events_url":"https://api.github.com/users/jwilder/received_events","type":"User","site_admin":false},"created_at":"2016-07-19T02:07:16Z","updated_at":"2016-07-19T02:07:16Z","body":"Duplicate of #6946"}}
{"actor":{"display_login":"jwilder"}}