Re: [HACKERS] logical replication busy-waiting on a lock - Mailing list pgsql-hackers

From Jeff Janes
Subject Re: [HACKERS] logical replication busy-waiting on a lock
Date
Msg-id CAMkU=1zjF3qm873Qj73rUfEaNOnzAE3E2QmTHbU6kaOUKY0-5A@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] logical replication busy-waiting on a lock  (Petr Jelinek <petr.jelinek@2ndquadrant.com>)
Responses Re: [HACKERS] logical replication busy-waiting on a lock  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers
On Sat, May 27, 2017 at 6:48 AM, Petr Jelinek <petr.jelinek@2ndquadrant.com> wrote:


Actually, I guess it's the pid 47457 (COPY process) who is actually
running the xid 73322726. In that case that's the same thing Masahiko
Sawada reported [1].

Related, but not the same.  It would be nice if they didn't block, but if they do have to block, shouldn't it wait on a semaphore, rather than doing a tight loop?  It looks like maybe a latch didn't get reset when it should have or something.


[1]
https://www.postgresql.org/message-id/flat/CAD21AoC2KJdavS7MFffmSsRc1dn3Vg_0xmuc%3DUpBrZ-_MUxh-Q%40mail.gmail.com

Cheers,

Jeff

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] fix side-effect in get_qual_for_list()
Next
From: Andres Freund
Date:
Subject: Re: [HACKERS] logical replication busy-waiting on a lock