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 1h5Bqv-00010H-PU for pgsql-hackers@arkaria.postgresql.org; Sat, 16 Mar 2019 16:08:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1h5Bqt-0001yy-Jp for pgsql-hackers@arkaria.postgresql.org; Sat, 16 Mar 2019 16:08:03 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h5Bqt-0001sO-75 for pgsql-hackers@lists.postgresql.org; Sat, 16 Mar 2019 16:08:03 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h5Bqm-0008Tt-Ex for pgsql-hackers@lists.postgresql.org; Sat, 16 Mar 2019 16:08:02 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id x2GG7tAU027831 for ; Sat, 16 Mar 2019 12:07:55 -0400 From: Tom Lane To: pgsql-hackers@lists.postgresql.org Subject: Unduly short fuse in RequestCheckpoint MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <27829.1552752475.1@sss.pgh.pa.us> Content-Transfer-Encoding: quoted-printable Date: Sat, 16 Mar 2019 12:07:55 -0400 Message-ID: <27830.1552752475@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk I noticed an odd buildfarm failure today: https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=3Dsungazer&dt=3D20= 19-03-16%2012%3A12%3A20 of which the key bit seems to be 2019-03-16 15:20:43.835 UTC [10879304] 003_promote.pl LOG: received repli= cation command: BASE_BACKUP LABEL 'pg_basebackup base backup' NOWAIT = 2019-03-16 15:20:45.857 UTC [10879304] 003_promote.pl ERROR: could not re= quest checkpoint because checkpointer not running 2019-03-16 15:20:47.227 UTC [61604144] LOG: received immediate shutdown r= equest Digging in the buildfarm archives finds seven other occurrences of the same error in the past three months (I didn't look back further). The cause of this error is that RequestCheckpoint will give up and fail after just 2 seconds, which evidently is not long enough on slow or heavily loaded machines. Since there isn't any good reason why the checkpointer wouldn't be running, I'm inclined to swing a large hammer and kick this timeout up to 60 seconds. Thoughts? regards, tom lane