[ARROW-12821] [CI] Include the first occurrence of a task failure in the nightly report

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: Continuous Integration
• External issue URL: https://github.com/apache/arrow/issues/28556
• Assignee: Unassigned
• Reporter: Krisztian Szucs
• Created: 18/May/21 12:51
• Updated: 11/Jan/23 08:29

Description

It would be useful if the nightly report would help to identify the time of the regression when a nightly build has started to fail.
We can automatize this during the report generation by filtering the crossbow branches for the task's name, like on the github UI: https://github.com/ursacomputing/crossbow/branches/all?query=test-conda-python-3.7-turbodbc-latest

In order to avoid reaching the github rate limit, we could limit this search for the last one or two weeks and mark the older issues as persistent.