Re: recovering from "found xmin ... from before relfrozenxid ..."
От
Ashutosh Sharma
Тема
Re: recovering from "found xmin ... from before relfrozenxid ..."
Дата
Msg-id
CAE9k0Pm1bjfcHT7JWscGoWSc1MQbOEX8nKaJFb-Un0PSDGdEjw@mail.gmail.com
Ответ на
Список
Дерево обсуждения
recovering from "found xmin ... from before relfrozenxid ..." Robert Haas <robertmhaas@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Stephen Frost <sfrost@snowman.net>
Re: recovering from "found xmin ... from before relfrozenxid ..." Tom Lane <tgl@sss.pgh.pa.us>
Re: recovering from "found xmin ... from before relfrozenxid ..." Robert Haas <robertmhaas@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Fujii Masao <masao.fujii@oss.nttdata.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Robert Haas <robertmhaas@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Robert Haas <robertmhaas@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Andres Freund <andres@anarazel.de>
Re: recovering from "found xmin ... from before relfrozenxid ..." Robert Haas <robertmhaas@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Andres Freund <andres@anarazel.de>
Re: recovering from "found xmin ... from before relfrozenxid ..." Robert Haas <robertmhaas@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Robert Haas <robertmhaas@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Ashutosh Sharma <ashu.coek88@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Re: recovering from "found xmin ... from before relfrozenxid ..." Ashutosh Sharma <ashu.coek88@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Re: recovering from "found xmin ... from before relfrozenxid ..." Ashutosh Sharma <ashu.coek88@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Ashutosh Sharma <ashu.coek88@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Re: recovering from "found xmin ... from before relfrozenxid ..." MBeena Emerson <mbeena.emerson@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Ashutosh Sharma <ashu.coek88@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Ashutosh Sharma <ashu.coek88@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Robert Haas <robertmhaas@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Ashutosh Sharma <ashu.coek88@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Masahiko Sawada <masahiko.sawada@2ndquadrant.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Ashutosh Sharma <ashu.coek88@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Masahiko Sawada <masahiko.sawada@2ndquadrant.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Ashutosh Sharma <ashu.coek88@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Robert Haas <robertmhaas@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Ashutosh Sharma <ashu.coek88@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Asim Praveen <pasim@vmware.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Ashutosh Sharma <ashu.coek88@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Robert Haas <robertmhaas@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Masahiko Sawada <masahiko.sawada@2ndquadrant.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Ashutosh Sharma <ashu.coek88@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Alvaro Herrera <alvherre@2ndquadrant.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Robert Haas <robertmhaas@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Ashutosh Sharma <ashu.coek88@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Ashutosh Sharma <ashu.coek88@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Masahiko Sawada <masahiko.sawada@2ndquadrant.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Ashutosh Sharma <ashu.coek88@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Masahiko Sawada <masahiko.sawada@2ndquadrant.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Ashutosh Sharma <ashu.coek88@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Masahiko Sawada <masahiko.sawada@2ndquadrant.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Ashutosh Sharma <ashu.coek88@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Ashutosh Sharma <ashu.coek88@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Masahiko Sawada <masahiko.sawada@2ndquadrant.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Masahiko Sawada <masahiko.sawada@2ndquadrant.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Robert Haas <robertmhaas@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Ashutosh Sharma <ashu.coek88@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Ashutosh Sharma <ashu.coek88@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Robert Haas <robertmhaas@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Ashutosh Sharma <ashu.coek88@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Robert Haas <robertmhaas@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Masahiko Sawada <masahiko.sawada@2ndquadrant.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Robert Haas <robertmhaas@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Masahiko Sawada <masahiko.sawada@2ndquadrant.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Ashutosh Sharma <ashu.coek88@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Mark Dilger <mark.dilger@enterprisedb.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Ashutosh Sharma <ashu.coek88@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Ashutosh Sharma <ashu.coek88@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Robert Haas <robertmhaas@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Robert Haas <robertmhaas@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Justin Pryzby <pryzby@telsasoft.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Tom Lane <tgl@sss.pgh.pa.us>
Re: recovering from "found xmin ... from before relfrozenxid ..." Ashutosh Sharma <ashu.coek88@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Robert Haas <robertmhaas@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Tom Lane <tgl@sss.pgh.pa.us>
Re: recovering from "found xmin ... from before relfrozenxid ..." Ashutosh Sharma <ashu.coek88@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Tom Lane <tgl@sss.pgh.pa.us>
Re: recovering from "found xmin ... from before relfrozenxid ..." Ashutosh Sharma <ashu.coek88@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Ashutosh Sharma <ashu.coek88@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Robert Haas <robertmhaas@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Tom Lane <tgl@sss.pgh.pa.us>
Re: recovering from "found xmin ... from before relfrozenxid ..." Robert Haas <robertmhaas@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Tom Lane <tgl@sss.pgh.pa.us>
Re: recovering from "found xmin ... from before relfrozenxid ..." Ashutosh Sharma <ashu.coek88@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Robert Haas <robertmhaas@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Tom Lane <tgl@sss.pgh.pa.us>
Re: recovering from "found xmin ... from before relfrozenxid ..." Amit Kapila <amit.kapila16@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Tom Lane <tgl@sss.pgh.pa.us>
Re: recovering from "found xmin ... from before relfrozenxid ..." Tom Lane <tgl@sss.pgh.pa.us>
Re: recovering from "found xmin ... from before relfrozenxid ..." Tom Lane <tgl@sss.pgh.pa.us>
Re: recovering from "found xmin ... from before relfrozenxid ..." Andres Freund <andres@anarazel.de>
Re: recovering from "found xmin ... from before relfrozenxid ..." Tom Lane <tgl@sss.pgh.pa.us>
Re: recovering from "found xmin ... from before relfrozenxid ..." Andres Freund <andres@anarazel.de>
Re: recovering from "found xmin ... from before relfrozenxid ..." Tom Lane <tgl@sss.pgh.pa.us>
Re: recovering from "found xmin ... from before relfrozenxid ..." Andres Freund <andres@anarazel.de>
Re: recovering from "found xmin ... from before relfrozenxid ..." Andres Freund <andres@anarazel.de>
Re: recovering from "found xmin ... from before relfrozenxid ..." Andres Freund <andres@anarazel.de>
Re: recovering from "found xmin ... from before relfrozenxid ..." Andres Freund <andres@anarazel.de>
Re: recovering from "found xmin ... from before relfrozenxid ..." Andres Freund <andres@anarazel.de>
Re: recovering from "found xmin ... from before relfrozenxid ..." Andres Freund <andres@anarazel.de>
Re: recovering from "found xmin ... from before relfrozenxid ..." Andres Freund <andres@anarazel.de>
Re: recovering from "found xmin ... from before relfrozenxid ..." Andrey Borodin <x4mmm@yandex-team.ru>
Re: recovering from "found xmin ... from before relfrozenxid ..." Robert Haas <robertmhaas@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Michael Banck <michael.banck@credativ.de>
Re: recovering from "found xmin ... from before relfrozenxid ..." Robert Haas <robertmhaas@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Andrey Borodin <x4mmm@yandex-team.ru>
Re: recovering from "found xmin ... from before relfrozenxid ..." Robert Haas <robertmhaas@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Tom Lane <tgl@sss.pgh.pa.us>
Re: recovering from "found xmin ... from before relfrozenxid ..." Robert Haas <robertmhaas@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Tom Lane <tgl@sss.pgh.pa.us>
Re: recovering from "found xmin ... from before relfrozenxid ..." Andres Freund <andres@anarazel.de>
Re: recovering from "found xmin ... from before relfrozenxid ..." Amit Kapila <amit.kapila16@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Tom Lane <tgl@sss.pgh.pa.us>
Re: recovering from "found xmin ... from before relfrozenxid ..." Ashutosh Sharma <ashu.coek88@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Ashutosh Sharma <ashu.coek88@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Re: recovering from "found xmin ... from before relfrozenxid ..." Ashutosh Sharma <ashu.coek88@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Ashutosh Sharma <ashu.coek88@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Ashutosh Sharma <ashu.coek88@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Ashutosh Sharma <ashu.coek88@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Robert Haas <robertmhaas@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Ashutosh Sharma <ashu.coek88@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Rajkumar Raghuwanshi <rajkumar.raghuwanshi@enterprisedb.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Ashutosh Sharma <ashu.coek88@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Robert Haas <robertmhaas@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Ashutosh Sharma <ashu.coek88@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Robert Haas <robertmhaas@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Ashutosh Sharma <ashu.coek88@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Ashutosh Sharma <ashu.coek88@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Robert Haas <robertmhaas@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Ashutosh Sharma <ashu.coek88@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Robert Haas <robertmhaas@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Ashutosh Sharma <ashu.coek88@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Andres Freund <andres@anarazel.de>
Re: recovering from "found xmin ... from before relfrozenxid ..." Alvaro Herrera <alvherre@2ndquadrant.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Andres Freund <andres@anarazel.de>
Re: recovering from "found xmin ... from before relfrozenxid ..." Alvaro Herrera <alvherre@2ndquadrant.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Robert Haas <robertmhaas@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Andres Freund <andres@anarazel.de>
Re: recovering from "found xmin ... from before relfrozenxid ..." Robert Haas <robertmhaas@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Andres Freund <andres@anarazel.de>
Re: recovering from "found xmin ... from before relfrozenxid ..." Tom Lane <tgl@sss.pgh.pa.us>
Re: recovering from "found xmin ... from before relfrozenxid ..." Robert Haas <robertmhaas@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Tom Lane <tgl@sss.pgh.pa.us>
Re: recovering from "found xmin ... from before relfrozenxid ..." Jochem van Dieten <jochemd@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Magnus Hagander <magnus@hagander.net>
Re: recovering from "found xmin ... from before relfrozenxid ..." Robert Haas <robertmhaas@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Magnus Hagander <magnus@hagander.net>
Re: recovering from "found xmin ... from before relfrozenxid ..." Robert Haas <robertmhaas@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Magnus Hagander <magnus@hagander.net>
Re: recovering from "found xmin ... from before relfrozenxid ..." Stephen Frost <sfrost@snowman.net>
Re: recovering from "found xmin ... from before relfrozenxid ..." Robert Haas <robertmhaas@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Thomas Munro <thomas.munro@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Robert Haas <robertmhaas@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Thomas Munro <thomas.munro@gmail.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Peter Geoghegan <pg@bowt.ie>
Re: recovering from "found xmin ... from before relfrozenxid ..." Chris Travers <chris.travers@adjust.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." Rajkumar Raghuwanshi <rajkumar.raghuwanshi@enterprisedb.com>
Re: recovering from "found xmin ... from before relfrozenxid ..." "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Hi Robert,
Thanks for the review.
I've gone through all your review comments and understood all of them except this one:
I've gone through all your review comments and understood all of them except this one:
You really cannot
modify the buffer like this and then decide, oops, never mind, I think
I won't mark it dirty or write WAL for the changes. If you do that,
the buffer is still in memory, but it's now been modified. A
subsequent operation that modifies it will start with the altered
state you created here, quite possibly leading to WAL that cannot be
correctly replayed on the standby. In other words, you've got to
decide for certain whether you want to proceed with the operation
*before* you enter the critical section.
Could you please explain this point once more in detail? I am not quite able to understand under what circumstances a buffer would be modified, but won't be marked as dirty or a WAL won't be written for it.
В списке pgsql-hackers по дате отправления
От: David Rowley
Дата: