Bug (#3484) - Missing pg_clog/0AE6

Started by Alexandra Nitzschkeover 17 years ago2 messagesbugs
Jump to latest
#1Alexandra Nitzschke
an@clickware.de

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Alexandra Nitzschke (#1)
Re: Bug (#3484) - Missing pg_clog/0AE6

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