Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cmSsi-0000f7-1I for pgsql-hackers@arkaria.postgresql.org; Fri, 10 Mar 2017 22:19:28 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cmSsg-0007xM-Sl for pgsql-hackers@arkaria.postgresql.org; Fri, 10 Mar 2017 22:19:26 +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_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cmSsg-0007xC-5v for pgsql-hackers@postgresql.org; Fri, 10 Mar 2017 22:19:26 +0000 Received: from mail-qk0-x235.google.com ([2607:f8b0:400d:c09::235]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1cmSsc-0000Fb-CO for pgsql-hackers@postgresql.org; Fri, 10 Mar 2017 22:19:25 +0000 Received: by mail-qk0-x235.google.com with SMTP id v125so185242210qkh.2 for ; Fri, 10 Mar 2017 14:19:21 -0800 (PST) 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=C9Nkcfx2EKojpdF+wDZpWsuUA+vLHL+ugU8wWbolp0s=; b=LkE4l59hRrTLLT3DHDt8ufOgmxFTs7OpjL/REdi/oBRM2Npt01W1m1b5m41//zmGvh qDom20HSnZlJKFqJK8jkwVqr9PiqiJtLdLAAy8qhfF18ijtvhTfq7mk7irtHpfwVpkUj 5cE7yfI+VQVh5B9jnatipIEXsqvNbI5F4ZgBsTT51ymmw+t76Jn75Tx3l13nfUC5fgwJ p5+Q47dIDe4KhkCzdrAjt9JCsdKSqUdQrtMxvA2SuhUKdqFX1DA7/jb13b0b47TI8RkN Tdt+cvnD8gqWaCIZQ3QbovuIdSK0sZEXW0KJvafg18owBirnrSEIG5GJgypuh520ch3t wocg== 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=C9Nkcfx2EKojpdF+wDZpWsuUA+vLHL+ugU8wWbolp0s=; b=DhZ+UfT1uUUyF5wde6D1Rro5vf7PImmiGReCa//mOEkaBgmBMTPEJsu2gX4r5+tiTk CTFURZT4IGGCoI2uyUxZl2+7cr84oO7ILKIH+C8frSbas2DcTKHNUGNuK+1t6f41xXOv dt5Au06YUpPIpHsIiHRxKSfLLyLQBSWKX1Q6/ns4erJrXj83iwZ1HBHe+zCJt2akmMEP 3O/ulBBMO1IlLTGsLTt5V7wmujJgeOkjQ1tG+7LZwDZbBONpnO2fWu7jLUz/jKGA2bF0 qNWPiuHQuc1xX+ggohR6k7hgAsXtL5TVEvfy2HtUFjK0txA1DFCBwZ9zDkbfYy67Hlgi pOvQ== X-Gm-Message-State: AMke39kUA8+m1dR4C42STK33+GsocBTZI1yMdrFvNcKsRj9Z8nuYU1xd+LfANxX6xqDpG+gg X-Received: by 10.237.42.21 with SMTP id c21mr21463559qtd.11.1489184359581; Fri, 10 Mar 2017 14:19:19 -0800 (PST) Received: from alvin.alvh.no-ip.org ([179.57.115.10]) by smtp.gmail.com with ESMTPSA id m12sm7256400qtf.25.2017.03.10.14.19.18 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Fri, 10 Mar 2017 14:19:19 -0800 (PST) Received: by alvin.alvh.no-ip.org (Postfix, from userid 1000) id 4131B935; Fri, 10 Mar 2017 19:19:17 -0300 (CLST) Date: Fri, 10 Mar 2017 19:19:17 -0300 From: Alvaro Herrera To: Robert Haas Cc: Amit Kapila , Tom Lane , Michael Paquier , Dilip Kumar , Tomas Vondra , Jim Nasby , Andres Freund , pgsql-hackers Subject: Re: Speed up Clog Access by increasing CLOG buffers Message-ID: <20170310221917.dijugbcqym35of7o@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: User-Agent: NeoMutt/20170206-195-7adf12 (1.7.2) X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org Robert Haas wrote: > The smoking gun was in 009_twophase_slave.log: > > TRAP: FailedAssertion("!(nsubxids == MyPgXact->nxids)", File: > "clog.c", Line: 288) > > ...and then the node shuts down, which is why this hangs forever. > (Also... what's up with it hanging forever instead of timing out or > failing or something?) This bit my while messing with 2PC tests recently. I think it'd be worth doing something about this, such as causing the test to die if we request a server to (re)start and it doesn't start or it immediately crashes. This doesn't solve the problem of a server crashing at a point not immediately after start, though. (It'd be very annoying to have to sprinkle the Perl test code with "assert $server->islive", but perhaps we can add assertions of some kind in PostgresNode itself). -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers