Re: Invalid page feader on Solaris 10

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Rózsahegyi László <laszlo(dot)rozsahegyi(at)rool(dot)hu>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Invalid page feader on Solaris 10
Date: 2006-03-24 15:28:36
Message-ID: 4818.1143214116@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

=?ISO-8859-2?Q?R=F3zsahegyi_L=E1szl=F3?= <laszlo(dot)rozsahegyi(at)rool(dot)hu> writes:
> The dump of my database is about 2 GB if we are lucky.
> If not, we have one of error messages:

> - pg_dump: ERROR: invalid memory alloc request size 2623204397

> - pg_dump: ERROR: could not access status of transaction 2423378468
> DETAIL: could not open file "pg_clog/0907": No such file or directory

> - pg_dump: ERROR: invalid page header in block 16147 of relation "jn_szll"

> What is the problem?

All of those look like corrupt-data symptoms to me. I wonder whether
you've got hardware problems (flaky disk, flaky memory, bad cable ...)
How repeatable are the errors? Do they always occur for just one table,
or is the problem widespread?

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Pallav Kalva 2006-03-24 15:39:41 Re: Archive Command Configuration
Previous Message Tom Lane 2006-03-24 15:02:01 Re: Bloated pg_shdepend_depender_index