Re: [BUGS] BUG #14830: Missed NOTIFications, PostgreSQL 9.1.24

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [BUGS] BUG #14830: Missed NOTIFications, PostgreSQL 9.1.24
Дата
Msg-id 15645.1507643938@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [BUGS] BUG #14830: Missed NOTIFications, PostgreSQL 9.1.24  (Marko Tiikkaja <marko@joh.to>)
Ответы Re: [BUGS] BUG #14830: Missed NOTIFications, PostgreSQL 9.1.24  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Re: [BUGS] BUG #14830: Missed NOTIFications, PostgreSQL 9.1.24  (Marko Tiikkaja <marko@joh.to>)
Список pgsql-bugs
Marko Tiikkaja <marko@joh.to> writes:
> So I managed to accidentally kill and/or restart both servers while trying
> to install debug symbols, but I'm doing a new run now and I noticed
> something interesting: the listening backend's RecentXmin doesn't seem to
> ever go forward.  By my reading of this code, that would mean trouble for
> this piece of code in TransactionIdIsInProgress:

>   if (TransactionIdPrecedes(xid, RecentXmin))
>       return false;

Hmm ... I suppose it's possible that that happens if the listening
backend isn't executing any SQL commands but is just sitting.
While that might describe your test harness, does it describe any
real-world application?
        regards, tom lane


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Petr Jelinek
Дата:
Сообщение: Re: [BUGS] 10.0: Logical replication doesn't execute BEFORE UPDATE OF trigger
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: [BUGS] BUG #14830: Missed NOTIFications, PostgreSQL 9.1.24