Re: [Pgcluster-general] What happen to my pgcluster?
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_Compressyes /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_Interval11s /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_Interval15s /LifeCheck_Interval Log_File_Info File_Name /tmp/pgreplicate.log/File_Name File_Size 1M /File_Size Rotate3 /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
Re: [Pgcluster-general] What happen to my pgcluster?
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
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] 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