From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp2 ([2001:41d0:8:6d80::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms0.migadu.com with LMTPS id APYwBqswdGGbBgEAgWs5BA (envelope-from ) for ; Sat, 23 Oct 2021 17:56:27 +0200 Received: from aspmx1.migadu.com ([2001:41d0:8:6d80::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp2 with LMTPS id IJHUAaswdGG7YAAAB5/wlQ (envelope-from ) for ; Sat, 23 Oct 2021 15:56:27 +0000 Received: from lists.gnu.org (lists.gnu.org [209.51.188.17]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by aspmx1.migadu.com (Postfix) with ESMTPS id AAE821ACCE for ; Sat, 23 Oct 2021 17:56:26 +0200 (CEST) Received: from localhost ([::1]:59022 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1meJNh-0000fj-Qz for larch@yhetil.org; Sat, 23 Oct 2021 11:56:25 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:35544) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1meJNP-0000e7-TU for guix-devel@gnu.org; Sat, 23 Oct 2021 11:56:08 -0400 Received: from out4-smtp.messagingengine.com ([66.111.4.28]:43449) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1meJNL-0001aK-AL for guix-devel@gnu.org; Sat, 23 Oct 2021 11:56:07 -0400 Received: from compute5.internal (compute5.nyi.internal [10.202.2.45]) by mailout.nyi.internal (Postfix) with ESMTP id A27E35C01DD; Sat, 23 Oct 2021 11:56:00 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute5.internal (MEProxy); Sat, 23 Oct 2021 11:56:00 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :date:from:in-reply-to:message-id:mime-version:references :subject:to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender :x-sasl-enc; s=fm1; bh=1zwLty6EMMaZe//riW7r1gWT4d5MVqHK2xMEnvlY2 J0=; b=lEBhwWtlMBULSRrj3CsJfBxXmHWHGMDas95ESzg+eQI3WgnV8cq9h8qum 5kQOYaQrfD/KwCH5xr2EbYsLHrqA1R8sAviZcdmmzrhBudrgIqe8KPq8LKveTl0i uHV0HIqsr22XXIk2E4XPyuTXY5+L5F7mHIikwhpui8uhBeM1gzt09/lGdbdccLaR hlUeNqEXV+BpGQum0FE+nbE67DI93iZSw6oS1Ovnf8R+4jWtlP4sNDrUx2/31AFY ufes8GM8g2qsq/5kcTz9QrTBEey1cBcGO3kSP/sKw6sTQ3WmYcIZn3VeiLgT3nM4 BjCG82B3xMunnFfhhAsz/QIIW2okw== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvtddrvdeftddgledvucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucenucfjughrpefhvffufhffjgfkfgggtgfgsehtqh ertddtreejnecuhfhrohhmpefvihhmohhthhihucfurghmphhlvgcuoehsrghmphhlvght sehnghihrhhordgtohhmqeenucggtffrrghtthgvrhhnpeekgfffvdeivdfgjeefhfetfe duleeikefggffgjeekheduueduheegudevvdduffenucffohhmrghinhepghhithhhuhgs rdgtohhmnecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomh epshgrmhhplhgvthesnhhghihrohdrtghomh X-ME-Proxy: Received: by mail.messagingengine.com (Postfix) with ESMTPA; Sat, 23 Oct 2021 11:56:00 -0400 (EDT) From: Timothy Sample To: zimoun Subject: Re: Preservation of Guix 2021-10-22 References: <87v91o35u2.fsf@ngyro.com> <86a6j0b2jo.fsf@gmail.com> Date: Sat, 23 Oct 2021 11:55:58 -0400 In-Reply-To: <86a6j0b2jo.fsf@gmail.com> (zimoun's message of "Sat, 23 Oct 2021 09:52:59 +0200") Message-ID: <87r1cb3fch.fsf@ngyro.com> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/27.2 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Received-SPF: pass client-ip=66.111.4.28; envelope-from=samplet@ngyro.com; helo=out4-smtp.messagingengine.com X-Spam_score_int: -25 X-Spam_score: -2.6 X-Spam_bar: -- X-Spam_report: (-2.6 / 5.0 requ) BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H3=0.001, RCVD_IN_MSPIKE_WL=0.001, SPF_HELO_PASS=-0.001, SPF_PASS=-0.001 autolearn=ham autolearn_force=no X-Spam_action: no action X-BeenThere: guix-devel@gnu.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: "Development of GNU Guix and the GNU System distribution." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Cc: guix-devel@gnu.org Errors-To: guix-devel-bounces+larch=yhetil.org@gnu.org Sender: "Guix-devel" X-Migadu-Flow: FLOW_IN ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1635004586; h=from:from:sender:sender:reply-to:subject:subject:date:date: message-id:message-id:to:to:cc:cc:mime-version:mime-version: content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references:list-id:list-help: list-unsubscribe:list-subscribe:list-post:dkim-signature; bh=1zwLty6EMMaZe//riW7r1gWT4d5MVqHK2xMEnvlY2J0=; b=IpCDx9Nd0/bHJoVIJIxXycHA5CI8ixssI9T64eWPWfMkTyInOK3+PvOHk65x3CT+8it+hi QvVH5Qg2RWG2/CAu1pBd7O0hzMhIJJm+FkTePiMoS5d4n2bQuqto6ud2d86ghgfssTcmlN g3iz0jawnYVrneS4ajUDlMoHh3zQpb33WhDkeNv4qMvKFK27rhEpnndc0OrEdlNjiQB8/H Z/KBQohufvNeH079q1fVRYDaKY60hipXJRaRz7rBO5DZqo2BQqbadN0AsGKKDmD95Nbl41 dpYKiF3ncaAwVOsm6jwo+mJt3a0evGcQm364RGuPJigpD2Hd8IRiCLSpgKk+Vg== ARC-Seal: i=1; s=key1; d=yhetil.org; t=1635004586; a=rsa-sha256; cv=none; b=V89JVLb9VwAUIQYLdFUpeFIlajBvzH3yFhXWMe/7tkq7THcNh0tSZnYZbQvODhasNDi9iC Oz5LGUfBZPZNczvxVwH6FKL/ycWNrvEI7uO4ZzhwjzWr8HwxhZhq8KmypmnU3RY8g6JP8E 1yHOG8us0L0HhkLfxOBx918gDBQutyVxXlxJ8H4eeRh8bOfpKBQEcZEWj+857Hayc2/mZv ae768M3Jhmj68dgGcHSj5LSqQEV3pjIzIxRGPXVHybLB6kYoUJbNOcpYb+nsVMVaHq78XN qZa9NwsxsRdv/8ck9Dnkyz7wKGiEWQt3eY1qRbEzmvFq5FmXyIfol2zy3xbTgg== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=pass header.d=messagingengine.com header.s=fm1 header.b=lEBhwWtl; dmarc=none; spf=pass (aspmx1.migadu.com: domain of guix-devel-bounces@gnu.org designates 209.51.188.17 as permitted sender) smtp.mailfrom=guix-devel-bounces@gnu.org X-Migadu-Spam-Score: -1.13 Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=messagingengine.com header.s=fm1 header.b=lEBhwWtl; dmarc=none; spf=pass (aspmx1.migadu.com: domain of guix-devel-bounces@gnu.org designates 209.51.188.17 as permitted sender) smtp.mailfrom=guix-devel-bounces@gnu.org X-Migadu-Queue-Id: AAE821ACCE X-Spam-Score: -1.13 X-Migadu-Scanner: scn0.migadu.com X-TUID: 4U28dKHuLYby Hello, zimoun writes: > How can I get the list of these 376+217 packages? Because it appears to > me easy to send a save request for them. :_) Download the database (there=E2=80=99s a button at the bottom of the report= ), and use SQLite to run the following queries. For the 376: SELECT fod_id, swhid, reference FROM fods LEFT JOIN fod_references USING (fod_id) WHERE NOT is_in_swh AND reference LIKE '(git-reference%'; For the 217 (which is the best place to start): SELECT fod_id, swhid, reference FROM fods JOIN fod_commit_links USING (fod_id) JOIN commits USING (commit_id) LEFT JOIN fod_references USING (fod_id) WHERE commits.hash =3D '258a27eea9aab4f8af995f95743ccd264b5efcb5' AND NOT is_in_swh AND reference LIKE '(git-reference%'; Keep in mind that there is still a possibility of bugs or issues. Some of the results make sense to me, like if it=E2=80=99s from sourcehut. Howe= ver, most of them are from Github, and they should have ended up in the archive one way or another. In short, sometimes you have to double check the SWHID. You can do this by searching by origin and finding the tag. If there=E2=80=99s a difference, it=E2=80=99s not necessarily a bug (= like with the Gawk 3.0.0 tarball), but it will have to be investigated. I investigated one just to see: . It turns out that SWH just hasn=E2=80=99t visited it since September, so they didn=E2=80=99t have the most recent tags. I asked them to visit it, and now they do. It=E2=80=99s as simple as that! I still think there might be more interesting problems, but it=E2=80=99s nice that some of them are that simp= le. -- Tim