pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedIndex problem...
6+ messages / 3 participants
[nested] [flat]
* Index problem...
@ 2008-05-22 16:41 Carol Walter <walterc@indiana.edu>
0 siblings, 1 reply; 6+ messages in thread
From: Carol Walter @ 2008-05-22 16:41 UTC (permalink / raw)
To: pgsql-admin
Greetings...
I'm getting an error. The error says...
places=# REINDEX INDEX maps_map_id_seq;
ERROR: "maps_map_id_seq" is not an index
places=# SELECT * FROM maps;
ERROR: missing chunk number 0 for toast value 131343627
I have tried reindexing the index, the table, and the database. I
continue to get this error. What can I do to recover from this.
Carol Walter
PS Let me say that I know this is my fault. This index is very
bloated. Yesterday, I tried to vacuum. I got errors because
max_fsm_pages what set at a number that was too small.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Index problem...
@ 2008-05-22 17:02 Tomeh, Husam <HTomeh@facorelogic.com>
parent: Carol Walter <walterc@indiana.edu>
0 siblings, 1 reply; 6+ messages in thread
From: Tomeh, Husam @ 2008-05-22 17:02 UTC (permalink / raw)
To: Carol Walter <walterc@indiana.edu>; pgsql-admin
You may want to try to reindex the associated toast table and see if
that clears it up.
To get the name of the associated toast table, you may run this query:
select relname from pg_class where oid =
(select reltoastrelid from pg_class where relname = 'maps');
Then, reindex it.
reindex table "toast table name" ..
-------
Regards,
Husam
-----Original Message-----
From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Carol Walter
Sent: Thursday, May 22, 2008 9:42 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Index problem...
Greetings...
I'm getting an error. The error says...
places=# REINDEX INDEX maps_map_id_seq;
ERROR: "maps_map_id_seq" is not an index
places=# SELECT * FROM maps;
ERROR: missing chunk number 0 for toast value 131343627
I have tried reindexing the index, the table, and the database. I
continue to get this error. What can I do to recover from this.
Carol Walter
PS Let me say that I know this is my fault. This index is very
bloated. Yesterday, I tried to vacuum. I got errors because
max_fsm_pages what set at a number that was too small.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
**********************************************************************
This message contains confidential information intended only for the use of the addressee(s) named above and may contain information that is legally privileged. If you are not the addressee, or the person responsible for delivering it to the addressee, you are hereby notified that reading, disseminating, distributing or copying this message is strictly prohibited. If you have received this message by mistake, please immediately notify us by replying to the message and delete the original message immediately thereafter.
Thank you.
FADLD Tag
**********************************************************************
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Index problem...
@ 2008-05-22 17:37 Carol Walter <walterc@indiana.edu>
parent: Tomeh, Husam <HTomeh@facorelogic.com>
0 siblings, 1 reply; 6+ messages in thread
From: Carol Walter @ 2008-05-22 17:37 UTC (permalink / raw)
To: Tomeh, Husam <HTomeh@facorelogic.com>; +Cc: pgsql-admin
When I ran the query you specified I got relname of "pg_toast_16429.
When I ran the REINDEX TABLE pg_toast_16429 the system responds that
relation "pg_toast_16429" does not exist.
Carol
On May 22, 2008, at 1:02 PM, Tomeh, Husam wrote:
>
> You may want to try to reindex the associated toast table and see if
> that clears it up.
>
> To get the name of the associated toast table, you may run this query:
>
> select relname from pg_class where oid =
> (select reltoastrelid from pg_class where relname = 'maps');
>
> Then, reindex it.
>
> reindex table "toast table name" ..
>
> -------
>
> Regards,
> Husam
>
> -----Original Message-----
> From: pgsql-admin-owner@postgresql.org
> [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Carol Walter
> Sent: Thursday, May 22, 2008 9:42 AM
> To: pgsql-admin@postgresql.org
> Subject: [ADMIN] Index problem...
>
> Greetings...
>
> I'm getting an error. The error says...
>
> places=# REINDEX INDEX maps_map_id_seq;
> ERROR: "maps_map_id_seq" is not an index
> places=# SELECT * FROM maps;
> ERROR: missing chunk number 0 for toast value 131343627
>
> I have tried reindexing the index, the table, and the database. I
> continue to get this error. What can I do to recover from this.
>
> Carol Walter
>
> PS Let me say that I know this is my fault. This index is very
> bloated. Yesterday, I tried to vacuum. I got errors because
> max_fsm_pages what set at a number that was too small.
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
> **********************************************************************
> This message contains confidential information intended only for
> the use of the addressee(s) named above and may contain information
> that is legally privileged. If you are not the addressee, or the
> person responsible for delivering it to the addressee, you are
> hereby notified that reading, disseminating, distributing or
> copying this message is strictly prohibited. If you have received
> this message by mistake, please immediately notify us by replying
> to the message and delete the original message immediately thereafter.
>
> Thank you.
>
> FADLD Tag
> **********************************************************************
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Index problem...
@ 2008-05-22 17:57 hubert depesz lubaczewski <depesz@depesz.com>
parent: Carol Walter <walterc@indiana.edu>
0 siblings, 1 reply; 6+ messages in thread
From: hubert depesz lubaczewski @ 2008-05-22 17:57 UTC (permalink / raw)
To: Carol Walter <walterc@indiana.edu>; +Cc: Tomeh, Husam <HTomeh@facorelogic.com>; pgsql-admin
On Thu, May 22, 2008 at 01:37:56PM -0400, Carol Walter wrote:
> When I ran the query you specified I got relname of "pg_toast_16429.
> When I ran the REINDEX TABLE pg_toast_16429 the system responds that
> relation "pg_toast_16429" does not exist.
I think it should be pg_toast.pg_toast_16429
so:
REINDEX TABLE pg_toast.pg_toast_16429;
check relnamespace in pg_class for this table, and check it against
pg_namespace to be sure.
depesz
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Index problem...
@ 2008-05-22 19:41 Carol Walter <walterc@indiana.edu>
parent: hubert depesz lubaczewski <depesz@depesz.com>
0 siblings, 1 reply; 6+ messages in thread
From: Carol Walter @ 2008-05-22 19:41 UTC (permalink / raw)
To: depesz@depesz.com; +Cc: Tomeh, Husam <HTomeh@facorelogic.com>; pgsql-admin
This gives the same error. I can select columns from the table
although select * gets the error. I tried making a copy of the
"maps" table using CREATE TABLE new table name (all columns) AS
SELECT all columns FROM maps; This also gave me the same error.
Carol
On May 22, 2008, at 1:57 PM, hubert depesz lubaczewski wrote:
> On Thu, May 22, 2008 at 01:37:56PM -0400, Carol Walter wrote:
>> When I ran the query you specified I got relname of "pg_toast_16429.
>> When I ran the REINDEX TABLE pg_toast_16429 the system responds that
>> relation "pg_toast_16429" does not exist.
>
> I think it should be pg_toast.pg_toast_16429
> so:
> REINDEX TABLE pg_toast.pg_toast_16429;
>
> check relnamespace in pg_class for this table, and check it against
> pg_namespace to be sure.
>
> depesz
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Index problem...
@ 2008-05-22 20:15 hubert depesz lubaczewski <depesz@depesz.com>
parent: Carol Walter <walterc@indiana.edu>
0 siblings, 0 replies; 6+ messages in thread
From: hubert depesz lubaczewski @ 2008-05-22 20:15 UTC (permalink / raw)
To: Carol Walter <walterc@indiana.edu>; +Cc: pgsql-admin
On Thu, May 22, 2008 at 03:41:38PM -0400, Carol Walter wrote:
> This gives the same error. I can select columns from the table
> although select * gets the error. I tried making a copy of the
> "maps" table using CREATE TABLE new table name (all columns) AS
> SELECT all columns FROM maps; This also gave me the same error.
well. i think that it's time to move the PGDATA someplace else, initdb,
and load backup.
depesz
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2008-05-22 20:15 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-05-22 16:41 Index problem... Carol Walter <walterc@indiana.edu>
2008-05-22 17:02 ` Tomeh, Husam <HTomeh@facorelogic.com>
2008-05-22 17:37 ` Carol Walter <walterc@indiana.edu>
2008-05-22 17:57 ` hubert depesz lubaczewski <depesz@depesz.com>
2008-05-22 19:41 ` Carol Walter <walterc@indiana.edu>
2008-05-22 20:15 ` hubert depesz lubaczewski <depesz@depesz.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox