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 1lNHwp-0003fu-5Z for pgsql-hackers@arkaria.postgresql.org; Fri, 19 Mar 2021 16:26:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lNHwo-0002Gx-0z for pgsql-hackers@arkaria.postgresql.org; Fri, 19 Mar 2021 16:26:02 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lNHwn-0002Gq-Qc for pgsql-hackers@lists.postgresql.org; Fri, 19 Mar 2021 16:26:01 +0000 Received: from mail-ed1-x52e.google.com ([2a00:1450:4864:20::52e]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1lNHwl-0003ji-Dm for pgsql-hackers@lists.postgresql.org; Fri, 19 Mar 2021 16:26:00 +0000 Received: by mail-ed1-x52e.google.com with SMTP id dm8so11498797edb.2 for ; Fri, 19 Mar 2021 09:25:59 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb-com.20150623.gappssmtp.com; s=20150623; h=subject:to:cc:references:from:message-id:date:user-agent :mime-version:in-reply-to:content-language:content-transfer-encoding; bh=czOTEU/isLAgAihrq/8X1oQQHpAtJG1pjgtqp5mn2bs=; b=EeCLW6aIKvpnWaZSTTbPrXF2bc0myuh8Y3FEP0cl8s0lnWyi/7Y7XyNibAQHM7WkQl fqSWiWV1TPGPUOzTdK37yIoUmTNm4OK1pakGeCxIwQIbWgZ1YPEF6DFv93o4hx6gTuaO eR9gbjiTD+LO2+uXmSZWBOMq9sXyGlnTFqT5qDMe/PmFt0cy9MMtd2sa/0HhcoE54sEm DGBqa1SkPoRV8J2m0tLdbV6svLpBXRRdkKWRDm/FtMjVvydjb9yFM/HneUV9Sd27pVVi BaHznWyRXPwWmlxMDxHaF8abRzM7QRWBfAYYZ8cj3ZgDh69r/D1ZQ4zRN5CLyNSTtUU4 oxtQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:cc:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-language :content-transfer-encoding; bh=czOTEU/isLAgAihrq/8X1oQQHpAtJG1pjgtqp5mn2bs=; b=RO+umvOWXn8xrD1JChHll9if8TuiFlJb77rkxCW4yg3LcSM60AX6w5oYqiIQygEC6K MSW9SlfLEn/YU6qeArLLuw1hSh9aetl7bBadDgJyENX51Lx+wCwAJFBbHaVo5nXSJl4J GnQY0xS6VCcbSrUsaEK4BOc8L+5N8L903Xt/F7kxnacSot7fnJVQqSd7A0P8KfD6b6h2 H51iisw9jG/MOXW/w+U/SX93bIKnPgtCN45uOY9cuqW1fvyrF9J1D05hA39nQChWk2I1 zfQ2PlcUpHqrj0+0ET1mzi+XOBuuj1DwwJ7FdIc5ozCckscqPldFAjGIFEi5ATeW7QOk TfDw== X-Gm-Message-State: AOAM5321hZ1S020sLSvYSeorVwvSv/Ik2GlwM864rEHemwBcnSHr2vNY WT+k7HUp/N32Jx6zFDaPD9f7yPCsMS97g7sb1u/Cl7RTh7F1AyCUUGoN+bgxHWoFrePrO2TJlhz sM9iUHg0Nq4PJvdKZrx7Dj/XHVEBSbzS4aDsay0ZYme/K9FK9LahUqIXunvrFJ57X5F42Lp3EYf 56CjnrR+BWRvntnbSLN5OdJzLa5/RGtKBQKVAgEruJD+WBIHZruiYBd1Cm4z7plTpqvinWKM1z2 /f52xmYQk8XNENWH1Sem3PKTjD/qqFrlTEAxauCV3C0ImlUngRuVA== X-Google-Smtp-Source: ABdhPJzUXmWxAocGP4LtM4+XQwtMQ7kqcnM1HRNRGKUzQeIADpYBz0CydI1FAQa4W5mEDchrvzeb+w== X-Received: by 2002:aa7:cc94:: with SMTP id p20mr10761939edt.353.1616171157539; Fri, 19 Mar 2021 09:25:57 -0700 (PDT) Received: from [10.137.0.4] (ip-86-49-253-127.net.upcbroadband.cz. [86.49.253.127]) by smtp.gmail.com with ESMTPSA id d5sm3881979ejc.98.2021.03.19.09.25.56 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Fri, 19 Mar 2021 09:25:56 -0700 (PDT) Subject: Re: cleanup temporary files after crash To: Euler Taveira , Tom Lane Cc: Thomas Munro , Michael Paquier , Euler Taveira , Anastasia Lubennikova , Tomas Vondra , PostgreSQL Hackers References: <4245d284-97b2-4056-96c2-455792d9b564@www.fastmail.com> <8740f056-a7c0-ff12-0a50-de5324a928ee@enterprisedb.com> <822e3a60-56a1-219d-c473-365751c3e108@enterprisedb.com> <54663718-1d87-46f2-a27b-e7edacbfae0d@www.fastmail.com> <1ec33f3d-ea4c-28c8-502c-3eb0a008a6ac@enterprisedb.com> <34226249-c5ba-4780-a1bb-f3433d19716e@www.fastmail.com> <05d307fc-8391-4091-b279-1b3214658f10@www.fastmail.com> <049a2752-fc99-194d-31b2-b15ffa914cd4@enterprisedb.com> <482a6498-7713-e937-c554-7d235c415fba@enterprisedb.com> <112f0847-a71!a-eec2-e561-2d39dc26127a@enterprisedb.com> <4028905.1616122655@sss.pgh.pa.us> <19bc3276-6280-43bd-d868-ab3cb146266a@enter!prisedb.com> <4030089.1616124234@sss.pgh.pa.us> <6eff9861-b059-4eaa-ae70-e5ff877b6448@www.fastmail.com> <70bbfaac-74dd-de9a-b086-8bf43224e1c0@enterprisedb.com> From: Tomas Vondra Message-ID: <9c4357e6-549d-02c7-6402-d2a466da7bdc@enterprisedb.com> Date: Fri, 19 Mar 2021 17:25:54 +0100 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101 Thunderbird/78.8.0 MIME-Version: 1.0 In-Reply-To: <70bbfaac-74dd-de9a-b086-8bf43224e1c0@enterprisedb.com> Content-Type: text/plain; charset=utf-8 Content-Language: en-US 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 3/19/21 5:23 PM, Tomas Vondra wrote: > ... > > If I replace this with a wait loop in a plpgsql block, that works > perfectly fine (no infinite loops). Tested both on x86_64 and rpi. > For the record, here's the version with plpgsql block, which seems to be working just fine. regards -- Tomas Vondra EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company