Lists: | pgsql-general |
---|
From: | paulo matadr <saddoness(at)yahoo(dot)com(dot)br> |
---|---|
To: | GENERAL <pgsql-general(at)postgresql(dot)org> |
Subject: | Error stranger |
Date: | 2009-04-20 13:25:44 |
Message-ID: | 12493.56075.qm@web52510.mail.re2.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
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
Veja quais são os assuntos do momento no Yahoo! +Buscados
http://br.maisbuscados.yahoo.com
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 |
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