Ben Madin <lists(at)remoteinformation(dot)com(dot)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