Re: WAL replay failure after file truncation(?)

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: WAL replay failure after file truncation(?)
Дата
Msg-id 14292.1117202187@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: WAL replay failure after file truncation(?)  (Hans-Jürgen Schönig <postgres@cybertec.at>)
Ответы Re: WAL replay failure after file truncation(?)  (Hans-Jürgen Schönig <postgres@cybertec.at>)
Список pgsql-hackers
Hans-Jürgen Schönig <postgres@cybertec.at> writes:
> My question is: What happens if the system is killed inside 
> rebuild_relation or inside swap_relfilenodes which is called by 
> rebuild_relation?

Nothing at all, because the system catalog updates aren't committed yet,
and we haven't done anything to the relation's old physical file.

If I were you I'd be looking into whether your disk hardware honors
write ordering properly.  This sounds like something allowed the
directory change to reach disk before the transaction commit WAL record
did; which is impossible if fsync is doing what it's supposed to.
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: foreign keys and RI triggers
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Cost of XLogInsert CRC calculations