Re: FATAL: could not open relation pg_tblspc/491086/467369/491103: No such file or directory

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: FATAL: could not open relation pg_tblspc/491086/467369/491103: No such file or directory
Дата
Msg-id 497D6AC4.6010305@enterprisedb.com
обсуждение исходный текст
Ответ на Re: FATAL: could not open relation pg_tblspc/491086/467369/491103: No such file or directory  (Simon Riggs <simon@2ndQuadrant.com>)
Ответы Re: FATAL: could not open relation pg_tblspc/491086/467369/491103: No such file or directory  (Simon Riggs <simon@2ndQuadrant.com>)
Список pgsql-hackers
Simon Riggs wrote:
> In various places in current HEAD we throw a checkpoint when we want to
> be certain that all buffers have been flushed.
> 
> In recovery, a checkpoint isn't always a restartpoint for two reasons:
> timing and rmgr state. This gives both a cause for the error and an
> explanation of why it does not occur consistently. ISTM this could
> likely effect previous releases as well.

Were you able to narrow this down? Do you know exactly what command 
caused it? At least replay of CREATE DATABASE already calls 
FlushDatabaseBuffers(), but are we missing that from some other place?

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com


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

Предыдущее
От: KaiGai Kohei
Дата:
Сообщение: Re: 8.4 release planning (was Re: [COMMITTERS] pgsql: Automatic view update rules)
Следующее
От: Koichi Suzuki
Дата:
Сообщение: Re: V4 of PITR performance improvement for 8.4