Re: [GENERAL] Database corruption using 7.4.1

2004-06-21 Thread Florian G. Pflug
On Fri, Jun 18, 2004 at 02:32:16PM -0400, Tom Lane wrote: > > Since that 7.4.2 release-note only talked about crashing queries due to the > > 7.4.1 bug, but not about data-corruption occuring, I wondered if the > > symptoms I have seen are related to the alignment bug in 7.4.1 or not. > > No, I d

Re: [GENERAL] Database corruption using 7.4.1

2004-06-18 Thread Tom Lane
"Florian G. Pflug" <[EMAIL PROTECTED]> writes: > ... I upgraded to 7.4.2, and fixed the system-tables > according to the 7.4.2 release-note. But this didn't really help - the > "analyze table" issued after fixing the system-tables exited with an > error about an invalid page header in one of our ta

[GENERAL] Database corruption using 7.4.1

2004-06-18 Thread Florian G. Pflug
Hi One of our production systems was running 7.4.1 for a few months, when suddenly some queries that used a specifiy table (a cache table) started crashing the backend. A colleague of mine "fixed" the problem by simply dumping and rebuilding the affected table (That was possible since it was onl