Re: Error stranger

From: Diego Schulz <dschulz(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Error stranger
Date: 2009-04-21 13:26:42
Message-ID: 47dcfe400904210626m34d4a040xa5bca7d56c47e911@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Apr 20, 2009 at 9:25 AM, paulo matadr <saddoness(at)yahoo(dot)com(dot)br> wrote:
> I get  this error when make a select below
>
> "SELECT * FROM batch.funcionalidade_iniciada  where proi_id = x"
>
> ERROR: missing chunk number 0 for toast value 458755
> SQL state: XX000

Looks like your database repository is corrupted and/or your disk is failing.

I'd suggest you to

1) look at the logs for error messages
2) fix hardware problems (if any)
3) if you don't have UPS, buy one
4) restore your database from last backup

regards,

diego

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mikko 2009-04-21 13:58:21 Re: trouble with to_char('L')
Previous Message Jasen Betts 2009-04-21 12:11:26 Re: DISTINCT ON without ORDER BY