pgcluster

Hallo,

habe ein problem mit pgcluster.

Ich nutze zwei db Knoten und einen Replikator unter Suse 9.3.

Der Replikator synchronisiert die Inserts nicht auf den 2. DB Knoten. Der Client hängt im Insert - Kommando fest.

Meine konfiguration ist: 2 DB, 1 Replikator, 1 Loadbalancer

Configdateien

Replikator

<Cluster_Server_Info>
    <Host_Name>   dbknoten1  </Host_Name>
    <Port>                5432        </Port>
    <Recovery_Port>       7101        </Recovery_Port>
    <LifeCheck_Port>      7201        </LifeCheck_Port>
</Cluster_Server_Info>

<Cluster_Server_Info>
    <Host_Name>   dbknoten2 </Host_Name>
    <Port>                5432        </Port>
    <Recovery_Port>       7101        </Recovery_Port>
    <LifeCheck_Port>      7201        </LifeCheck_Port>
</Cluster_Server_Info>

<Status_Log_File>  /var/log/postgres/pgreplicate.sts  </Status_Log_File>
<Error_Log_File>   /var/log/postgres/pgreplicate.log  </Error_Log_File>
<Replication_Port>       8001            </Replication_Port>
<Recovery_Port>          8101            </Recovery_Port>
<LifeCheck_Port>         8201            </LifeCheck_Port>
<RLOG_Port>              8301            </RLOG_Port>
<Response_Mode>        normal            </Response_Mode>
<Use_Replication_Log>     no          </Use_Replication_Log>
<Reserved_Connections>      1            </Reserved_Connections>

ClusterDB

<Replicate_Server_Info>
        <Host_Name> replikation1  </Host_Name>
        <Port> 8001 </Port>
        <Recovery_Port> 8101 </Recovery_Port>
        <LifeCheck_Port> 8201 </LifeCheck_Port>
</Replicate_Server_Info>


<Recovery_Port> 7101 </Recovery_Port>
<LifeCheck_Port> 7201 </LifeCheck_Port>
<Rsync_Path> /usr/bin/rsync </Rsync_Path>
<Rsync_Option> ssh -2 -p 26 </Rsync_Option>
<When_Stand_Alone> read_only  </When_Stand_Alone>
<Status_Log_File>  /var/log/postgres/cluster.sts </Status_Log_File>
<Error_Log_File> /var/log/postgres/cluster.log  </Error_Log_File>

Loadbalancer

<Cluster_Server_Info>
        <Host_Name> dbknoten1 </Host_Name>
        <Port> 5432 </Port>
        <Max_Connect> 30 </Max_Connect>
</Cluster_Server_Info>

<Cluster_Server_Info>
        <Host_Name> dbknoten2 </Host_Name>
        <Port> 5432 </Port>
        <Max_Connect> 30 </Max_Connect>
</Cluster_Server_Info>

#LoadBalancer Configuration

<Receive_Port> 5432 </Receive_Port>
<Recovery_Port> 6101 </Recovery_Port>
<Live_Check_Port> 6201 </Live_Check_Port>
<Max_Cluster_Num> 128 </Max_Cluster_Num>
<Use_Connection_Pooling> no </Use_Connection_Pooling>

Es scheint, dass der Rplikator ein leeres Query erhält:

DEBUG:PGRreplicate_packet_send():cmdSts=Q
DEBUG:PGRreplicate_packet_send():cmdType=I
DEBUG:PGRreplicate_packet_send():rlog=0
DEBUG:PGRreplicate_packet_send():request_id=0
DEBUG:PGRreplicate_packet_send():replicate_id=0
DEBUG:PGRreplicate_packet_send():port=5432
DEBUG:PGRreplicate_packet_send():pid=13542
DEBUG:PGRreplicate_packet_send():from_host=dbknoten1
DEBUG:PGRreplicate_packet_send():dbName=testdb
DEBUG:PGRreplicate_packet_send():userName=postgres
DEBUG:PGRreplicate_packet_send():recieve sec=1145622455
DEBUG:PGRreplicate_packet_send():recieve usec=703381
DEBUG:PGRreplicate_packet_send():query_size=41
DEBUG:PGRreplicate_packet_send():query=
DEBUG:sem_lock[1]

Kann mir jemand helfen ?[/code]