Please read this before reporting a bug:
https://wiki.archlinux.org/title/Bug_reporting_guidelines
Do NOT report bugs when a package is just outdated, or it is in the AUR. Use the 'flag out of date' link on the package page, or the Mailing List.
REPEAT: Do NOT report bugs for outdated packages!
https://wiki.archlinux.org/title/Bug_reporting_guidelines
Do NOT report bugs when a package is just outdated, or it is in the AUR. Use the 'flag out of date' link on the package page, or the Mailing List.
REPEAT: Do NOT report bugs for outdated packages!
FS#28717 - {archweb} display possible maintainers for orphan packages
Attached to Project:
Arch Linux
Opened by Florian Pritz (bluewind) - Wednesday, 29 February 2012, 17:31 GMT
Last edited by Jelle van der Waa (jelly) - Wednesday, 28 April 2021, 10:53 GMT
Opened by Florian Pritz (bluewind) - Wednesday, 29 February 2012, 17:31 GMT
Last edited by Jelle van der Waa (jelly) - Wednesday, 28 April 2021, 10:53 GMT
|
DetailsThis query returns a list of orphan packages and finds possible maintainers for those by looking at all packages that directly depend on the orphan.
Please make this a report page in the developer area of archweb. SELECT distinct sub.depname as "(orphan) child", sub.pkgbase as "parent", coalesce(user.username, "orphan") as "parent maintainer", p.packager_str as "last child packager" FROM ( SELECT distinct p.pkgbase, dep.depname FROM package_depends as dep JOIN packages as p on p.id = dep.pkg_id WHERE dep.depname in ( SELECT distinct p.pkgbase FROM packages as p LEFT JOIN packages_packagerelation as rel on rel.pkgbase = p.pkgbase WHERE rel.id is null) ) as sub LEFT JOIN packages_packagerelation as rel on rel.pkgbase = sub.pkgbase LEFT JOIN auth_user as user on user.id = rel.user_id LEFT JOIN packages as p on sub.depname = p.pkgname ORDER BY sub.depname, sub.pkgbase; The query is somewhat slow (~1sec execution time) and probably needs to be optimized. |
This task depends upon
Closed by Jelle van der Waa (jelly)
Wednesday, 28 April 2021, 10:53 GMT
Reason for closing: Upstream
Additional comments about closing: https://github.com/archlinux/archweb/iss ues/106
Wednesday, 28 April 2021, 10:53 GMT
Reason for closing: Upstream
Additional comments about closing: https://github.com/archlinux/archweb/iss ues/106
Comment by Dan McGee (toofishes) -
Thursday, 01 March 2012, 00:25 GMT
SELECT DISTINCT pp.pkgbase, ppr.user_id, child.pkgname FROM package_depends ppd JOIN packages pp ON ppd.pkg_id = pp.id JOIN packages_packagerelation ppr ON pp.pkgbase = ppr.pkgbase JOIN (SELECT DISTINCT cp.pkgname FROM packages cp LEFT JOIN packages_packagerelation pr ON cp.pkgbase = pr.pkgbase WHERE pr.id IS NULL) child ON ppd.depname = child.pkgname ORDER BY child.pkgname;