Source: tar
Version: 1.35+dfsg-3
Severity: wishlist

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-de...@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 <broo...@debian.org>                         
                   |                                                            
     | 
 tar         | 216067 | Janos Lenart <o...@debian.org>                          
                   | https://salsa.debian.org/debian/tar.git                    
     | 
 sysvinit    | 214097 | Debian sysvinit maintainers 
<debian-init-divers...@chiark.greenend.org.uk> | 
https://salsa.debian.org/debian/sysvinit.git                    | 
 libgcrypt20 | 212538 | Debian GnuTLS Maintainers 
<pkg-gnutls-ma...@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

-- System Information:
Debian Release: trixie/sid
  APT prefers unstable
  APT policy: (500, 'unstable'), (500, 'testing'), (50, 'buildd-unstable'), (1, 
'experimental')
Architecture: amd64 (x86_64)

Kernel: Linux 6.3.0-2-amd64 (SMP w/8 CPU threads; PREEMPT)
Locale: LANG=de_DE.UTF-8, LC_CTYPE=de_DE.UTF-8 (charmap=UTF-8), LANGUAGE not set
Shell: /bin/sh linked to /usr/bin/dash
Init: systemd (via /run/systemd/system)
LSM: AppArmor: enabled

Reply via email to