From: | "Jeff Brenton" <jbrenton(at)sandvine(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | database corruption |
Date: | 2009-04-09 01:32:06 |
Message-ID: | F489AB573A749146B33461ECE080913A09DF6857@EXCHANGE-1.sandvine.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I've encountered some db corruption after restarting postgres on my
database server running 8.2.4. I think that postgres did not shut down
cleanly. Postgres started appropriately but crashed 45 minutes later.
I used pg_resetxlog after the crash to get the db to start again but it
appears that the database is not running properly now. When users try
to access some of the tables in the db they get the error below;
ERROR: index "testrun_log_pkey" contains unexpected zero page at block
3155408
HINT: Please REINDEX it.}> <SQL environment diagnostic: no diagnostic
record
SQL connection is null
SQL statement diagnostic: XX002 7 {Error while executing the query;
ERROR: index "testrun_log_pkey" contains unexpected zero page at block
3155408
HINT: Please REINDEX it.}
I've attempted to re-index the pkey listed but after an hour it fails
with
REINDEX INDEX testrun_log_pkey;
ERROR: could not write block 1832079 of temporary file: No space left
on device
HINT: Perhaps out of disk space?
There is currently 14GB free on the disk that postgres is installed on.
Does anyone know what I can do to get the db up and running again?
/dev/amrd0s1a 3.9G 2.7G 898M 75% /
/dev/amrd0s1e 115G 43G 63G 40% /backup
/dev/amrd1s1d 133G 748M 121G 1% /wal
/dev/amrd2s1d 663G 596G 14G 98% /db
/dev/amrd0s1d 3.9G 184M 3.4G 5% /var
From | Date | Subject | |
---|---|---|---|
Next Message | Justin | 2009-04-09 01:58:26 | Re: Is it possible for PostgreSQL to support mmddyyyy date format? |
Previous Message | Leif B. Kristensen | 2009-04-08 23:57:04 | Re: Are there performance advantages in storing bulky field in separate table? |