Postgres Pro
Downloads
Home   >   mailing lists

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 Jim Nasby
Subject Re: The slave suddenly stopped with such DB log : "will not overwrite a used ItemId" and "heap_insert_redo: failed to add tuple"
Date
Msg-id 54F8151C.9070403@BlueTreble.com
Whole thread Raw
In response to 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 <shuhujiaolong@gmail.com>)
Responses 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 <shuhujiaolong@gmail.com>)
List pgsql-general
Tree view 
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.
--
Jim Nasby, Data Architect, Blue Treble Consulting
Data in Trouble? Get it in Treble! http://BlueTreble.com

pgsql-general by date:

Previous
From: Jim Nasby
Date:
Subject: Re: Re: [pgadmin-support] Issue with a hanging apply process on the replica db after vacuum works on primary
Next
From: Jim Nasby
Date:
Subject: Re: Copy Data between different databases