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

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 (view raw or flat)
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

pgsql-bugs by date

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

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