uninitialized page in standby recovery

Поиск
Список
Период
Сортировка
От Ray Stell
Тема uninitialized page in standby recovery
Дата
Msg-id b1fcef70-d8c5-689c-a3a8-b01e4f212c53@vt.edu
обсуждение исходный текст
Ответы Re: uninitialized page in standby recovery  (Ray Stell <stellr@vt.edu>)
Re: uninitialized page in standby recovery  (Ray Stell <stellr@vt.edu>)
Список pgsql-admin
I built a standby with 9.4.12 and about a day later the standby crashed 
with this:

2018-02-02 16:20:44 EST,0, WARNING:  page 1347460 of relation 
base/16391/16414 is uninitialized
2018-02-02 16:20:44 EST,0, CONTEXT:  xlog redo visible: rel 
1663/16391/16414; blk 1347460
2018-02-02 16:20:44 EST,0, PANIC:  WAL contains references to invalid pages
2018-02-02 16:20:44 EST,0, CONTEXT:  xlog redo visible: rel 
1663/16391/16414; blk 1347460
2018-02-02 16:20:44 EST,0, LOG:  startup process (PID 24057) was 
terminated by signal 6: Aborted
2018-02-02 16:20:44 EST,0, LOG:  terminating any other active server 
processes

Any hints to where the corruption begins?  I don't see any disk i/o 
issues.  Not sure what to look for in the release notes,

but I'll try to patch asap, but that is difficult to get done politically.



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

Предыдущее
От: robert
Дата:
Сообщение: Re: pg_restore has problems with restoring sequences.
Следующее
От: Ray Stell
Дата:
Сообщение: Re: uninitialized page in standby recovery