Re: [cobalt-users] cron.daily error

["Tomislav Crnicki" <tcrnicki@xxxxxxxxxxxx>]

On Mon, 12 Aug 2002, mika wrote:

> Till i'm back from holidays i got in the root's mailbox this kind of
> messages
>
> 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's the mean of this and how to solve it?

Hi!

It's a corrupt index in the PostGres DB.

Here is a what you do to correct this:

Telnet to the box as admin
Type:
su -
cd /home/pgsql
su postgres
edit pg_hba.conf
change "local cobalt crypt" to "local all trust"
Type:
pg_dump cobalt > cobalt.dump
edit cobalt.dump
find "create_table for quota" and hash out that section, (comment it out) save and close
Type:
destroydb cobalt
createdb cobalt
psql cobalt < cobalt.dump
edit pg_hba.conf
change "local all trust" back to "local cobalt crypt"
exit back to root by typing exit
Type:
swatch


And no, it's not out of my head, but from Sun's Knowledgebase on an entirly different error. I found this while searching for the keyword TUPLES. It resolved the problem you 
have on two of our RAQ 3 servers.

http://cobalt-knowledge.sun.com/cgi-bin/kbase.cfg/php/enduser/std_adp.php?p_refno=010829-000026

We hope it helps you too!

Best regards,

Tomi Crnicki - Abacus, Croatia