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

On 03/02/2015 02:49 AM, hailong Li wrote:
>
>
> Hi, dear pgsql-general
>
>
> The details are as follows:
>
> *1. environment*
>
> *DB Master*
>
> $ cat /etc/issue
> CentOS release 6.5 (Final)
> Kernel \r on an \m
>
> $ uname -av
> Linux l-xxxxx1.xx.cnx 3.14.29-3.centos6.x86_64 #1 SMP Tue Jan 20
> 17:48:32 CST 2015 x86_64 x86_64 x86_64 GNU/Linux
>
> $ psql -U postgres
> psql (9.3.5)
> Type "help" for help.
>
> postgres=# select version();
>                       version
> --------------------------------------------------------------------------------------------------------------
>   PostgreSQL 9.3.5 on x86_64-unknown-linux-gnu, compiled by gcc (GCC)
> 4.4.7 20120313 (Red Hat 4.4.7-3), 64-bit
> (1 row)
>

>
> *DB Slave
>
> *$ cat /etc/issue
> CentOS release 6.5 (Final)
> Kernel \r on an \m
>
> $ uname -av
> Linux l-xxxx2.xx.cnx 3.14.31-3.centos6.x86_64 #1 SMP Mon Feb 2 15:26:04
> CST 2015 x86_64 x86_64 x86_64 GNU/Linux*
> *
> $ psql -U postgres
> psql (9.3.5)
> Type "help" for help.
>
> postgres=# select version();
>                                                     version
> --------------------------------------------------------------------------------------------------------------
>   PostgreSQL 9.3.5 on x86_64-unknown-linux-gnu, compiled by gcc (GCC)
> 4.4.7 20120313 (Red Hat 4.4.7-3), 64-bit
> (1 row)
>

>
> *The salve was running, but stopped suddenly , and I never start it !
>
> Anyone encounter the same problem?  Could tell me why and how to avoid it?
>
> If you need some more detailed information, please tell me and I'll give it to you.

So what sort of replication(streaming, archiving, synchronous,etc) where
you doing?

Was the streaming happening across a local network or a remote network?

Was there a hardware issue on either of the machines?

>
>
> Thanks
>
> Best Regards!
>


--
Adrian Klaver
adrian.klaver@aklaver.com