| Lists: | pgsql-bugs |
|---|
| From: | Alexandra Nitzschke <an(at)clickware(dot)de> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Bug (#3484) - Missing pg_clog/0AE6 |
| Date: | 2008-10-27 16:34:10 |
| Message-ID: | 4905ED82.8020401@clickware.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
Hi,
since our last report at 15.02.2008 we again encountered database errors:
Livesystem:
30.04.2008 ERROR: invalid page header in block 12324 of relation "tzf_taf_fk"
----------------------------------------------------------------------
----- 12.09.2008 Update postgres from 8.1.3 to 8.3.3.
----------------------------------------------------------------------
11.10.2008 ERROR: could not open segment 4 of relation 1663/16388/273243518 (target block 1075838999):
18.10.2008 ERROR: invalid page header in block 457602 of relation "tre_pk"
26.10.2008 ERROR: invalid page header in block 234011 of relation "trx_nr_i"
27.10.2008 ERROR: invalid page header in block 647 of relation "akzeptanz".
Testsystem:
15.07.2008 ERROR: invalid page header in block 231845 of relation "txa_wae_fk"
----------------------------------------------------------------------
----- 18.07.2008 Update postgres from 8.2.4 to 8.3.3.
----------------------------------------------------------------------
04.08.2008 ERROR: invalid page header in block 26 of relation "dfp_sta_fk"
06.08.2008 ERROR: invalid page header in block 463493 of relation "trx_unique"
02.09.2008 ERROR: invalid page header in block 197264 of relation "trx_aenderung_ts"
Both Systems currently use postgres version 8.3.3.
Is there any chance that updating to version 8.3.4 will fix our problems ?
Did you incorporate any substatial fixes regarding these problems in 8.3.4 ?
Regards
A. Nitzschke
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Alexandra Nitzschke <an(at)clickware(dot)de> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: Bug (#3484) - Missing pg_clog/0AE6 |
| Date: | 2008-10-27 19:54:20 |
| Message-ID: | 23517.1225137260@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
Alexandra Nitzschke <an(at)clickware(dot)de> writes:
> since our last report at 15.02.2008 we again encountered database errors:
> Livesystem:
> 30.04.2008 ERROR: invalid page header in block 12324 of relation "tzf_taf_fk"
> ----------------------------------------------------------------------
> ----- 12.09.2008 Update postgres from 8.1.3 to 8.3.3.
> ----------------------------------------------------------------------
> 11.10.2008 ERROR: could not open segment 4 of relation 1663/16388/273243518 (target block 1075838999):
> 18.10.2008 ERROR: invalid page header in block 457602 of relation "tre_pk"
> 26.10.2008 ERROR: invalid page header in block 234011 of relation "trx_nr_i"
> 27.10.2008 ERROR: invalid page header in block 647 of relation "akzeptanz".
Have you checked for hardware problems? This looks more like a case of
a flaky disk drive or possibly bad RAM than a software problem.
regards, tom lane