From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp1 ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms11 with LMTPS id KDElMQfnsl94EAAA0tVLHw (envelope-from ) for ; Mon, 16 Nov 2020 20:54:31 +0000 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp1 with LMTPS id SFXHLAfnsl/wBQAAbx9fmQ (envelope-from ) for ; Mon, 16 Nov 2020 20:54:31 +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 838AD940367 for ; Mon, 16 Nov 2020 20:54:31 +0000 (UTC) Received: from localhost ([::1]:57728 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1kelWA-00011S-HO for larch@yhetil.org; Mon, 16 Nov 2020 15:54:30 -0500 Received: from eggs.gnu.org ([2001:470:142:3::10]:47730) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1kelVy-0000tt-1G for guix-devel@gnu.org; Mon, 16 Nov 2020 15:54:18 -0500 Received: from mira.cbaines.net ([2a01:7e00:e000:2f8:fd4d:b5c7:13fb:3d27]:38381) by eggs.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1kelVw-0006nd-5Y for guix-devel@gnu.org; Mon, 16 Nov 2020 15:54:17 -0500 Received: from localhost (188.30.135.14.threembb.co.uk [188.30.135.14]) by mira.cbaines.net (Postfix) with ESMTPSA id 2A81027BBF5; Mon, 16 Nov 2020 20:54:15 +0000 (GMT) Received: from capella (localhost [127.0.0.1]) by localhost (OpenSMTPD) with ESMTP id ad18072f; Mon, 16 Nov 2020 20:54:12 +0000 (UTC) References: <868scbvalo.fsf@gmail.com> <87d01m3475.fsf@ambrevar.xyz> <87a6wg7wto.fsf@gnu.org> <87k0ulm78x.fsf@cbaines.net> <86a6vhqcc3.fsf@gmail.com> User-agent: mu4e 1.4.13; emacs 27.1 From: Christopher Baines To: zimoun Subject: Re: Data Services: use cases In-reply-to: <86a6vhqcc3.fsf@gmail.com> Date: Mon, 16 Nov 2020 20:54:09 +0000 Message-ID: <87blfxm39q.fsf@cbaines.net> MIME-Version: 1.0 Content-Type: multipart/signed; boundary="=-=-="; micalg=pgp-sha512; protocol="application/pgp-signature" Received-SPF: pass client-ip=2a01:7e00:e000:2f8:fd4d:b5c7:13fb:3d27; envelope-from=mail@cbaines.net; helo=mira.cbaines.net X-detected-operating-system: by eggs.gnu.org: First seen = 2020/11/16 12:54:49 X-ACL-Warn: Detected OS = ??? X-Spam_score_int: -18 X-Spam_score: -1.9 X-Spam_bar: - X-Spam_report: (-1.9 / 5.0 requ) BAYES_00=-1.9, 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 Errors-To: guix-devel-bounces+larch=yhetil.org@gnu.org Sender: "Guix-devel" X-Scanner: ns3122888.ip-94-23-21.eu Authentication-Results: aspmx1.migadu.com; dkim=none; 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-Spam-Score: -3.11 X-TUID: bRdpL5f+N1t/ --=-=-= Content-Type: text/plain zimoun writes: > Hi Chris, > > On Mon, 16 Nov 2020 at 19:28, Christopher Baines wrote: > >>> I recently have a very similar issue [1]. And based on my >>> investigations [2], the issue seems "commit date vs author date"; >>> especially when merges are floating around. Because of that, from >>> "From" to "To" is not always accurate. Chris, could you confirm? >>> >>> 1: >>> 2: >> >> The Guix Data Service stores the date in the email from the Git hook >> that runs when one pushes to Savannah. That's the date you see for a >> revision, and it should be pretty close to when it actually showed up in >> the Git repository. It's not perfectly accurate, but it should be better >> than either the commit date or author date from the Git metadata. > > Re-reading [2] above, I am confused. Because the Data Service seems to > show the author date rather than the commit date or the header email > date. > > The email database from where the Data Service is fetching is > guix-commits, right? > > If yes, there is different dates that are appearing; for instance the > first I find: commit 5627bfe45ce46f498979b4ad2deab1fdfed22b6c authored > by Jason Conroy and pushed by mothacehe: > > --8<---------------cut here---------------start------------->8--- > From MAILER-DAEMON Thu Oct 01 03:28:02 2020 > Date: Thu, 01 Oct 2020 03:27:57 -0400 > X-List-Received-Date: Thu, 01 Oct 2020 07:28:00 -0000 > -- > AuthorDate: Sun Sep 27 13:16:39 2020 -0400 > --8<---------------cut here---------------end--------------->8--- > > Message-ID: <20201001072757.23203.96292@vcs0.savannah.gnu.org> > > > And from my Git checkout: CommitDate: Thu Oct 1 09:27:33 2020 +0200. > > (Modulo some timezone conversion, I guess.) > > > Maybe my investigations in [2] above are wrong but which date from the > email the Data Service is using? > > > I agree the most accurate is the date from the email header of > guix-commits. So the date given by data.guix.gnu.org for this revision is: 2020-10-01 07:27:57 [1] 1: https://data.guix.gnu.org/revision/5627bfe45ce46f498979b4ad2deab1fdfed22b6c Unfortunately, it's not explicit about the timezone, but it's UTC. This matches the date in the email, as you include it above: It's just expressed in a different timezone. --=-=-= Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQKlBAEBCgCPFiEEPonu50WOcg2XVOCyXiijOwuE9XcFAl+y5vJfFIAAAAAALgAo aXNzdWVyLWZwckBub3RhdGlvbnMub3BlbnBncC5maWZ0aGhvcnNlbWFuLm5ldDNF ODlFRUU3NDU4RTcyMEQ5NzU0RTBCMjVFMjhBMzNCMEI4NEY1NzcRHG1haWxAY2Jh aW5lcy5uZXQACgkQXiijOwuE9XcMgg/7Bj48NGFx8zJobD7hSaIMqT4QmtF0fvvp yCzAdtIXzihtWevhkGcf12dGGLmZkZ7252OqjFveW/4FYUhAsn8c410nBK0b8/f8 ymLMH5+b8ewcHCZwPvZFC+m0DTEm0xXRimEOs1FfGFKRb/UBK8sr8wNAElxXdJv2 XGfMZ3ZaYlq2sGNk3406S4J0dyq8B1NJD8YcMRYXPJB73JyKrXe9GV5ojiveSWXc nCUFRSWQMz9r3haUGMI16cLaKMvIL6odY2X7BYXRQe9JGYFwZFU26WCl5CMLRBVq H92bO05tc2xZwrodXnmUJdFOh0539DTH/zrzMJ4lNdqc8CPeHlMnsjm3tvcgcal/ VSQJBrvNvgo3Eh/Ha/oQmsovfnPklZ4R0JkZ9eL88PT+ZD99Q/FDXinC8+LD/JQ2 Dy2x8VmueeHVnem45EgaRPiiqF3z+LKz2nV9+deJF0EqqTAPtx+1XuM5QjdearV9 su2/MZ4ohQ3DOkhF5rA4/JkEZ6H+cAG5St6RgdOoNMjny+oCQTa9MLaOJHEJjFOq 7/UcCSjMqAmRTdBi/4ocFgX91FKW/Vxw7m/FqYmJQZXjrGe87QaJP42G3oyVjKXK NqubE2lUUkEeI5rC+xcO1U0Xkyrlg2Vgij0TYeDJ+UwJPlwG3PTura7wv3XEzexm nEhAQC6t7SQ= =lL0a -----END PGP SIGNATURE----- --=-=-=--