Re: FATAL 2: open of /var/lib/pgsql/data/pg_clog/0EE3

scott.marlowe wrote:

>>Why doesn't it complain after I restart it then?
>>
>>
>
>Why should it? If the problem is corrupted data in an index / table
>/system table etc... you won't see an error until it accesses the
>table/index etc... that's causing the problem.
>
>
Right...

So,

1) I do

analyze mytable;

,.. it crashes.

2) I do it again:

analyze mytable;

... it crashes.

3) I restart the server manually, and try again

analyze mytable;

... it *works*

4) I let it run for a while, then try again:

analyze mytable;

... it crashes.

So, it looks like, if there is some data structure or a catalog screwed
up, it is not screwed up by 7.2.1 earlier, it is *being* screwed up
somewhere between #3 and #4 above...

Dima