Re: SIREAD lock versus ACCESS EXCLUSIVE lock
Kevin Grittner <kevin.grittner@wicourts.gov>
From: "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
To: "Tom Lane" <tgl@sss.pgh.pa.us>
Cc: <simon@2ndquadrant.com>,<drkp@csail.mit.edu>, "Heikki Linnakangas" <heikki.linnakangas@enterprisedb.com>, <pgsql-hackers@postgresql.org>
Date: 2011-06-07T15:29:10Z
Lists: pgsql-hackers
Tom Lane <tgl@sss.pgh.pa.us> wrote: > "Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes: >> What am I missing? > > Out-of-memory. Query cancel. The attempted catalog access > failing because it results in a detected deadlock. I could > probably think of several more if I spent ten minutes on it; and > that's not even considering genuine problem conditions such as a > corrupted catalog index, which robustness demands that we not fall > over completely for. > > You should never, ever assume that an operation as complicated as > a catalog lookup can't fail. Got it. Thanks. -Kevin