Re: BUG #10013: PostgreSQL 9.4 initdb FATAL: could not write to file "pg_xlog/xlogtemp.3590": No space left on devi

Поиск
Список
Период
Сортировка
От 德哥
Тема Re: BUG #10013: PostgreSQL 9.4 initdb FATAL: could not write to file "pg_xlog/xlogtemp.3590": No space left on devi
Дата
Msg-id 2c0e50b0.f2.1456d0a648a.Coremail.digoal@126.com
обсуждение исходный текст
Ответ на Re: BUG #10013: PostgreSQL 9.4 initdb FATAL: could not write to file "pg_xlog/xlogtemp.3590": No space left on devi  (Heikki Linnakangas <hlinnakangas@vmware.com>)
Список pgsql-bugs
Дерево обсуждения
HI,

Use this snapshot  the problem fixed, thanks Heikki and Andres's help.

Use correctly-sized buffer when zero-filling a WAL file.
authorHeikki Linnakangas <heikki.linnakangas@iki.fi>
Wed, 16 Apr 2014 07:21:09 +0000 (10:21 +0300)
committerHeikki Linnakangas <heikki.linnakangas@iki.fi>
Wed, 16 Apr 2014 07:26:36 +0000 (10:26 +0300)
commit848b9f05ab283724dd063d936a92568c1fdf422b
treee6f0804cb145b3c09841bc91a9dd6e07e5778551tree | snapshot
parentab76d8e9d672c661fe8ce4d9405dc8956b8ece9dcommit | diff
Use correctly-sized buffer when zero-filling a WAL file.

I mixed up BLCKSZ and XLOG_BLCKSZ when I changed the way the buffer is
allocated a couple of weeks ago. With the default settings, they are both
8k, but they can be changed at compile-time.
src/backend/access/transam/xlog.cdiff | blob | blame | history




--
公益是一辈子的事,I'm Digoal,Just Do It.


在 2014-04-16 07:28:52，"Heikki Linnakangas" <hlinnakangas@vmware.com> 写道：
>On 04/16/2014 02:17 PM, 德哥 wrote:
>> LOG:  write() in XLogFileInit returned 40960: Success
>
>Oh, that's interesting. Have you tweaked BLCKSZ or XLOG_BLCKSZ? If you 
>have, try with a fresh checkout - I just fixed a bug in that code where 
>I had used BLCKSZ instead of XLOG_BLCKSZ in the allocation of the 
>buffer. They're the same by default, but if you've changed them, that 
>might be it.
>
>- Heikki


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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: Having trouble configuring a Master with multiple standby Servers in PostgreSQL 9.3.3
Следующее
От:
Дата:
Сообщение: Re: Having trouble configuring a Master with multiple standby Servers in PostgreSQL 9.3.3