Обсуждение: Problem with database: FATAL 1: cannot find attribute 24 of relation

Поиск
Список
Период
Сортировка

Problem with database: FATAL 1: cannot find attribute 24 of relation

От
"Tauren Mills"
Дата:
Help!

One of my customers is having a problem with their database causing all of
their sites to be down right now.  The problem seems to effect only their
database, not any other databases on the server.  Here is the output when
connecting to it:

[root@s1 data]# psql -U postgres dans_pgsql
Password:
Asql: FATAL 1:  cannot find attribute 24 of relation

I've searched the email archives as well as deja.com, but cannot find this
error message mentioned anywhere.  Does anyone know what it means?  I've
tried restarting postgres.  Can anyone help suggest what I can do to get
this database working again?

I have backups of all raw files on the server, but the customer has not done
a dump of their database recently.  I rather doubt that restoring their
database from tape would replace it in a consistent state.  Any thoughts on
this as well?

Thanks,
Tauren




Re: Problem with database: FATAL 1: cannot find attribute 24 of relation

От
"Tauren Mills"
Дата:
One more thing...

The vacuum command is giving the same error:

[root@s1 data]# vacuumdb -v -U postgres dans_pgsql
Password:
Asql: FATAL 1:  cannot find attribute 24 of relation
vacuumdb: vacuum  dans_pgsql failed

Is there another way to fix a corrupt database (assuming that is what the
problem here is)?

Thanks,
Tauren


> -----Original Message-----
> From: Tauren Mills [mailto:tauren@servlets.net]
> Sent: Friday, September 14, 2001 8:23 AM
> To: pgsql-admin@postgresql.org
> Subject: Problem with database: FATAL 1: cannot find attribute 24 of
> relation
>
>
> Help!
>
> One of my customers is having a problem with their database causing all of
> their sites to be down right now.  The problem seems to effect only their
> database, not any other databases on the server.  Here is the output when
> connecting to it:
>
> [root@s1 data]# psql -U postgres dans_pgsql
> Password:
> Asql: FATAL 1:  cannot find attribute 24 of relation
>
> I've searched the email archives as well as deja.com, but cannot find this
> error message mentioned anywhere.  Does anyone know what it means?  I've
> tried restarting postgres.  Can anyone help suggest what I can do to get
> this database working again?
>
> I have backups of all raw files on the server, but the customer
> has not done
> a dump of their database recently.  I rather doubt that restoring their
> database from tape would replace it in a consistent state.  Any
> thoughts on
> this as well?
>
> Thanks,
> Tauren
>
>
>