)]}'
{"/PATCHSET_LEVEL":[{"author":{"_account_id":7118,"name":"Ian Wienand","email":"iwienand@redhat.com","username":"iwienand"},"change_message_id":"dc0356f176adf65964be0c66b42732d09dac41f6","unresolved":false,"context_lines":[],"source_content_type":"","patch_set":2,"id":"aab21f71_2fe42a04","updated":"2022-04-11 23:58:19.000000000","message":"This is still clearly a problem, I did a quick summary of this message from our recent logs\n\nhttps://paste.opendev.org/show/bl8rmy33qhmcir0o3J9M/\n\nand basically every project has many entries about this.  clearly a lot of queries take \u003e5s\n\nBUT\n\nthen I looked a bit closer\n\n# zgrep \u0027Diff loader\u0027 error* | egrep \u0027(stackalytics-poll|attstackalytics)\u0027 | wc -l\n34094\n# zgrep \u0027Diff loader\u0027 error* | egrep -v \u0027(stackalytics-poll|attstackalytics)\u0027 | wc -l\n3\n\nit is essentially only stackalytics hitting this.  \n\nOf the 3 other ones, two were for spider.yandex.com. -- so again some indexing\n\nThe single non-stackalytics/spider query that seemed to hit this then was\n\n[2022-03-29T13:55:06.524Z] [SSH gerrit query --format json --current-patch-set --comments --start 0 status:merged branch:master -- -age:7d (slaweq)] WARN  com.google.gerrit.server.patch.filediff.PatchListLoader : 5000 ms timeout reached for Diff loader in project vexxhost/ansible-collection-atmosphere on commit 218d781a65757854e52d205051ad61eff12db93a on path releasenotes/notes/fix-role-promotion-8c41b8dfd8b1c74e.yaml comparing 0000000000000000000000000000000000000000..836a0745779d79ae1b402797d385b236eff7ed51\n\nGiven that, I think this just has the potential to increase gerrit load for questionable stackalytics queries. \n","commit_id":"d53c2d182d8b8ffb6052ae2275b4e15a508b1851"},{"author":{"_account_id":4146,"name":"Clark Boylan","email":"cboylan@sapwetik.org","username":"cboylan"},"change_message_id":"431532d437e06690160dac6b9021e4f25d55f447","unresolved":false,"context_lines":[],"source_content_type":"","patch_set":2,"id":"23ad25ca_60fe6c64","updated":"2022-03-15 23:14:38.000000000","message":"recheck the error is in synchronizing project-config before we ever get to even run gerrit.","commit_id":"d53c2d182d8b8ffb6052ae2275b4e15a508b1851"}]}