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

From johnkeefe
Subject Re: SQLSTATE XX000 Internal Error 7
Date
Msg-id 1346293494710-5721837.post@n5.nabble.com
Whole thread Raw
In response to Re: SQLSTATE XX000 Internal Error 7  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: SQLSTATE XX000 Internal Error 7  (Craig Ringer <ringerc@ringerc.id.au>)
List pgsql-general
I know this post is a few months old now, but I have a strikingly similar
setup and am getting a similar, somewhat more reliable error:

  ERROR:  could not open file "base/29292/12186914_fsm": Invalid argument

It happens while doing an ST_Difference() function on two large geometries.

I'm running OSX 10.8 (Mountain Lion)
Postgresql 9.4.1
PostGIS 2.0.1

It's failing repeatedly for me right now, so at the moment it's a hard fail.
That said, just last week, with the same database, same command but
different table, I got this slightly different error:

  ERROR:  could not open file "base/29292/49722_fsm": Invalid argument

THAT error, however, cleared up mysteriously after I shut down and
restarted. (I haven't been able to get tonight's error to clear up in the
same way.)

What other information can I provide to help track squash this bug?

Thanks,
John




--
View this message in context:
http://postgresql.1045698.n5.nabble.com/SQLSTATE-XX000-Internal-Error-7-tp5682117p5721837.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: String comparision in PostgreSQL
Next
From: Craig Ringer
Date:
Subject: Re: SQLSTATE XX000 Internal Error 7