Re: repeatable system index corruption on 7.4.2

Joe Conway <mail@joeconway.com> writes:
> I'm seeing the following errors after a few hours of fairly aggressive 
> bulk load of a database running on Postgres 7.4.2:

> cyspec=# select version();
> ERROR:  root page 43 of "pg_proc_proname_args_nsp_index" has level 0, 
> expected 2

[ scratches head... ]  Are you just doing bulk *data* load, or are you
doing extensive schema hacking too?  What reason would there be for
index churn in pg_proc (or pg_class for that matter)?

Can you get a pg_filedump dump of that page of the index?

> When I say aggressive, I mean up to 6 simultaneous COPY processes. It is 
> different from the issue Tom solved the other day in that we don't get 
> SIGABORT, just corrupt index pages. Here is a backtrace:

That may have more to do with whether the error is detected inside a
critical section than anything else.
        regards, tom lane