[pgcluster: 330] pgbenchが通らない

[KIKAWADA Mitsukuni/黄川田光国]

きかわだです。

ようやくクラスタ構成で動いたはよいものの、クラスタ構成上でpgbenchの
イニシャライズが10000タプルが終わったところで固まってしまいます。
同じような経験をされている方はいらっしゃいますでしょうか？

使用している環境は、

	SUN solaris 9
	pgcluster 1.0.7rc2

です。

関係ありそうな部分のログを抜き出して下記します。

・pgbenchのログ

bash-2.05$ pgbench -i -h 172.16.1.110 pgbench
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'branches_pkey' for table 'branches'
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'branches_pkey' for table 'branches'
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'tellers_pkey' for table 'tellers'
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'tellers_pkey' for table 'tellers'
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'accounts_pkey' for table 'accounts'
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'accounts_pkey' for table 'accounts'
creating tables...
10000 tuples done.


・pglbのログ

DEBUG(mystrlinelen): cp->len(3) cp->po(991)
DEBUG(mystrlinelen): strlength(3) bufsz(1024)
DEBUG(pool_read): read kind from backend C
DEBUG(pool_read_string): pool_read_string: readsize: 1024 readp: 0
DEBUG(pool_read_string): pool_read_string: buf:COPY: readlen: 6
DEBUG(mystrlen): strlength: 5
DEBUG(mystrlen): pending data saved: :ZINSERT 37131 1: length: 1 return data: :COPY: length: 5
DEBUG(pool_read): read kind from backend pending data Z len: 0 po: 1
DEBUG(pool_read): read kind from frontend Q(51)
DEBUG(pool_read_string): pool_read_string: readsize: 1024 readp: 0
DEBUG(pool_read_string): pool_read_string: buf:copy accounts from stdin: readlen: 25
DEBUG(mystrlen): strlength: 25
DEBUG(mystrlen): pool_read_string: string: :copy accounts from stdin:
DEBUG(mystrlen): pool_read_string: final read 25 string: :copy accounts from stdin:
DEBUG(mystrlen): pool_read_string: total result 25 string: :copy accounts from stdin:
DEBUG(PGRcreate_recv_socket): recovery wait

DEBUG(PGRget_child_status): load balance wait


・pgreplicateのログ

DEBUG(PGRreplicate_packet_send): useFlag[2]
DEBUG(PGRis_same_host): 5432 @ wt001112 return trigger
DEBUG(is_need_sync_time): sem_lock[1]
DEBUG(PGRreturn_result): PGRreturn_result[]
DEBUG(PGRreturn_result): 128 send
DEBUG(PGRreturn_result): status of PGRreturn_result[0]
DEBUG(PGRreturn_result): sem_lock[2]
DEBUG(PGRsem_lock): sem_unlock[1]
DEBUG(PGRreplicate_packet_send_each_server): except:5432 ＠ wt001112 host:5432 ＠ wt001113

DEBUG(PGRreplicate_packet_send_each_server): send replicate to:wt001113

DEBUG(PGRsend_replicate_packet_to_server): host(wt001113) : port(5432)
DEBUG(getTransactionTbl): hit !! transaction tbl host wt001113 db:pgbench pid:16743
DEBUG(getTransactionTbl): db:pgbench port:5432 user:postgres host:wt001113 query:
DEBUG(replicate_loop): wait replicate




よろしく御願いします。

-- 
黄川田光国 / KIKAWADA Mitsukuni <mitsukuni ＠ unixmagic.net>