Re: amcheck (B-Tree integrity checking tool)
От
Peter Geoghegan
Тема
Re: amcheck (B-Tree integrity checking tool)
Дата
Msg-id
CAM3SWZRGycL9t9GSSQPb2L5Zaxt-4ZnrFi35FRghvdOeetWs-g@mail.gmail.com
Ответ на
Re: amcheck (B-Tree integrity checking tool) (Robert Haas)
Список
Дерево обсуждения
amcheck (B-Tree integrity checking tool) Peter Geoghegan <pg@heroku.com>
Re: amcheck (B-Tree integrity checking tool) Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: amcheck (B-Tree integrity checking tool) Peter Geoghegan <pg@heroku.com>
Re: amcheck (B-Tree integrity checking tool) Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: amcheck (B-Tree integrity checking tool) Peter Geoghegan <pg@heroku.com>
Re: amcheck (B-Tree integrity checking tool) Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: amcheck (B-Tree integrity checking tool) Peter Geoghegan <pg@heroku.com>
Re: amcheck (B-Tree integrity checking tool) Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: amcheck (B-Tree integrity checking tool) Robert Haas <robertmhaas@gmail.com>
Re: amcheck (B-Tree integrity checking tool) Peter Geoghegan <pg@heroku.com>
Re: amcheck (B-Tree integrity checking tool) Peter Geoghegan <pg@heroku.com>
Re: amcheck (B-Tree integrity checking tool) Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: amcheck (B-Tree integrity checking tool) Peter Geoghegan <pg@heroku.com>
Re: amcheck (B-Tree integrity checking tool) Matt Kelly <mkellycs@gmail.com>
Re: amcheck (B-Tree integrity checking tool) Peter Geoghegan <pg@heroku.com>
Re: amcheck (B-Tree integrity checking tool) Peter Geoghegan <pg@heroku.com>
Re: amcheck (B-Tree integrity checking tool) Michael Paquier <michael.paquier@gmail.com>
Re: amcheck (B-Tree integrity checking tool) Peter Geoghegan <pg@heroku.com>
Re: amcheck (B-Tree integrity checking tool) Michael Paquier <michael.paquier@gmail.com>
Re: amcheck (B-Tree integrity checking tool) Peter Geoghegan <pg@heroku.com>
Re: amcheck (B-Tree integrity checking tool) Peter Geoghegan <pg@heroku.com>
Re: amcheck (B-Tree integrity checking tool) Kevin Grittner <kgrittn@gmail.com>
Re: amcheck (B-Tree integrity checking tool) Peter Geoghegan <pg@heroku.com>
Re: amcheck (B-Tree integrity checking tool) Kevin Grittner <kgrittn@gmail.com>
Re: amcheck (B-Tree integrity checking tool) Peter Geoghegan <pg@heroku.com>
Re: amcheck (B-Tree integrity checking tool) Andres Freund <andres@anarazel.de>
Re: amcheck (B-Tree integrity checking tool) Peter Geoghegan <pg@heroku.com>
Re: amcheck (B-Tree integrity checking tool) Peter Geoghegan <pg@heroku.com>
Re: amcheck (B-Tree integrity checking tool) Robert Haas <robertmhaas@gmail.com>
Re: amcheck (B-Tree integrity checking tool) Peter Geoghegan <pg@heroku.com>
Re: amcheck (B-Tree integrity checking tool) Robert Haas <robertmhaas@gmail.com>
Re: amcheck (B-Tree integrity checking tool) Peter Geoghegan <pg@heroku.com>
Re: [HACKERS] amcheck (B-Tree integrity checking tool) Andres Freund <andres@anarazel.de>
Re: [HACKERS] amcheck (B-Tree integrity checking tool) Andres Freund <andres@anarazel.de>
Re: [HACKERS] amcheck (B-Tree integrity checking tool) Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] amcheck (B-Tree integrity checking tool) Andres Freund <andres@anarazel.de>
Re: [HACKERS] amcheck (B-Tree integrity checking tool) Peter Geoghegan <pg@bowt.ie>
Re: [HACKERS] amcheck (B-Tree integrity checking tool) Andres Freund <andres@anarazel.de>
Re: [HACKERS] amcheck (B-Tree integrity checking tool) Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] amcheck (B-Tree integrity checking tool) Andres Freund <andres@anarazel.de>
Re: [HACKERS] amcheck (B-Tree integrity checking tool) Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] amcheck (B-Tree integrity checking tool) Andres Freund <andres@anarazel.de>
Re: [HACKERS] amcheck (B-Tree integrity checking tool) Peter Geoghegan <pg@bowt.ie>
Re: [HACKERS] amcheck (B-Tree integrity checking tool) Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] amcheck (B-Tree integrity checking tool) Andres Freund <andres@anarazel.de>
Re: [HACKERS] amcheck (B-Tree integrity checking tool) Peter Geoghegan <pg@bowt.ie>
Re: [HACKERS] amcheck (B-Tree integrity checking tool) Andres Freund <andres@anarazel.de>
Re: [HACKERS] amcheck (B-Tree integrity checking tool) Peter Geoghegan <pg@bowt.ie>
Re: [HACKERS] amcheck (B-Tree integrity checking tool) Andres Freund <andres@anarazel.de>
Re: [HACKERS] amcheck (B-Tree integrity checking tool) Peter Geoghegan <pg@bowt.ie>
Re: [HACKERS] amcheck (B-Tree integrity checking tool) Andres Freund <andres@anarazel.de>
Re: [HACKERS] amcheck (B-Tree integrity checking tool) Peter Geoghegan <pg@bowt.ie>
Re: [HACKERS] amcheck (B-Tree integrity checking tool) Peter Geoghegan <pg@bowt.ie>
Re: [HACKERS] amcheck (B-Tree integrity checking tool) Peter Geoghegan <pg@bowt.ie>
Re: [HACKERS] amcheck (B-Tree integrity checking tool) Peter Geoghegan <pg@bowt.ie>
Re: [HACKERS] amcheck (B-Tree integrity checking tool) Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] amcheck (B-Tree integrity checking tool) Amit Kapila <amit.kapila16@gmail.com>
Re: amcheck (B-Tree integrity checking tool) Michael Paquier <michael.paquier@gmail.com>
Re: amcheck (B-Tree integrity checking tool) Peter Geoghegan <pg@heroku.com>
Re: amcheck (B-Tree integrity checking tool) Michael Paquier <michael.paquier@gmail.com>
Re: amcheck (B-Tree integrity checking tool) Thomas Munro <thomas.munro@enterprisedb.com>
Re: amcheck (B-Tree integrity checking tool) Peter Geoghegan <pg@heroku.com>
Re: amcheck (B-Tree integrity checking tool) Thomas Munro <thomas.munro@enterprisedb.com>
Re: amcheck (B-Tree integrity checking tool) Peter Geoghegan <pg@heroku.com>
Re: amcheck (B-Tree integrity checking tool) Haribabu Kommi <kommi.haribabu@gmail.com>
Re: [HACKERS] amcheck (B-Tree integrity checking tool) Michael Paquier <michael.paquier@gmail.com>
Re: amcheck (B-Tree integrity checking tool) Peter Geoghegan <pg@heroku.com>
Re: amcheck (B-Tree integrity checking tool) Peter Geoghegan <pg@heroku.com>
Re: amcheck (B-Tree integrity checking tool) Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: amcheck (B-Tree integrity checking tool) Peter Geoghegan <pg@heroku.com>
Re: amcheck (B-Tree integrity checking tool) Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: amcheck (B-Tree integrity checking tool) Peter Geoghegan <pg@heroku.com>
Re: amcheck (B-Tree integrity checking tool) Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: amcheck (B-Tree integrity checking tool) David Steele <david@pgmasters.net>
Re: amcheck (B-Tree integrity checking tool) Peter Geoghegan <pg@heroku.com>
Re: amcheck (B-Tree integrity checking tool) Peter Geoghegan <pg@heroku.com>
Re: amcheck (B-Tree integrity checking tool) Anastasia Lubennikova <a.lubennikova@postgrespro.ru>
Re: amcheck (B-Tree integrity checking tool) Peter Geoghegan <pg@heroku.com>
Re: amcheck (B-Tree integrity checking tool) Peter Geoghegan <pg@heroku.com>
Re: amcheck (B-Tree integrity checking tool) Anastasia Lubennikova <a.lubennikova@postgrespro.ru>
Re: amcheck (B-Tree integrity checking tool) Michael Paquier <michael.paquier@gmail.com>
Re: amcheck (B-Tree integrity checking tool) Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: amcheck (B-Tree integrity checking tool) Peter Geoghegan <pg@heroku.com>
Re: amcheck (B-Tree integrity checking tool) Peter Geoghegan <pg@heroku.com>
Re: amcheck (B-Tree integrity checking tool) Peter Geoghegan <pg@heroku.com>
Re: amcheck (B-Tree integrity checking tool) Peter Geoghegan <pg@heroku.com>
Re: amcheck (B-Tree integrity checking tool) Peter Geoghegan <pg@heroku.com>
Re: amcheck (B-Tree integrity checking tool) Noah Misch <noah@leadboat.com>
Re: amcheck (B-Tree integrity checking tool) Michael Paquier <michael.paquier@gmail.com>
On Sat, Nov 19, 2016 at 6:45 PM, Robert Haas wrote: >> What do you think about new argument with default vs. GUC? I guess >> that the GUC might be a lot less of a foot-gun. We might even give it >> a suitably scary name, to indicate that it will make the server PANIC. >> (I gather that you don't care about other aspects of verbosity -- just >> about the ability to make amcheck PANIC in the event of an invariant >> violation without recompiling it.) > > Yikes. I don't think I want to expose any kind of API that lets the > user PANIC the server. A value < ERROR sounds far more reasonable > than a value > ERROR. In general, I don't want to get into the business of reasoning about how well we can limp along when there is a would-be error condition within amcheck. Once "the impossible" has actually occurred, it's very difficult to reason about what still works. Also, I actually agree that making it possible for the tool to force a PANIC through a user-visible interface is a bad idea. Maybe we should just leave it as it is -- experts can recompile the tool after modifying it to use an elevel that is != ERROR (the thing I mention about elevel < ERROR is already documented in code comments). If that breaks, they get to keep both halves. -- Peter Geoghegan
В списке pgsql-hackers по дате отправления