Re: The slave suddenly stopped with such DB log : "will not
overwrite a used ItemId" and "heap_insert_redo: failed to add tuple" - Mailing list pgsql-general
From
hailong Li
Subject
Re: The slave suddenly stopped with such DB log : "will not
overwrite a used ItemId" and "heap_insert_redo: failed to add tuple"
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