[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