Re: SQLSTATE XX000 Internal Error 7

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