Re: SQLSTATE XX000 Internal Error 7

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ben Madin <lists(at)remoteinformation(dot)com(dot)au>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: SQLSTATE XX000 Internal Error 7
Date: 2012-05-03 14:00:56
Message-ID: 22149.1336053656@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ben Madin <lists(at)remoteinformation(dot)com(dot)au> writes:
> On 03/05/2012, at 11:57 AM, Tom Lane wrote:
>> 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.

> [ it's an up-to-date, pretty vanilla looking OS X Lion installation ]

Hm, so no smoking gun visible there. Can you put together a
self-contained test case that triggers this error for you? I recognize
that it'll be of the form "if you run this long enough, it'll fail"
rather than a deterministic failure, but that's OK. What we want to
know at this point is if anyone else can reproduce it. If we can do
that, and can show positively that the kernel is returning EINVAL for
valid-looking open() arguments, we'll have the needed ammunition to
file a bug with Apple.

> (PS How did you come to deciding that it was EINVAL - is that 'Error INVALid argument'?)

The "Invalid argument" part of our error message comes from strerror(),
and that's the standard text for EINVAL.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2012-05-03 15:02:39 Re: Removal of BSDi, BSD/OS port
Previous Message David Welton 2012-05-03 13:42:00 Encryption - searching and sorting