Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dG2Of-0004jl-GI for pgsql-bugs@arkaria.postgresql.org; Wed, 31 May 2017 12:06:41 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dG2Oe-0005EM-I2 for pgsql-bugs@arkaria.postgresql.org; Wed, 31 May 2017 12:06:40 +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 1dFuNm-0005on-2L for pgsql-bugs@postgresql.org; Wed, 31 May 2017 03:33:14 +0000 Received: from wrigleys.postgresql.org ([204.145.124.246]) by magus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dFuNc-0005zQ-LE for pgsql-bugs@postgresql.org; Wed, 31 May 2017 03:33:11 +0000 MIME-Version: 1.0 Subject: BUG #14680: startup process on standby encounter a deadlock of TwoPhaseStateLock when redo 2PC xlog To: pgsql-bugs@postgresql.org From: wangchuanting@huawei.com Date: Wed, 31 May 2017 03:32:28 +0000 Message-ID: <20170531033228.1487.10124@wrigleys.postgresql.org> X-Pg-Spam-Score: -1.2 (-) Content-Transfer-Encoding: base64 Content-Type: text/plain; charset="utf-8" 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 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDY4MApMb2dnZWQgYnk6ICAg ICAgICAgIGNodWFudGluZyAgd2FuZwpFbWFpbCBhZGRyZXNzOiAgICAgIHdh bmdjaHVhbnRpbmdAaHVhd2VpLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246IDEw YmV0YTEKT3BlcmF0aW5nIHN5c3RlbTogICBTdVNFCkRlc2NyaXB0aW9uOiAg ICAgICAgCgpzdGFydHVwIHByb2Nlc3Mgb24gc3RhbmRieSBlbmNvdW50ZXIg YSBkZWFkbG9jayBvZiBUd29QaGFzZVN0YXRlTG9jayB3aGVuCnJlZG8gMlBD IHhsb2cuDQoNCnRoZSBzdGFjayBpczoNClRocmVhZCA2IChUaHJlYWQgMHg3 ZjAwMmUzZmY3MDAgKExXUCAzNTMwNSkpOg0KIzAgIDB4MDAwMDdmMTEwNjE2 NzYyNyBpbiBzZW1vcCAoKSBmcm9tIC9saWI2NC9saWJjLnNvLjYNCiMxICAw eDAwMDAwMDAwMDBjZTU2MjIgaW4gUEdTZW1hcGhvcmVMb2NrKFBHU2VtYXBo b3JlRGF0YSosIGJvb2wpICgpDQojMiAgMHgwMDAwMDAwMDAwZDczZTRkIGlu IExXTG9ja0FjcXVpcmUoTFdMb2NrSWQsIExXTG9ja01vZGUpICgpDQojMyAg MHgwMDAwMDAwMDAwOTY5MDI4IGluIFJlbW92ZUdYYWN0KEdsb2JhbFRyYW5z YWN0aW9uRGF0YSopICgpDQojNCAgMHgwMDAwMDAwMDAwOTZiMjU0IGluIFBy b2Nlc3NUd29QaGFzZUJ1ZmZlcih1bnNpZ25lZCBpbnQsIFhMb2dSZWNQdHIs CmJvb2wsIGJvb2wsIGJvb2wpICgpDQojNSAgMHgwMDAwMDAwMDAwOTZiNmI4 IGluIFByZXNjYW5QcmVwYXJlZFRyYW5zYWN0aW9ucyh1bnNpZ25lZCBpbnQq KiwgaW50KikKKCkNCiM2ICAweDAwMDAwMDAwMDA5N2FmOTcgaW4geGxvZ19y ZWRvKFhMb2dSZWFkZXJTdGF0ZSopICgpDQojNyAgMHgwMDAwMDAwMDAwOTgz OWRmIGluIFN0YXJ0dXBYTE9HKCkgKCkNCiM4ICAweDAwMDAwMDAwMDBjZmZk MGIgaW4gU3RhcnR1cFByb2Nlc3NNYWluKCkgKCkNCiM5ICAweDAwMDAwMDAw MDA5OTE1MzkgaW4gQXV4aWxpYXJ5UHJvY2Vzc01haW4oaW50LCBjaGFyKiop ICgpDQojMTAgMHgwMDAwMDAwMDAwY2ZiMjA5IGluIFN1YlBvc3RtYXN0ZXJN YWluKGludCwgY2hhcioqKSAoKQ0KIzExIDB4MDAwMDAwMDAwMGNmYjRmMiBp biBNYWluU3RhcnRlclRocmVhZEZ1bmModm9pZCopICgpDQojMTIgMHgwMDAw N2YxMTA5OWExN2I2IGluIHN0YXJ0X3RocmVhZCAoKSBmcm9tIC9saWI2NC9s aWJwdGhyZWFkLnNvLjANCiMxMyAweDAwMDA3ZjExMDYxNjVkNmQgaW4gY2xv bmUgKCkgZnJvbSAvbGliNjQvbGliYy5zby42DQojMTQgMHgwMDAwMDAwMDAw MDAwMDAwIGluID8/ICgpDQoNCnRoZSByZWFzb24gaXM6DQp3aGVuIGRvIFBy ZXNjYW5QcmVwYXJlZFRyYW5zYWN0aW9ucywgc3RhcnR1cCBwcm9jZXNzIGFs cmVhZHkgZ3JhbnRlZCBhCnNoYXJlZCBsb2NrIG9uIFR3b1BoYXNlU3RhdGVM b2NrLCB0aGVuIGl0IGNhbGxlZCBSZW1vdmVHWGFjdCwgYnV0IGluClJlbW92 ZUdYYWN0IGl0IGFjcXVpcmVkIGV4Y2x1c2l2ZSBsb2NrIG9uIFR3b1BoYXNl U3RhdGVMb2NrLCBzbyBpdCBibG9ja2VkCmJ5IGl0c2VsZg0KDQoNCmFueW9u ZSwgaGFzIHNvbWUgaWRlYSBvbiBob3cgdG8gZml4IGl0Pw0KCgoKLS0gClNl bnQgdmlhIHBnc3FsLWJ1Z3MgbWFpbGluZyBsaXN0IChwZ3NxbC1idWdzQHBv c3RncmVzcWwub3JnKQpUbyBtYWtlIGNoYW5nZXMgdG8geW91ciBzdWJzY3Jp cHRpb246Cmh0dHA6Ly93d3cucG9zdGdyZXNxbC5vcmcvbWFpbHByZWYvcGdz cWwtYnVncwo=