yet another db corruption issue

From: Jon Lapham <lapham(at)extracta(dot)com(dot)br>
To: pgsql-general(at)postgresql(dot)org
Subject: yet another db corruption issue
Date: 2001-10-17 18:45:05
Message-ID: 3BCDD1B1.3040703@extracta.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello-

I'm beginning to suspect that I have some hardware issue. Last week I
posted a message saying that I had a corrupted index, which Tom Lane
helped me resolve. He also suggested that I upgrade from v7.1.2 to v7.1.3.

I did the upgrade, and rebuilt my dbs from a clean "pgdump" file (as per
the upgrade instructions). Everything has been running great for the
last week.

Today, I am getting the following messages when accessing the "fraction"
table:

main_v0_8=# select * from fraction;
ERROR: cannot find attribute 19 of relation fraction

Suggestions on how to track this problem down? As of yesterday, the
fraction table (as well as all the others) were working fine. Does it
sound like a hardware issue?

Vital statistics:
www(at)exprod > uname -a
Linux exprod.extracta.com.br 2.4.9 #1 Fri Aug 17 16:54:36 BRT 2001 i686
unknown

compiled with: --with-tcl --with-perl --with-odbc --enable-hba
--enable-locale --enable-syslog

--

-**-*-*---*-*---*-*---*-----*-*-----*---*-*---*-----*-----*-*-----*---
Jon Lapham
Extracta Moléculas Naturais, Rio de Janeiro, Brasil
email: lapham(at)extracta(dot)com(dot)br web: http://www.extracta.com.br/
***-*--*----*-------*------------*--------------------*---------------

Browse pgsql-general by date

  From Date Subject
Next Message Jon Lapham 2001-10-17 19:01:18 yet another db corruption issue (more info)
Previous Message Mihai Gheorghiu 2001-10-17 18:29:23 Views and locks