Hi,

I used

$ PGPASSWORD="udd-mirror" psql --port=5432 --host=udd-mirror.debian.net --username=udd-mirror  udd <<EOT
SELECT source,
       vote,
       maintainer,
       vcs_url,
       tags
  FROM (
  SELECT source, vote, MAX(testsuite) as testsuite, maintainer, vcs_url, tags FROM (
    SELECT source, vote, testsuite, maintainer, vcs_url, tags, row_number() OVER (PARTITION BY source ORDER BY vote DESC) FROM (
      SELECT DISTINCT p.source, p.package, s.maintainer, s.vcs_url,
            CASE WHEN pop.vote IS NULL THEN -1 ELSE pop.vote END AS vote,
            s.testsuite, d.tags FROM packages p
        LEFT OUTER JOIN popcon  pop ON p.package = pop.package
        LEFT OUTER JOIN (SELECT source, maintainer, vcs_url, testsuite FROM sources WHERE release = 'sid' ) s ON p.source  = s.source
        LEFT OUTER JOIN (SELECT package, array_agg(tag) AS tags FROM debtags WHERE tag LIKE 'uitoolkit::%' OR tag LIKE '%x11%' GROUP BY package) d ON p.package = d.package
        WHERE p.release = 'sid'
    ) tmp1
  ) tmp2
  GROUP BY source, vote, tags, maintainer, vcs_url
) tmp3 WHERE testsuite is NULL
AND VOTE > 1000
ORDER BY vote DESC, source
    LIMIT 5;
EOT
   source    |  vote  |                                 maintainer                                 |                             vcs_url                             |                                       tags
-------------+--------+----------------------------------------------------------------------------+-----------------------------------------------------------------+----------------------------------------------------------------------------------
 debconf     | 217976 | Debconf Developers <debconf-devel@lists.alioth.debian.org>                 | https://salsa.debian.org/pkg-debconf/debconf.git                | {uitoolkit::ncurses,interface::x11,uitoolkit::TODO,uitoolkit::gtk,uitoolkit::qt}
 zlib        | 217757 | Mark Brown <broonie@debian.org>                                            |                                                                 |
 tar         | 216067 | Janos Lenart <ocsi@debian.org>                                             | https://salsa.debian.org/debian/tar.git                         |
 sysvinit    | 214097 | Debian sysvinit maintainers <debian-init-diversity@chiark.greenend.org.uk> | https://salsa.debian.org/debian/sysvinit.git                    |
 libgcrypt20 | 212538 | Debian GnuTLS Maintainers <pkg-gnutls-maint@lists.alioth.debian.org>       | https://salsa.debian.org/gnutls-team/libgcrypt.git -b branch1.6 |



to find out what most popular packages in Debian are not featuring some
autopkgtest.  Since I somehow considered tar some feasible target to
write such a test I tweaked the build time test to hopefully work as
autopkgtest.  I succeeded in my local chroot.  To make sure it will
really work reliably I created a branch in Git[1] where I added this
test.  My hope was an additional verification that it works in CI - but
this failed[2].  I admit I'm a bit clueless about

  1. Why this test fails in Salsa CI while it succeeds locally
  2. Whether this kind of test is really sensible since it includes
     some automake created header files I have stolen from amd64
     build[3] which definitely is a hack that might break for
      a) upgrades
      b) other architectures
  3. Whether we might consider a more simple test just as starting
     point.

Thus I did not created a MR and do not tag this bug patch leaving it for
further discussion.  If you prefer I should rather fork your git
repository on Salsa and discuss things in some MR I'm fine with removing
that said branch.  I just don't know your prefered way of communication
in your small packaging team.

Thanks a lot for maintaining tar
    Andreas.

[1] https://salsa.debian.org/debian/tar/-/tree/autopkgtest?ref_type=heads
[2] https://salsa.debian.org/debian/tar/-/jobs/5494107
[3] https://salsa.debian.org/debian/tar/-/blob/autopkgtest/debian/tests/headers.tar.xz?ref_type=heads

Hi Santiago,

Am Thu, Nov 28, 2024 at 09:30:15AM -0300 schrieb Santiago Ruano Rincón:

This reminds me to my attempt to write some autopkgtest for tar.  I've
created an according bug report[1] (in CC) but I did not went really far
to run the upstream test suite in an autopkgtest.  I needed some local
header files from the build which is definitely not a good idea and
the final autopkgtest failed even then[2].

Currently I have no time to continue with this.  However, if someone
wants to add an autopkgtest to one of our most used packages this would
be great.

Kind regards
   Andreas.

[1] https://bugs.debian.org/1068576
[2] https://salsa.debian.org/debian/tar/-/jobs/5494107