Обсуждение: Bug (#3484) - Missing pg_clog/0AE6

Поиск
Список
Период
Сортировка

Bug (#3484) - Missing pg_clog/0AE6

От
Alexandra Nitzschke
Дата:
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

Re: Bug (#3484) - Missing pg_clog/0AE6

От
Tom Lane
Дата:
Alexandra Nitzschke <an@clickware.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