{"action":"created","comment":{"url":"https://api.github.com/repos/kubernetes/test-infra/pulls/comments/111481351","pull_request_review_id":32733046,"id":111481351,"diff_hunk":"@@ -0,0 +1,29 @@\n+#!/bin/bash\n+# Copyright 2017 The Kubernetes Authors.\n+#\n+# Licensed under the Apache License, Version 2.0 (the \"License\");\n+# you may not use this file except in compliance with the License.\n+# You may obtain a copy of the License at\n+#\n+#     http://www.apache.org/licenses/LICENSE-2.0\n+#\n+# Unless required by applicable law or agreed to in writing, software\n+# distributed under the License is distributed on an \"AS IS\" BASIS,\n+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.\n+# See the License for the specific language governing permissions and\n+# limitations under the License.\n+\n+# Usage: ./flakes.sh | tee flakes-$(date +%Y-%m-%d).json\n+# This script uses flakes.sql to find job flake data for the past week\n+# The script then filters jobs down to those which flake more than 4x/day\n+# And also notes any test in those jobs which flake more than 1x/day\n+\n+set -o pipefail\n+set -o errexit\n+set -o xtrace\n+\n+dir=\"$(dirname \"${0}\")\"","path":"experiment/bigquery/daily.sh","position":25,"original_position":25,"commit_id":"00a0d0b621d90c7d11f8f0b0c63af69a5ebda1da","original_commit_id":"00a0d0b621d90c7d11f8f0b0c63af69a5ebda1da","user":{"login":"rmmh","id":211868,"avatar_url":"https://avatars3.githubusercontent.com/u/211868?v=3","gravatar_id":"","url":"https://api.github.com/users/rmmh","html_url":"https://github.com/rmmh","followers_url":"https://api.github.com/users/rmmh/followers","following_url":"https://api.github.com/users/rmmh/following{/other_user}","gists_url":"https://api.github.com/users/rmmh/gists{/gist_id}","starred_url":"https://api.github.com/users/rmmh/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rmmh/subscriptions","organizations_url":"https://api.github.com/users/rmmh/orgs","repos_url":"https://api.github.com/users/rmmh/repos","events_url":"https://api.github.com/users/rmmh/events{/privacy}","received_events_url":"https://api.github.com/users/rmmh/received_events","type":"User","site_admin":false},"body":"simpler to just cd here","created_at":"2017-04-13T20:37:06Z","updated_at":"2017-04-13T20:37:06Z","html_url":"https://github.com/kubernetes/test-infra/pull/2472#discussion_r111481351","pull_request_url":"https://api.github.com/repos/kubernetes/test-infra/pulls/2472","_links":{"self":{"href":"https://api.github.com/repos/kubernetes/test-infra/pulls/comments/111481351"},"html":{"href":"https://github.com/kubernetes/test-infra/pull/2472#discussion_r111481351"},"pull_request":{"href":"https://api.github.com/repos/kubernetes/test-infra/pulls/2472"}}},"pull_request":{"url":"https://api.github.com/repos/kubernetes/test-infra/pulls/2472","id":115630005,"html_url":"https://github.com/kubernetes/test-infra/pull/2472","diff_url":"https://github.com/kubernetes/test-infra/pull/2472.diff","patch_url":"https://github.com/kubernetes/test-infra/pull/2472.patch","issue_url":"https://api.github.com/repos/kubernetes/test-infra/issues/2472","number":2472,"state":"open","locked":false,"title":"Update consistency stats to data from Apr 12","user":{"login":"fejta","id":940341,"avatar_url":"https://avatars1.githubusercontent.com/u/940341?v=3","gravatar_id":"","url":"https://api.github.com/users/fejta","html_url":"https://github.com/fejta","followers_url":"https://api.github.com/users/fejta/followers","following_url":"https://api.github.com/users/fejta/following{/other_user}","gists_url":"https://api.github.com/users/fejta/gists{/gist_id}","starred_url":"https://api.github.com/users/fejta/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/fejta/subscriptions","organizations_url":"https://api.github.com/users/fejta/orgs","repos_url":"https://api.github.com/users/fejta/repos","events_url":"https://api.github.com/users/fejta/events{/privacy}","received_events_url":"https://api.github.com/users/fejta/received_events","type":"User","site_admin":false},"body":"Create a `daily.sh` script to more quickly create these files.\r\n\r\nIgnore federation flakes when calculating PR consistency (remove once we make federation presubmit required)\r\n\r\nAlso create a `failures.sh` to generate the data for https://github.com/kubernetes/test-infra/issues/2453 (once we no longer have jobs that have never passed the intent is to find the jobs that have been failing the longest... which right now is forever).\r\n\r\nPS: Ryan I'm using `/* comment */` because vim recognizes this comment style and does not recognize `# comment`","created_at":"2017-04-12T20:35:00Z","updated_at":"2017-04-13T20:37:06Z","closed_at":null,"merged_at":null,"merge_commit_sha":"08efe74dc07470b5ac8a686aa489aff437c71d9d","assignee":{"login":"madhusudancs","id":10183,"avatar_url":"https://avatars3.githubusercontent.com/u/10183?v=3","gravatar_id":"","url":"https://api.github.com/users/madhusudancs","html_url":"https://github.com/madhusudancs","followers_url":"https://api.github.com/users/madhusudancs/followers","following_url":"https://api.github.com/users/madhusudancs/following{/other_user}","gists_url":"https://api.github.com/users/madhusudancs/gists{/gist_id}","starred_url":"https://api.github.com/users/madhusudancs/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/madhusudancs/subscriptions","organizations_url":"https://api.github.com/users/madhusudancs/orgs","repos_url":"https://api.github.com/users/madhusudancs/repos","events_url":"https://api.github.com/users/madhusudancs/events{/privacy}","received_events_url":"https://api.github.com/users/madhusudancs/received_events","type":"User","site_admin":false},"assignees":[{"login":"madhusudancs","id":10183,"avatar_url":"https://avatars3.githubusercontent.com/u/10183?v=3","gravatar_id":"","url":"https://api.github.com/users/madhusudancs","html_url":"https://github.com/madhusudancs","followers_url":"https://api.github.com/users/madhusudancs/followers","following_url":"https://api.github.com/users/madhusudancs/following{/other_user}","gists_url":"https://api.github.com/users/madhusudancs/gists{/gist_id}","starred_url":"https://api.github.com/users/madhusudancs/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/madhusudancs/subscriptions","organizations_url":"https://api.github.com/users/madhusudancs/orgs","repos_url":"https://api.github.com/users/madhusudancs/repos","events_url":"https://api.github.com/users/madhusudancs/events{/privacy}","received_events_url":"https://api.github.com/users/madhusudancs/received_events","type":"User","site_admin":false},{"login":"rmmh","id":211868,"avatar_url":"https://avatars3.githubusercontent.com/u/211868?v=3","gravatar_id":"","url":"https://api.github.com/users/rmmh","html_url":"https://github.com/rmmh","followers_url":"https://api.github.com/users/rmmh/followers","following_url":"https://api.github.com/users/rmmh/following{/other_user}","gists_url":"https://api.github.com/users/rmmh/gists{/gist_id}","starred_url":"https://api.github.com/users/rmmh/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rmmh/subscriptions","organizations_url":"https://api.github.com/users/rmmh/orgs","repos_url":"https://api.github.com/users/rmmh/repos","events_url":"https://api.github.com/users/rmmh/events{/privacy}","received_events_url":"https://api.github.com/users/rmmh/received_events","type":"User","site_admin":false},{"login":"cjwagner","id":5334145,"avatar_url":"https://avatars0.githubusercontent.com/u/5334145?v=3","gravatar_id":"","url":"https://api.github.com/users/cjwagner","html_url":"https://github.com/cjwagner","followers_url":"https://api.github.com/users/cjwagner/followers","following_url":"https://api.github.com/users/cjwagner/following{/other_user}","gists_url":"https://api.github.com/users/cjwagner/gists{/gist_id}","starred_url":"https://api.github.com/users/cjwagner/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cjwagner/subscriptions","organizations_url":"https://api.github.com/users/cjwagner/orgs","repos_url":"https://api.github.com/users/cjwagner/repos","events_url":"https://api.github.com/users/cjwagner/events{/privacy}","received_events_url":"https://api.github.com/users/cjwagner/received_events","type":"User","site_admin":false}],"milestone":null,"commits_url":"https://api.github.com/repos/kubernetes/test-infra/pulls/2472/commits","review_comments_url":"https://api.github.com/repos/kubernetes/test-infra/pulls/2472/comments","review_comment_url":"https://api.github.com/repos/kubernetes/test-infra/pulls/comments{/number}","comments_url":"https://api.github.com/repos/kubernetes/test-infra/issues/2472/comments","statuses_url":"https://api.github.com/repos/kubernetes/test-infra/statuses/00a0d0b621d90c7d11f8f0b0c63af69a5ebda1da","head":{"label":"fejta:sql","ref":"sql","sha":"00a0d0b621d90c7d11f8f0b0c63af69a5ebda1da","user":{"login":"fejta","id":940341,"avatar_url":"https://avatars1.githubusercontent.com/u/940341?v=3","gravatar_id":"","url":"https://api.github.com/users/fejta","html_url":"https://github.com/fejta","followers_url":"https://api.github.com/users/fejta/followers","following_url":"https://api.github.com/users/fejta/following{/other_user}","gists_url":"https://api.github.com/users/fejta/gists{/gist_id}","starred_url":"https://api.github.com/users/fejta/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/fejta/subscriptions","organizations_url":"https://api.github.com/users/fejta/orgs","repos_url":"https://api.github.com/users/fejta/repos","events_url":"https://api.github.com/users/fejta/events{/privacy}","received_events_url":"https://api.github.com/users/fejta/received_events","type":"User","site_admin":false},"repo":{"id":59241934,"name":"test-infra","full_name":"fejta/test-infra","owner":{"login":"fejta","id":940341,"avatar_url":"https://avatars1.githubusercontent.com/u/940341?v=3","gravatar_id":"","url":"https://api.github.com/users/fejta","html_url":"https://github.com/fejta","followers_url":"https://api.github.com/users/fejta/followers","following_url":"https://api.github.com/users/fejta/following{/other_user}","gists_url":"https://api.github.com/users/fejta/gists{/gist_id}","starred_url":"https://api.github.com/users/fejta/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/fejta/subscriptions","organizations_url":"https://api.github.com/users/fejta/orgs","repos_url":"https://api.github.com/users/fejta/repos","events_url":"https://api.github.com/users/fejta/events{/privacy}","received_events_url":"https://api.github.com/users/fejta/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/fejta/test-infra","description":"Test infrastructure for the Kubernetes project.","fork":true,"url":"https://api.github.com/repos/fejta/test-infra","forks_url":"https://api.github.com/repos/fejta/test-infra/forks","keys_url":"https://api.github.com/repos/fejta/test-infra/keys{/key_id}","collaborators_url":"https://api.github.com/repos/fejta/test-infra/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/fejta/test-infra/teams","hooks_url":"https://api.github.com/repos/fejta/test-infra/hooks","issue_events_url":"https://api.github.com/repos/fejta/test-infra/issues/events{/number}","events_url":"https://api.github.com/repos/fejta/test-infra/events","assignees_url":"https://api.github.com/repos/fejta/test-infra/assignees{/user}","branches_url":"https://api.github.com/repos/fejta/test-infra/branches{/branch}","tags_url":"https://api.github.com/repos/fejta/test-infra/tags","blobs_url":"https://api.github.com/repos/fejta/test-infra/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/fejta/test-infra/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/fejta/test-infra/git/refs{/sha}","trees_url":"https://api.github.com/repos/fejta/test-infra/git/trees{/sha}","statuses_url":"https://api.github.com/repos/fejta/test-infra/statuses/{sha}","languages_url":"https://api.github.com/repos/fejta/test-infra/languages","stargazers_url":"https://api.github.com/repos/fejta/test-infra/stargazers","contributors_url":"https://api.github.com/repos/fejta/test-infra/contributors","subscribers_url":"https://api.github.com/repos/fejta/test-infra/subscribers","subscription_url":"https://api.github.com/repos/fejta/test-infra/subscription","commits_url":"https://api.github.com/repos/fejta/test-infra/commits{/sha}","git_commits_url":"https://api.github.com/repos/fejta/test-infra/git/commits{/sha}","comments_url":"https://api.github.com/repos/fejta/test-infra/comments{/number}","issue_comment_url":"https://api.github.com/repos/fejta/test-infra/issues/comments{/number}","contents_url":"https://api.github.com/repos/fejta/test-infra/contents/{+path}","compare_url":"https://api.github.com/repos/fejta/test-infra/compare/{base}...{head}","merges_url":"https://api.github.com/repos/fejta/test-infra/merges","archive_url":"https://api.github.com/repos/fejta/test-infra/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/fejta/test-infra/downloads","issues_url":"https://api.github.com/repos/fejta/test-infra/issues{/number}","pulls_url":"https://api.github.com/repos/fejta/test-infra/pulls{/number}","milestones_url":"https://api.github.com/repos/fejta/test-infra/milestones{/number}","notifications_url":"https://api.github.com/repos/fejta/test-infra/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/fejta/test-infra/labels{/name}","releases_url":"https://api.github.com/repos/fejta/test-infra/releases{/id}","deployments_url":"https://api.github.com/repos/fejta/test-infra/deployments","created_at":"2016-05-19T20:53:03Z","updated_at":"2017-01-21T20:00:13Z","pushed_at":"2017-04-13T20:30:37Z","git_url":"git://github.com/fejta/test-infra.git","ssh_url":"git@github.com:fejta/test-infra.git","clone_url":"https://github.com/fejta/test-infra.git","svn_url":"https://github.com/fejta/test-infra","homepage":null,"size":16477,"stargazers_count":0,"watchers_count":0,"language":"Go","has_issues":false,"has_projects":true,"has_downloads":true,"has_wiki":false,"has_pages":false,"forks_count":0,"mirror_url":null,"open_issues_count":0,"forks":0,"open_issues":0,"watchers":0,"default_branch":"master"}},"base":{"label":"kubernetes:master","ref":"master","sha":"cdf740a7199a087083c97b7c797ca1298b1a2f34","user":{"login":"kubernetes","id":13629408,"avatar_url":"https://avatars1.githubusercontent.com/u/13629408?v=3","gravatar_id":"","url":"https://api.github.com/users/kubernetes","html_url":"https://github.com/kubernetes","followers_url":"https://api.github.com/users/kubernetes/followers","following_url":"https://api.github.com/users/kubernetes/following{/other_user}","gists_url":"https://api.github.com/users/kubernetes/gists{/gist_id}","starred_url":"https://api.github.com/users/kubernetes/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kubernetes/subscriptions","organizations_url":"https://api.github.com/users/kubernetes/orgs","repos_url":"https://api.github.com/users/kubernetes/repos","events_url":"https://api.github.com/users/kubernetes/events{/privacy}","received_events_url":"https://api.github.com/users/kubernetes/received_events","type":"Organization","site_admin":false},"repo":{"id":57333709,"name":"test-infra","full_name":"kubernetes/test-infra","owner":{"login":"kubernetes","id":13629408,"avatar_url":"https://avatars1.githubusercontent.com/u/13629408?v=3","gravatar_id":"","url":"https://api.github.com/users/kubernetes","html_url":"https://github.com/kubernetes","followers_url":"https://api.github.com/users/kubernetes/followers","following_url":"https://api.github.com/users/kubernetes/following{/other_user}","gists_url":"https://api.github.com/users/kubernetes/gists{/gist_id}","starred_url":"https://api.github.com/users/kubernetes/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kubernetes/subscriptions","organizations_url":"https://api.github.com/users/kubernetes/orgs","repos_url":"https://api.github.com/users/kubernetes/repos","events_url":"https://api.github.com/users/kubernetes/events{/privacy}","received_events_url":"https://api.github.com/users/kubernetes/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/kubernetes/test-infra","description":"Test infrastructure for the Kubernetes project.","fork":false,"url":"https://api.github.com/repos/kubernetes/test-infra","forks_url":"https://api.github.com/repos/kubernetes/test-infra/forks","keys_url":"https://api.github.com/repos/kubernetes/test-infra/keys{/key_id}","collaborators_url":"https://api.github.com/repos/kubernetes/test-infra/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/kubernetes/test-infra/teams","hooks_url":"https://api.github.com/repos/kubernetes/test-infra/hooks","issue_events_url":"https://api.github.com/repos/kubernetes/test-infra/issues/events{/number}","events_url":"https://api.github.com/repos/kubernetes/test-infra/events","assignees_url":"https://api.github.com/repos/kubernetes/test-infra/assignees{/user}","branches_url":"https://api.github.com/repos/kubernetes/test-infra/branches{/branch}","tags_url":"https://api.github.com/repos/kubernetes/test-infra/tags","blobs_url":"https://api.github.com/repos/kubernetes/test-infra/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/kubernetes/test-infra/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/kubernetes/test-infra/git/refs{/sha}","trees_url":"https://api.github.com/repos/kubernetes/test-infra/git/trees{/sha}","statuses_url":"https://api.github.com/repos/kubernetes/test-infra/statuses/{sha}","languages_url":"https://api.github.com/repos/kubernetes/test-infra/languages","stargazers_url":"https://api.github.com/repos/kubernetes/test-infra/stargazers","contributors_url":"https://api.github.com/repos/kubernetes/test-infra/contributors","subscribers_url":"https://api.github.com/repos/kubernetes/test-infra/subscribers","subscription_url":"https://api.github.com/repos/kubernetes/test-infra/subscription","commits_url":"https://api.github.com/repos/kubernetes/test-infra/commits{/sha}","git_commits_url":"https://api.github.com/repos/kubernetes/test-infra/git/commits{/sha}","comments_url":"https://api.github.com/repos/kubernetes/test-infra/comments{/number}","issue_comment_url":"https://api.github.com/repos/kubernetes/test-infra/issues/comments{/number}","contents_url":"https://api.github.com/repos/kubernetes/test-infra/contents/{+path}","compare_url":"https://api.github.com/repos/kubernetes/test-infra/compare/{base}...{head}","merges_url":"https://api.github.com/repos/kubernetes/test-infra/merges","archive_url":"https://api.github.com/repos/kubernetes/test-infra/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/kubernetes/test-infra/downloads","issues_url":"https://api.github.com/repos/kubernetes/test-infra/issues{/number}","pulls_url":"https://api.github.com/repos/kubernetes/test-infra/pulls{/number}","milestones_url":"https://api.github.com/repos/kubernetes/test-infra/milestones{/number}","notifications_url":"https://api.github.com/repos/kubernetes/test-infra/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/kubernetes/test-infra/labels{/name}","releases_url":"https://api.github.com/repos/kubernetes/test-infra/releases{/id}","deployments_url":"https://api.github.com/repos/kubernetes/test-infra/deployments","created_at":"2016-04-28T21:05:35Z","updated_at":"2017-04-13T15:10:57Z","pushed_at":"2017-04-13T20:31:50Z","git_url":"git://github.com/kubernetes/test-infra.git","ssh_url":"git@github.com:kubernetes/test-infra.git","clone_url":"https://github.com/kubernetes/test-infra.git","svn_url":"https://github.com/kubernetes/test-infra","homepage":null,"size":17243,"stargazers_count":75,"watchers_count":75,"language":"Go","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":false,"has_pages":false,"forks_count":126,"mirror_url":null,"open_issues_count":164,"forks":126,"open_issues":164,"watchers":75,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/kubernetes/test-infra/pulls/2472"},"html":{"href":"https://github.com/kubernetes/test-infra/pull/2472"},"issue":{"href":"https://api.github.com/repos/kubernetes/test-infra/issues/2472"},"comments":{"href":"https://api.github.com/repos/kubernetes/test-infra/issues/2472/comments"},"review_comments":{"href":"https://api.github.com/repos/kubernetes/test-infra/pulls/2472/comments"},"review_comment":{"href":"https://api.github.com/repos/kubernetes/test-infra/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/kubernetes/test-infra/pulls/2472/commits"},"statuses":{"href":"https://api.github.com/repos/kubernetes/test-infra/statuses/00a0d0b621d90c7d11f8f0b0c63af69a5ebda1da"}}}}
{"actor":{"display_login":"rmmh"}}