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.92) (envelope-from ) id 1jEeiF-0006s2-FL for pgsql-hackers@arkaria.postgresql.org; Wed, 18 Mar 2020 19:50:47 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1jEeiD-0004Ax-Ta for pgsql-hackers@arkaria.postgresql.org; Wed, 18 Mar 2020 19:50:45 +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 1jEeiD-0004Ao-H8 for pgsql-hackers@lists.postgresql.org; Wed, 18 Mar 2020 19:50:45 +0000 Received: from mail-qv1-xf44.google.com ([2607:f8b0:4864:20::f44]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1jEeiA-0001v0-Ek for pgsql-hackers@postgresql.org; Wed, 18 Mar 2020 19:50:44 +0000 Received: by mail-qv1-xf44.google.com with SMTP id cz10so13615828qvb.0 for ; Wed, 18 Mar 2020 12:50:42 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=date:from:to:cc:subject:message-id:mime-version:content-disposition :content-transfer-encoding:in-reply-to:user-agent; bh=VV/210xLpu8exT1YP9/3TzrPX63ZFsbuuqzW183kFsE=; b=SCkKLPfASoaaSzF2NApe6Qz6eFfn3JSVSt4v1iUK/+LM/B43wUMd1qrNVgDbHaGLY7 2S63WJWdc8lhFm5Pc8MPRJeDzBfZ4+RD4l1NQzwbMO8ikLIMwk+Y/1DGD6vE6E/zcLwT A7/RXcwfEFdw1M1YLNVQUs5Arx/knCICcsskzSlVBTYIDlcDiJv8HpmornVZczzS+i69 hXWyiS2YLErQaVzpbGouLz7fdghako6mn6qOKt/+wSIesPXJYORT00JmwL4rACslRX2l eHpg0N3lwgHsmq3bLbscDCM3W7uiT3aIpzZxLQdgWvin+K3vQ/K3+ebO1No+H1wgBtp/ lF3w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:from:to:cc:subject:message-id:mime-version :content-disposition:content-transfer-encoding:in-reply-to :user-agent; bh=VV/210xLpu8exT1YP9/3TzrPX63ZFsbuuqzW183kFsE=; b=Xo5m4Y4nHOsb2wnNJlyfqofn1K7keY4haumjBA8sSdYNv1diMZCvcuVd3LGLaXfNYs 4cpJfox1vZSM/7lokbjJMkpFDAkBIAdwwsqSvQ4uS6DaIfNiXnsUyc+qYU1WeCCXWQCa WpYlKEF9Sq6P9aKq1g9IIOOOsdcrFKkV4NR/glH0Y+VvQoymh43jx6SoWxqMC5sjLLDY j8IU7zN3MZm8v4dpNvIwXuJVntikilOCmmwZ6AbvrT3FGCFAIbMaLZ62YqDQLq3Z7Pvh zUzIUYFAHU3f3H4ZSgECWKpZII+nNI1TeLBT+mglNQWpdH0JmvqmrwskMVJtj04Botdk eInA== X-Gm-Message-State: ANhLgQ0OPxgdyheHc6B7y9FU7FxZrNbhRYpabI8LKw6RqRcCIY17z1H1 KVYV24s2yZzEWKg8eTlMbzZmQw== X-Google-Smtp-Source: ADFU+vtIy6jpfs6zTekUyca+QBeBo4tAYFsX/zDSAOq10QkxHpe5DlpXk8jKufBvzDLdNe6Uy9Yegg== X-Received: by 2002:a0c:fde7:: with SMTP id m7mr6071149qvu.53.1584561041281; Wed, 18 Mar 2020 12:50:41 -0700 (PDT) Received: from nimloth.alvh.no-ip.org ([201.186.208.119]) by smtp.gmail.com with ESMTPSA id h5sm4729495qkc.118.2020.03.18.12.50.40 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 18 Mar 2020 12:50:40 -0700 (PDT) Received: by nimloth.alvh.no-ip.org (Postfix, from userid 1000) id 68585300819; Wed, 18 Mar 2020 16:50:38 -0300 (-03) Date: Wed, 18 Mar 2020 16:50:38 -0300 From: Alvaro Herrera To: Amit Khandekar Cc: Rahila Syed , pgsql-hackers Subject: Re: Minimal logical decoding on standbys Message-ID: <20200318195038.GA7123@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <20200318184249.GA29007@alvherre.pgsql> User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 2020-Mar-18, Alvaro Herrera wrote: > On 2020-Mar-18, Alvaro Herrera wrote: > > > There were conflicts again, so I rebased once more. Didn't do anything > > else. > > This compiles fine, but tests seem to hang forever with no output. well, not "forever", but: $ make check PROVE_TESTS=t/019_standby_logical_decoding_conflicts.pl PROVE_FLAGS=-v ... cd /pgsql/source/master/src/test/recovery && TESTDIR='/home/alvherre/mnt/crypt/alvherre/Code/pgsql/build/master/src/test/recovery' PATH="/pgsql/build/master/tmp_install/pgsql/install/master/bin:$PATH" LD_LIBRARY_PATH="/pgsql/build/master/tmp_install/pgsql/install/master/lib" PGPORT='655432' PG_REGRESS='/home/alvherre/mnt/crypt/alvherre/Code/pgsql/build/master/src/test/recovery/../../../src/test/regress/pg_regress' REGRESS_SHLIB='/pgsql/build/master/src/test/regress/regress.so' /usr/bin/prove -I /pgsql/source/master/src/test/perl/ -I /pgsql/source/master/src/test/recovery -v t/019_standby_logical_decoding_conflicts.pl t/019_standby_logical_decoding_conflicts.pl .. 1..24 ok 1 - dropslot on standby created ok 2 - activeslot on standby created # poll_query_until timed out executing this query: # SELECT '0/35C9190' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name = 'standby'; # expecting this output: # t # last actual query output: # # with stderr: Bailout called. Further testing stopped: system pg_ctl failed Bail out! system pg_ctl failed FAILED--Further testing stopped: system pg_ctl failed make: *** [Makefile:19: check] Error 255 -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services