Thread: META vacuum - FAIL: ERROR

META vacuum - FAIL: ERROR

From

Albert Csaba

Date:

06 June 2002, 07:46:32

Hi!

I have a RaQ3 Cobalt server, which uses PostgreSQL.
Lately I'm getting this error:

NOTICE:  Index pg_attribute_attrelid_index: NUMBER OF
INDEX' TUPLES (574) IS NOT THE SAME AS HEAP' (561)
NOTICE:  Index pg_attribute_relid_attnum_index: NUMBER
OF INDEX' TUPLES (574) IS NOT THE SAME AS HEAP' (561)
NOTICE:  Index pg_attribute_relid_attnam_index: NUMBER
OF INDEX' TUPLES (574) IS NOT THE SAME AS HEAP' (561)
META vacuum - FAIL: ERROR:  cannot find attribute 1 of
relation quota

What can I do? Can I change manually somehow the
database?

Any help is welcome,
Thank you in advance

Csaba Albert


__________________________________________________
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com

Re: META vacuum - FAIL: ERROR

From

"Henshall, Stuart - WCP"

Date:

06 June 2002, 08:20:36

> -----Original Message-----
> From: Albert Csaba [mailto:maka_cs@yahoo.com]
>
> Hi!
>
> I have a RaQ3 Cobalt server, which uses PostgreSQL.
> Lately I'm getting this error:
>
> NOTICE: Index pg_attribute_attrelid_index: NUMBER OF
> INDEX' TUPLES (574) IS NOT THE SAME AS HEAP' (561)
> NOTICE: Index pg_attribute_relid_attnum_index: NUMBER
> OF INDEX' TUPLES (574) IS NOT THE SAME AS HEAP' (561)
> NOTICE: Index pg_attribute_relid_attnam_index: NUMBER
> OF INDEX' TUPLES (574) IS NOT THE SAME AS HEAP' (561)
> META vacuum - FAIL: ERROR: cannot find attribute 1 of
> relation quota
>
> What can I do? Can I change manually somehow the
> database?
>
> Any help is welcome,
> Thank you in advance
>
> Csaba Albert

Try reindex from a stand alone postgres (just postgres rather than postmaster).
This should reindex the system tables.
hth,
- Stuart

Re: META vacuum - FAIL: ERROR

From

"Henshall, Stuart - WCP"

Date:

06 June 2002, 09:06:07

Try:
http://www.postgresql.org/idocs/index.php?sql-reindex.html
This has a better explanation than I could manage :)
hth,
- Stuart

> -----Original Message-----
> From: Albert Csaba [mailto:maka_cs@yahoo.com]
> Sent: 06 June 2002 10:38
> To: Henshall, Stuart - WCP
> Subject: Re: [NOVICE] META vacuum - FAIL: ERROR
>
>
>
> --- "Henshall, Stuart - WCP"
> <SHenshall@westcountrypublications.co.uk> wrote:
> >
> >
> > > -----Original Message-----
> > > From: Albert Csaba [mailto:maka_cs@yahoo.com]
> > >
> > > Hi!
> > >
> > > I have a RaQ3 Cobalt server, which uses
> > PostgreSQL.
> > > Lately I'm getting this error:
> > >
> > > NOTICE: Index pg_attribute_attrelid_index: NUMBER
> > OF
> > > INDEX' TUPLES (574) IS NOT THE SAME AS HEAP' (561)
> > > NOTICE: Index pg_attribute_relid_attnum_index:
> > NUMBER
> > > OF INDEX' TUPLES (574) IS NOT THE SAME AS HEAP'
> > (561)
> > > NOTICE: Index pg_attribute_relid_attnam_index:
> > NUMBER
> > > OF INDEX' TUPLES (574) IS NOT THE SAME AS HEAP'
> > (561)
> > > META vacuum - FAIL: ERROR: cannot find attribute
> > 1 of
> > > relation quota
> > >
> > > What can I do? Can I change manually somehow the
> > > database?
> > >
> > > Any help is welcome,
> > > Thank you in advance
> > >
> > > Csaba Albert
> >
> > Try reindex from a stand alone postgres (just
> > postgres rather than
> > postmaster).
> > This should reindex the system tables.
> > hth,
> > - Stuart
> >
>
> Thanks for your answer. But to save me some time and
> if not's so much trouble to you, how do I make
> reindex?
>
> Csaba Albert
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! - Official partner of 2002 FIFA World Cup
> http://fifaworldcup.yahoo.com
>

Re: META vacuum - FAIL: ERROR

From

"Henshall, Stuart - WCP"

Date:

06 June 2002, 12:15:34

> -----Original Message-----
> From: Albert Csaba [mailto:maka_cs@yahoo.com]
> Sent: 06 June 2002 11:55
> To: Henshall, Stuart - WCP
> Subject: RE: [NOVICE] META vacuum - FAIL: ERROR
>
>
>
> Thank you, it helped me to start. It's my first time
> using PostgreSQL, I've used till now only MySQL, but
> it seems that I am forced a little bit now to use it.
> I have on the Cobalt server PostgreSQL 6.5, and trying
> to do what says there, I'm getting the following:
>
> postgres -D /home/pgsql/ -O
> pg_attribute_attrelid_index
> FATAL 1: Database pg_attribute_attrelid_index does
> not exist in pg_database
> FATAL 1: Database pg_attribute_attrelid_index does
> not exist in pg_database
>
> postgres -D /home/pgsql/base/cobalt -O
> pg_attribute_attrelid_index
> FATAL 1: Cannot open
> /home/pgsql/base/cobalt/pg_database
> FATAL 1: Cannot open
> /home/pgsql/base/cobalt/pg_database
>
> The option -P is not supported. The structure is:
>
> /home/pgsql--base--cobalt--pg_attribute_attrelid_index
>
> Am I doing something wrong? What next?
>
> Thank you,
> Csaba Albert
>

Hi,
What database version are you using? 7.2.1 is the latest.
Is your data directory really /home/pgsql?
This should be the same path you used initdb on.
If you have PG_DATA set then you don't need the -D option.
I just used (for instance):
postgres -O -P template1
you can give your database name instead of template1
hth,
- Stuart

Re: META vacuum - FAIL: ERROR

From

"Henshall, Stuart - WCP"

Date:

06 June 2002, 13:37:29

I've never used 6.5, but I vaguely recall an error with heap a similar error to the one you report being something in the old/full vacuum for moving chains. I believe it was said to just stop vacuum. It might be worth a scan of the archives (I seem to recall Tom Lane gave the reason).

I would have thought just dropping the index and recreating would be ok, but have never come across this problem myself.

Regards,
- Stuart

> -----Original Message-----
> From: Albert Csaba [mailto:maka_cs@yahoo.com]
> Sent: 06 June 2002 14:43
> To: Henshall, Stuart - WCP
> Subject: Re: [NOVICE] META vacuum - FAIL: ERROR
>
>
>
> Thanks again for your answer, I really appreciate it.
> I'm using version 6.5 (yes, it's old, but because of
> warranty, I cannot upgrade it).I managed finally to
> start postgres (silly me, i gave tha table name in
> place of the database name)
>
> postgres -D /home/pgsql/base -O cobalt
>
> but the command REINDEX isn't supported in this
> version yet... so any other ideas, what could I do?
> can delete the old index and create a new one?
>
>
> Thank you,
> kind regards,
> Csaba Albert
>
>
>
>
> --- "Henshall, Stuart - WCP"
> <SHenshall@westcountrypublications.co.uk> wrote:
> >
> >
> > > -----Original Message-----
> > > From: Albert Csaba [mailto:maka_cs@yahoo.com]
> > > Sent: 06 June 2002 11:55
> > > To: Henshall, Stuart - WCP
> > > Subject: RE: [NOVICE] META vacuum - FAIL: ERROR
> > >
> > >
> > >
> > > Thank you, it helped me to start. It's my first
> > time
> > > using PostgreSQL, I've used till now only MySQL,
> > but
> > > it seems that I am forced a little bit now to use
> > it.
> > > I have on the Cobalt server PostgreSQL 6.5, and
> > trying
> > > to do what says there, I'm getting the following:
> > >
> > > postgres -D /home/pgsql/ -O
> > > pg_attribute_attrelid_index
> > > FATAL 1: Database pg_attribute_attrelid_index
> > does
> > > not exist in pg_database
> > > FATAL 1: Database pg_attribute_attrelid_index
> > does
> > > not exist in pg_database
> > >
> > > postgres -D /home/pgsql/base/cobalt -O
> > > pg_attribute_attrelid_index
> > > FATAL 1: Cannot open
> > > /home/pgsql/base/cobalt/pg_database
> > > FATAL 1: Cannot open
> > > /home/pgsql/base/cobalt/pg_database
> > >
> > > The option -P is not supported. The structure is:
> > >
> > >
> >
> /home/pgsql--base--cobalt--pg_attribute_attrelid_index
> > >
> > > Am I doing something wrong? What next?
> > >
> > > Thank you,
> > > Csaba Albert
> > >
> >
> > Hi,
> > What database version are you using? 7.2.1 is the
> > latest.
> > Is your data directory really /home/pgsql?
> > This should be the same path you used initdb on.
> > If you have PG_DATA set then you don't need the -D
> > option.
> > I just used (for instance):
> > postgres -O -P template1
> > you can give your database name instead of template1
> > hth,
> > - Stuart
> >
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! - Official partner of 2002 FIFA World Cup
> http://fifaworldcup.yahoo.com
>

Re: META vacuum - FAIL: ERROR

From

"Henshall, Stuart - WCP"

Date:

07 June 2002, 08:22:15

You could try a dump/restore if nothing else works.
It may be worth mailing pgsql-bugs and general.
If you still don't get any joy maybe try hackers.
Sorry I couldn't be of more help,
- Stuart

> -----Original Message-----
> From: Albert Csaba [mailto:maka_cs@yahoo.com]
> Sent: 07 June 2002 10:02
> To: Henshall, Stuart - WCP
> Subject: RE: [NOVICE] META vacuum - FAIL: ERROR
>
>
>
> --- "Henshall, Stuart - WCP"
> <SHenshall@westcountrypublications.co.uk> wrote:
> > I've never used 6.5, but I vaguely recall an error
> > with heap a similar error
> > to the one you report being something in the
> > old/full vacuum for moving
> > chains. I believe it was said to just stop vacuum.
> > It might be worth a scan
> > of the archives (I seem to recall Tom Lane gave the
> > reason).
> > I would have thought just dropping the index and
> > recreating would be ok, but
> > have never come across this problem myself.
> > Regards,
> > - Stuart
>
> Thank you for your help. I couldn't find anything
> related to my problem in the archives. I guess I'll
> give up... hope it won't lead me to more severe errors
> :-)
>
> Thank you,
> kind regards,
> Csaba
>
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! - Official partner of 2002 FIFA World Cup
> http://fifaworldcup.yahoo.com
>

Re: META vacuum - FAIL: ERROR

From

"Henshall, Stuart - WCP"

Date:

07 June 2002, 09:13:15

Sorry to not reply in one post, here is as close a reference as I could easily find:
http://archives.postgresql.org/pgsql-sql/1999-06/msg00005.php
http://archives.postgresql.org/pgsql-hackers/1999-10/msg00084.php
http://archives.postgresql.org/pgsql-general/1999-12/msg00445.php
NB I said in my last post dump restore, you'd probably need to dump all, initdb then restore all if just receating the index doesn't work

- Stuart