Re: SQLSTATE XX000 Internal Error 7 - Mailing list pgsql-general

From Tom Lane
Subject Re: SQLSTATE XX000 Internal Error 7
Date
Msg-id 11522.1336017455@sss.pgh.pa.us
Whole thread Raw
In response to SQLSTATE XX000 Internal Error 7  (Ben Madin <lists@remoteinformation.com.au>)
Responses Re: SQLSTATE XX000 Internal Error 7
List pgsql-general
Ben Madin <lists@remoteinformation.com.au> writes:
> SQLSTATE[XX000]: Internal error: 7 ERROR:  could not open file "base/102979/430122_fsm": Invalid argument

[ scratches head ... ]  AFAICS the only documented reason for open() to
fail with EINVAL on OS X is

     [EINVAL]           The value of oflag is not valid.

which is surely bogus since that code path calls it with a constant
value for oflag --- there's no way it could fail just some of the time.

So this is smelling like a kernel or filesystem bug.  I wonder exactly
which OS X update you're running, and what sort of filesystem the
database is stored on.

            regards, tom lane

pgsql-general by date:

Previous
From: Ben Chobot
Date:
Subject: logging query result size?
Next
From: Ben Madin
Date:
Subject: Re: SQLSTATE XX000 Internal Error 7