payload: {"action":"created","issue":{"url":"https://api.github.com/repos/cockroachdb/cockroach/issues/36904","repository_url":"https://api.github.com/repos/cockroachdb/cockroach","labels_url":"https://api.github.com/repos/cockroachdb/cockroach/issues/36904/labels{/name}","comments_url":"https://api.github.com/repos/cockroachdb/cockroach/issues/36904/comments","events_url":"https://api.github.com/repos/cockroachdb/cockroach/issues/36904/events","html_url":"https://github.com/cockroachdb/cockroach/issues/36904","id":434240737,"node_id":"MDU6SXNzdWU0MzQyNDA3Mzc=","number":36904,"title":"\"pq: unexpected value\" error during INSERT","user":{"login":"chessman","id":781558,"node_id":"MDQ6VXNlcjc4MTU1OA==","avatar_url":"https://avatars1.githubusercontent.com/u/781558?v=4","gravatar_id":"","url":"https://api.github.com/users/chessman","html_url":"https://github.com/chessman","followers_url":"https://api.github.com/users/chessman/followers","following_url":"https://api.github.com/users/chessman/following{/other_user}","gists_url":"https://api.github.com/users/chessman/gists{/gist_id}","starred_url":"https://api.github.com/users/chessman/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/chessman/subscriptions","organizations_url":"https://api.github.com/users/chessman/orgs","repos_url":"https://api.github.com/users/chessman/repos","events_url":"https://api.github.com/users/chessman/events{/privacy}","received_events_url":"https://api.github.com/users/chessman/received_events","type":"User","site_admin":false},"labels":[{"id":78928345,"node_id":"MDU6TGFiZWw3ODkyODM0NQ==","url":"https://api.github.com/repos/cockroachdb/cockroach/labels/C-bug","name":"C-bug","color":"c5def5","default":false},{"id":1063639517,"node_id":"MDU6TGFiZWwxMDYzNjM5NTE3","url":"https://api.github.com/repos/cockroachdb/cockroach/labels/S-3","name":"S-3","color":"f07700","default":false}],"state":"open","locked":false,"assignee":{"login":"mjibson","id":41181,"node_id":"MDQ6VXNlcjQxMTgx","avatar_url":"https://avatars1.githubusercontent.com/u/41181?v=4","gravatar_id":"","url":"https://api.github.com/users/mjibson","html_url":"https://github.com/mjibson","followers_url":"https://api.github.com/users/mjibson/followers","following_url":"https://api.github.com/users/mjibson/following{/other_user}","gists_url":"https://api.github.com/users/mjibson/gists{/gist_id}","starred_url":"https://api.github.com/users/mjibson/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mjibson/subscriptions","organizations_url":"https://api.github.com/users/mjibson/orgs","repos_url":"https://api.github.com/users/mjibson/repos","events_url":"https://api.github.com/users/mjibson/events{/privacy}","received_events_url":"https://api.github.com/users/mjibson/received_events","type":"User","site_admin":false},"assignees":[{"login":"mjibson","id":41181,"node_id":"MDQ6VXNlcjQxMTgx","avatar_url":"https://avatars1.githubusercontent.com/u/41181?v=4","gravatar_id":"","url":"https://api.github.com/users/mjibson","html_url":"https://github.com/mjibson","followers_url":"https://api.github.com/users/mjibson/followers","following_url":"https://api.github.com/users/mjibson/following{/other_user}","gists_url":"https://api.github.com/users/mjibson/gists{/gist_id}","starred_url":"https://api.github.com/users/mjibson/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mjibson/subscriptions","organizations_url":"https://api.github.com/users/mjibson/orgs","repos_url":"https://api.github.com/users/mjibson/repos","events_url":"https://api.github.com/users/mjibson/events{/privacy}","received_events_url":"https://api.github.com/users/mjibson/received_events","type":"User","site_admin":false}],"milestone":null,"comments":3,"created_at":"2019-04-17T11:52:00Z","updated_at":"2019-06-03T18:15:53Z","closed_at":null,"author_association":"NONE","body":"**Describe the problem**\r\n\r\nI've got a strange error after INSERT:\r\n\r\n```\r\npq: unexpected value: raw_bytes:\"\\354\\332Yn\\003\\022mid:a9560f5fcf7da89c485087b1e2a81c1d\\000\\001C\\332\\207\\200\\200\\020\\023\\000\\030\\250\\266\\265\\313\\013\\340\\341\\203\\257\\007\\023\\000\\037\\017\\010 \\000\\000\\000\\000\\000\\000\\000\" timestamp:<wall_time:1555475860990640712 logical:1 >\r\n```\r\n\r\nIt happened once and I couldn't reproduce it.\r\n\r\n**To Reproduce**\r\n\r\nI had concurrent INSERTs and a unique constraint that usually returns `unique_violation` that I handle.\r\n\r\n**Expected behavior**\r\n\r\nThe error should be more meaningful. \r\n\r\n**Additional data / screenshots**\r\n\r\n```\r\nCREATE TABLE IF NOT EXISTS fs_dirents (\r\n\t\"id\" VARCHAR PRIMARY KEY ,\r\n\t\"x0\" VARCHAR NOT NULL ,\r\n\t\"parent_id\" VARCHAR REFERENCES fs_dirents (id) ,\r\n\t\"x1\" BIGINT NOT NULL ,\r\n\t\"x2\" BIGINT NOT NULL ,\r\n\t\"x3\" TIMESTAMP WITH TIME ZONE NOT NULL ,\r\n\t\"x4\" BIGINT NOT NULL ,\r\n\t\"x5\" JSONB ,\r\n\t\"x6\" VARCHAR NOT NULL ,\r\n\t\"x7\" VARCHAR NOT NULL ,\r\n\t\"x8\" BIGINT NOT NULL DEFAULT 0 ,\r\n\t\"x9\" BIGINT NOT NULL DEFAULT 0 ,\r\n\t\"x10\" BIGINT NOT NULL DEFAULT 0 ,\r\n\t\"x11\" BOOLEAN NOT NULL DEFAULT false ,\r\n\t\"x12\" TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT now() ,\r\n\tFAMILY f1 (id, x8, x9, x10, x11, x12),\r\n\tFAMILY f2 (x0, parent_id, x1, x2, x3, x4, x5, x6, x7));\r\nCREATE UNIQUE INDEX ON fs_dirents (parent_id, x0, x6) STORING (x1, x2, x3, x4, x5);\r\nCREATE INDEX ON fs_dirents (x7, x6, x11)\r\n\r\nINSERT INTO fs_dirents (x4,x3,id,x5,x1,x0,parent_id,x2,x6,x8,x7) VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11)\r\n```\r\n\r\n**Environment:**\r\n\r\n3 on-premise servers, cockroaches are in Docker containers.\r\n\r\n - CockroachDB version: 2.1.6\r\n - Server OS: CentOS 7\r\n - Client app: Golang database/sql"},"comment":{"url":"https://api.github.com/repos/cockroachdb/cockroach/issues/comments/498367971","html_url":"https://github.com/cockroachdb/cockroach/issues/36904#issuecomment-498367971","issue_url":"https://api.github.com/repos/cockroachdb/cockroach/issues/36904","id":498367971,"node_id":"MDEyOklzc3VlQ29tbWVudDQ5ODM2Nzk3MQ==","user":{"login":"mjibson","id":41181,"node_id":"MDQ6VXNlcjQxMTgx","avatar_url":"https://avatars1.githubusercontent.com/u/41181?v=4","gravatar_id":"","url":"https://api.github.com/users/mjibson","html_url":"https://github.com/mjibson","followers_url":"https://api.github.com/users/mjibson/followers","following_url":"https://api.github.com/users/mjibson/following{/other_user}","gists_url":"https://api.github.com/users/mjibson/gists{/gist_id}","starred_url":"https://api.github.com/users/mjibson/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mjibson/subscriptions","organizations_url":"https://api.github.com/users/mjibson/orgs","repos_url":"https://api.github.com/users/mjibson/repos","events_url":"https://api.github.com/users/mjibson/events{/privacy}","received_events_url":"https://api.github.com/users/mjibson/received_events","type":"User","site_admin":false},"created_at":"2019-06-03T18:15:53Z","updated_at":"2019-06-03T18:15:53Z","author_association":"MEMBER","body":"I wasn't able to find out anything more than described above: that this seems to be a case where an error wasn't wrapped correctly, but the error is expected. Maybe there's an error return code path that doesn't go through `ConvertBatchError`. In any case, I'm moving this to our backlog until it shows up more or is reproducible."}}
other: {"actor":{"display_login":"mjibson"}}