BUG #2311: Toast table chunk_id overflow

From: "Chris Hodgson" <chodgson(at)refractions(dot)net>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2311: Toast table chunk_id overflow
Date: 2006-03-10 00:43:59
Message-ID: 20060310004359.176E2F0B08@svr2.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 2311
Logged by: Chris Hodgson
Email address: chodgson(at)refractions(dot)net
PostgreSQL version: 7.4.7
Operating system: Linux Fedora Core 3
Description: Toast table chunk_id overflow
Details:

If you cycle through enough id's in your toast tables, the chunk_id goes
past 2^32 and wraps around, leaving you in an intermittent error state.
Inserting further toasted chunks will fail depending on whether that
particular next id from the sequence is already in the table or not.

It really shouldn't be possible to get into this state. There is obviously a
hard limitation of using 4-byte integers as ids for the toasted chunks... I
don't know what the solution is, but at very least an error message that is
more clear about what has happened than repeated, seemingly random
occurences of "duplicate key in table pg_toast.pg_toast_1834831156_index".

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2006-03-10 00:48:17 Re: BUG #2309: Wrong string comparison
Previous Message Malix 2006-03-10 00:26:34 Re: BUG #2303: UPDATE from manual is incorrect