Database corruption with Postgre 7.4.2 on FreeBSD 6.1?

From: aurora <aurora00(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Database corruption with Postgre 7.4.2 on FreeBSD 6.1?
Date: 2006-07-26 22:27:56
Message-ID: op.tdbh0ur06yt6e7@wtung-lt.ironportsystems.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

We are stressing testing our application. It adds and deletes a lot of
rows. Within 24 hours we ran into some sort of database corruption
problem. We got this error when trying to insert into the users table.

ERROR XX001: invalid page header in block 2552 of relation
"users_name_lower_idx"

The schema looks like this

create table users (
userid integer not null,
name text unique not null,
...
PRIMARY KEY (userid)
);

create index users_name_lower_idx on users (lower(name));

Then the box froze up. We suspect it might ran out of IO bufs.

We are using Postgre 7.4.2 running on FreeBSD 6.1 and Dell 2850.

Thanks for any help,

wy

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Redefined Horizons 2006-07-26 22:55:51 Understanding VARHDRSZ
Previous Message Shoaib Mir 2006-07-26 22:15:45 Re: Table Inheritence...Just Columns?