From: | "Jaime Casanova" <systemguards(at)gmail(dot)com> |
---|---|
To: | "Magnus Hagander" <magnus(at)hagander(dot)net> |
Cc: | "Alvaro Herrera" <alvherre(at)commandprompt(dot)com>, "Roberts, Jon" <Jon(dot)Roberts(at)asurion(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: could not open relation: Invalid argument |
Date: | 2008-01-16 00:42:14 |
Message-ID: | c2d9e70e0801151642q4969e1i4195cb953bec6c82@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Jan 15, 2008 4:25 AM, Magnus Hagander <magnus(at)hagander(dot)net> wrote:
> On Mon, Jan 14, 2008 at 10:12:55PM -0500, Jaime Casanova wrote:
> > On Jan 14, 2008 11:03 AM, Alvaro Herrera <alvherre(at)commandprompt(dot)com> wrote:
> > > Roberts, Jon wrote:
> > > > Version: PostgreSQL 8.2.5 on i686-pc-mingw32
> > > >
> > > > I recently started getting this error message randomly, "could not open
> > > > relation 42904/42906/42985: Invalid argument". I also got it for a couple
> > > > of other files. All three files are related to tables that have just a
> > > > single row each.
> > >
> > > This has been reported before, and we've patched the system so that the
> > > error reported is better. In HEAD we also patched it so that the system
> > > would automatically retry a number of times if the problem is
> > > ERROR_SHARING_VIOLATION (or something like that). That patch was not
> > > backported to 8.2 due to lack of testing -- the original reported did
> > > not come back to try the patched version.
> > >
> > > If you want to try, the patch is here:
> > > https://projects.commandprompt.com/public/pgsql/changeset/29853
> > >
> > > Let us know how it goes. If your problem is easily reproducible and the
> > > patch makes it go away, we would consider back-patching the fix.
> > >
> >
> > I have builded a patched version of 8.2, if you want i can send it to you...
> > if your mail server doesn't accept large files (the zip file is 5.6
> > mb) then maybe someone can share some space for temporarily store
> > it...
>
> Sure, I can do that.
>
Good... can you tell me where can i upload de file?
--
regards
Jaime Casanova
"Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots.
So far, the universe is winning."
Richard Cook
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2008-01-16 00:47:26 | Re: COPY encoding |
Previous Message | Sim Zacks | 2008-01-16 00:42:06 | Re: 8.2.4 serious slowdown |