Search Postgresql Archives

Re: missing chunk number 0 for toast value xxxxx

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




On Aug 5, 2006, at 4:29 PM, Robby Russell wrote:

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

Thanks to the kind folks in #postgresql I was able to run a loop through the database and find the corrupt row in the table and delete it.

All is well!

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]




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux