Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 5E1129FB579 for ; Thu, 19 Apr 2007 12:59:53 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 73745-07 for ; Thu, 19 Apr 2007 12:59:49 -0300 (ADT) X-Greylist: delayed 01:00:01.28341 by SQLgrey-1.7.4 Received: from mx.mailhost.ru (mx.mailhost.ru [217.16.26.110]) by postgresql.org (Postfix) with ESMTP id 609FC9FB8F3 for ; Thu, 19 Apr 2007 12:59:45 -0300 (ADT) Received: from [213.134.196.50] (account sand@reggi.ru HELO code) by mx.mailhost.ru (CommuniGate Pro SMTP 4.3.11) with ESMTPA id 8557985 for pgsql-admin@postgresql.org; Thu, 19 Apr 2007 18:59:42 +0400 Date: Thu, 19 Apr 2007 18:59:34 +0400 To: pgsql-admin@postgresql.org Subject: PGcluster replicator from_host:0.0.0.0 From: Alexander Organization: Reggi Content-Type: text/plain; format=flowed; delsp=yes; charset=koi8-r MIME-Version: 1.0 Content-Transfer-Encoding: Quoted-Printable Message-ID: User-Agent: Opera Mail/9.00 (Win32) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.535 tagged_above=0 required=5 tests=BAYES_40=-0.185, SARE_SPEC_REPLICA=0.72 X-Spam-Level: X-Archive-Number: 200704/200 X-Sequence-Number: 25264 I use pgcluster-1.5.0rc16. OS: Debian Etch Linux 2.6.18-4-amd64 Servers: cluster-db-1.vm replicator-1.vm DNS info: # host cluster-db-1.vm cluster-db-1.vm A 192.168.0.91 # host replicator-1.vm replicator-1.vm A 192.168.0.93 # host 192.168.0.91 Name: cluster-db-1.vm Address: 192.168.0.91 # host 192.168.0.93 Name: replicator-1.vm Address: 192.168.0.93 Config on cluster-db-1.vm: #=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D replicator-1.vm. 8001 8101 #------------------------------------------------------------- cluster-db-1.vm. 7001 /usr/bin/rsync ssh -1 yes /usr/lib/postgresql/8.1/bin/pg_dump read_only 1min 3s 11s #=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Config on replicator-1.vm: #=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D cluster-db-1.vm. 5432 7001 replicator-1.vm. 8001 8101 8301 normal no 1min 3s 15s #------------------------------------------------------------- /tmp/pgreplicate.log 1M 3 #=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Replicator log: Starting replicator... 2007-04-19 18:40:14 [12817] DEBUG:PGR_Get_Conf_Data ok 2007-04-19 18:40:14 [12817] DEBUG:LoadBalanceTbl allocate ok 2007-04-19 18:40:14 [12817] DEBUG:PGRget_Conf_Data():CascadeTbl shmget o= k 2007-04-19 18:40:14 [12817] DEBUG:PGRget_Conf_Data():CascadeTbl shmat ok= 2007-04-19 18:40:14 [12817] DEBUG:PGRget_Conf_Data():CascadeInf shmget o= k 2007-04-19 18:40:14 [12817] DEBUG:PGRget_Conf_Data():CascadeInf shmat ok= 2007-04-19 18:40:14 [12817] DEBUG:PGRget_Conf_Data():CommitLog shmget ok= 2007-04-19 18:40:14 [12817] DEBUG:PGRget_Conf_Data():Commit_Log_Tbl shma= t = ok 2007-04-19 18:40:14 [12817] DEBUG:PGRget_Conf_Data():RLog Memory = Allocation ok 2007-04-19 18:40:14 [12817] DEBUG:registering = (key,value)=3D(Host_Name,cluster-db-1.vm.) 2007-04-19 18:40:14 [12817] DEBUG:registering hostname cluster-db-1.vm. 2007-04-19 18:40:14 [12817] DEBUG:resolved name is 192.168.0.91 2007-04-19 18:40:14 [12817] DEBUG:registering (key,value)=3D(Port,5432) 2007-04-19 18:40:14 [12817] DEBUG:registering = (key,value)=3D(Recovery_Port,7001) 2007-04-19 18:40:14 [12817] DEBUG:registering = (key,value)=3D(Host_Name,192.168.0.93) 2007-04-19 18:40:14 [12817] DEBUG:registering = (key,value)=3D(Replication_Port,8001) 2007-04-19 18:40:14 [12817] DEBUG:registering = (key,value)=3D(Recovery_Port,8101) 2007-04-19 18:40:14 [12817] DEBUG:registering (key,value)=3D(RLOG_Port,8= 301) 2007-04-19 18:40:14 [12817] DEBUG:registering = (key,value)=3D(Response_Mode,normal) 2007-04-19 18:40:14 [12817] DEBUG:registering = (key,value)=3D(Use_Replication_Log,no) 2007-04-19 18:40:14 [12817] DEBUG:registering = (key,value)=3D(Replication_Timeout,1min) 2007-04-19 18:40:14 [12817] DEBUG:registering = (key,value)=3D(LifeCheck_Timeout,3s) 2007-04-19 18:40:14 [12817] DEBUG:registering = (key,value)=3D(LifeCheck_Interval,15s) 2007-04-19 18:40:14 [12817] DEBUG:registering = (key,value)=3D(File_Name,/tmp/pgreplicate.log) 2007-04-19 18:40:14 [12817] DEBUG:registering (key,value)=3D(File_Size,1= M) 2007-04-19 18:40:14 [12817] DEBUG:registering (key,value)=3D(Rotate,3) 2007-04-19 18:40:14 [12817] DEBUG:PGRget_Conf_Data():HostTbl shmget ok 2007-04-19 18:40:14 [12817] DEBUG:PGRget_Conf_Data():HostTbl shmat ok 2007-04-19 18:40:14 [12818] DEBUG:PGRrecovery_main():PGRrecovery_main bi= nd = port 8101 2007-04-19 18:40:14 [12817] DEBUG:replicate_main():entering replicate_ma= in 2007-04-19 18:40:14 [12817] DEBUG:replicate_main() 8001 port bind OK 2007-04-19 18:40:14 [12817] DEBUG:cmdSts=3DN 2007-04-19 18:40:14 [12817] DEBUG:rlog=3D0 2007-04-19 18:40:14 [12817] DEBUG:port=3D0 2007-04-19 18:40:14 [12817] DEBUG:pid=3D0 2007-04-19 18:40:14 [12817] DEBUG:from_host=3D192.168.0.93 2007-04-19 18:40:14 [12817] DEBUG:dbName=3Dtemplate1 2007-04-19 18:40:14 [12817] DEBUG:userName=3Dpostgres 2007-04-19 18:40:14 [12817] DEBUG:recieve sec=3D0 2007-04-19 18:40:14 [12817] DEBUG:recieve usec=3D0 2007-04-19 18:40:14 [12817] DEBUG:query_size=3D62 2007-04-19 18:40:14 [12817] DEBUG:request_id=3D0 2007-04-19 18:40:14 [12817] DEBUG:replicate_id=3D0 2007-04-19 18:40:14 [12817] DEBUG:recovery_status=3D0 2007-04-19 18:40:14 [12817] DEBUG:query=3DSELECT = PGR_SYSTEM_COMMAND_FUNCTION(1,'192.168.0.93',8001,8101) 2007-04-19 18:40:14 [12817] DEBUG:PGRis_same_host():target host 2007-04-19 18:40:15 [12817] DEBUG:start thread_send_cluster() 2007-04-19 18:40:15 [12817] DEBUG:send_replicate_packet_to_server():PQex= ec = send :SELECT PGR_SYSTEM_COMMAND_FUNCTION(1,'192.168.0.93',8001,8101) 2007-04-19 18:40:15 [12817] DEBUG:send_replicate_packet_to_server():PQex= ec = returns :SYSTEM_COMMAND 2007-04-19 18:40:15 [12817] DEBUG:thread_send_cluster():return value fro= m = send_replicate_packet_to_server() is 0 2007-04-19 18:40:15 [12817] DEBUG:thread_send_cluster():pthread_exit[0] 2007-04-19 18:40:35 [12823] DEBUG:PGRdo_replicate():query :: create tabl= e = lsls7(id int) 2007-04-19 18:40:35 [12823] DEBUG:cmdSts=3DQ 2007-04-19 18:40:35 [12823] DEBUG:cmdType=3DO 2007-04-19 18:40:35 [12823] DEBUG:rlog=3D0 2007-04-19 18:40:35 [12823] DEBUG:port=3D5432 2007-04-19 18:40:35 [12823] DEBUG:pid=3D4329 >>>>>>>>>>>>>>>>>>> 2007-04-19 18:40:35 [12823] DEBUG:from_host=3D0.0.0.0 <<<<<<<<<<<<<<<<<<< 2007-04-19 18:40:35 [12823] DEBUG:dbName=3Dtemplate1 2007-04-19 18:40:35 [12823] DEBUG:userName=3Dpostgres 2007-04-19 18:40:35 [12823] DEBUG:recieve sec=3D1176993635 2007-04-19 18:40:35 [12823] DEBUG:recieve usec=3D425712 2007-04-19 18:40:35 [12823] DEBUG:query_size=3D26 2007-04-19 18:40:35 [12823] DEBUG:request_id=3D1 2007-04-19 18:40:35 [12823] DEBUG:replicate_id=3D0 2007-04-19 18:40:35 [12823] DEBUG:recovery_status=3D0 2007-04-19 18:40:35 [12823] DEBUG:query=3Dcreate table lsls7(id int) 2007-04-19 18:40:35 [12823] DEBUG:sem_lock [1] req 2007-04-19 18:40:35 [12823] DEBUG:sem_lock [1] got it 2007-04-19 18:40:35 [12817] DEBUG:start thread_send_cluster() 2007-04-19 18:40:35 [12817] = DEBUG:send_replicate_packet_to_server():sync_command(SELECT = PGR_SYSTEM_COMMAND_FUNCTION(3,1176993635,425712,0,1,2) ) 2007-04-19 18:40:35 [12817] DEBUG:send_replicate_packet_to_server():PQex= ec = send :create table lsls7(id int) 2007-04-19 18:40:35 [12817] DEBUG:send_replicate_packet_to_server():PQex= ec = returns :CREATE TABLE 2007-04-19 18:40:35 [12817] DEBUG:thread_send_cluster():return value fro= m = send_replicate_packet_to_server() is 0 2007-04-19 18:40:35 [12817] DEBUG:thread_send_cluster():pthread_exit[0] 2007-04-19 18:40:35 [12823] DEBUG:sem_unlock[1] Execution of query 'create table lsls7(id int)' on cluster-db-1.vm bring= s = replicator to infinitive loop. Replicator executes query each 1min = . How to resolve this problem? -- = Best regards