#!/bin/sh

ssh buildmaster '
  find /srv/http/build-logs/error/ \
    -maxdepth 1 \
    -name "*.i486.*" \
    -mtime -3 \
    -exec zgrep "^error: target not found: " {} \; | \
    cut -d" " -f5 | \
    sed "s/[<=>].*\$//"
' | \
  grep -vxF "$(
    for db in $(
      printf 'https://mirror.archlinux32.org/i486/%s/%s.db.tar.gz\n' \
        core core \
        extra extra \
        community community \
        testing testing \
        community-testing community-testing \
        staging staging \
        community-staging community-staging
      printf 'http://archlinux32.andreasbaumann.cc/bootstrap/i486/%s.db.tar.gz\n' \
        bootstrap \
        staging/bootstrap-staging \
        community-staging/bootstrap-community-staging \
        testing/bootstrap-community-testing \
        core/bootstrap-core \
        extra/bootstrap-extra \
        community/bootstrap-community
    ); do
      curl -s "$db" | \
        tar -tz 2>/dev/null
    done | \
    sed '
      s,\(-[^-]\+\)\{2\}/desc$,,
      t
      d
    ' | \
    sort -u
  )" | \
  sort | \
  uniq -c | \
  sort -k1n,1