HI,

I don't know what connections will cause that.

Best wishes,
 
Dika Ye
 
NTT Com Asia Limited

-----Original Message-----
From: pgcluster-general-boun...@pgfoundry.org
[mailto:pgcluster-general-boun...@pgfoundry.org] On Behalf Of Dika Ye
Sent: 2010年4月2日 9:41
To: markus.schmidleit...@ocilion.com; pgcluster-general@pgfoundry.org
Subject: Re: [Pgcluster-general] What happen to my pgcluster?

Hi Markus,

Thanks for you reply. But what will cause that? 

Please see the configure as follows:

Cluster.conf
######cut here######
<Replicate_Server_Info>
        <Host_Name>             rep01                           </Host_Name>
        <Port>                  8001                            </Port>
        <Recovery_Port>         8101
</Recovery_Port>
</Replicate_Server_Info>
<Host_Name>             db01            </Host_Name>
<Recovery_Port>         7001            </Recovery_Port>
<Rsync_Path>            /usr/bin/rsync  </Rsync_Path>
<Rsync_Option>          ssh             </Rsync_Option>
<Rsync_Compress>        yes             </Rsync_Compress>
<Rsync_Timeout>         10min           </Rsync_Timeout>
<Rsync_Bwlimit>         0KB             </Rsync_Bwlimit>
<Pg_Dump_Path>          /usr/local/pgsql/bin/pg_dump    </Pg_Dump_Path>
<When_Stand_Alone>      read_only       </When_Stand_Alone>
<Replication_Timeout>   1min            </Replication_Timeout>
<LifeCheck_Timeout>     3s              </LifeCheck_Timeout>
<LifeCheck_Interval>    11s             </LifeCheck_Interval>
######cut here######


pgreplicate.conf
######cut here######
<Cluster_Server_Info>
    <Host_Name>                 db01            </Host_Name>
    <Port>                      2000            </Port>
    <Recovery_Port>             7001            </Recovery_Port>
</Cluster_Server_Info>
<Cluster_Server_Info>
    <Host_Name>                 db02            </Host_Name>
    <Port>                      2000            </Port>
    <Recovery_Port>             7001            </Recovery_Port>
</Cluster_Server_Info>
<Cluster_Server_Info>
    <Host_Name>                 db03            </Host_Name>
    <Port>                      2000            </Port>
    <Recovery_Port>             7001            </Recovery_Port>
</Cluster_Server_Info>
<Cluster_Server_Info>
    <Host_Name>                 db04            </Host_Name>
    <Port>                      2000            </Port>
    <Recovery_Port>             7001            </Recovery_Port>
</Cluster_Server_Info>
<Host_Name>                     rep01                           </Host_Name>
<Replication_Port>              8001
</Replication_Port>
<Recovery_Port>                 8101
</Recovery_Port>
<RLOG_Port>                     8301                            </RLOG_Port>
<Response_Mode>                 normal
</Response_Mode>
<Use_Replication_Log>           yes
</Use_Replication_Log>
<Replication_Timeout>           1min
</Replication_Timeout>
<LifeCheck_Timeout>             3s
</LifeCheck_Timeout>
<LifeCheck_Interval>            15s
</LifeCheck_Interval>
<Log_File_Info>
        <File_Name>             /tmp/pgreplicate.log    </File_Name>
        <File_Size>             1M                      </File_Size>
        <Rotate>                3                       </Rotate>
</Log_File_Info>
######cut here######
-----Original Message-----
From: pgcluster-general-boun...@pgfoundry.org
[mailto:pgcluster-general-boun...@pgfoundry.org] On Behalf Of Markus
Schmidleitner
Sent: 2010年4月1日 17:26
To: pgcluster-general@pgfoundry.org
Subject: Re: [Pgcluster-general] What happen to my pgcluster?

hi Dika.Ye!

it seems like the backend connection has been closed on the remote host
after replication server sent the command to it.
so the replication server can not read any result from it.
Connection reset by peer usually means that.

regards,
markus

Am Donnerstag, den 01.04.2010, 16:20 +0800 schrieb Dika Ye:
> So confound, no body know it?
> 
>  
> 
>                                    
> ______________________________________________________________________
> From: pgcluster-general-boun...@pgfoundry.org
> [mailto:pgcluster-general-boun...@pgfoundry.org] On Behalf Of Dika Ye
> Sent: 2010年3月31日17:21
> To: pgcluster-general@pgfoundry.org
> Subject: [Pgcluster-general] What happen to my pgcluster?
> 
> 
>  
> 
> Hi all,
> 
>  
> 
> I use pgcluster-1.1.2rc10, and there is one replication server with
> four db master servers, when I start the replication server and db
> master servers,
> 
> I found an error occur in the replication server screen:
> 
>  
> 
> 2010-03-31 17:09:16 [21318] DEBUG:start thread_send_cluster()
> 
> 2010-03-31 17:09:16 [21318] DEBUG:sem_unlock[1]
> 
> 2010-03-31 17:09:56 [21341] ERROR:PGRread_packet():recv failed:
> (Connection reset by peer)
> 
> 2010-03-31 17:09:56 [21341] ERROR:PGRread_packet():recv failed:
> (Connection reset by peer)
> 
> 2010-03-31 17:10:01 [21350] ERROR:PGRread_packet():recv failed:
> (Connection reset by peer)
> 
> 2010-03-31 17:10:01 [21350] ERROR:PGRread_packet():recv failed:
> (Connection reset by peer)
> 
> 2010-03-31 17:10:02 [21351] ERROR:PGRread_packet():recv failed:
> (Connection reset by peer)
> 
> 2010-03-31 17:10:02 [21351] ERROR:PGRread_packet():recv failed:
> (Connection reset by peer)
> 
> 2010-03-31 17:10:02 [21352] ERROR:PGRread_packet():recv failed:
> (Connection reset by peer)
> 
> 2010-03-31 17:10:02 [21352] ERROR:PGRread_packet():recv failed:
> (Connection reset by peer)
> 
>  
> 
> But it seems the db master servers can finish the replication, what
> happen? 
> 
>  
> 
> Best wishes,
> 
>  
> 
> Dika.Ye
> 
>  
> 
> 
> _______________________________________________
> Pgcluster-general mailing list
> Pgcluster-general@pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgcluster-general

_______________________________________________
Pgcluster-general mailing list
Pgcluster-general@pgfoundry.org
http://pgfoundry.org/mailman/listinfo/pgcluster-general

_______________________________________________
Pgcluster-general mailing list
Pgcluster-general@pgfoundry.org
http://pgfoundry.org/mailman/listinfo/pgcluster-general

_______________________________________________
Pgcluster-general mailing list
Pgcluster-general@pgfoundry.org
http://pgfoundry.org/mailman/listinfo/pgcluster-general

Reply via email to