From: | "Scott Mead" <scott(dot)mead(at)enterprisedb(dot)com> |
---|---|
To: | "Patrick Desjardins" <mrdesjardins(at)gmail(dot)com>, pgsql-general-owner(at)postgresql(dot)org, "Emanuel Calvo Franco" <postgres(dot)arg(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: [GENERAL] Re: [GENERAL] ERROR: XX001: could not read block 2354 of relation… |
Date: | 2009-04-01 16:59:53 |
Message-ID: | 426777945-1238605211-cardhu_decombobulator_blackberry.rim.net-412099955-@bxe1161.bisx.prod.on.blackberry |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
If you are using the EnterpriseDB release, and paying for support, you can always take this to them.
Sent from my mobile device
-----Original Message-----
From: Patrick Desjardins <mrdesjardins(at)gmail(dot)com>
Date: Wed, 1 Apr 2009 11:53:59
To: Emanuel Calvo Franco<postgres(dot)arg(at)gmail(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: [GENERAL] Re: [GENERAL] ERROR: XX001: could not read block 235
4 of relation…
We are using EnterpriseDB PostGresql 8.3. I can't simply take a good backup
because weeks have pass since the first error occurs.
I will try to Vacumm Full first, if nothing is fixed, I will try to pg_dump
like you suggest.
On Wed, Apr 1, 2009 at 11:49 AM, Emanuel Calvo Franco <
postgres(dot)arg(at)gmail(dot)com> wrote:
> 2009/3/31 Patrick Desjardins <mrdesjardins(at)gmail(dot)com>:
> > Hi,
> >
> > I have the error ERROR: XX001: could not read block 2354 of relation
> > 1663/17633/17925: read only 0 of 8192 bytes, but only sometime, when
> trying
> > to Insert data into a table. I would say that 99% of Insert works and
> 100%
> > of read works. This is only happenning since few weeks. I have done
> Vaccum
> > Analyze without any success (the vaccum take 65 minutes but nothing is
> > fixed, still have the ERROR XXX001). I have this error in the backend
> > application and when I do some Insert Query in the PgAdmin tool.
> >
>
> This kind of error occurs generally on 7.x versions or if you are using
> fsync =off and you have a surprised system down.
>
> Try to do a pg_dump of the database or clean (no delete) del wal files
> (this is not
> recommendable for new users).
>
> > What can I do to fix that problem?
> >
> > Thank you,
> >
>
>
>
> --
> Emanuel Calvo Franco
> Sumate al ARPUG !
> (www.postgres-arg.org -
> www.arpug.com.ar)
> ArPUG / AOSUG Member
> Postgresql Support & Admin
>
From | Date | Subject | |
---|---|---|---|
Next Message | Patrick Desjardins | 2009-04-01 17:03:43 | Re: [GENERAL] Re: [GENERAL] ERROR: XX001: could not read block 2354 of relation… |
Previous Message | David E. Wheeler | 2009-04-01 16:52:50 | Re: [HACKERS] string_to_array with empty input |