Re: The slave suddenly stopped with such DB log : "will not overwrite a used ItemId" and "heap_insert_redo: failed to add tuple"

Поиск
Список
Период
Сортировка
От hailong Li
Тема Re: The slave suddenly stopped with such DB log : "will not overwrite a used ItemId" and "heap_insert_redo: failed to add tuple"
Дата
Msg-id CAELgjyBjZE96sy7EoxvyC0O9Kn1j3+jCZy9Os2fNyh_vQgmrTQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: The slave suddenly stopped with such DB log : "will not overwrite a used ItemId" and "heap_insert_redo: failed to add tuple"  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
Список pgsql-general


2015-03-05 16:34 GMT+08:00 Jim Nasby <Jim.Nasby@bluetreble.com>:
On 3/3/15 6:52 AM, hailong Li wrote:

Finally , I made a  new slave instance on the slave server and it  works
fine until now.

Just so you're aware, that error means there was page level corruption either on the replica or possibly on the master, or the replication stream or WAL files got corrupted. You probably have either a hardware or a configuration problem somewhere.

Actually there were 3 slave nodes of the same master, and they  stopped nearly at the same time. So, I  prefer page level corruption  on the master to the slaves, and SSD hardware to configuration problem somewhere.
 
--
Jim Nasby, Data Architect, Blue Treble Consulting
Data in Trouble? Get it in Treble! http://BlueTreble.com

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

Предыдущее
От: Andrzej Pilacik
Дата:
Сообщение: Strange security issue with Superuser access
Следующее
От: PT
Дата:
Сообщение: Re: Strange security issue with Superuser access