Re: Really odd corruption problem: cannot open pg_aggregate:

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Adam Haberlach <adam(at)newsnipple(dot)com>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Really odd corruption problem: cannot open pg_aggregate:
Date: 2003-07-24 17:29:39
Message-ID: Pine.LNX.4.33.0307241128520.25823-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, 24 Jul 2003, Adam Haberlach wrote:

> So, one of the many machines that I support seems to have developed
> an incredibly odd and specific corruption that I've never seen before.
>
> Whenever a query requiring an aggregate is attempted, it spits out:
> cannot open pg_aggregate: No such file or directory
> and fails.
>
> If I do:
> select * from pg_class where relname='pg_aggregate';
> I see that the relation exists.
>
> If I check the relfilenode in the data directory, that exists, and
> seems to be an object file containing what should be the basic
> aggregate functions.
>
> version: PostgreSQL 7.2.3 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2 20020903 (Red Hat Linux 8.0 3.2-7)
>
>
> The system ran for a few weeks before anything odd happened, and
> then suddenly this. Does anyone have any ideas? Now that I look at
> the above string, I realize that the system /is/ an Athlon processor.
> Does anyone know if there could be an issue between the i686 and
> athlon optimizations?

test your memory and drive subsystem first. memtest86.com has a nice
tester for free, and on linux badblocks can do a decent job (not great,
just decent) of finding bad blocks.

Postgresql is good, but it can't make up for bad hardware.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Doug McNaught 2003-07-24 17:39:19 Re: Really odd corruption problem: cannot open pg_aggregate: No such file or directory
Previous Message Adam Haberlach 2003-07-24 17:17:06 Really odd corruption problem: cannot open pg_aggregate: No such file or directory