Re: Completely broken replica after PANIC: WAL contains references to invalid pages

Поиск
Список
Период
Сортировка
От Sergey Konoplev
Тема Re: Completely broken replica after PANIC: WAL contains references to invalid pages
Дата
Msg-id CAL_0b1t1gVQLvPmZocykRt-G44Ce7TDDx6XTYGHiHrnUMiuBeQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Completely broken replica after PANIC: WAL contains references to invalid pages  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
Hi all,

I recently noticed that I continue to receive "allocation failure"
messages from postmaster in /var/log/messages on the server where the
problem occurred.

Aug 17 23:00:51 tms2 kernel: : postmaster: page allocation failure.
order:5, mode:0xd0
Aug 17 23:00:51 tms2 kernel: : Pid: 21223, comm: postmaster Not
tainted 2.6.32-279.22.1.el6.x86_64 #1
Aug 17 23:00:51 tms2 kernel: : Call Trace:
Aug 17 23:00:51 tms2 kernel: : [<ffffffff8112343f>] ?
__alloc_pages_nodemask+0x77f/0x940
Aug 17 23:00:51 tms2 kernel: : [<ffffffff8115d3e2>] ? kmem_getpages+0x62/0x170
Aug 17 23:00:51 tms2 kernel: : [<ffffffff8115dffa>] ? fallback_alloc+0x1ba/0x270
Aug 17 23:00:51 tms2 kernel: : [<ffffffff8115da4f>] ? cache_grow+0x2cf/0x320
Aug 17 23:00:51 tms2 kernel: : [<ffffffff8115dd79>] ?
____cache_alloc_node+0x99/0x160
Aug 17 23:00:51 tms2 kernel: : [<ffffffff813fd455>] ?
dma_pin_iovec_pages+0xb5/0x230
Aug 17 23:00:51 tms2 kernel: : [<ffffffff8115eb49>] ? __kmalloc+0x189/0x220
Aug 17 23:00:51 tms2 kernel: : [<ffffffff813fd455>] ?
dma_pin_iovec_pages+0xb5/0x230
Aug 17 23:00:51 tms2 kernel: : [<ffffffff8141a47c>] ? lock_sock_nested+0xac/0xc0
Aug 17 23:00:51 tms2 kernel: : [<ffffffff8146edaa>] ? tcp_recvmsg+0x4ca/0xe80
Aug 17 23:00:51 tms2 kernel: : [<ffffffff8148f90a>] ? inet_recvmsg+0x5a/0x90
Aug 17 23:00:51 tms2 kernel: : [<ffffffff81418b93>] ? sock_recvmsg+0x133/0x160
Aug 17 23:00:51 tms2 kernel: : [<ffffffff81090be0>] ?
autoremove_wake_function+0x0/0x40
Aug 17 23:00:51 tms2 kernel: : [<ffffffff8117660a>] ? do_sync_read+0xfa/0x140
Aug 17 23:00:51 tms2 kernel: : [<ffffffff81418d0e>] ? sys_recvfrom+0xee/0x180
Aug 17 23:00:51 tms2 kernel: : [<ffffffff8118b09d>] ?
poll_select_set_timeout+0x8d/0xa0
Aug 17 23:00:51 tms2 kernel: : [<ffffffff810d3f47>] ?
audit_syscall_entry+0x1d7/0x200
Aug 17 23:00:51 tms2 kernel: : [<ffffffff8100b072>] ?
system_call_fastpath+0x16/0x1b

Except these messages everything is just fine. The server is a passive
(very rarely queried) hot standby.

Are there any ideas of why and what could it be?

Thank you.

On Tue, Jun 11, 2013 at 6:50 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Sergey Konoplev <gray.ru@gmail.com> writes:
>> Just curious, what is the planned date for the next minor release, and
>> BTW where is it possible to see the roadmap for minor releases?
>
> There is no planned date, and certainly no "roadmap".  We make minor
> releases when the core team judges that enough (or severe enough)
> fixes have accumulated since the last time.  Historically we've averaged
> about four minor releases a year, but that's not set in stone anywhere.
>
>                         regards, tom lane



--
Kind regards,
Sergey Konoplev
PostgreSQL Consultant and DBA

http://www.linkedin.com/in/grayhemp
+1 (415) 867-9984, +7 (901) 903-0499, +7 (988) 888-1979
gray.ru@gmail.com

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: 9.3beta2: Failure to pg_upgrade
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: BUG 5199:ERROR: cannot override frame clause of window xx