BUG #5077: Corrupted Table

From: "Bryan McLemore" <kaelten(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5077: Corrupted Table
Date: 2009-09-23 23:29:33
Message-ID: 200909232329.n8NNTXER019344@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 5077
Logged by: Bryan McLemore
Email address: kaelten(at)gmail(dot)com
PostgreSQL version: 8.4.0
Operating system: Ubuntu 64 bit
Description: Corrupted Table
Details:

Today a table corrupted and I started getting:

"invalid page header in block 900 of relation pg_tblspc/32041/138911/187737"

on all selects on a given table.

RhodiumToad & StuckMojo (and a few others) helped me track it down. The
page in question looked like this:

http://pgsql.privatepaste.com/83JfmQGtS5

RhodiumToad gave me this command to repair the table:

printf '\x00\x01\x40\x03\x00\x20' | dd of=pg_tblspc/32041/138911/187737 bs=1
conv=notrunc seek=7372812 count=6

The reason they asked me to report this is that it appears this occured when
a disk filled up while pg_dump was running.

On this system df -h shows:

/dev/sda1 65G 23G 39G 38% /
varrun 4.0G 48K 4.0G 1% /var/run
varlock 4.0G 0 4.0G 0% /var/lock
udev 4.0G 40K 4.0G 1% /dev
devshm 4.0G 0 4.0G 0% /dev/shm
/dev/sdb1 136G 23G 107G 18% /data

/dev/sda1 is where the pgdata directory is.
/dev/sbd1 is where the tablespace is.

/sda1 is the drive that filled up while running a pg_dump.

If there is any additional info I can provide please let me know.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Euler Taveira de Oliveira 2009-09-23 23:31:20 Re: BUG #5075: Text Search parser does not identify xml tag when attribute name's contains underscore
Previous Message Mauro Infantino 2009-09-23 22:45:24 BUG #5076: LEFT OUTER JOIN and WHERE madness