pgsql: Prevent incorrect updates of pg_index while reindexing pg_index
От | Tom Lane |
---|---|
Тема | pgsql: Prevent incorrect updates of pg_index while reindexing pg_index |
Дата | |
Msg-id | E1QAtEm-0002X4-HF@gemulon.postgresql.org обсуждение исходный текст |
Список | pgsql-committers |
Prevent incorrect updates of pg_index while reindexing pg_index itself. The places that attempt to change pg_index.indcheckxmin during a reindexing operation cannot be executed safely if pg_index itself is the subject of the operation. This is the explanation for a couple of recent reports of VACUUM FULL failing with ERROR: duplicate key value violates unique constraint "pg_index_indexrelid_index" DETAIL: Key (indexrelid)=(2678) already exists. However, there isn't any real need to update indcheckxmin in such a situation, if we assume that pg_index can never contain a truly broken HOT chain. This assumption holds if new indexes are never created on it during concurrent operations, which is something we don't consider safe for any system catalog, not just pg_index. Accordingly, modify the code to not manipulate indcheckxmin when reindexing any system catalog. Back-patch to 8.3, where HOT was introduced. The known failure scenarios involve 9.0-style VACUUM FULL, so there might not be any real risk before 9.0, but let's not assume that. Branch ------ REL8_3_STABLE Details ------- http://git.postgresql.org/pg/commitdiff/2c69fc0596e0b785dcc990d2942be89f01c213fd Modified Files -------------- src/backend/catalog/index.c | 25 ++++++++++++++++++++++--- 1 files changed, 22 insertions(+), 3 deletions(-)
В списке pgsql-committers по дате отправления: