Skip site navigation (1) Skip section navigation (2)

database corruption

From: Michael Guerin <guerin(at)rentec(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: database corruption
Date: 2004-06-11 20:16:30
Message-ID: 40CA131E.809@rentec.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hi,

    We recently switch over from Solaris to Linux and we've been 
experiencing a couple database corruptions problems.  We're using the 
2.6 kernel and a XFS file system, in case there are any known problems 
with this setup. 

It's my understanding that these errors are typically b/c of hardware 
problems, so we're in the process of checking the disk.  However, are 
there other things that I should look to find out what's going on?   The 
table that was corrupted earlier this week was dropped and  recreated, 
but it was corrupted again sometime last night.  The table is pretty 
active, about 10GB are inserted and deleted every day.

-Michael


here's what vacuum comes up with

INFO:  vacuuming "public.tbltimeseries"
WARNING:  relation "tbltimeseries" TID 696892/1: OID is invalid
WARNING:  relation "tbltimeseries" TID 696892/2: OID is invalid
WARNING:  relation "tbltimeseries" TID 696892/3: OID is invalid
WARNING:  relation "tbltimeseries" TID 696892/4: OID is invalid
WARNING:  relation "tbltimeseries" TID 696892/5: OID is invalid
WARNING:  relation "tbltimeseries" TID 696892/6: OID is invalid
WARNING:  relation "tbltimeseries" TID 696893/1: OID is invalid
WARNING:  relation "tbltimeseries" TID 696893/2: OID is invalid
WARNING:  relation "tbltimeseries" TID 696893/3: OID is invalid
WARNING:  relation "tbltimeseries" TID 696893/4: OID is invalid
WARNING:  relation "tbltimeseries" TID 696893/5: OID is invalid
WARNING:  relation "tbltimeseries" TID 696893/6: OID is invalid
WARNING:  relation "tbltimeseries" TID 696894/1: OID is invalid
WARNING:  relation "tbltimeseries" TID 696894/2: OID is invalid
WARNING:  relation "tbltimeseries" TID 696894/3: OID is invalid
WARNING:  relation "tbltimeseries" TID 696894/4: OID is invalid
WARNING:  relation "tbltimeseries" TID 696895/1: OID is invalid
WARNING:  relation "tbltimeseries" TID 696895/2: OID is invalid
WARNING:  relation "tbltimeseries" TID 696895/3: OID is invalid
WARNING:  relation "tbltimeseries" TID 696895/4: OID is invalid
WARNING:  relation "tbltimeseries" TID 696895/5: OID is invalid
WARNING:  relation "tbltimeseries" TID 696895/6: OID is invalid
WARNING:  relation "tbltimeseries" TID 1124824/1: OID is invalid
WARNING:  relation "tbltimeseries" TID 1124824/2: OID is invalid
WARNING:  relation "tbltimeseries" TID 1124824/3: OID is invalid
WARNING:  relation "tbltimeseries" TID 1124824/4: OID is invalid
WARNING:  relation "tbltimeseries" TID 1124824/5: OID is invalid
INFO:  index "idx_timeseries2" now contains 27066056 row versions in 
108521 pages
DETAIL:  0 index pages have been deleted, 0 are currently reusable.
CPU 3.30s/1.06u sec elapsed 17.28 sec.
INFO:  "tbltimeseries": found 0 removable, 27065818 nonremovable row 
versions in 1643991 pages
DETAIL:  0 dead row versions cannot be removed yet.
There were 86 unused item pointers.
0 pages are entirely empty.
CPU 25.41s/4.88u sec elapsed 272.64 sec.
INFO:  vacuuming "pg_toast.pg_toast_1436963967"
ERROR:  invalid page header in block 1890530 of relation 
"pg_toast_1436963967"

Responses

pgsql-novice by date

Next:From: Scott MarloweDate: 2004-06-11 21:38:13
Subject: Re: database corruption
Previous:From: Bruno Wolff IIIDate: 2004-06-11 19:33:11
Subject: Re: Character encoding in database dumps

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group