Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dGRA4-0007cB-AA for pgsql-bugs@arkaria.postgresql.org; Thu, 01 Jun 2017 14:33:16 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dGRA3-0006NM-T0 for pgsql-bugs@arkaria.postgresql.org; Thu, 01 Jun 2017 14:33:15 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dGKGK-0007Ri-Cl for pgsql-bugs@postgresql.org; Thu, 01 Jun 2017 07:11:16 +0000 Received: from mwork.nabble.com ([162.253.133.43]) by makus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dGKGF-0002eS-VZ for pgsql-bugs@postgresql.org; Thu, 01 Jun 2017 07:11:13 +0000 Received: from mben.nabble.com (unknown [162.253.133.72]) by mwork.nabble.com (Postfix) with ESMTP id 190D9465B48B5 for ; Thu, 1 Jun 2017 00:11:08 -0700 (MST) Date: Thu, 1 Jun 2017 00:11:08 -0700 (MST) From: wangchuanting To: pgsql-bugs@postgresql.org Message-ID: <1496301068099-5964241.post@n3.nabble.com> In-Reply-To: References: <20170531033228.1487.10124@wrigleys.postgresql.org> <28851.1496239047@sss.pgh.pa.us> Subject: Re: BUG #14680: startup process on standby encounter a deadlock of TwoPhaseStateLock when redo 2PC xlog MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -1.2 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-bugs Precedence: bulk Sender: pgsql-bugs-owner@postgresql.org we use Postgres-XC+pg10(4 coordinator + 4 datanode(pg 10 as datanode, and 1 master 1 standby for each datanode)), and benchmark tpcc, there is some cross datanode transactions that use 2pc, during testing, we restart the cluster, then one datanode standby can not recovery done and hangup with TwoPhaseStateLock deadlock. and sorry, we reinstall the cluster, and the log is removed, we will try to reproduce, but anyway, the code is not right like Michael saied. -- View this message in context: http://www.postgresql-archive.org/BUG-14680-startup-process-on-standby-encounter-a-deadlock-of-TwoPhaseStateLock-when-redo-2PC-xlog-tp5964069p5964241.html Sent from the PostgreSQL - bugs mailing list archive at Nabble.com. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs