)]}'
{"queries/1686542.yaml":[{"author":{"_account_id":6873,"name":"Matt Riedemann","email":"mriedem.os@gmail.com","username":"mriedem"},"change_message_id":"1f20ac86acf829f42211656674ffc6e6e133801c","unresolved":false,"context_lines":[{"line_number":2,"context_line":"  (message: \"FAILED with status: 137\" OR"},{"line_number":3,"context_line":"  message: \"FAILED with status: 143\" OR"},{"line_number":4,"context_line":"  message: \"RUN END RESULT_TIMED_OUT\") AND"},{"line_number":5,"context_line":"  NOT message:\"POST-RUN END RESULT_TIMED OUT\" AND"},{"line_number":6,"context_line":"  tags: \"console\""}],"source_content_type":"text/x-yaml","patch_set":3,"id":"3f79a3b5_9c72c9ae","line":5,"updated":"2018-12-19 19:23:21.000000000","message":"OK with this the query yields 1224 hits in 7 days:\n\nhttp://logstash.openstack.org/#dashboard/file/logstash.json?query\u003d(message%3A%20%5C%22FAILED%20with%20status%3A%20137%5C%22%20OR%20%20%20message%3A%20%5C%22FAILED%20with%20status%3A%20143%5C%22%20OR%20%20%20message%3A%20%5C%22RUN%20END%20RESULT_TIMED_OUT%5C%22)%20AND%20%20%20NOT%20message%3A%5C%22POST-RUN%20END%20RESULT_TIMED%20OUT%5C%22%20AND%20%20%20tags%3A%20%5C%22console%5C%22\u0026from\u003d7d\n\nIf I remove the change here, I get the same number of hits:\n\nhttp://logstash.openstack.org/#dashboard/file/logstash.json?query\u003d(message%3A%20%5C%22FAILED%20with%20status%3A%20137%5C%22%20OR%20%20%20message%3A%20%5C%22FAILED%20with%20status%3A%20143%5C%22%20OR%20%20%20message%3A%20%5C%22RUN%20END%20RESULT_TIMED_OUT%5C%22)%20AND%20%20%20tags%3A%20%5C%22console%5C%22\u0026from\u003d7d\n\nSo the new filter obviously doesn\u0027t have any affect...","commit_id":"bf8187fc130a12782ff4a118f049f4ddde605b81"},{"author":{"_account_id":24162,"name":"Sorin Sbârnea","display_name":"zbr","email":"ssbarnea@redhat.com","username":"ssbarnea","status":"do not feed the troll 🥕"},"change_message_id":"407cf9803b01b3ba36548b9f2d701aa3152da5eb","unresolved":false,"context_lines":[{"line_number":2,"context_line":"  (message: \"FAILED with status: 137\" OR"},{"line_number":3,"context_line":"  message: \"FAILED with status: 143\" OR"},{"line_number":4,"context_line":"  message: \"RUN END RESULT_TIMED_OUT\") AND"},{"line_number":5,"context_line":"  NOT message:\"POST-RUN END RESULT_TIMED OUT\" AND"},{"line_number":6,"context_line":"  tags: \"console\""}],"source_content_type":"text/x-yaml","patch_set":3,"id":"1f769fc5_6b044518","line":5,"in_reply_to":"3f79a3b5_9c72c9ae","updated":"2018-12-27 16:01:50.000000000","message":"Thre was a typo in the message which I just fixed, I wrote RESULT_TIMED OUT instead of RESULT_TIMED_OUT\n\nLet me know if other changes are needed.","commit_id":"bf8187fc130a12782ff4a118f049f4ddde605b81"},{"author":{"_account_id":6873,"name":"Matt Riedemann","email":"mriedem.os@gmail.com","username":"mriedem"},"change_message_id":"df4824fc15ca70cc54d5d0e57d9790286ac4877c","unresolved":false,"context_lines":[{"line_number":1,"context_line":"query: \u003e-"},{"line_number":2,"context_line":"  (message: \"FAILED with status: 137\" OR"},{"line_number":3,"context_line":"  message: \"FAILED with status: 143\" OR"},{"line_number":4,"context_line":"  message: \"RUN END RESULT_TIMED_OUT\") AND"},{"line_number":5,"context_line":"  tags: \"console\""}],"source_content_type":"text/x-yaml","patch_set":4,"id":"5fc1f717_01ba116d","side":"PARENT","line":5,"range":{"start_line":2,"start_character":2,"end_line":5,"end_character":17},"updated":"2019-04-04 16:08:13.000000000","message":"This results in 630 hits in 7 days on check and gate queues, all branches, all failures:\n\nhttp://logstash.openstack.org/#dashboard/file/logstash.json?query\u003d(message%3A%20%5C%22FAILED%20with%20status%3A%20137%5C%22%20OR%20%20%20message%3A%20%5C%22FAILED%20with%20status%3A%20143%5C%22%20OR%20%20%20message%3A%20%5C%22RUN%20END%20RESULT_TIMED_OUT%5C%22)%20AND%20%20%20tags%3A%20%5C%22console%5C%22\u0026from\u003d7d","commit_id":"b9146d923f02f4a6b3836bcf34426aa15479627e"},{"author":{"_account_id":6873,"name":"Matt Riedemann","email":"mriedem.os@gmail.com","username":"mriedem"},"change_message_id":"df4824fc15ca70cc54d5d0e57d9790286ac4877c","unresolved":false,"context_lines":[{"line_number":1,"context_line":"query: \u003e-"},{"line_number":2,"context_line":"  (message: \"FAILED with status: 137\" OR"},{"line_number":3,"context_line":"  message: \"FAILED with status: 143\" OR"},{"line_number":4,"context_line":"  message: \"RUN END RESULT_TIMED_OUT\") AND"},{"line_number":5,"context_line":"  NOT message:\"POST-RUN END RESULT_TIMED_OUT\" AND"},{"line_number":6,"context_line":"  tags: \"console\""}],"source_content_type":"text/x-yaml","patch_set":4,"id":"5fc1f717_e16b45ee","line":6,"range":{"start_line":2,"start_character":2,"end_line":6,"end_character":17},"updated":"2019-04-04 16:08:13.000000000","message":"This results in 604 hits in 7 days, check and gate, all failures all branches:\n\nhttp://logstash.openstack.org/#dashboard/file/logstash.json?query\u003d(message%3A%20%5C%22FAILED%20with%20status%3A%20137%5C%22%20OR%20%20%20message%3A%20%5C%22FAILED%20with%20status%3A%20143%5C%22%20OR%20%20%20message%3A%20%5C%22RUN%20END%20RESULT_TIMED_OUT%5C%22)%20AND%20%20%20NOT%20message%3A%5C%22POST-RUN%20END%20RESULT_TIMED_OUT%5C%22%20AND%20%20%20tags%3A%20%5C%22console%5C%22\u0026from\u003d7d","commit_id":"c2c3f3a683289fa5bac03cb423fb9d11ddb3becf"}],"queries/1807940.yaml":[{"author":{"_account_id":6873,"name":"Matt Riedemann","email":"mriedem.os@gmail.com","username":"mriedem"},"change_message_id":"79d649591572e1d00f75a77db790c6e86e1b3f40","unresolved":false,"context_lines":[{"line_number":1,"context_line":"query: \u003e-"},{"line_number":2,"context_line":"  (message: \"FAILED with status: 137\" OR"},{"line_number":3,"context_line":"  message: \"FAILED with status: 143\" OR"},{"line_number":4,"context_line":"  message: \"POST-RUN END RESULT_TIMED_OUT\") AND"},{"line_number":5,"context_line":"  tags: \"console\""}],"source_content_type":"text/x-yaml","patch_set":2,"id":"3f79a3b5_524bee27","line":4,"range":{"start_line":4,"start_character":12,"end_line":4,"end_character":20},"updated":"2018-12-17 20:54:53.000000000","message":"This is the difference from:\n\nhttp://status.openstack.org/elastic-recheck/#1686542\n\n(message: \"FAILED with status: 137\" OR message: \"FAILED with status: 143\" OR message: \"RUN END RESULT_TIMED_OUT\") AND tags: \"console\"\n\nIf you want to distinguish these, then the query for bug 1686542 should be updated to exclude any that start with \"POST-RUN\" using a:\n\nAND NOT message:\"POST-RUN END RESULT_TIMED OUT\"\n\nfilter, otherwise bug 1686542 hits are just a subset of this.","commit_id":"24a85c68a0ffd36b9c96a38625648bde44749247"},{"author":{"_account_id":24162,"name":"Sorin Sbârnea","display_name":"zbr","email":"ssbarnea@redhat.com","username":"ssbarnea","status":"do not feed the troll 🥕"},"change_message_id":"c8b95ea08331c519f33cf0e0641d1e3854048fdb","unresolved":false,"context_lines":[{"line_number":1,"context_line":"query: \u003e-"},{"line_number":2,"context_line":"  (message: \"FAILED with status: 137\" OR"},{"line_number":3,"context_line":"  message: \"FAILED with status: 143\" OR"},{"line_number":4,"context_line":"  message: \"POST-RUN END RESULT_TIMED_OUT\") AND"},{"line_number":5,"context_line":"  tags: \"console\""}],"source_content_type":"text/x-yaml","patch_set":2,"id":"3f79a3b5_9299866d","line":4,"range":{"start_line":4,"start_character":12,"end_line":4,"end_character":20},"in_reply_to":"3f79a3b5_524bee27","updated":"2018-12-17 21:06:31.000000000","message":"Done","commit_id":"24a85c68a0ffd36b9c96a38625648bde44749247"},{"author":{"_account_id":6873,"name":"Matt Riedemann","email":"mriedem.os@gmail.com","username":"mriedem"},"change_message_id":"1f20ac86acf829f42211656674ffc6e6e133801c","unresolved":false,"context_lines":[{"line_number":1,"context_line":"query: \u003e-"},{"line_number":2,"context_line":"  message: \"POST-RUN END RESULT_TIMED_OUT\" AND"},{"line_number":3,"context_line":"  tags: \"console\""}],"source_content_type":"text/x-yaml","patch_set":3,"id":"3f79a3b5_3c8cd52a","line":3,"range":{"start_line":2,"start_character":2,"end_line":3,"end_character":17},"updated":"2018-12-19 19:23:21.000000000","message":"This has 604 hits in 7 days:\n\nhttp://logstash.openstack.org/#dashboard/file/logstash.json?query\u003dmessage%3A%20%5C%22POST-RUN%20END%20RESULT_TIMED_OUT%5C%22%20AND%20%20%20tags%3A%20%5C%22console%5C%22\u0026from\u003d7d\n\nBut this also hits in successful jobs 45% of the time? Why is that? Filtering on build_status:\"SUCCESS\" shows it\u0027s all on change 624381:\n\nhttps://review.openstack.org/#/c/624381/\n\nwhich I guess is why...\n\nIf I add: AND NOT build_change:\"624381\"\n\nThen this is 100% failure.","commit_id":"bf8187fc130a12782ff4a118f049f4ddde605b81"},{"author":{"_account_id":6873,"name":"Matt Riedemann","email":"mriedem.os@gmail.com","username":"mriedem"},"change_message_id":"df4824fc15ca70cc54d5d0e57d9790286ac4877c","unresolved":false,"context_lines":[{"line_number":1,"context_line":"query: \u003e-"},{"line_number":2,"context_line":"  message: \"POST-RUN END RESULT_TIMED_OUT\" AND"},{"line_number":3,"context_line":"  tags: \"console\""}],"source_content_type":"text/x-yaml","patch_set":4,"id":"5fc1f717_817a81b7","line":2,"updated":"2019-04-04 16:08:13.000000000","message":"This results in 26 hits (as I\u0027d expect), all failures, check and gate:\n\nhttp://logstash.openstack.org/#dashboard/file/logstash.json?query\u003dmessage%3A%20%5C%22POST-RUN%20END%20RESULT_TIMED_OUT%5C%22%20AND%20%20%20tags%3A%20%5C%22console%5C%22\u0026from\u003d7d","commit_id":"c2c3f3a683289fa5bac03cb423fb9d11ddb3becf"}]}