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

Hi Tauren,

Have you found the solution for this yet?

It really sounds like part of your customer's database has been deleted
or gone missing.

Which version of PostgreSQL are you using, and which operating system is
it on?

:-)

Regards and best wishes,

Justin Clift

Tauren Mills wrote:
>
> Sorry for cross-posting this to both admin and general. I first posted to
> admin, but as I'm desperate here and there is more activity in the general
> list, I'm now posting it here as well.
>
> ---
>
> 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(at)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?
>
> One more thing...
>
> The vacuum command is giving the same error:
>
> [root(at)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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org

--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi