Re: SQLSTATE XX000 Internal Error 7

Поиск
Список
Период
Сортировка
От johnkeefe
Тема Re: SQLSTATE XX000 Internal Error 7
Дата
Msg-id 1346293494710-5721837.post@n5.nabble.com
обсуждение исходный текст
Ответ на Re: SQLSTATE XX000 Internal Error 7  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: SQLSTATE XX000 Internal Error 7  (Craig Ringer <ringerc@ringerc.id.au>)
Список 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 по дате отправления:

Предыдущее
От: Craig Ringer
Дата:
Сообщение: Re: String comparision in PostgreSQL
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: SQLSTATE XX000 Internal Error 7