Postgres Pro
Downloads
Home   >   mailing lists

BUG #7819: missing chunk number 0 for toast value 1235919 in pg_toast_35328 - Mailing list pgsql-bugs

From pchan@contigo.com
Subject BUG #7819: missing chunk number 0 for toast value 1235919 in pg_toast_35328
Date
Msg-id E1TxRlp-0007zA-Mw@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #7819: missing chunk number 0 for toast value 1235919 in pg_toast_35328
List pgsql-bugs
Tree view 
The following bug has been logged on the website:

Bug reference:      7819
Logged by:          Pius Chan
Email address:      pchan@contigo.com
PostgreSQL version: 9.1.7
Operating system:   CentOS (Linux version 2.6.32-220
Description:        =


We just upgraded from PostgreSQL 9.1.3 to 9.1.7 last week. In our database
cluster, one database is used by the Java Message Service (JMS) system. One
table in the database "jms_messages", is inserted, updated and then deleted
frequently. For every five minutes, we have a cron job to "cluster
jms_messages; analyze jms_messages". About once per day, we go the above
ERROR and I check that pg_toast_35328 is the toast area of the jms_messages
table.

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #7816: test for compiler output produces bogus results
Next
From: Tom Lane
Date:
Subject: Re: BUG #7819: missing chunk number 0 for toast value 1235919 in pg_toast_35328