[pgcluster: 882] レプリケーションから戻らない
shinozaki ＠ cobalt.co.jp
shinozaki ＠ cobalt.co.jp
2006年 4月 18日 (火) 14:17:05 JST
初めて投稿させていただきます。
篠崎と申します。
この度、
PGCluster-1.5.0rc7を３台のサーバにインストール
してみました。
過去ログを確認してみた所[pgcluster: 745]と同じ症状のようです。
psqlで接続をしてレプリケーションが走らない処理では、
問題ないのですが、update 等の処理を実行すると
処理が固まります。
実際にＤＢのレプリケートまでは、
行われるのですが、処理がpsqlまで戻って来ませんでした。
namtest01 （クラスタリング１）
hostsの内容
127.0.0.1 namtest01 localhost.localdomain localhost
10.1.1.253 c04
10.1.1.220 namtest02 nam.clst02
cluster.confの内容
<Replicate_Server_Info>
<Host_Name> c04 </Host_Name>
<Port> 8777 </Port>
<Recovery_Port> 7778 </Recovery_Port>
</Replicate_Server_Info>
<Recovery_Port> 7779 </Recovery_Port>
<Rsync_Path> /usr/bin/rsync </Rsync_Path>
<Rsync_Option> ssh -1 </Rsync_Option>
<Rsync_Compress> yes </Rsync_Compress>
<When_Stand_Alone> read_only </When_Stand_Alone>
namtest02 （クラスタリング２）
hostsの内容
127.0.0.1 namtest02 localhost.localdomain localhost
10.1.1.253 c04
10.1.1.220 namtest01
cluster.confの内容
<Replicate_Server_Info>
<Host_Name> c04 </Host_Name>
<Port> 8777 </Port>
<Recovery_Port> 7778 </Recovery_Port>
</Replicate_Server_Info>
<Recovery_Port> 7779 </Recovery_Port>
<Rsync_Path> /usr/bin/rsync </Rsync_Path>
<Rsync_Option> ssh -1 </Rsync_Option>
<Rsync_Compress> yes </Rsync_Compress>
<When_Stand_Alone> read_only </When_Stand_Alone>
c04 （ロードバランサ、レプリケーション）
hostsの内容
127.0.0.1 c04 c04.cobalt.co.jp localhost.localdomain localhost lbm
aster
10.1.1.220 namtest01
10.1.1.221 namtest02
pglb.confの内容
<Cluster_Server_Info>
<Host_Name> namtest01 </Host_Name>
<Port> 5432 </Port>
<Max_Connect> 50 </Max_Connect>
</Cluster_Server_Info>
<Cluster_Server_Info>
<Host_Name> namtest02 </Host_Name>
<Port> 5432 </Port>
<Max_Connect> 50 </Max_Connect>
</Cluster_Server_Info>
<Backend_Socket_Dir> /tmp </Backend_Socket_Dir>
<Receive_Port> 5434 </Receive_Port>
<Recovery_Port> 7774 </Recovery_Port>
<Max_Cluster_Num> 16 </Max_Cluster_Num>
<Use_Connection_Pooling> no </Use_Connection_Pooling>
pgreplicate.confの内容
<Cluster_Server_Info>
<Host_Name> namtest01 </Host_Name>
<Port> 5432 </Port>
<Recovery_Port> 7779 </Recovery_Port>
</Cluster_Server_Info>
<Cluster_Server_Info>
<Host_Name> namtest02 </Host_Name>
<Port> 5432 </Port>
<Recovery_Port> 7779 </Recovery_Port>
</Cluster_Server_Info>
<LoadBalance_Server_Info>
<Host_Name> c04 </Host_Name>
<Recovery_Port> 7777 </Recovery_Port>
</LoadBalance_Server_Info>
<Replication_Port> 8777 </Replication_Port>
<Recovery_Port> 7778 </Recovery_Port>
<Response_Mode> normal </Response_Mode>
<Use_Replication_Log> no </Use_Replication_Log>
<RLOG_Port> 8301 </RLOG_Port>
以下ログ
ロードバランサ
2006-04-18 13:50:33 [25609] DEBUG:PGRset_status_on_cluster_tbl():host:namtest01 port:5432 max:50 use:0 status2
2006-04-18 13:50:33 [25609] DEBUG:PGRset_status_on_cluster_tbl():host:namtest02 port:5432 max:50 use:0 status2
2006-04-18 13:50:33 [25609] DEBUG:init_pglb():Child_Tbl size is[10200]
2006-04-18 13:51:16 [25609] DEBUG:PGRscan_cluster:2 ClusterDB can be used
2006-04-18 13:51:16 [25609] DEBUG:PGRscan_cluster:namtest01 [5432],useFlag->2 max->50 use_num->0
2006-04-18 13:51:16 [25703] DEBUG:PGRdo_child():I am 25703
2006-04-18 13:51:16 [25703] DEBUG:do_accept():I am 25703 accept fd 6
2006-04-18 13:51:16 [25703] DEBUG:read_startup_packet():Protocol Major: 3 Minor: 0 database: testdb user: pgcluster
2006-04-18 13:51:16 [25703] DEBUG:ParameterStatus():name: client_encoding value: EUC_JP
2006-04-18 13:51:16 [25703] DEBUG:pool_param_debug_print(): No.0: name: client_encoding value: EUC_JP
2006-04-18 13:51:16 [25703] DEBUG:ParameterStatus():name: DateStyle value: ISO, MDY
2006-04-18 13:51:16 [25703] DEBUG:pool_param_debug_print(): No.0: name: client_encoding value: EUC_JP
2006-04-18 13:51:16 [25703] DEBUG:pool_param_debug_print(): No.1: name: DateStyle value: ISO, MDY
2006-04-18 13:51:16 [25703] DEBUG:ParameterStatus():name: integer_datetimes value: off
2006-04-18 13:51:16 [25703] DEBUG:pool_param_debug_print(): No.0: name: client_encoding value: EUC_JP
2006-04-18 13:51:16 [25703] DEBUG:pool_param_debug_print(): No.1: name: DateStyle value: ISO, MDY
2006-04-18 13:51:16 [25703] DEBUG:pool_param_debug_print(): No.2: name: integer_datetimes value: off
2006-04-18 13:51:16 [25703] DEBUG:ParameterStatus():name: is_superuser value: on
2006-04-18 13:51:16 [25703] DEBUG:pool_param_debug_print(): No.0: name: client_encoding value: EUC_JP
2006-04-18 13:51:16 [25703] DEBUG:pool_param_debug_print(): No.1: name: DateStyle value: ISO, MDY
2006-04-18 13:51:16 [25703] DEBUG:pool_param_debug_print(): No.2: name: integer_datetimes value: off
2006-04-18 13:51:16 [25703] DEBUG:pool_param_debug_print(): No.3: name: is_superuser value: on
2006-04-18 13:51:16 [25703] DEBUG:ParameterStatus():name: server_encoding value: EUC_JP
2006-04-18 13:51:16 [25703] DEBUG:pool_param_debug_print(): No.0: name: client_encoding value: EUC_JP
2006-04-18 13:51:16 [25703] DEBUG:pool_param_debug_print(): No.1: name: DateStyle value: ISO, MDY
2006-04-18 13:51:16 [25703] DEBUG:pool_param_debug_print(): No.2: name: integer_datetimes value: off
2006-04-18 13:51:16 [25703] DEBUG:pool_param_debug_print(): No.3: name: is_superuser value: on
2006-04-18 13:51:16 [25703] DEBUG:pool_param_debug_print(): No.4: name: server_encoding value: EUC_JP
2006-04-18 13:51:16 [25703] DEBUG:ParameterStatus():name: server_version value: 8.1.2
2006-04-18 13:51:16 [25703] DEBUG:pool_param_debug_print(): No.0: name: client_encoding value: EUC_JP
2006-04-18 13:51:16 [25703] DEBUG:pool_param_debug_print(): No.1: name: DateStyle value: ISO, MDY
2006-04-18 13:51:16 [25703] DEBUG:pool_param_debug_print(): No.2: name: integer_datetimes value: off
2006-04-18 13:51:16 [25703] DEBUG:pool_param_debug_print(): No.3: name: is_superuser value: on
2006-04-18 13:51:16 [25703] DEBUG:pool_param_debug_print(): No.4: name: server_encoding value: EUC_JP
2006-04-18 13:51:16 [25703] DEBUG:pool_param_debug_print(): No.5: name: server_version value: 8.1.2
2006-04-18 13:51:16 [25703] DEBUG:ParameterStatus():name: session_authorization value: pgcluster
2006-04-18 13:51:16 [25703] DEBUG:pool_param_debug_print(): No.0: name: client_encoding value: EUC_JP
2006-04-18 13:51:16 [25703] DEBUG:pool_param_debug_print(): No.1: name: DateStyle value: ISO, MDY
2006-04-18 13:51:16 [25703] DEBUG:pool_param_debug_print(): No.2: name: integer_datetimes value: off
2006-04-18 13:51:16 [25703] DEBUG:pool_param_debug_print(): No.3: name: is_superuser value: on
2006-04-18 13:51:16 [25703] DEBUG:pool_param_debug_print(): No.4: name: server_encoding value: EUC_JP
2006-04-18 13:51:16 [25703] DEBUG:pool_param_debug_print(): No.5: name: server_version value: 8.1.2
2006-04-18 13:51:16 [25703] DEBUG:pool_param_debug_print(): No.6: name: session_authorization value: pgcluster
2006-04-18 13:51:16 [25703] DEBUG:ParameterStatus():name: standard_conforming_strings value: off
2006-04-18 13:51:16 [25703] DEBUG:pool_param_debug_print(): No.0: name: client_encoding value: EUC_JP
2006-04-18 13:51:16 [25703] DEBUG:pool_param_debug_print(): No.1: name: DateStyle value: ISO, MDY
2006-04-18 13:51:16 [25703] DEBUG:pool_param_debug_print(): No.2: name: integer_datetimes value: off
2006-04-18 13:51:16 [25703] DEBUG:pool_param_debug_print(): No.3: name: is_superuser value: on
2006-04-18 13:51:16 [25703] DEBUG:pool_param_debug_print(): No.4: name: server_encoding value: EUC_JP
2006-04-18 13:51:16 [25703] DEBUG:pool_param_debug_print(): No.5: name: server_version value: 8.1.2
2006-04-18 13:51:16 [25703] DEBUG:pool_param_debug_print(): No.6: name: session_authorization value: pgcluster
2006-04-18 13:51:16 [25703] DEBUG:pool_param_debug_print(): No.7: name: standard_conforming_strings value: off
2006-04-18 13:51:16 [25703] DEBUG:ParameterStatus():name: TimeZone value: Japan
2006-04-18 13:51:16 [25703] DEBUG:pool_param_debug_print(): No.0: name: client_encoding value: EUC_JP
2006-04-18 13:51:16 [25703] DEBUG:pool_param_debug_print(): No.1: name: DateStyle value: ISO, MDY
2006-04-18 13:51:16 [25703] DEBUG:pool_param_debug_print(): No.2: name: integer_datetimes value: off
2006-04-18 13:51:16 [25703] DEBUG:pool_param_debug_print(): No.3: name: is_superuser value: on
2006-04-18 13:51:16 [25703] DEBUG:pool_param_debug_print(): No.4: name: server_encoding value: EUC_JP
2006-04-18 13:51:16 [25703] DEBUG:pool_param_debug_print(): No.5: name: server_version value: 8.1.2
2006-04-18 13:51:16 [25703] DEBUG:pool_param_debug_print(): No.6: name: session_authorization value: pgcluster
2006-04-18 13:51:16 [25703] DEBUG:pool_param_debug_print(): No.7: name: standard_conforming_strings value: off
2006-04-18 13:51:16 [25703] DEBUG:pool_param_debug_print(): No.8: name: TimeZone value: Japan
2006-04-18 13:51:16 [25703] DEBUG:pool_process_query():read kind from backend pending data Z len: 5 po: 270
2006-04-18 13:51:16 [25703] DEBUG:ReadyForQuery(): message length: 5
2006-04-18 13:51:16 [25703] DEBUG:ReadyForQuery(): transaction state: I
2006-04-18 13:51:21 [25703] DEBUG:ProcessFrontendResponse():read kind from frontend Q(51)
2006-04-18 13:51:21 [25703] DEBUG:Query(): select * from test_tbl;
2006-04-18 13:51:21 [25703] DEBUG:pool_process_query():read kind from backend T
2006-04-18 13:51:21 [25703] DEBUG:pool_process_query():read kind from backend pending data D len: 196 po: 28
2006-04-18 13:51:21 [25703] DEBUG:pool_process_query():read kind from backend pending data D len: 179 po: 45
2006-04-18 13:51:21 [25703] DEBUG:pool_process_query():read kind from backend pending data D len: 162 po: 62
2006-04-18 13:51:21 [25703] DEBUG:pool_process_query():read kind from backend pending data D len: 145 po: 79
2006-04-18 13:51:21 [25703] DEBUG:pool_process_query():read kind from backend pending data D len: 128 po: 96
2006-04-18 13:51:21 [25703] DEBUG:pool_process_query():read kind from backend pending data D len: 111 po: 113
2006-04-18 13:51:21 [25703] DEBUG:pool_process_query():read kind from backend pending data D len: 94 po: 130
2006-04-18 13:51:21 [25703] DEBUG:pool_process_query():read kind from backend pending data D len: 77 po: 147
2006-04-18 13:51:21 [25703] DEBUG:pool_process_query():read kind from backend pending data D len: 60 po: 164
2006-04-18 13:51:21 [25703] DEBUG:pool_process_query():read kind from backend pending data D len: 43 po: 181
2006-04-18 13:51:21 [25703] DEBUG:pool_process_query():read kind from backend pending data D len: 30 po: 194
2006-04-18 13:51:21 [25703] DEBUG:pool_process_query():read kind from backend pending data C len: 17 po: 207
2006-04-18 13:51:21 [25703] DEBUG:pool_process_query():read kind from backend pending data Z len: 5 po: 219
2006-04-18 13:51:21 [25703] DEBUG:ReadyForQuery(): message length: 5
2006-04-18 13:51:21 [25703] DEBUG:ReadyForQuery(): transaction state: I
2006-04-18 13:51:26 [25703] DEBUG:ProcessFrontendResponse():read kind from frontend Q(51)
2006-04-18 13:51:26 [25703] DEBUG:Query(): insert into test_tbl(f1) values(11);
帰って来ないからpsqlをキャンセルすると以下を出力
2006-04-18 13:25:35 [25422] ERROR:pool_read: EOF encountered
2006-04-18 13:25:35 [25422] ERROR:ProcessFrontendResponse(): failed to read kind
レプリケータ
2006-04-18 13:48:56 [25573] DEBUG:PGR_Get_Conf_Data ok
2006-04-18 13:48:56 [25573] DEBUG:LoadBalanceTbl allocate ok
2006-04-18 13:48:56 [25573] DEBUG:PGRget_Conf_Data():CascadeTbl shmget ok
2006-04-18 13:48:56 [25573] DEBUG:PGRget_Conf_Data():CascadeTbl shmat ok
2006-04-18 13:48:56 [25573] DEBUG:PGRget_Conf_Data():CascadeInf shmget ok
2006-04-18 13:48:56 [25573] DEBUG:PGRget_Conf_Data():CascadeInf shmat ok
2006-04-18 13:48:56 [25573] DEBUG:PGRget_Conf_Data():CommitLog shmget ok
2006-04-18 13:48:56 [25573] DEBUG:PGRget_Conf_Data():Commit_Log_Tbl shmat ok
2006-04-18 13:48:56 [25573] DEBUG:PGRget_Conf_Data():RLog Memory Allocation ok
2006-04-18 13:48:56 [25573] DEBUG:registering (key,value)=(Host_Name,namtest01)
2006-04-18 13:48:56 [25573] DEBUG:registering hostname namtest01
2006-04-18 13:48:56 [25573] DEBUG:resolved name is 10.1.1.220
2006-04-18 13:48:56 [25573] DEBUG:registering (key,value)=(Port,5432)
2006-04-18 13:48:56 [25573] DEBUG:registering (key,value)=(Recovery_Port,7779)
2006-04-18 13:48:56 [25573] DEBUG:registering (key,value)=(Host_Name,namtest02)
2006-04-18 13:48:56 [25573] DEBUG:registering hostname namtest02
2006-04-18 13:48:56 [25573] DEBUG:resolved name is 10.1.1.221
2006-04-18 13:48:56 [25573] DEBUG:registering (key,value)=(Port,5432)
2006-04-18 13:48:56 [25573] DEBUG:registering (key,value)=(Recovery_Port,7779)
2006-04-18 13:48:56 [25573] DEBUG:registering (key,value)=(Host_Name,c04)
2006-04-18 13:48:56 [25573] DEBUG:registering (key,value)=(Recovery_Port,7777)
2006-04-18 13:48:56 [25573] DEBUG:registering (key,value)=(Replication_Port,8777)
2006-04-18 13:48:56 [25573] DEBUG:registering (key,value)=(Recovery_Port,7778)
2006-04-18 13:48:56 [25573] DEBUG:registering (key,value)=(Response_Mode,normal)
2006-04-18 13:48:56 [25573] DEBUG:registering (key,value)=(Use_Replication_Log,no)
2006-04-18 13:48:56 [25573] DEBUG:registering (key,value)=(RLOG_Port,8301)
2006-04-18 13:48:56 [25573] DEBUG:PGRget_Conf_Data():HostTbl shmget ok
2006-04-18 13:48:56 [25573] DEBUG:PGRget_Conf_Data():HostTbl shmat ok
2006-04-18 13:48:56 [25573] DEBUG: set replication id [14]
2006-04-18 13:48:56 [25574] DEBUG:PGRrecovery_main():PGRrecovery_main bind port 7778
2006-04-18 13:48:56 [25573] DEBUG:replicate_main() 8777 port bind OK
2006-04-18 13:48:56 [25573] DEBUG:cmdSts=N
2006-04-18 13:48:56 [25573] DEBUG:rlog=0
2006-04-18 13:48:56 [25573] DEBUG:port=0
2006-04-18 13:48:56 [25573] DEBUG:pid=0
2006-04-18 13:48:56 [25573] DEBUG:from_host=c04.cobalt.co.jp
2006-04-18 13:48:56 [25573] DEBUG:dbName=template1
2006-04-18 13:48:56 [25573] DEBUG:userName=pgcluster
2006-04-18 13:48:56 [25573] DEBUG:recieve sec=0
2006-04-18 13:48:56 [25573] DEBUG:recieve usec=0
2006-04-18 13:48:56 [25573] DEBUG:query_size=66
2006-04-18 13:48:56 [25573] DEBUG:request_id=0
2006-04-18 13:48:56 [25573] DEBUG:replicate_id=0
2006-04-18 13:48:56 [25573] DEBUG:query=SELECT PGR_SYSTEM_COMMAND_FUNCTION(1,'c04.cobalt.co.jp',8777,7778)
2006-04-18 13:48:56 [25573] DEBUG:PGRreplicate_packet_send():checking host namtest01 for creating threads
2006-04-18 13:48:56 [25573] DEBUG:PGRis_same_host():not same host
2006-04-18 13:48:56 [25573] DEBUG:[0] is not same host
2006-04-18 13:48:56 [25573] DEBUG:pgr_createConn():PQsetdbLogin host[10.1.1.220] port[5432] db[template1] user[pgcluster]
2006-04-18 13:48:56 [25573] DEBUG:pgr_createConn():Retry. h_errno is 0,reason is 'could not connect to server: Connection refused
Is the server running on host "10.1.1.220" and accepting
TCP/IP connections on port 5432?
'
2006-04-18 13:48:59 [25573] DEBUG:pgr_createConn():Retry. h_errno is 0,reason is 'could not connect to server: Connection refused
Is the server running on host "10.1.1.220" and accepting
TCP/IP connections on port 5432?
'
2006-04-18 13:49:02 [25573] DEBUG:pgr_createConn():Retry. h_errno is 0,reason is 'could not connect to server: Connection refused
Is the server running on host "10.1.1.220" and accepting
TCP/IP connections on port 5432?
'
2006-04-18 13:49:05 [25573] DEBUG:pgr_createConn():Retry. h_errno is 0,reason is ''
2006-04-18 13:49:08 [25573] DEBUG:pgr_createConn():PQsetdbLogin ok!!
2006-04-18 13:49:08 [25573] DEBUG:start thread_send_cluster()
2006-04-18 13:49:08 [25573] DEBUG:send_replicate_packet_to_server():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(8,1,0,1) )
2006-04-18 13:49:08 [25573] DEBUG:PGRreplicate_packet_send():checking host namtest02 for creating threads
2006-04-18 13:49:08 [25573] DEBUG:PGRis_same_host():not same host
2006-04-18 13:49:08 [25573] DEBUG:[1] is not same host
2006-04-18 13:49:08 [25573] DEBUG:pgr_createConn():PQsetdbLogin host[10.1.1.221] port[5432] db[template1] user[pgcluster]
2006-04-18 13:49:08 [25573] DEBUG:send_replicate_packet_to_server():sync_command returns SYSTEM_COMMAND
2006-04-18 13:49:08 [25573] DEBUG:send_replicate_packet_to_server():execute query(SELECT PGR_SYSTEM_COMMAND_FUNCTION(1,'c04.cobalt.co.jp',8777,7778))
2006-04-18 13:49:08 [25573] DEBUG:pgr_createConn():Retry. h_errno is 0,reason is 'could not connect to server: Connection refused
Is the server running on host "10.1.1.221" and accepting
TCP/IP connections on port 5432?
'
2006-04-18 13:49:08 [25573] DEBUG:send_replicate_packet_to_server():PQexec returns :SYSTEM_COMMAND
2006-04-18 13:49:08 [25573] DEBUG:deleteTransactionTbl():
2006-04-18 13:49:08 [25573] DEBUG:thread_send_cluster():return value from send_replicate_packet_to_server() is 0
2006-04-18 13:49:08 [25573] DEBUG:deleteTransactionTbl():
2006-04-18 13:49:08 [25573] DEBUG:thread_send_cluster():pthread_exit[0]
2006-04-18 13:49:11 [25573] DEBUG:pgr_createConn():Retry. h_errno is 0,reason is ''
2006-04-18 13:49:14 [25573] DEBUG:pgr_createConn():PQsetdbLogin ok!!
2006-04-18 13:49:14 [25573] DEBUG:start thread_send_cluster()
2006-04-18 13:49:14 [25573] DEBUG:send_replicate_packet_to_server():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(8,1,0,1) )
2006-04-18 13:49:14 [25573] DEBUG:send_replicate_packet_to_server():sync_command returns SYSTEM_COMMAND
2006-04-18 13:49:14 [25573] DEBUG:send_replicate_packet_to_server():execute query(SELECT PGR_SYSTEM_COMMAND_FUNCTION(1,'c04.cobalt.co.jp',8777,7778))
2006-04-18 13:49:14 [25573] DEBUG:send_replicate_packet_to_server():PQexec returns :SYSTEM_COMMAND
2006-04-18 13:49:14 [25573] DEBUG:deleteTransactionTbl():
2006-04-18 13:49:14 [25573] DEBUG:thread_send_cluster():return value from send_replicate_packet_to_server() is 0
2006-04-18 13:49:14 [25573] DEBUG:deleteTransactionTbl():
2006-04-18 13:49:14 [25573] DEBUG:thread_send_cluster():pthread_exit[1]
2006-04-18 13:49:14 [25573] DEBUG:thread_send_source was not executed
2006-04-18 13:51:26 [25704] DEBUG:cmdSts=Q
2006-04-18 13:51:26 [25704] DEBUG:cmdType=I
2006-04-18 13:51:26 [25704] DEBUG:rlog=0
2006-04-18 13:51:26 [25704] DEBUG:port=5432
2006-04-18 13:51:26 [25704] DEBUG:pid=31653
2006-04-18 13:51:26 [25704] DEBUG:from_host=127.0.0.1
2006-04-18 13:51:26 [25704] DEBUG:dbName=testdb
2006-04-18 13:51:26 [25704] DEBUG:userName=pgcluster
2006-04-18 13:51:26 [25704] DEBUG:recieve sec=1145335886
2006-04-18 13:51:26 [25704] DEBUG:recieve usec=976681
2006-04-18 13:51:26 [25704] DEBUG:query_size=35
2006-04-18 13:51:26 [25704] DEBUG:request_id=1
2006-04-18 13:51:26 [25704] DEBUG:replicate_id=0
2006-04-18 13:51:26 [25704] DEBUG:query=insert into test_tbl(f1) values(11)
2006-04-18 13:51:26 [25704] DEBUG:sem_lock [1] req
2006-04-18 13:51:26 [25704] DEBUG:sem_lock [1] got it
2006-04-18 13:51:26 [25704] DEBUG:PGRreplicate_packet_send():checking host namtest01 for creating threads
2006-04-18 13:51:26 [25704] DEBUG:[0] is not same host
2006-04-18 13:51:26 [25704] DEBUG:pgr_createConn():PQsetdbLogin host[10.1.1.220] port[5432] db[testdb] user[pgcluster]
2006-04-18 13:51:26 [25704] DEBUG:pgr_createConn():PQsetdbLogin ok!!
2006-04-18 13:51:26 [25704] DEBUG:start thread_send_cluster()
2006-04-18 13:51:26 [25704] DEBUG:send_replicate_packet_to_server():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1145335886,976681,15,1,2) )
2006-04-18 13:51:26 [25704] DEBUG:PGRreplicate_packet_send():checking host namtest02 for creating threads
2006-04-18 13:51:26 [25704] DEBUG:[1] is not same host
2006-04-18 13:51:26 [25704] DEBUG:pgr_createConn():PQsetdbLogin host[10.1.1.221] port[5432] db[testdb] user[pgcluster]
2006-04-18 13:51:26 [25704] DEBUG:send_replicate_packet_to_server():sync_command returns SYSTEM_COMMAND
2006-04-18 13:51:26 [25704] DEBUG:send_replicate_packet_to_server():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(8,2,0,1) )
2006-04-18 13:51:26 [25704] DEBUG:send_replicate_packet_to_server():sync_command returns SYSTEM_COMMAND
2006-04-18 13:51:26 [25704] DEBUG:send_replicate_packet_to_server():execute query(insert into test_tbl(f1) values(11))
2006-04-18 13:51:26 [25704] DEBUG:pgr_createConn():PQsetdbLogin ok!!
2006-04-18 13:51:26 [25704] DEBUG:start thread_send_cluster()
2006-04-18 13:51:26 [25704] DEBUG:send_replicate_packet_to_server():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1145335886,976681,15,1,2) )
2006-04-18 13:51:26 [25704] DEBUG:send_replicate_packet_to_server():PQexec returns :INSERT 0 1
2006-04-18 13:51:26 [25704] DEBUG:thread_send_cluster():return value from send_replicate_packet_to_server() is 0
2006-04-18 13:51:26 [25704] DEBUG:thread_send_cluster():pthread_exit[0]
2006-04-18 13:51:27 [25704] DEBUG:send_replicate_packet_to_server():sync_command returns SYSTEM_COMMAND
2006-04-18 13:51:27 [25704] DEBUG:send_replicate_packet_to_server():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(8,2,0,1) )
2006-04-18 13:51:27 [25704] DEBUG:send_replicate_packet_to_server():sync_command returns SYSTEM_COMMAND
2006-04-18 13:51:27 [25704] DEBUG:send_replicate_packet_to_server():execute query(insert into test_tbl(f1) values(11))
2006-04-18 13:51:27 [25704] DEBUG:send_replicate_packet_to_server():PQexec returns :INSERT 0 1
2006-04-18 13:51:27 [25704] DEBUG:thread_send_cluster():return value from send_replicate_packet_to_server() is 0
2006-04-18 13:51:27 [25704] DEBUG:thread_send_cluster():pthread_exit[1]
2006-04-18 13:51:27 [25704] DEBUG:thread_send_source was not executed
2006-04-18 13:51:27 [25704] DEBUG:sem_unlock[1]
2006-04-18 13:51:27 [25704] DEBUG:PGRdo_replicate():PGRreplicate_packet_send returns 0
2006-04-18 13:51:46 [25574] DEBUG:quick_exit:signo = 2
2006-04-18 13:51:46 [25577] DEBUG:quick_exit:signo = 2
2006-04-18 13:51:46 [25578] DEBUG:quick_exit:signo = 2
2006-04-18 13:51:46 [25704] DEBUG:quick_exit:signo = 2
巨大なメールになってしましましたが、
何か分かることがありましたらご教授願えないでしょうか。
よろしくお願いいたします。
pgcluster メーリングリストの案内