invalid page in block

Поиск
Список
Период
Сортировка
От Artem Tomyuk
Тема invalid page in block
Дата
Msg-id CANYYVqJTgvaSA7Rto5RDwteMt07XDJ4MfLCNxQ8QGRYFoVExoQ@mail.gmail.com
обсуждение исходный текст
Список pgsql-admin
Hi.

Today slave exited with error

===========>16008   2016-02-14 02:42:53 EET XX001 [11-1]FATAL:  invalid page in block 35921 of relation base/69823/12792

===========>16008   2016-02-14 02:42:53 EET XX001 [12-1]CONTEXT:  xlog redo vacuum: rel 1663/69823/12792; blk 73837, lastBlockVacuumed 7360

===========>16005   2016-02-14 02:42:55 EET 00000 [4-1]LOG:  startup process (PID 16008) exited with exit code 1

===========>16005   2016-02-14 02:42:55 EET 00000 [5-1]LOG:  terminating any other active server processes

===========>31144   2016-02-14 08:54:04 EET 00000 [1-1]LOG:  database system was interrupted while in recovery at log time 2016-02-14 02:03:17 EET

===========>31144   2016-02-14 08:54:04 EET 00000 [2-1]HINT:  If this has occurred more than once some data might be corrupted and you might need to choose an earlier recovery target.

What should i do?

From the message i see that is somehow connected with vacuum process?

I've added the zero_damaged_pages = on to conf, then started service.

For now replica is working with no errors.

Thanks!



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

Предыдущее
От: jaime soler
Дата:
Сообщение: Re: Downgrade 9.2.13.28 to 9.2.8
Следующее
От: "drum.lucas@gmail.com"
Дата:
Сообщение: Error with libdir - PostgreSQL 9.2