Re: [HACKERS] make async slave to wait for lsn to be replayed
От
Картышов Иван
Тема
Re: [HACKERS] make async slave to wait for lsn to be replayed
Дата
Msg-id
22f122-655b3e80-3-688b3700@97587957
Ответ на
Re: [HACKERS] make async slave to wait for lsn to be replayed (Alexander Korotkov)
Список
Дерево обсуждения
Re: [HACKERS] make async slave to wait for lsn to be replayed Kartyshov Ivan <i.kartyshov@postgrespro.ru>
Re: [HACKERS] make async slave to wait for lsn to be replayed Peter Eisentraut <peter.eisentraut@enterprisedb.com>
Re: [HACKERS] make async slave to wait for lsn to be replayed Kartyshov Ivan <i.kartyshov@postgrespro.ru>
Re: [HACKERS] make async slave to wait for lsn to be replayed Kartyshov Ivan <i.kartyshov@postgrespro.ru>
Re: [HACKERS] make async slave to wait for lsn to be replayed Картышов Иван <i.kartyshov@postgrespro.ru>
Re: [HACKERS] make async slave to wait for lsn to be replayed Alexander Korotkov <aekorotkov@gmail.com>
Re: [HACKERS] make async slave to wait for lsn to be replayed Alexander Korotkov <aekorotkov@gmail.com>
Re: [HACKERS] make async slave to wait for lsn to be replayed Картышов Иван <i.kartyshov@postgrespro.ru>
Re: [HACKERS] make async slave to wait for lsn to be replayed Bowen Shi <zxwsbg12138@gmail.com>
Re: [HACKERS] make async slave to wait for lsn to be replayed Alexander Korotkov <aekorotkov@gmail.com>
Re: [HACKERS] make async slave to wait for lsn to be replayed Alexander Korotkov <aekorotkov@gmail.com>
Re: [HACKERS] make async slave to wait for lsn to be replayed Kartyshov Ivan <i.kartyshov@postgrespro.ru>
Re: [HACKERS] make async slave to wait for lsn to be replayed Alexander Korotkov <aekorotkov@gmail.com>
Re: [HACKERS] make async slave to wait for lsn to be replayed Kartyshov Ivan <i.kartyshov@postgrespro.ru>
Fwd: Re: [HACKERS] make async slave to wait for lsn to be replayed Kartyshov Ivan <i.kartyshov@postgrespro.ru>
Re: [HACKERS] make async slave to wait for lsn to be replayed Kartyshov Ivan <i.kartyshov@postgrespro.ru>
Re: [HACKERS] make async slave to wait for lsn to be replayed Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] make async slave to wait for lsn to be replayed Alexander Korotkov <aekorotkov@gmail.com>
Re: [HACKERS] make async slave to wait for lsn to be replayed Kartyshov Ivan <i.kartyshov@postgrespro.ru>
Re: [HACKERS] make async slave to wait for lsn to be replayed Kartyshov Ivan <i.kartyshov@postgrespro.ru>
Re: [HACKERS] make async slave to wait for lsn to be replayed Alexander Korotkov <aekorotkov@gmail.com>
Re: [HACKERS] make async slave to wait for lsn to be replayed Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: [HACKERS] make async slave to wait for lsn to be replayed Kartyshov Ivan <i.kartyshov@postgrespro.ru>
Re: [HACKERS] make async slave to wait for lsn to be replayed Alexander Korotkov <aekorotkov@gmail.com>
Re: [HACKERS] make async slave to wait for lsn to be replayed Alexander Korotkov <aekorotkov@gmail.com>
Re: [HACKERS] make async slave to wait for lsn to be replayed Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] make async slave to wait for lsn to be replayed Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: [HACKERS] make async slave to wait for lsn to be replayed Alexander Korotkov <aekorotkov@gmail.com>
Re: [HACKERS] make async slave to wait for lsn to be replayed Peter Eisentraut <peter@eisentraut.org>
Re: [HACKERS] make async slave to wait for lsn to be replayed Kartyshov Ivan <i.kartyshov@postgrespro.ru>
Re: [HACKERS] make async slave to wait for lsn to be replayed Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: [HACKERS] make async slave to wait for lsn to be replayed Alexander Korotkov <aekorotkov@gmail.com>
Re: [HACKERS] make async slave to wait for lsn to be replayed Alexander Korotkov <aekorotkov@gmail.com>
Re: [HACKERS] make async slave to wait for lsn to be replayed Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] make async slave to wait for lsn to be replayed Alexander Korotkov <aekorotkov@gmail.com>
Re: [HACKERS] make async slave to wait for lsn to be replayed Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] make async slave to wait for lsn to be replayed Alexander Korotkov <aekorotkov@gmail.com>
Re: [HACKERS] make async slave to wait for lsn to be replayed Kartyshov Ivan <i.kartyshov@postgrespro.ru>
Re: [HACKERS] make async slave to wait for lsn to be replayed Peter Eisentraut <peter@eisentraut.org>
Re: [HACKERS] make async slave to wait for lsn to be replayed Alexander Korotkov <aekorotkov@gmail.com>
Re: [HACKERS] make async slave to wait for lsn to be replayed Alexander Korotkov <aekorotkov@gmail.com>
Re: [HACKERS] make async slave to wait for lsn to be replayed vignesh C <vignesh21@gmail.com>
Re: [HACKERS] make async slave to wait for lsn to be replayed Kartyshov Ivan <i.kartyshov@postgrespro.ru>
Re: [HACKERS] make async slave to wait for lsn to be replayed Kartyshov Ivan <i.kartyshov@postgrespro.ru>
Re: [HACKERS] make async slave to wait for lsn to be replayed Dilip Kumar <dilipbalaut@gmail.com>
Re: [HACKERS] make async slave to wait for lsn to be replayed Peter Smith <smithpb2250@gmail.com>
Re: [HACKERS] make async slave to wait for lsn to be replayed Alexander Korotkov <aekorotkov@gmail.com>
Re: [HACKERS] make async slave to wait for lsn to be replayed Kartyshov Ivan <i.kartyshov@postgrespro.ru>
Re: [HACKERS] make async slave to wait for lsn to be replayed Greg Stark <stark@mit.edu>
Re: [HACKERS] make async slave to wait for lsn to be replayed Michael Paquier <michael@paquier.xyz>
Alexander, thank you for your review and pointing this issues. According to
them I made some fixes and rebase all patch.
But I can`t repeat your ERROR. Not with hot_standby_feedback = on nor
hot_standby_feedback = off.
Patch rebased and ready for review.
them I made some fixes and rebase all patch.
But I can`t repeat your ERROR. Not with hot_standby_feedback = on nor
hot_standby_feedback = off.
master: create table test as (select i from generate_series(1,10000) i);Also I use little hack to work out of snapshot similar to SnapshotResetXmin.
slave conn1: select pg_wal_replay_pause();
master: delete from test;
master: vacuum test;
master: select pg_current_wal_lsn();
slave conn2: select pg_wait_lsn('the value from previous query'::pg_lsn, 0);
slave conn1: select pg_wal_replay_resume();
slave conn2: ERROR: canceling statement due to conflict with recovery
DETAIL: User query might have needed to see row versions that must be removed.
Patch rebased and ready for review.
В списке pgsql-hackers по дате отправления
От: Dilip Kumar
Дата: