[Pgcluster-general] PGR_Create_Socket_Connect(): FAIL 7
Boris Schulz
bxs at irlwinckl.de
Thu Jan 3 14:46:42 UTC 2008
Hi,
I am trying out a self compiled cybercluster 1.0.0 and am stuck with a
problem where google always points me to pgcluster without giving any actual
help. So if anyone here can help me, I would greatly appreciate it.
I have set up one replication server and two nodes. Installation went
smoothly, however, when I start the nodes I get these Lines, the first
beeing the one that gives me headaches:
LOG: PGR_Create_Socket_Connect(): FAIL 7
LOG: database system was shut down at 2008-01-03 15:19:36 CET
LOG: checkpoint record is at 0/4616F0
LOG: redo record is at 0/4616F0; undo record is at 0/0; shutdown TRUE
LOG: next transaction ID: 0/648; next OID: 16406
LOG: next MultiXactId: 1; next MultiXactOffset: 0
LOG: PGR_Do_Master_Main(): PGR_Create_Socket_Bind succeeded
LOG: database system is ready
I can normally connect to the nodes, but any write access ist accomapnied by
these lines:
LOG: PGR_Create_Socket_Connect(): FAIL 7
LOG: PGR_Create_Socket_Connect(): FAIL 7
And the writes are not propagated to the other node.
The meaning is pretty obvious, but I am unsure what to do...
I tried starting the master first, as well as the master last, it does not
matter.
My config files are pretty basic.
This is my cluster.conf on node 1:
<Replicate_Server_Info>
<Host_Name> repmaster </Host_Name>
<Port> 8001 </Port>
<Recovery_Port> 8101 </Recovery_Port>
</Replicate_Server_Info>
<Host_Name> node1 </Host_Name>
<Recovery_Port> 7001 </Recovery_Port>
<Rsync_Path> /usr/bin/rsync </Rsync_Path>
<Rsync_Option> ssh -1 </Rsync_Option>
<Rsync_Compress> yes </Rsync_Compress>
<Pg_Dump_Path> /usr/local/cybercluster/bin/pg_dump </Pg_Dump_Path>
<When_Stand_Alone> read_write </When_Stand_Alone>
<Replication_Timeout> 1min </Replication_Timeout>
<LifeCheck_Timeout> 3s </LifeCheck_Timeout>
<LifeCheck_Interval> 11s </LifeCheck_Interval>
This is my cluster.conf on node 2:
<Replicate_Server_Info>
<Host_Name> repmaster </Host_Name>
<Port> 8001 </Port>
<Recovery_Port> 8101 </Recovery_Port>
</Replicate_Server_Info>
<Host_Name> node2 </Host_Name>
<Recovery_Port> 7001 </Recovery_Port>
<Rsync_Path> /usr/bin/rsync </Rsync_Path>
<Rsync_Option> ssh -1 </Rsync_Option>
<Rsync_Compress> yes </Rsync_Compress>
<Pg_Dump_Path> /usr/local/cybercluster/bin/pg_dump </Pg_Dump_Path>
<When_Stand_Alone> read_write </When_Stand_Alone>
<Replication_Timeout> 1min </Replication_Timeout>
<LifeCheck_Timeout> 3s </LifeCheck_Timeout>
<LifeCheck_Interval> 11s </LifeCheck_Interval>
And this is my pgreplication.conf
<Cluster_Server_Info>
<Host_Name> node1 </Host_Name>
<Port> 5432 </Port>
<Recovery_Port> 7001 </Recovery_Port>
</Cluster_Server_Info>
<Cluster_Server_Info>
<Host_Name> node2 </Host_Name>
<Port> 5432 </Port>
<Recovery_Port> 7001 </Recovery_Port>
</Cluster_Server_Info>
<Host_Name> repmaster </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/cybercluster.log </File_Name>
<File_Size> 1M </File_Size>
<Rotate> 3 </Rotate>
</Log_File_Info>
greets, B.S.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://pgfoundry.org/pipermail/pgcluster-general/attachments/20080103/b3f53439/attachment.html
More information about the Pgcluster-general
mailing list