[ARROW-16165] [CI][Archery] Fix archery crossbow query to fix nightly builds

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 8.0.0
• Component/s: Continuous Integration, Developer Tools
• Labels: pull-request-available
• External issue URL: https://github.com/apache/arrow/issues/31570
• Assignee: Raúl Cumplido
• Reporter: Raúl Cumplido
• Created: 11/Apr/22 17:10
• Updated: 11/Jan/23 11:42
• Resolved: 12/Apr/22 14:59

Description

Nightly reports are currently failing (https://github.com/ursacomputing/crossbow/runs/5840285120?check_suite_focus=true) due to the following error from archery crossbbow:

  File "/home/runner/work/crossbow/crossbow/arrow/dev/archery/archery/crossbow/cli.py", line 237, in latest_prefix
    latest = queue.latest_for_prefix(prefix)
  File "/home/runner/work/crossbow/crossbow/arrow/dev/archery/archery/crossbow/core.py", line 568, in latest_for_prefix
    latest_id += "-0"
TypeError: unsupported operand type(s) for +=: 'int' and 'str'
Error: Process completed with exit code 1. 

Issue Links

• links to: GitHub Pull Request #12862