Re: pg 7.3.4 and linux box crash

On Thu, 11 Sep 2003, pginfo wrote:

> Hi,
> I am runing linux red hat 7.3 (standart install)
> on dual athlon box , 1 GB ram and pg 7.3.4.
>
> If I try to access with pgAdmin one from my tables (i contains ~ 1 M
> records)
> the linux box crashes.
> In my pg log I can find:
> ERROR: Invalid page header in block 5604 of a_acc
>
> before this error I see also :
> FATAL: Database "template0" is not currently accepting connections
> ERROR: Relation "pg_relcheck" does not exist
>
> and
>
> ERROR: 'ksqo' is not a valid option name
>
>
> I am using reiserFS on this box and do not find any other problems with
> it.

This sounds very strange and I am thinking of RAM problems or a
corrupted filesystem. Using ReiserFS or not seems to be a religious
issue. Some reported strange errors due to ReiserFS and some are very
happy with it. I have no experiences with ReiserFS.

> Can I solve this problem or I need to recreate the datebase ( The table
> and the database are created befor 2 days)?

Can you stop the postmaster, copy the data-directory to a non-ReiserFS
and make a symlink, so PostgreSQL thinks tha location has not changed?

Can you run memtest86 for a day to find out if you have some faulty RAM?

--
PGP/GPG Key-ID:
http://blackhole.pca.dfn.de:11371/pks/lookup?op=get&search=0xB5A1AFE1