Thread: could not open relation: Invalid argument

could not open relation: Invalid argument

From
"Roberts, Jon"
Date:
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.

I googled the error message and found that this looks like a problem on
Windows (which I'm running until we get access to our Linux server) and
probably related to anti-virus scanning.  Having run Oracle on Windows
before, I have experienced the problem with an anti-virus scanner locking a
file and causing the database to error.  I thought I understood and fixed
the problem.

Today, I used pgAdmin to Vacuum Analyze the entire database.  It flew
through this task as my database is fairly small.  However, when it got to
the three tables that exhibited this error message, it hung.  It took maybe
2-3 seconds to vacuum analyze each one of these tables.

Now I don't get it.  Was there something corrupt in the file and it wasn't
related to the anti-virus scanner?  


Jon


Re: could not open relation: Invalid argument

From
Alvaro Herrera
Date:
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.

Thanks.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


Re: could not open relation: Invalid argument

From
"Jaime Casanova"
Date:
On Jan 14, 2008 11:03 AM, Alvaro Herrera <alvherre@commandprompt.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...

-- 
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


Re: could not open relation: Invalid argument

From
Magnus Hagander
Date:
On Mon, Jan 14, 2008 at 10:12:55PM -0500, Jaime Casanova wrote:
> On Jan 14, 2008 11:03 AM, Alvaro Herrera <alvherre@commandprompt.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.

//Magnus


Re: could not open relation: Invalid argument

From
"Jaime Casanova"
Date:
On Jan 15, 2008 4:25 AM, Magnus Hagander <magnus@hagander.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@commandprompt.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