Re: BUG #2712: could not fsync segment: Permission

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #2712: could not fsync segment: Permission
Дата
Msg-id 28745.1161638475@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: BUG #2712: could not fsync segment: Permission  ("Thomas H." <me@alternize.com>)
Список pgsql-bugs
"Thomas H." <me@alternize.com> writes:
> right now its PID 4844 ("\BaseNamedObjects\pgident: postgres: db_outnow
> outnow1 127.0.0.1(2122) idle") that tries to write
> "D:\DB\PostgreSQL-8.2\data\base\3964774\6422331"

Do you actually mean it's trying to write that file?  Or is it just
sitting there holding the open filehandle?

> can i somehow check what object that file-OID belong(ed/s) to?

You can check in pg_class.relfilenode and pg_class.oid of that database
to see if you get a match.  But our theory is that this table has been
deleted ...

            regards, tom lane

В списке pgsql-bugs по дате отправления:

Предыдущее
От: "Thomas H."
Дата:
Сообщение: Re: BUG #2712: could not fsync segment: Permission
Следующее
От: Tom Lane
Дата:
Сообщение: global symbol conflict in test/pgtypeslib/dt_test2.pgc