Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





2015-03-05 16:34 GMT+08:00 Jim Nasby <Jim.Nasby@xxxxxxxxxxxxxx>:
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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux