{"action":"closed","issue":{"url":"https://api.github.com/repos/influxdata/influxdb/issues/7262","repository_url":"https://api.github.com/repos/influxdata/influxdb","labels_url":"https://api.github.com/repos/influxdata/influxdb/issues/7262/labels{/name}","comments_url":"https://api.github.com/repos/influxdata/influxdb/issues/7262/comments","events_url":"https://api.github.com/repos/influxdata/influxdb/issues/7262/events","html_url":"https://github.com/influxdata/influxdb/issues/7262","id":175359753,"number":7262,"title":"reproducible corruption:  rows merged from 2 inserts when overwriting","user":{"login":"dylan-ferreira","id":15990432,"avatar_url":"https://avatars.githubusercontent.com/u/15990432?v=3","gravatar_id":"","url":"https://api.github.com/users/dylan-ferreira","html_url":"https://github.com/dylan-ferreira","followers_url":"https://api.github.com/users/dylan-ferreira/followers","following_url":"https://api.github.com/users/dylan-ferreira/following{/other_user}","gists_url":"https://api.github.com/users/dylan-ferreira/gists{/gist_id}","starred_url":"https://api.github.com/users/dylan-ferreira/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dylan-ferreira/subscriptions","organizations_url":"https://api.github.com/users/dylan-ferreira/orgs","repos_url":"https://api.github.com/users/dylan-ferreira/repos","events_url":"https://api.github.com/users/dylan-ferreira/events{/privacy}","received_events_url":"https://api.github.com/users/dylan-ferreira/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/influxdata/influxdb/labels/area/queries","name":"area/queries","color":"fbca04"},{"url":"https://api.github.com/repos/influxdata/influxdb/labels/area/tsm","name":"area/tsm","color":"fbca04"},{"url":"https://api.github.com/repos/influxdata/influxdb/labels/kind/bug","name":"kind/bug","color":"d93f0b"}],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":5,"created_at":"2016-09-06T21:44:36Z","updated_at":"2016-09-16T18:54:27Z","closed_at":"2016-09-16T18:54:27Z","body":"## System info:\r\nReproduced on 3 instances of InfluxDB:\r\n\r\nInfluxd: 0.13.0\r\nOS: Ubuntu Trusty 14.04\r\nSystem: 2xSSD hdd, 256GB RAM, 32 cores\r\n\r\nInfluxd: 0.13.0\r\nOS: Mac OS X 10.11.6 (15G1004)\r\nSystem: Macbook Pro 15 (Mid 2015), 16GB RAM\r\n\r\nInfluxd: 1.0.0-rc2\r\nOS: Mac OS X 10.11.6 (15G1004)\r\nSystem: Macbook Pro 15 (Mid 2015), 16GB RAM\r\n\r\n## Details:\r\n[influx_issue.zip](https://github.com/influxdata/influxdb/files/457843/influx_issue.zip)\r\n\r\nWhen inserting data (via HTTP) that collides with existing timestamps, I occasionally get rows that contain a mix of field data from multiple inserts.\r\n\r\nThe test I've put together (see attached) inserts rows in batches of 8000 with a precision of 1 second to encourage collisions.  The rows contain 3 fields:\r\n- \"batchcounter\": an number incrementing once for each 8000 sample batch I post.\r\n- \"counter1\" & \"counter2\": a per-sample incrementing number set by the same variable.\r\n\r\n```\r\nfields := map[string]interface{}{\r\n        \"batchcounter\": batchcounter,\r\n        \"counter1\":     counter,\r\n        \"counter2\":     counter,\r\n}\r\n```\r\nThe idea being \"counter1\" & \"counter2\" always match on insert and should always match in the database.\r\n\r\nWhen running the attached test concurrently (I ran 10 workers) against the same database, I find a small percentage of my resulting rows show a difference between \"counter1\" & \"counter2\".\r\n\r\nQuery: `SELECT * FROM testcounter WHERE counter1 != counter2`\r\n```\r\n{\r\n    \"results\": [\r\n        {\r\n            \"series\": [\r\n                {\r\n                    \"name\": \"testcounter\",\r\n                    \"columns\": [\r\n                        \"time\",\r\n                        \"batchcounter\",\r\n                        \"counter1\",\r\n                        \"counter2\",\r\n                        \"version\"\r\n                    ],\r\n                    \"values\": [\r\n                        [\r\n                            \"2016-09-05T19:39:34Z\",\r\n                            138,\r\n                            1263999,\r\n                            975999,\r\n                            \"0.0.1\"\r\n                        ],\r\n                        [\r\n                            \"2016-09-05T19:40:10Z\",\r\n                            320,\r\n                            2567999,\r\n                            2767999,\r\n                            \"0.0.1\"\r\n                        ],\r\n                        [\r\n                            \"2016-09-05T19:40:14Z\",\r\n                            338,\r\n                            2711999,\r\n                            2895999,\r\n                            \"0.0.1\"\r\n                        ],\r\n                        [\r\n                            \"2016-09-05T19:40:45Z\",\r\n                            512,\r\n                            4103999,\r\n                            4271999,\r\n                            \"0.0.1\"\r\n                        ],\r\n                        [\r\n                            \"2016-09-05T19:41:18Z\",\r\n                            699,\r\n                            5599999,\r\n                            5543999,\r\n                            \"0.0.1\"\r\n                        ],\r\n                        [\r\n                            \"2016-09-05T19:41:33Z\",\r\n                            757,\r\n                            6063999,\r\n                            6223999,\r\n                            \"0.0.1\"\r\n                        ],\r\n                        [\r\n                            \"2016-09-05T19:41:36Z\",\r\n                            805,\r\n                            6255999,\r\n                            6447999,\r\n                            \"0.0.1\"\r\n                        ],\r\n                        [\r\n                            \"2016-09-05T19:42:23Z\",\r\n                            1100,\r\n                            8807999,\r\n                            8751999,\r\n                            \"0.0.1\"\r\n                        ]\r\n                    ]\r\n                }\r\n            ]\r\n        }\r\n    ]\r\n```"}}
{"actor":{"display_login":"jsternberg"}}