Re: [GENERAL] Checkpoint request failed on version 8.2.1.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [GENERAL] Checkpoint request failed on version 8.2.1.
Дата
Msg-id 7654.1168619725@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [GENERAL] Checkpoint request failed on version 8.2.1.  (Magnus Hagander <magnus@hagander.net>)
Ответы Re: [GENERAL] Checkpoint request failed on version 8.2.1.  (Magnus Hagander <magnus@hagander.net>)
Список pgsql-hackers
Magnus Hagander <magnus@hagander.net> writes:
> Tom Lane wrote:
>> Actually, it could still be the same problem, with the AV software only
>> involved to the extent that it's trying to scan files for viruses.

> Partially the same, but I've seen AV software keeping it open for
> hours... Basically until reboot.

Well, the bug report that just went by proves there's another problem:

: select version();
:
: "PostgreSQL 8.2.1 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC)
: 3.4.2 (mingw-special)"
:
: pg_log:
:
: 2007-01-12 17:23:16 PANIC:  could not open control file
: "global/pg_control": Permission denied

pg_control is certainly not ever deleted or renamed, and in fact I
believe there's an LWLock enforcing that only one PG process at a time
is even touching it.  So we need another theory to explain this one :-(
... anyone have a better one than "Windows is a piece of junk"?

            regards, tom lane

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

Предыдущее
От: Magnus Hagander
Дата:
Сообщение: Re: [GENERAL] Checkpoint request failed on version 8.2.1.
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [pgsql-patches] [PATCHES] Patch to log usage of