From: | Emanuel Calvo Franco <postgres(dot)arg(at)gmail(dot)com> |
---|---|
To: | Patrick Desjardins <mrdesjardins(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: [GENERAL] ERROR: XX001: could not read block 2354 of relation… |
Date: | 2009-04-01 15:49:36 |
Message-ID: | f205bb120904010849n66726ef0h76172d28265daf3a@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 15:53:59 | Re: [GENERAL] ERROR: XX001: could not read block 2354 of relation… |
Previous Message | Scott Marlowe | 2009-04-01 15:41:31 | Re: [GENERAL] Re: [GENERAL] Re: [GENERAL] ERROR: XX001: could not read block 2354 of relation… |