Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1owOVi-00087y-GB for pgsql-hackers@arkaria.postgresql.org; Sat, 19 Nov 2022 14:07:58 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1owOVg-00021Z-1M for pgsql-hackers@arkaria.postgresql.org; Sat, 19 Nov 2022 14:07:56 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1owOVf-00021Q-89 for pgsql-hackers@lists.postgresql.org; Sat, 19 Nov 2022 14:07:55 +0000 Received: from mail-ej1-x630.google.com ([2a00:1450:4864:20::630]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1owOVX-0003TR-Pc for pgsql-hackers@lists.postgresql.org; Sat, 19 Nov 2022 14:07:54 +0000 Received: by mail-ej1-x630.google.com with SMTP id f27so19424073eje.1 for ; Sat, 19 Nov 2022 06:07:47 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; h=content-transfer-encoding:in-reply-to:from:references:cc:to :content-language:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=qpjAoOKk8VR5tWpWruNSkEo+HaaJd+9KVQALdwJXLiE=; b=Ij5LI6JHdDg1pax+BR7afhlOiqtdEjurLxIUpj4jUKOJnW25x6km2RzPVq1vsCZddy PV12U75JF8kcBqeWhVro2mzxE6lrY3Akvv9wNhc2c1lcZ8N554h1+zW3vcvK39Qgyi0k IzF0JlfNeGQHDuhLI6k4df4BvkGh/onOimP6mkIRdBtJ8DI9yOlUnU5OksmygJrJwljf FZ2W7OJzq+9rlr9t2owunDXKbtheXNw9USJPFpCDaRsbzXNk50CUpnABV9YUMQOZuVB2 CPOLWZ7kCw5DfVZkMTEcOaOCPzc6ftZR3oM8/MZsI7TnxEWKqIj6SbgcAd7vVHQ5Z2wj It9w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=content-transfer-encoding:in-reply-to:from:references:cc:to :content-language:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=qpjAoOKk8VR5tWpWruNSkEo+HaaJd+9KVQALdwJXLiE=; b=bcb2JGjPm2SUuhhgGV+HYtfM7Z7UUYGHWwY9ULEOblTwI8PwI+icMDF8voPq8SfPPt 692XduY0lwE6Bu74UaE77Ro8alqjBld6FkxNyg74/7yEhDohXDAAXKbd/K8qVPiX7IrP U5kh2kslwrwfbj0nFqwJdoRS10zshO9MZOR/TD5+ImRk6voWV/R/Thg7T5PF/g70P+SO 8oxH5e4QTIHSz4YJfsZ+e8zS+/TUeWOCeF3K3oiFd75ZlACKCi3xvNA+Hf3hQuifZPLt iqg2D0Af2G5IhvsJizvbVuTVxcMG6Kwq1YBKf3KgGxXW037MIzsutIDz1jaKKvHSiPMf 8pDA== X-Gm-Message-State: ANoB5pnEgo19tAVRrRpPWgWK63w0Pj424I1I2vWXR0WlOdR2ExA88AdY 69sxbFUYNx1Ank25HfLmGnasjnPl/VnlXWzn4y+NWN+7yX86o4vmrvtk7RVmN7IKghM4WZNtDNc f+9MzdOjll94VCP8dFDV9mFNeLto56VgT0HQnFt14Mlz/O8JCcgwN5y3GFgCnpbHxUPfmdAM6rF EK/aQyaySFEo/hRCRpDeP00iXNp73yv/VvMURu8WH0G7NHXACXmU1KpkBXvb3HarxOanrGMwze4 Ly1BTNwn1soqqrDiEN6lTTwk3nCjXVoXLGRLL9lyGRjG/jetRvEtBd8qJFnQlVosSPQ X-Google-Smtp-Source: AA0mqf4U8IU4PQ61qLWEpLIeZQTwPALMhdA5SbHGdEkYLYYdvl+5iavw09k8slNTo/Whx8aVK7MV6g== X-Received: by 2002:a17:906:f281:b0:7ae:3b9e:1d8a with SMTP id gu1-20020a170906f28100b007ae3b9e1d8amr9063199ejb.581.1668866866639; Sat, 19 Nov 2022 06:07:46 -0800 (PST) Received: from [10.137.0.17] (ip-86-49-228-162.bb.vodafone.cz. [86.49.228.162]) by smtp.gmail.com with ESMTPSA id fg7-20020a056402548700b004618a89d273sm2929273edb.36.2022.11.19.06.07.45 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Sat, 19 Nov 2022 06:07:46 -0800 (PST) Message-ID: <1bbb0340-3dbe-717a-4094-a4344238245b@enterprisedb.com> Date: Sat, 19 Nov 2022 15:07:45 +0100 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.5.0 Subject: Re: test/modules/test_oat_hooks vs. debug_discard_caches=1 Content-Language: en-US To: Andrew Dunstan , Tom Lane , Andres Freund Cc: pgsql-hackers@lists.postgresql.org References: <2267406.1668804934@sss.pgh.pa.us> <20221119003349.uzpopxq2skgrmwc4@awork3.anarazel.de> <2316565.1668827411@sss.pgh.pa.us> <9ce14134-5725-5b9f-e27e-f4002ff13a4e@enterprisedb.com> From: Tomas Vondra In-Reply-To: Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-CLOUD-SEC-AV-Info: enterprisedb,google_mail,monitor X-CLOUD-SEC-AV-Sent: true X-Gm-Spam: 0 X-Gm-Phishy: 0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 11/19/22 14:51, Andrew Dunstan wrote: > > On 2022-11-19 Sa 05:34, Tomas Vondra wrote: >> >> I wonder if it'd make sense to have some simple & optional alerting >> based on how long ago the machine reported the last result. Send e-mail >> if there was no report for a month or so would be enough. > > > This has been part of the buildfarm for a very long time. See the alerts > section of the config file. > I'm aware of that, but those alerts are not quite what I was asking about. Imagine the run gets stuck for whatever reason (like infinite loop somewhere), or maybe the VM fails / gets inaccessible for whatever reason, perhaps because of some sort of human error so that the cron does not get run ... I don't think alerting from the client would catch those cases, but maybe it's a rare issue and I'm overthinking it. regards -- Tomas Vondra EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company