missing chunk number 0 for toast value xxxxx - Mailing list pgsql-general

From Robby Russell
Subject missing chunk number 0 for toast value xxxxx
Date
Msg-id C35A64E9-AF4A-4A07-866E-16FD25CEFEE1@planetargon.com
Whole thread Raw
Responses Re: missing chunk number 0 for toast value xxxxx  (Robby Russell <robby.lists@planetargon.com>)
List pgsql-general
I'm seeing this weird issue pop up on one a database.

This seems to work...

robbyonrails_typo_dev=# SELECT count(id) FROM contents WHERE title ~*
'postgresql' LIMIT 20;
count
-------
     19
(1 row)

...but these two seem to be causing an error now.

robbyonrails_typo_dev=# SELECT count(id) FROM contents WHERE body ~*
'postgresql' LIMIT 20;
ERROR:  missing chunk number 0 for toast value 58441

robbyonrails_typo_dev=# SELECT count(id) FROM contents WHERE
body_html ~* 'postgresql' LIMIT 20;
ERROR:  missing chunk number 0 for toast value 58440

I tried reindexing the table but it''s not going away. Any pointers?

Robby


--
Robby Russell
Founder & Executive Director

PLANET ARGON, LLC
Ruby on Rails Development, Consulting & Hosting

www.planetargon.com
www.robbyonrails.com

+1 503 445 2457
+1 877 55 ARGON [toll free]
+1 815 642 4068 [fax]



pgsql-general by date:

Previous
From: "Gavin M. Roy"
Date:
Subject: Re: Ajax/PostgreSQL
Next
From: Peter Wilson
Date:
Subject: Re: Ajax/PostgreSQL