Skip site navigation (1) Skip section navigation (2)

pgsql: Repair PANIC condition in hash indexes when a previous index

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Repair PANIC condition in hash indexes when a previous index
Date: 2007-04-19 20:24:18
Message-ID: 20070419202418.D9DF09FB60E@postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
Log Message:
-----------
Repair PANIC condition in hash indexes when a previous index extension attempt
failed (due to lock conflicts or out-of-space).  We might have already
extended the index's filesystem EOF before failing, causing the EOF to be
beyond what the metapage says is the last used page.  Hence the invariant
maintained by the code needs to be "EOF is at or beyond last used page",
not "EOF is exactly the last used page".  Problem was created by my patch
of 2006-11-19 that attempted to repair bug #2737.  Since that was
back-patched to 7.4, this needs to be as well.  Per report and test case
from Vlastimil Krejcir.

Tags:
----
REL8_1_STABLE

Modified Files:
--------------
    pgsql/src/backend/access/hash:
        README (r1.4 -> r1.4.6.1)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/hash/README.diff?r1=1.4&r2=1.4.6.1)
        hashovfl.c (r1.47.2.2 -> r1.47.2.3)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/hash/hashovfl.c.diff?r1=1.47.2.2&r2=1.47.2.3)
        hashpage.c (r1.52.2.2 -> r1.52.2.3)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/hash/hashpage.c.diff?r1=1.52.2.2&r2=1.52.2.3)
    pgsql/src/include/access:
        hash.h (r1.63 -> r1.63.2.1)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/access/hash.h.diff?r1=1.63&r2=1.63.2.1)

pgsql-committers by date

Next:From: Tom LaneDate: 2007-04-19 20:24:29
Subject: pgsql: Repair PANIC condition in hash indexes when a previous index
Previous:From: Tom LaneDate: 2007-04-19 20:24:10
Subject: pgsql: Repair PANIC condition in hash indexes when a previous index

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group