Error: missing chunk number ...

From: Neophytos Demetriou <k2pts(at)cytanet(dot)com(dot)cy>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Error: missing chunk number ...
Date: 2002-08-04 21:15:41
Message-ID: 3D4D997D.9020807@cytanet.com.cy
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

I've recently observed some strange behavior using postgresql 7.2.1 on a
RH-7.3 system. I've got a service for fetching rss feeds from the web.
These feeds are stored into a text column. Here's how the table looks like:

Column | Type | Modifiers
------------------+--------------------------+-----------
channel_id | integer |
dataurl | character varying(1000) |
...
...
latest_feed | text |
feedidx | txtidx |
Indexes: hellofeedidx

(feedidx uses tsearch and indexes the faulty column, namely latest_feed).

This is not on a production system. After running this service for a
while (almost a week). I get messages like:

# select * from rss_channels;
ERROR: missing chunk number 1 for toast value 797979

If I try to delete the culprit row. I get:
# delete from rss_channels where channel_id=116;
ERROR: simple_heap_delete: tuple already updated by self

I'm running a full vacuum daily:
su - postgres -c 'vacuumdb --full --analyze --quiet --all'

and a simple vacuum once every hour:
su - postgres -c 'vacuumdb --analyze --quiet --all'

Here's how I configure and run PG:
./configure --enable-multibyte=UNICODE --with-tcl --with-perl
--enable-syslog

su -l postgres -c 'export LANG=C; /usr/local/pgsql/bin/postmaster -N 200
-B 1000 -o "-S 2000" -S -D /usr/local/pgsql/data '

Note that I cannot do a pg_dump on the rss_channels table.

Any idea of what might be the problem?

Best wishes,
Neophytos

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Joe Conway 2002-08-04 21:45:29 Re: anonymous composite types for Table Functions (aka
Previous Message Tom Lane 2002-08-04 21:08:45 Re: anonymous composite types for Table Functions (aka SRFs)