pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Petr Jelinek <petr.jelinek@2ndquadrant.com>
To: Erik Rijkers <er@xs4all.nl>
Cc: Andres Freund <andres@anarazel.de>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Cc: Robert Haas <robertmhaas@gmail.com>
Cc: Craig Ringer <craig@2ndquadrant.com>
Subject: Re: snapbuild woes
Date: Wed, 10 May 2017 10:43:07 +0200
Message-ID: <7b5b72b3-4d83-2279-4d44-4217ac71ff4e@2ndquadrant.com> (raw)
In-Reply-To: <75ea19824d366c9626ee821fa3c35883@xs4all.nl>
References: <20170413002959.apytyi5lkknauauj@alap3.anarazel.de>
	<0d06dfc1-0bc5-c3ab-3555-24e2f275d7fa@2ndquadrant.com>
	<30242bc6-eca4-b7bb-670e-8d0458753a8c@2ndquadrant.com>
	<20170501005921.qcqd7w2njpv3av6s@alap3.anarazel.de>
	<20170501013529.sejtgo2acxbvq26q@alap3.anarazel.de>
	<209861fc-718f-0a7b-3a1d-36512865c209@2ndquadrant.com>
	<20170501080348.vb6mj5whdex3f7l7@alap3.anarazel.de>
	<e6c1fdfe-50bc-62e4-3ad7-854f6ac5c35e@2ndquadrant.com>
	<20170501191419.coqbtx2jodu22ufz@alap3.anarazel.de>
	<ba7a3052-6e71-d162-d4a0-b5bdd7145c19@2ndquadrant.com>
	<20170505000004.gihrtl7bhxeolf3q@alap3.anarazel.de>
	<076a3e4c3d4fef091522d3cd7e50c7eb@xs4all.nl>
	<46835ad4-ce7d-ae45-bfdd-9e5f79d33a89@2ndquadrant.com>
	<169b7d221f3236b7cb790c8dd323dbe0@xs4all.nl>
	<4ff19c9f-96ed-40ee-14f4-6286a56b5ac8@2ndquadrant.com>
	<84a48a73304ed5363433ec4b9fbb4438@xs4all.nl>
	<7d3b9bb1-41a9-1f9a-43ca-c4bb271333a1@2ndquadrant.com>
	<75ea19824d366c9626ee821fa3c35883@xs4all.nl>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-hackers>

On 09/05/17 22:11, Erik Rijkers wrote:
> On 2017-05-09 21:00, Petr Jelinek wrote:
>> On 09/05/17 19:54, Erik Rijkers wrote:
>>> On 2017-05-09 11:50, Petr Jelinek wrote:
>>>
>>
>> Ah okay, so this is same issue that's reported by both Masahiko Sawada
>> [1] and Jeff Janes [2].
>>
>> [1]
>> https://www.postgresql.org/message-id/CAD21AoBYpyqTSw%2B%3DES%2BxXtRGMPKh%3DpKiqjNxZKnNUae0pSt9bg%40...
>>
>> [2]
>> https://www.postgresql.org/message-id/flat/CAMkU%3D1xUJKs%3D2etq2K7bmbY51Q7g853HLxJ7qEB2Snog9oRvDw%4...
>>
> 
> I don't understand why you come to that conclusion: both Masahiko Sawada
> and Jeff Janes have a DROP SUBSCRIPTION in the mix; my cases haven't. 
> Isn't that a real difference?
> 

Because I only see the sync workers running in the output you shown, the
bug described in those threads can as one of side effects cause the sync
workers to wait forever for the apply that was killed, crashed, etc, in
the right moment, which I guess is what happened during your failed test
(there should be some info in the log about apply exiting).

-- 
  Petr Jelinek                  http://www.2ndQuadrant.com/
  PostgreSQL Development, 24x7 Support, 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



view thread (92+ messages)  latest in thread

Message-ID: <7b5b72b3-4d83-2279-4d44-4217ac71ff4e@2ndquadrant.com>
Permalink:  ../7b5b72b3-4d83-2279-4d44-4217ac71ff4e@2ndquadrant.com/
Also on:    postgresql.org/message-id/7b5b72b3-4d83-2279-4d44-4217ac71ff4e@2ndquadrant.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: petr.jelinek@2ndquadrant.com, er@xs4all.nl, andres@anarazel.de, robertmhaas@gmail.com, craig@2ndquadrant.com
  Subject: Re: snapbuild woes
  In-Reply-To: <7b5b72b3-4d83-2279-4d44-4217ac71ff4e@2ndquadrant.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox