Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iAXcS-0004gS-IA for pgsql-hackers@arkaria.postgresql.org; Wed, 18 Sep 2019 10:55:32 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iAXcR-0002t6-Bf for pgsql-hackers@arkaria.postgresql.org; Wed, 18 Sep 2019 10:55:31 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iAXcR-0002st-0W for pgsql-hackers@lists.postgresql.org; Wed, 18 Sep 2019 10:55:31 +0000 Received: from mail-vs1-xe41.google.com ([2607:f8b0:4864:20::e41]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iAXcO-0001Zl-Ab for pgsql-hackers@lists.postgresql.org; Wed, 18 Sep 2019 10:55:30 +0000 Received: by mail-vs1-xe41.google.com with SMTP id m22so4132451vsl.9 for ; Wed, 18 Sep 2019 03:55:27 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=SKcLGv5iWHjwcd2K3RTTSGEibh0s5zsW0x8QvsCTZ9M=; b=jKz1NSn172NFp8S0M91BQtnZi32Ju6lFIVqUmMhSDAOcch4DUF/Mg6jI0j+gDXnW0S 6I0uUjMIJ1etoWdUNljft81exq4ztrpTVYStc6R6/3K74L6Vn5F7mEwpoAeZPNknfJia pYMUXn/rbcsDt9qx3MvqSL/+2aqbSe+HTDCBNm5zpu3h2Bf3mSmIlXSfod5qEmtCi+8x 0UHMaMqmzOlQniQlqtzNANfAWTpGqCSCxvjXEH0VpmWGWCQ6bKQ4nIQmXlwI3Q3p2Sdp h0t9MTs4WYIN5yEH0GQzjXZ7bGeYfA/yipEaLkdvWqTLi4RvL0fvJdMrjxWi7By4s5lj Zpgg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=SKcLGv5iWHjwcd2K3RTTSGEibh0s5zsW0x8QvsCTZ9M=; b=CeKfUxYMu4B8lYzFjz+ZZhRBVKqwu7uAHOR0EIvDlh69dEZ1jHbTk7KhNfCudTd38N ls8l2rXarrC6DSAsGyhco6QNg4xsISV2roDGJp5Wit5FOac1RaXTsY+0PygSnUg/aiAw IWTi+0eRrz0sj9jrmuq1jOvkBZ6sB0XaE/f94I8Bg+aqroBSb+TPP4MPEJlvWQ1e145f wN9dqL5nztT60Hymq1UyS3QKbKEUTLJpY2ShTXE220RkJeUGVXan9h3+wOOmAx5j6yOF z1IqPyq04VxYxmKG1PkRF5a4MsaAY6yVmm1BvRdodIiPOlX6peYbP79H+/P6VyG/Uaze 0ENg== X-Gm-Message-State: APjAAAXwsCxuW/ziXzkHZv5G1OHkEdnlYGpfrxanzey15bo7A48mYRQn qb78s5cKQgbmZjoLq8lYXlwqonP3wOvj9bRbZ4A= X-Google-Smtp-Source: APXvYqw2BhprP56KVls/gCFdJpEvId7whIZznVxYvX6oHVq2CbmJLi9uuJfm2nsj4id+aYTl/NiPtox+5+4sWW/YV2E= X-Received: by 2002:a67:70c5:: with SMTP id l188mr1652639vsc.19.1568804126095; Wed, 18 Sep 2019 03:55:26 -0700 (PDT) MIME-Version: 1.0 References: <31663.1550082243@sss.pgh.pa.us> <20190213183303.ns54frt7cmvo6pgg@alap3.anarazel.de> <1466.1550085086@sss.pgh.pa.us> <20190213215147.cjbymfojf6xndr4t@alap3.anarazel.de> <20190813080435.GL2551@paquier.xyz> <20190826132904.3ayuw36qzl2c4ktr@development> <7361.1568738373@sss.pgh.pa.us> <20190917194510.iqwyl3be62pz7l27@development> <20190918005815.GB8909@paquier.xyz> In-Reply-To: <20190918005815.GB8909@paquier.xyz> From: Kuntal Ghosh Date: Wed, 18 Sep 2019 16:25:14 +0530 Message-ID: Subject: Re: subscriptionCheck failures on nightjar To: Michael Paquier Cc: Tomas Vondra , Tom Lane , Robert Haas , Andres Freund , Thomas Munro , PostgreSQL Hackers Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hello Michael, On Wed, Sep 18, 2019 at 6:28 AM Michael Paquier wrote: > > On my side, I have let this thing run for a couple of hours with a > patched version to include a sleep between the rename and the sync but > I could not reproduce it either: > #!/bin/bash > attempt=0 > while true; do > attempt=$((attempt+1)) > echo "Attempt $attempt" > cd $HOME/postgres/src/test/recovery/ > PROVE_TESTS=t/006_logical_decoding.pl make check > /dev/null 2>&1 > ERRNUM=$? > if [ $ERRNUM != 0 ]; then > echo "Failed at attempt $attempt" > exit $ERRNUM > fi > done I think the failing test is src/test/subscription/t/010_truncate.pl. I've tried to reproduce the same failure using your script in OS X 10.14 and Ubuntu 18.04.2 (Linux version 5.0.0-23-generic), but couldn't reproduce the same. -- Thanks & Regards, Kuntal Ghosh EnterpriseDB: http://www.enterprisedb.com