{"action":"created","issue":{"url":"https://api.github.com/repos/cockroachdb/cockroach/issues/30947","repository_url":"https://api.github.com/repos/cockroachdb/cockroach","labels_url":"https://api.github.com/repos/cockroachdb/cockroach/issues/30947/labels{/name}","comments_url":"https://api.github.com/repos/cockroachdb/cockroach/issues/30947/comments","events_url":"https://api.github.com/repos/cockroachdb/cockroach/issues/30947/events","html_url":"https://github.com/cockroachdb/cockroach/issues/30947","id":366631437,"node_id":"MDU6SXNzdWUzNjY2MzE0Mzc=","number":30947,"title":"workload: new foreign key definition incompatible with existing fixtures","user":{"login":"cockroach-teamcity","id":20559710,"node_id":"MDQ6VXNlcjIwNTU5NzEw","avatar_url":"https://avatars0.githubusercontent.com/u/20559710?v=4","gravatar_id":"","url":"https://api.github.com/users/cockroach-teamcity","html_url":"https://github.com/cockroach-teamcity","followers_url":"https://api.github.com/users/cockroach-teamcity/followers","following_url":"https://api.github.com/users/cockroach-teamcity/following{/other_user}","gists_url":"https://api.github.com/users/cockroach-teamcity/gists{/gist_id}","starred_url":"https://api.github.com/users/cockroach-teamcity/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cockroach-teamcity/subscriptions","organizations_url":"https://api.github.com/users/cockroach-teamcity/orgs","repos_url":"https://api.github.com/users/cockroach-teamcity/repos","events_url":"https://api.github.com/users/cockroach-teamcity/events{/privacy}","received_events_url":"https://api.github.com/users/cockroach-teamcity/received_events","type":"User","site_admin":false},"labels":[{"id":914190256,"node_id":"MDU6TGFiZWw5MTQxOTAyNTY=","url":"https://api.github.com/repos/cockroachdb/cockroach/labels/A-testing","name":"A-testing","color":"37cea3","default":false},{"id":191587409,"node_id":"MDU6TGFiZWwxOTE1ODc0MDk=","url":"https://api.github.com/repos/cockroachdb/cockroach/labels/C-test-failure","name":"C-test-failure","color":"c5def5","default":false},{"id":335217860,"node_id":"MDU6TGFiZWwzMzUyMTc4NjA=","url":"https://api.github.com/repos/cockroachdb/cockroach/labels/O-robot","name":"O-robot","color":"666ad1","default":false}],"state":"open","locked":false,"assignee":{"login":"nvanbenschoten","id":5438456,"node_id":"MDQ6VXNlcjU0Mzg0NTY=","avatar_url":"https://avatars3.githubusercontent.com/u/5438456?v=4","gravatar_id":"","url":"https://api.github.com/users/nvanbenschoten","html_url":"https://github.com/nvanbenschoten","followers_url":"https://api.github.com/users/nvanbenschoten/followers","following_url":"https://api.github.com/users/nvanbenschoten/following{/other_user}","gists_url":"https://api.github.com/users/nvanbenschoten/gists{/gist_id}","starred_url":"https://api.github.com/users/nvanbenschoten/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nvanbenschoten/subscriptions","organizations_url":"https://api.github.com/users/nvanbenschoten/orgs","repos_url":"https://api.github.com/users/nvanbenschoten/repos","events_url":"https://api.github.com/users/nvanbenschoten/events{/privacy}","received_events_url":"https://api.github.com/users/nvanbenschoten/received_events","type":"User","site_admin":false},"assignees":[{"login":"nvanbenschoten","id":5438456,"node_id":"MDQ6VXNlcjU0Mzg0NTY=","avatar_url":"https://avatars3.githubusercontent.com/u/5438456?v=4","gravatar_id":"","url":"https://api.github.com/users/nvanbenschoten","html_url":"https://github.com/nvanbenschoten","followers_url":"https://api.github.com/users/nvanbenschoten/followers","following_url":"https://api.github.com/users/nvanbenschoten/following{/other_user}","gists_url":"https://api.github.com/users/nvanbenschoten/gists{/gist_id}","starred_url":"https://api.github.com/users/nvanbenschoten/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nvanbenschoten/subscriptions","organizations_url":"https://api.github.com/users/nvanbenschoten/orgs","repos_url":"https://api.github.com/users/nvanbenschoten/repos","events_url":"https://api.github.com/users/nvanbenschoten/events{/privacy}","received_events_url":"https://api.github.com/users/nvanbenschoten/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/cockroachdb/cockroach/milestones/17","html_url":"https://github.com/cockroachdb/cockroach/milestone/17","labels_url":"https://api.github.com/repos/cockroachdb/cockroach/milestones/17/labels","id":3492386,"node_id":"MDk6TWlsZXN0b25lMzQ5MjM4Ng==","number":17,"title":"2.2","description":"","creator":{"login":"petermattis","id":6201335,"node_id":"MDQ6VXNlcjYyMDEzMzU=","avatar_url":"https://avatars0.githubusercontent.com/u/6201335?v=4","gravatar_id":"","url":"https://api.github.com/users/petermattis","html_url":"https://github.com/petermattis","followers_url":"https://api.github.com/users/petermattis/followers","following_url":"https://api.github.com/users/petermattis/following{/other_user}","gists_url":"https://api.github.com/users/petermattis/gists{/gist_id}","starred_url":"https://api.github.com/users/petermattis/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/petermattis/subscriptions","organizations_url":"https://api.github.com/users/petermattis/orgs","repos_url":"https://api.github.com/users/petermattis/repos","events_url":"https://api.github.com/users/petermattis/events{/privacy}","received_events_url":"https://api.github.com/users/petermattis/received_events","type":"User","site_admin":false},"open_issues":323,"closed_issues":259,"state":"open","created_at":"2018-07-12T18:50:47Z","updated_at":"2018-10-04T15:37:51Z","due_on":null,"closed_at":null},"comments":4,"created_at":"2018-10-04T05:48:55Z","updated_at":"2018-10-04T15:44:41Z","closed_at":null,"author_association":"MEMBER","body":"SHA: https://github.com/cockroachdb/cockroach/commits/6a236533824c797948eaddbd6bedf5e12eee1a13\n\nParameters:\n\nTo repro, try:\n\n```\n# Don't forget to check out a clean suitable branch and experiment with the\n# stress invocation until the desired results present themselves. For example,\n# using stressrace instead of stress and passing the '-p' stressflag which\n# controls concurrency.\n./scripts/gceworker.sh start && ./scripts/gceworker.sh mosh\ncd ~/go/src/github.com/cockroachdb/cockroach && \\\nmake stress TESTS=cancel/tpcc/local/w=10,nodes=3 PKG=roachtest TESTTIMEOUT=5m STRESSFLAGS='-stderr=false -maxtime 20m -timeout 10m'\n```\n\nFailed test: https://teamcity.cockroachdb.com/viewLog.html?buildId=942507&tab=buildLog\n\n```\nThe test failed on master:\n\ttest.go:500,cluster.go:897,cancel.go:50,cluster.go:1206,errgroup.go:58: /home/agent/work/.go/bin/roachprod run teamcity-942507-cancel-tpcc-local-w-10-nodes-3:1 -- ./workload fixtures load tpcc --warehouses=10 {pgurl:1} returned:\n\t\tstderr:\n\t\t\n\t\tstdout:\n\t\tindex entries, 17 MiB)\n\t\tI181004 05:46:30.041303 89 ccl/workloadccl/fixture.go:454  loaded item (42s, 100000 rows, 0 index entries, 7.8 MiB)\n\t\tI181004 05:46:30.105306 88 ccl/workloadccl/fixture.go:454  loaded new_order (42s, 90000 rows, 0 index entries, 1.1 MiB)\n\t\tI181004 05:46:34.823063 84 ccl/workloadccl/fixture.go:454  loaded district (47s, 100 rows, 0 index entries, 9.9 KiB)\n\t\tI181004 05:46:42.311833 90 ccl/workloadccl/fixture.go:454  loaded stock (54s, 1000000 rows, 1000000 index entries, 318 MiB)\n\t\tI181004 05:46:43.811248 86 ccl/workloadccl/fixture.go:454  loaded history (56s, 300000 rows, 600000 index entries, 38 MiB)\n\t\tI181004 05:46:43.823298 91 ccl/workloadccl/fixture.go:454  loaded order_line (56s, 2995549 rows, 2995549 index entries, 205 MiB)\n\t\tI181004 05:46:43.835403 85 ccl/workloadccl/fixture.go:454  loaded customer (56s, 300000 rows, 300000 index entries, 176 MiB)\n\t\tError: restoring fixture: PostLoad hook: pq: foreign key requires an existing index on columns (\"ol_supply_w_id\", \"ol_i_id\")\n\t\tError:  exit status 1\n\t\t: exit status 1\n\ttest.go:500,cluster.go:1227,cancel.go:105,cancel.go:133: Goexit() was called\n\n```"},"comment":{"url":"https://api.github.com/repos/cockroachdb/cockroach/issues/comments/427068605","html_url":"https://github.com/cockroachdb/cockroach/issues/30947#issuecomment-427068605","issue_url":"https://api.github.com/repos/cockroachdb/cockroach/issues/30947","id":427068605,"node_id":"MDEyOklzc3VlQ29tbWVudDQyNzA2ODYwNQ==","user":{"login":"danhhz","id":52528,"node_id":"MDQ6VXNlcjUyNTI4","avatar_url":"https://avatars1.githubusercontent.com/u/52528?v=4","gravatar_id":"","url":"https://api.github.com/users/danhhz","html_url":"https://github.com/danhhz","followers_url":"https://api.github.com/users/danhhz/followers","following_url":"https://api.github.com/users/danhhz/following{/other_user}","gists_url":"https://api.github.com/users/danhhz/gists{/gist_id}","starred_url":"https://api.github.com/users/danhhz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/danhhz/subscriptions","organizations_url":"https://api.github.com/users/danhhz/orgs","repos_url":"https://api.github.com/users/danhhz/repos","events_url":"https://api.github.com/users/danhhz/events{/privacy}","received_events_url":"https://api.github.com/users/danhhz/received_events","type":"User","site_admin":false},"created_at":"2018-10-04T15:44:41Z","updated_at":"2018-10-04T15:44:41Z","author_association":"CONTRIBUTOR","body":"I'm fine with any of them. If we do the second, we should stick a TODO in there to remove the logic after the next time we regenerate fixtures"}}
{"actor":{"display_login":"danhhz"}}