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

Re: Error stranger

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 (view raw) 
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 (view raw) 
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

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