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 1n89zG-0004tI-Qf for pgsql-hackers@arkaria.postgresql.org; Thu, 13 Jan 2022 23:58:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1n89zE-0007nz-UB for pgsql-hackers@arkaria.postgresql.org; Thu, 13 Jan 2022 23:58:32 +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 1n89zE-0007np-Gk for pgsql-hackers@lists.postgresql.org; Thu, 13 Jan 2022 23:58:32 +0000 Received: from mail-io1-xd31.google.com ([2607:f8b0:4864:20::d31]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1n89zB-0000hp-96 for pgsql-hackers@lists.postgresql.org; Thu, 13 Jan 2022 23:58:31 +0000 Received: by mail-io1-xd31.google.com with SMTP id a12so5633316iod.9 for ; Thu, 13 Jan 2022 15:58:29 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20210112.gappssmtp.com; s=20210112; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:content-transfer-encoding:in-reply-to :user-agent; bh=g9HZ5eUlMBawEtPYC9dSwm/JIroSuEXEH9PIQNWa1bI=; b=idd20PsYTuDbV5hdFiUt6bBPcmXgtEFV2eJ3+Ebbqt/3vDlF9355ApYkt+dEImtw0l Av0N0pBnrMN9B+XQc4XMCkWUtPMkjPVdrf97y0YsEm4RY2kFfbVTNFf5EQpoMSQ5NuMp cXvWPzS5U5T/QmGkdTP16hwPBPYRgKwoaojmCLCobtraZp606oOEGgC43Gu1lsSIGGEL 1ZBSoNP3yS0jfXZTdcc4/qqMXOwJhQ7G+gjUyU2deXXVmtRvDC/uHS0QtVBtKxUXtCjF DVTmS0mIu8pRxHWyFasHeUYkhOoAPhpgd17XetDNnzyaYyb+okEHIzBpACniILoDgnYD cKrg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:content-transfer-encoding :in-reply-to:user-agent; bh=g9HZ5eUlMBawEtPYC9dSwm/JIroSuEXEH9PIQNWa1bI=; b=SP3fP40izlMJ0sRg+8uLDJfxk97h2AhMqoq5kJ4YGG8sl/XgXkJwCftyOCZXsSMl6m hOa63tolxSadxBuDphFsK56yy/KXByalX+6k+XElIXwxRYSz2ipHXbHj/ZyIsroGDBBs 1ndSKki2aXiuJSqfqjptv6sQWZqRu0QGhTJTf2HOsDdKxikio29jZZ9lNjX+lWnHxn+7 ZToIvfCfTX4n+AbAIoUBoTY7foHbkWF9nXnyhzhPDCa01dRmqWgECxqLPIF1W5FBOnlE PNlytWn2+k85TKi3KxcLucNL5da0e9VmcqCOVpsPkLvqu44FEz5QNg2Z+l0e9za5mMlU 2vFw== X-Gm-Message-State: AOAM531P5L8otxtfX1ufRytKnqeqfrSD+I0O/VpsqJlg69FJ6PTSzYDG ZKGfzivCg/Cb5ED/87MGAMH6yMrTXywvPw== X-Google-Smtp-Source: ABdhPJwJevgiTfab//GXA8yFVpQS0MN5oa5WQMUgpdfBgBNLgpYaim3lT/OCBYpSCQT6w3tJdO2Vkg== X-Received: by 2002:a5e:8912:: with SMTP id k18mr1529096ioj.90.1642118308352; Thu, 13 Jan 2022 15:58:28 -0800 (PST) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id w19sm4210632iov.12.2022.01.13.15.58.27 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Thu, 13 Jan 2022 15:58:27 -0800 (PST) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id 48361800783; Thu, 13 Jan 2022 17:58:27 -0600 (CST) Date: Thu, 13 Jan 2022 17:58:27 -0600 From: Justin Pryzby To: Daniil Zakhlystov Cc: pgsql-hackers@lists.postgresql.org, Andrey Borodin Subject: Re: libpq compression (part 2) Message-ID: <20220113235827.GM14051@telsasoft.com> References: <20220112141526.GF14051@telsasoft.com> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, Jan 14, 2022 at 02:12:17AM +0500, Daniil Zakhlystov wrote: > Hi, Justin! > > First of all, thanks for the detailed review. I’ve applied your patches to the current version. Note that my message had other comments that weren't addressed in this patch. Your 0003 patch has a couple "noise" hunks that get rid of ^M characters added in previous patches. The ^M shouldn't be added in the first place. Did you apply my fixes using git-am or something else ? On Fri, Jan 14, 2022 at 02:12:17AM +0500, Daniil Zakhlystov wrote: > > On 12 Jan 2022, at 19:15, Justin Pryzby wrote: > > > > zlib still causes check-world to get stuck. I first mentioned this last March: > > 20210319062800.GI11765@telsasoft.com > > ... > > I removed the thread from the CFBOT until that's resolved. > > I’ve fixed the failing tests, now they should pass. macos: passed linux: timed out after 1hr freebsd: failed in pg_rewind: ... <= replay_lsn AND state = 'streaming' FROM ... windows: "Failed test 'data_checksums=on is reported on an offline cluster stdout /(?^:^on$)/'" / WARNING: 01000: algorithm zlib is not supported Note that it's possible and easy to kick off a CI run using any github account: see ./src/tools/ci/README For me, it's faster than running check-world -j4 locally, and runs tests on 4 OSes. I re-ran your branch under my own account and linux didn't get stuck (and the compiler warnings tests passed). But on a third attempt, macos failed the pg_rewind test, and bsd failed the subscription test: | SELECT count(1) = 0 FROM pg_subscription_rel WHERE srsubstate NOT IN ('s', 'r'); -- Justin