[pgcluster: 929] psqlでクエリーが固まる

[takay]

高柳です。

psql から select クエリーを発行すると、レスポンスが返ってこないで
固まってしまう現象が出てます。
（PGCluster-1.1.2rc5 にしてから一度も成功してません。）

レプリケーションサーバのログには以下のように表示され、ストップします。

2006-10-24 18:49:18 [20272] DEBUG:PGRread_packet():PG_read_query returns BEGIN.
2006-10-24 18:49:18 [20272] DEBUG:PGRreturn_result():PGRreturn_result[1]
2006-10-24 18:49:18 [20272] DEBUG:PGRreturn_result():128 send
2006-10-24 18:49:18 [20272] DEBUG:PGRread_packet():PG_read_query returns BEGIN.
2006-10-24 18:49:18 [20272] DEBUG:PGRdo_replicate():query :: BEGIN
2006-10-24 18:49:18 [20272] DEBUG:cmdSts=Q
2006-10-24 18:49:18 [20272] DEBUG:cmdType=B
2006-10-24 18:49:18 [20272] DEBUG:rlog=0
2006-10-24 18:49:18 [20272] DEBUG:port=15432
2006-10-24 18:49:18 [20272] DEBUG:pid=20271
2006-10-24 18:49:18 [20272] DEBUG:from_host=192.168.1.11
2006-10-24 18:49:18 [20272] DEBUG:dbName=xxxxxxxxxx
2006-10-24 18:49:18 [20272] DEBUG:userName=xxxxx
2006-10-24 18:49:18 [20272] DEBUG:recieve sec=1161683358
2006-10-24 18:49:18 [20272] DEBUG:recieve usec=499573
2006-10-24 18:49:18 [20272] DEBUG:query_size=5
2006-10-24 18:49:18 [20272] DEBUG:request_id=1
2006-10-24 18:49:18 [20272] DEBUG:replicate_id=0
2006-10-24 18:49:18 [20272] DEBUG:recovery_status=0
2006-10-24 18:49:18 [20272] DEBUG:query=BEGIN
2006-10-24 18:49:18 [20272] DEBUG:sem_lock [1] req
2006-10-24 18:49:18 [20272] DEBUG:sem_lock [1] got it
2006-10-24 18:49:18 [20272] DEBUG:pgr_createConn():PQsetdbLogin host[192.168.2.111] port[15432] db[xxxxxxxxxxxxx] user[xxxxx]
2006-10-24 18:49:18 [20272] DEBUG:pgr_createConn():PQsetdbLogin ok!!
2006-10-24 18:49:18 [20272] DEBUG:pgr_createConn():PQsetdbLogin host[192.168.2.112] port[15432] db[xxxxxxxxxxxxx] user[xxxxx]
2006-10-24 18:49:18 [20275] DEBUG:start thread_send_cluster()
2006-10-24 18:49:18 [20275] DEBUG:send_replicate_packet_to_server():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1161683358,499573,7,1,3) )
2006-10-24 18:49:18 [20275] DEBUG:send_replicate_packet_to_server():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(8,3,0,1) )
2006-10-24 18:49:18 [20275] DEBUG:send_replicate_packet_to_server():sync_command returns SYSTEM_COMMAND
2006-10-24 18:49:18 [20275] DEBUG:send_replicate_packet_to_server():PQexec send :BEGIN
2006-10-24 18:49:18 [20275] DEBUG:send_replicate_packet_to_server():PQexec returns :BEGIN
2006-10-24 18:49:18 [20275] DEBUG:thread_send_cluster():return value from send_replicate_packet_to_server() is 0
2006-10-24 18:49:18 [20275] DEBUG:thread_send_cluster():pthread_exit[0]
2006-10-24 18:49:18 [20272] DEBUG:pgr_createConn():PQsetdbLogin ok!!
2006-10-24 18:49:18 [20276] DEBUG:start thread_send_cluster()
2006-10-24 18:49:18 [20276] DEBUG:send_replicate_packet_to_server():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1161683358,499573,7,1,3) )
2006-10-24 18:49:18 [20276] DEBUG:send_replicate_packet_to_server():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(8,3,0,1) )
2006-10-24 18:49:18 [20276] DEBUG:send_replicate_packet_to_server():sync_command returns SYSTEM_COMMAND
2006-10-24 18:49:18 [20276] DEBUG:send_replicate_packet_to_server():PQexec send :BEGIN
2006-10-24 18:49:18 [20276] DEBUG:send_replicate_packet_to_server():PQexec returns :BEGIN
2006-10-24 18:49:18 [20276] DEBUG:thread_send_cluster():return value from send_replicate_packet_to_server() is 0
2006-10-24 18:49:18 [20276] DEBUG:thread_send_cluster():pthread_exit[1]
2006-10-24 18:49:18 [20272] DEBUG:sem_unlock[1]

半日ほどずっと原因を探っていたのですが、わかりませんでした。
何かヒントになることでもかまいませんので、教えてください。
よろしくお願いします。


---
takay.ml ＠ gmail.com