)]}'
{"id":"depot~10011","triplet_id":"depot~canon~Ia75ca8c43f8074fbaa34537ffdba68350c504e52","project":"depot","branch":"canon","attention_set":{},"removed_from_attention_set":{"1000005":{"account":{"_account_id":1000005,"name":"edef","email":"edef@edef.eu","username":"edef"},"last_update":"2023-11-12 16:43:40.000000000","reason":"removed on reply"},"1000036":{"account":{"_account_id":1000036,"name":"flokli","email":"flokli@flokli.de","username":"flokli"},"last_update":"2023-11-12 16:46:06.000000000","reason":"Change was submitted"},"1000073":{"account":{"_account_id":1000073,"name":"raitobezarius","display_name":"Ryan Lahfa","email":"tvl@lahfa.xyz","username":"raitobezarius"},"last_update":"2023-11-12 16:46:06.000000000","reason":"Change was submitted"}},"hashtags":[],"change_id":"Ia75ca8c43f8074fbaa34537ffdba68350c504e52","subject":"feat(users/flokli/nixos/archeology-ec2): automate bucket log parsing","status":"MERGED","created":"2023-11-12 16:35:18.000000000","updated":"2023-11-12 16:46:06.000000000","submitted":"2023-11-12 16:46:06.000000000","submitter":{"_account_id":1000036,"name":"flokli","email":"flokli@flokli.de","username":"flokli"},"total_comment_count":0,"unresolved_comment_count":0,"has_review_started":true,"submission_id":"10011","meta_rev_id":"f32f238e7e962f8345d9d34d6a6b2dca483e2535","_number":10011,"virtual_id_number":10011,"owner":{"_account_id":1000036,"name":"flokli","email":"flokli@flokli.de","username":"flokli"},"actions":{},"labels":{"Code-Review":{"approved":{"_account_id":1000005,"name":"edef","email":"edef@edef.eu","username":"edef"},"all":[{"tag":"autogenerated:gerrit:merged","value":2,"date":"2023-11-12 16:46:06.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":1000005,"name":"edef","email":"edef@edef.eu","username":"edef"},{"value":0,"_account_id":1000036,"name":"flokli","email":"flokli@flokli.de","username":"flokli"},{"value":0,"_account_id":1000014,"name":"BuildkiteCI","username":"buildkite","tags":["SERVICE_USER"]}],"values":{"-2":"This shall not be merged","-1":"I would prefer this is not merged as is"," 0":"No score","+1":"Looks good to me, but someone else must approve","+2":"Looks good to me, approved"},"description":"","default_value":0},"Verified":{"approved":{"_account_id":1000014,"name":"BuildkiteCI","username":"buildkite","tags":["SERVICE_USER"]},"all":[{"value":0,"_account_id":1000005,"name":"edef","email":"edef@edef.eu","username":"edef"},{"value":0,"_account_id":1000036,"name":"flokli","email":"flokli@flokli.de","username":"flokli"},{"tag":"autogenerated:gerrit:merged","value":1,"date":"2023-11-12 16:46:06.000000000","permitted_voting_range":{"min":1,"max":1},"_account_id":1000014,"name":"BuildkiteCI","username":"buildkite","tags":["SERVICE_USER"]}],"values":{"-1":"Fails"," 0":"No score","+1":"Verified"},"description":"","default_value":0},"Autosubmit":{"all":[{"value":0,"_account_id":1000005,"name":"edef","email":"edef@edef.eu","username":"edef"},{"value":0,"_account_id":1000036,"name":"flokli","email":"flokli@flokli.de","username":"flokli"},{"value":0,"_account_id":1000014,"name":"BuildkiteCI","username":"buildkite","tags":["SERVICE_USER"]}],"values":{" 0":"Submit manually","+1":"Submit automatically"},"description":"","default_value":0,"optional":true},"All-Comments-Resolved":{"approved":{"_account_id":1000036,"name":"flokli","email":"flokli@flokli.de","username":"flokli"},"all":[{"value":0,"_account_id":1000005,"name":"edef","email":"edef@edef.eu","username":"edef"},{"value":0,"_account_id":1000036,"name":"flokli","email":"flokli@flokli.de","username":"flokli"},{"value":0,"_account_id":1000014,"name":"BuildkiteCI","username":"buildkite","tags":["SERVICE_USER"]}]},"Conformant-Commit-Message":{"approved":{"_account_id":1000036,"name":"flokli","email":"flokli@flokli.de","username":"flokli"},"all":[{"value":0,"_account_id":1000005,"name":"edef","email":"edef@edef.eu","username":"edef"},{"value":0,"_account_id":1000036,"name":"flokli","email":"flokli@flokli.de","username":"flokli"},{"value":0,"_account_id":1000014,"name":"BuildkiteCI","username":"buildkite","tags":["SERVICE_USER"]}]}},"removable_reviewers":[{"_account_id":1000073,"name":"raitobezarius","display_name":"Ryan Lahfa","email":"tvl@lahfa.xyz","username":"raitobezarius"}],"reviewers":{"REVIEWER":[{"_account_id":1000005,"name":"edef","email":"edef@edef.eu","username":"edef"},{"_account_id":1000014,"name":"BuildkiteCI","username":"buildkite","tags":["SERVICE_USER"]},{"_account_id":1000036,"name":"flokli","email":"flokli@flokli.de","username":"flokli"},{"_account_id":1000073,"name":"raitobezarius","display_name":"Ryan Lahfa","email":"tvl@lahfa.xyz","username":"raitobezarius"}]},"pending_reviewers":{},"reviewer_updates":[{"updated":"2023-11-12 16:35:18.000000000","updated_by":{"_account_id":1000036,"name":"flokli","email":"flokli@flokli.de","username":"flokli"},"reviewer":{"_account_id":1000073,"name":"raitobezarius","display_name":"Ryan Lahfa","email":"tvl@lahfa.xyz","username":"raitobezarius"},"state":"REVIEWER"},{"updated":"2023-11-12 16:35:18.000000000","updated_by":{"_account_id":1000036,"name":"flokli","email":"flokli@flokli.de","username":"flokli"},"reviewer":{"_account_id":1000005,"name":"edef","email":"edef@edef.eu","username":"edef"},"state":"REVIEWER"},{"updated":"2023-11-12 16:35:20.000000000","updated_by":{"_account_id":1000014,"name":"BuildkiteCI","username":"buildkite","tags":["SERVICE_USER"]},"reviewer":{"_account_id":1000014,"name":"BuildkiteCI","username":"buildkite","tags":["SERVICE_USER"]},"state":"CC"},{"updated":"2023-11-12 16:39:30.000000000","updated_by":{"_account_id":1000014,"name":"BuildkiteCI","username":"buildkite","tags":["SERVICE_USER"]},"reviewer":{"_account_id":1000014,"name":"BuildkiteCI","username":"buildkite","tags":["SERVICE_USER"]},"state":"REVIEWER"}],"messages":[{"id":"ef24675c65fbbe1706e470992de1193ce724efe6","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":1000036,"name":"flokli","email":"flokli@flokli.de","username":"flokli"},"date":"2023-11-12 16:35:18.000000000","message":"Uploaded patch set 1.","accounts_in_message":[],"_revision_number":1},{"id":"1dfc6ab6331fc0c9afece3aab710aa5996b79866","tag":"autogenerated:gerrit:code-owners:addReviewer","author":{"_account_id":1000036,"name":"flokli","email":"flokli@flokli.de","username":"flokli"},"date":"2023-11-12 16:35:18.000000000","message":"\u003cGERRIT_ACCOUNT_1000005\u003e, who was added as reviewer owns the following files:\n* `users/flokli/nixos/archeology-ec2/configuration.nix`\n* `users/flokli/nixos/archeology-ec2/parse-bucket-logs-continuously.py`\n","accounts_in_message":[{"_account_id":1000005,"name":"edef","email":"edef@edef.eu","username":"edef"}],"_revision_number":1},{"id":"a269b3b6d091a705879765dbd97ed54420e4b346","tag":"autogenerated:buildkite~trigger","author":{"_account_id":1000014,"name":"BuildkiteCI","username":"buildkite","tags":["SERVICE_USER"]},"date":"2023-11-12 16:35:20.000000000","message":"Patch Set 1:\n\nStarted build for patchset #1 on: https://buildkite.com/tvl/depot/builds/28120","accounts_in_message":[],"_revision_number":1},{"id":"55ebeddfb84e244cfeaf109faf220b2c3507eac2","tag":"autogenerated:buildkite~result","author":{"_account_id":1000014,"name":"BuildkiteCI","username":"buildkite","tags":["SERVICE_USER"]},"date":"2023-11-12 16:39:30.000000000","message":"Patch Set 1: Verified+1\n\nBuild of patchset 1 passed: https://buildkite.com/tvl/depot/builds/28120","accounts_in_message":[],"_revision_number":1},{"id":"fea6664e8d391ad8d12bbaf1aacbdcb5851f900a","author":{"_account_id":1000005,"name":"edef","email":"edef@edef.eu","username":"edef"},"date":"2023-11-12 16:43:40.000000000","message":"Patch Set 1: Code-Review+2","accounts_in_message":[],"_revision_number":1},{"id":"f32f238e7e962f8345d9d34d6a6b2dca483e2535","tag":"autogenerated:gerrit:merged","author":{"_account_id":1000036,"name":"flokli","email":"flokli@flokli.de","username":"flokli"},"date":"2023-11-12 16:46:06.000000000","message":"Change has been successfully rebased and submitted as e4adca0880547f2ea825aeec5f64671c6c0324ae","accounts_in_message":[],"_revision_number":2}],"current_revision_number":2,"current_revision":"e4adca0880547f2ea825aeec5f64671c6c0324ae","revisions":{"8086d06f9711a14b06a18320077461d85ce408e3":{"kind":"REWORK","_number":1,"created":"2023-11-12 16:35:18.000000000","uploader":{"_account_id":1000036,"name":"flokli","email":"flokli@flokli.de","username":"flokli"},"ref":"refs/changes/11/10011/1","fetch":{"anonymous http":{"url":"https://cl.tvl.fyi/depot","ref":"refs/changes/11/10011/1","commands":{"Checkout":"git fetch https://cl.tvl.fyi/depot refs/changes/11/10011/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://cl.tvl.fyi/depot refs/changes/11/10011/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://cl.tvl.fyi/depot refs/changes/11/10011/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://cl.tvl.fyi/depot refs/changes/11/10011/1"}}},"commit":{"parents":[{"commit":"3fe455cd4ada32990f67af640becd4cf8ae6117c","subject":"chore(3p/nixpkgs/clickhouse): 23.3.13.6 -\u003e 23.10.3.5","web_links":[{"name":"cgit","tooltip":"Open in GitWeb","url":"https://code.tvl.fyi/commit/?id\u003d3fe455cd4ada32990f67af640becd4cf8ae6117c"}]}],"author":{"name":"Florian Klink","email":"flokli@flokli.de","date":"2023-11-12 16:09:03.000000000","tz":120},"committer":{"name":"Florian Klink","email":"flokli@flokli.de","date":"2023-11-12 16:12:04.000000000","tz":120},"subject":"feat(users/flokli/nixos/archeology-ec2): automate bucket log parsing","message":"feat(users/flokli/nixos/archeology-ec2): automate bucket log parsing\n\nThis adds a `parse-bucket-logs.{service,timer}`, running once every\nnight at 3AM UTC, figuring out the last time it was run and parsing\nbucket logs for all previous days.\n\nIt invokes the `archeology-parse-bucket-logs` script to produce\na .parquet file with the bucket logs in `s3://nix-cache-log/log/` for\nthat day (inside a temporary directory), then on success uploads the\nproduced parquet file to\n`s3://nix-archeologist/nix-cache-bucket-logs/yyyy-mm-dd.parquet`.\n\nChange-Id: Ia75ca8c43f8074fbaa34537ffdba68350c504e52\n","web_links":[{"name":"cgit","tooltip":"Open in GitWeb","url":"https://code.tvl.fyi/commit/?id\u003d8086d06f9711a14b06a18320077461d85ce408e3"}],"resolve_conflicts_web_links":[{"name":"cgit","tooltip":"Open in GitWeb","url":"https://code.tvl.fyi/commit/?id\u003d8086d06f9711a14b06a18320077461d85ce408e3"}]},"parents_data":[{"branch_name":"refs/heads/canon","commit_id":"3fe455cd4ada32990f67af640becd4cf8ae6117c","is_merged_in_target_branch":true,"change_id":"I3e4c43690fcaf50965152bf40e1ca2b027010fcf","change_number":9997,"patch_set_number":5,"change_status":"MERGED"}],"branch":"refs/heads/canon"},"e4adca0880547f2ea825aeec5f64671c6c0324ae":{"kind":"NO_CODE_CHANGE","_number":2,"created":"2023-11-12 16:46:06.000000000","uploader":{"_account_id":1000036,"name":"flokli","email":"flokli@flokli.de","username":"flokli"},"ref":"refs/changes/11/10011/2","fetch":{"anonymous http":{"url":"https://cl.tvl.fyi/depot","ref":"refs/changes/11/10011/2","commands":{"Checkout":"git fetch https://cl.tvl.fyi/depot refs/changes/11/10011/2 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://cl.tvl.fyi/depot refs/changes/11/10011/2 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://cl.tvl.fyi/depot refs/changes/11/10011/2 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://cl.tvl.fyi/depot refs/changes/11/10011/2"}}},"commit":{"parents":[{"commit":"3fe455cd4ada32990f67af640becd4cf8ae6117c","subject":"chore(3p/nixpkgs/clickhouse): 23.3.13.6 -\u003e 23.10.3.5","web_links":[{"name":"cgit","tooltip":"Open in GitWeb","url":"https://code.tvl.fyi/commit/?id\u003d3fe455cd4ada32990f67af640becd4cf8ae6117c"}]}],"author":{"name":"Florian Klink","email":"flokli@flokli.de","date":"2023-11-12 16:09:03.000000000","tz":120},"committer":{"name":"flokli","email":"flokli@flokli.de","date":"2023-11-12 16:46:06.000000000","tz":0},"subject":"feat(users/flokli/nixos/archeology-ec2): automate bucket log parsing","message":"feat(users/flokli/nixos/archeology-ec2): automate bucket log parsing\n\nThis adds a `parse-bucket-logs.{service,timer}`, running once every\nnight at 3AM UTC, figuring out the last time it was run and parsing\nbucket logs for all previous days.\n\nIt invokes the `archeology-parse-bucket-logs` script to produce\na .parquet file with the bucket logs in `s3://nix-cache-log/log/` for\nthat day (inside a temporary directory), then on success uploads the\nproduced parquet file to\n`s3://nix-archeologist/nix-cache-bucket-logs/yyyy-mm-dd.parquet`.\n\nChange-Id: Ia75ca8c43f8074fbaa34537ffdba68350c504e52\nReviewed-on: https://cl.tvl.fyi/c/depot/+/10011\nReviewed-by: edef \u003cedef@edef.eu\u003e\nTested-by: BuildkiteCI\n","web_links":[{"name":"cgit","tooltip":"Open in GitWeb","url":"https://code.tvl.fyi/commit/?id\u003de4adca0880547f2ea825aeec5f64671c6c0324ae"}],"resolve_conflicts_web_links":[{"name":"cgit","tooltip":"Open in GitWeb","url":"https://code.tvl.fyi/commit/?id\u003de4adca0880547f2ea825aeec5f64671c6c0324ae"}]},"parents_data":[{"branch_name":"refs/heads/canon","commit_id":"3fe455cd4ada32990f67af640becd4cf8ae6117c","is_merged_in_target_branch":true,"change_id":"I3e4c43690fcaf50965152bf40e1ca2b027010fcf","change_number":9997,"patch_set_number":5,"change_status":"MERGED"}],"branch":"refs/heads/canon"}},"requirements":[],"submit_records":[{"rule_name":"gerrit~PrologRule","status":"CLOSED","labels":[{"label":"Autosubmit","status":"MAY"},{"label":"Conformant-Commit-Message","status":"OK","applied_by":{"_account_id":1000036,"name":"flokli","email":"flokli@flokli.de","username":"flokli"}},{"label":"All-Comments-Resolved","status":"OK","applied_by":{"_account_id":1000036,"name":"flokli","email":"flokli@flokli.de","username":"flokli"}},{"label":"Verified","status":"OK","applied_by":{"_account_id":1000014,"name":"BuildkiteCI","username":"buildkite","tags":["SERVICE_USER"]}},{"label":"Code-Review","status":"OK","applied_by":{"_account_id":1000005,"name":"edef","email":"edef@edef.eu","username":"edef"}}]},{"rule_name":"Code-Owners","status":"CLOSED"}],"submit_requirements":[{"name":"All-Comments-Resolved","status":"SATISFIED","is_legacy":true,"submittability_expression_result":{"expression":"label:All-Comments-Resolved\u003dgerrit~PrologRule","fulfilled":true,"status":"PASS","passing_atoms":["label:All-Comments-Resolved\u003dgerrit~PrologRule"],"failing_atoms":[]}},{"name":"Verified","status":"SATISFIED","is_legacy":true,"submittability_expression_result":{"expression":"label:Verified\u003dgerrit~PrologRule","fulfilled":true,"status":"PASS","passing_atoms":["label:Verified\u003dgerrit~PrologRule"],"failing_atoms":[]}},{"name":"Code-Owners","status":"SATISFIED","is_legacy":true,"submittability_expression_result":{"expression":"rule:Code-Owners","fulfilled":true,"status":"PASS","passing_atoms":["Code-Owners"],"failing_atoms":[]}},{"name":"Conformant-Commit-Message","status":"SATISFIED","is_legacy":true,"submittability_expression_result":{"expression":"label:Conformant-Commit-Message\u003dgerrit~PrologRule","fulfilled":true,"status":"PASS","passing_atoms":["label:Conformant-Commit-Message\u003dgerrit~PrologRule"],"failing_atoms":[]}},{"name":"Code-Review","status":"SATISFIED","is_legacy":true,"submittability_expression_result":{"expression":"label:Code-Review\u003dgerrit~PrologRule","fulfilled":true,"status":"PASS","passing_atoms":["label:Code-Review\u003dgerrit~PrologRule"],"failing_atoms":[]}}]}