missing chunk number 0 for toast value xxxxx
От | Robby Russell |
---|---|
Тема | missing chunk number 0 for toast value xxxxx |
Дата | |
Msg-id | C35A64E9-AF4A-4A07-866E-16FD25CEFEE1@planetargon.com обсуждение исходный текст |
Ответы |
Re: missing chunk number 0 for toast value xxxxx
|
Список | 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 по дате отправления: