[pgcluster: 910] 1.0.10 でロードバランサからcreateした際に反応が返ってきません
shimada_yuu ＠ tdc.co.jp
shimada_yuu ＠ tdc.co.jp
2006年 7月 26日 (水) 17:25:21 JST
御世話になっております 島田です
現在、ｐgcluster-1.0.10を使用しておりますが、
ロードバランサからテーブル等を追加しようとすると反応が返ってこない状況に
なっています。
一見すると固まったように見えます。
各クラスタサーバを見るとテーブル自体は出来ているようです。
ポート等も確認してみたのですが、どういった状況になっているかが不明になって
おります
お手数をお掛けいたしますが、ご確認の程宜しくお願い致します
冗長構成は3台になっています
t20030063.tdc.co.jp(10.20.60.57)
ロードバランサ
レプリケーションサーバ
t199702699.tdc.co.jp(10.20.60.51)
クラスタサーバA
t1997026-13.tdc.co.jp(10.20.60.55)
クラスタサーバB
各設定とログは以下の通りです
■クラスタサーバの設定
#============================================================
# Cluster DB Server configuration file
#------------------------------------------------------------
# file: cluster.conf
#------------------------------------------------------------
# This file controls:
# o which hosts & port are replication server
# o which port use for replication request to replication server
# o which command use for recovery function
#============================================================
#------------------------------------------------------------
# set Replication Server information
# o Host_Name : hostname
# o Port : connection for postmaster
# o Recovery_Port : connection for recovery process
#------------------------------------------------------------
<Replicate_Server_Info>
<Host_Name> t20030063.tdc.co.jp </Host_Name>
<Port> 8777 </Port>
<Recovery_Port> 7778 </Recovery_Port>
</Replicate_Server_Info>
#-------------------------------------------------------------
# set Cluster DB Server information
# o Recovery_Port : connection for recovery
# o Rsync_Path : path of rsync command
# o Rsync_Option : file transfer option for rsync
# o Rsync_Compress : use compression option for rsync
# [yes/no]. default : yes
# o When_Stand_Alone : When all replication servers fell,
# you can set up two kinds of permittion,
# "real_only" or "read_write".
#-------------------------------------------------------------
<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_write </When_Stand_Alone>
#-------------------------------------------------------------
# set partitional replicate control information
# set DB name and Table name to stop reprication
# o DB_Name : DB name
# o Table_Name : table name
#-------------------------------------------------------------
#<Not_Replicate_Info>
# <DB_Name> test_db </DB_Name>
# <Table_Name> log_table </Table_Name>
#</Not_Replicate_Info>
■pgreplicate.conf
#=============================================================
# PGReplicate configuration file
#-------------------------------------------------------------
# file: pgreplicate.conf
#-------------------------------------------------------------
# This file controls:
# o which hosts & port are cluster server
# o which port use for replication request from cluster server
#=============================================================
#
#-------------------------------------------------------------
# A setup of Cluster DB(s)
#
# o Host_Name : The host name of Cluster DB.
# -- please write a host name by FQDN.
# -- do not write IP address.
# o Port : The connection port with postmaster.
# o Recovery_Port : The connection port at the time of
# a recovery sequence .
#-------------------------------------------------------------
<Cluster_Server_Info>
<Host_Name> t199702699.tdc.co.jp </Host_Name>
<Port> 5432 </Port>
<Recovery_Port> 7779 </Recovery_Port>
</Cluster_Server_Info>
<Cluster_Server_Info>
<Host_Name> t1997026-13.tdc.co.jp </Host_Name>
<Port> 5432 </Port>
<Recovery_Port> 7779 </Recovery_Port>
</Cluster_Server_Info>
#
#-------------------------------------------------------------
# A setup of Load Balance Server
#
# o Host_Name : The host name of a load balance server.
# -- please write a host name by FQDN.
# -- do not write IP address.
# o Recovery_Port : The connection port at the time of
# a recovery sequence .
#-------------------------------------------------------------
<LoadBalance_Server_Info>
<Host_Name> t20030063.tdc.co.jp </Host_Name>
<Recovery_Port> 7778 </Recovery_Port>
</LoadBalance_Server_Info>
#
#------------------------------------------------------------
# A setup of the upper replication server for cascade connection.
#
# o Host_Name : The host name of Cluster DB.
# -- please write a host name by FQDN.
# -- do not write IP address.
# o Port : The connection port with postmaster.
# o Recovery_Port : The connection port at the time of
# a recovery sequence .
#------------------------------------------------------------
#<Replicate_Server_Info>
# <Host_Name> t20030063.tdc.co.jp </Host_Name>
# <Port> 7778 </Port>
# <Recovery_Port> 8102 </Recovery_Port>
#</Replicate_Server_Info>
#
#-------------------------------------------------------------
# A setup of a replication server
#
# o Replicate_Port : connection for replication
# o Recovery_Port : connection for recovery
# o Response_mode : timing which returns a response
# normal -- return result of DB which received the query
# reliable -- return result after waiting for response of
# all Cluster DBs.
# o Use_Replication_Log : use replication log
# [yes/no]. default : no
# o RLOG_Port : connection for replication log
#-------------------------------------------------------------
<Replication_Port> 8777 </Replication_Port>
<Recovery_Port> 7778 </Recovery_Port>
<Response_Mode> normal </Response_Mode>
<Use_Replication_Log> yes </Use_Replication_Log>
<RLOG_Port> 8301 </RLOG_Port>
■pglb.conf
#============================================================
# Load Balance Server configuration file
#-------------------------------------------------------------
# file: pglb.conf
#-------------------------------------------------------------
# This file controls:
# o which hosts are db cluster server
# o which port use connect to db cluster server
# o how many connections are allowed on each DB server
#============================================================
#-------------------------------------------------------------
# set cluster DB server information
# o Host_Name : hostname
# o Port : connection for postmaster
# o Max_Connection : maximun number of connection to
postmaster
#-------------------------------------------------------------
<Cluster_Server_Info>
<Host_Name> t1997026-13.tdc.co.jp </Host_Name>
<Port> 5432 </Port>
<Max_Connect> 30 </Max_Connect>
</Cluster_Server_Info>
<Cluster_Server_Info>
<Host_Name> T199702699.tdc.co.jp </Host_Name>
<Port> 5432 </Port>
<Max_Connect> 30 </Max_Connect>
</Cluster_Server_Info>
#-------------------------------------------------------------
# set Load Balance server information
# o Backend_Socket_Dir : Unix domain socket path for the
backend
# o Receive_Port : connection from client
# o Recovery_Port : connection for recovery process
# o Max_Cluster_Num : maximun number of cluster DB servers
# o Use_Connection_Pooling : use connection pool [yes/no]
# o Max_Pool_Each_Server : number of pool connections/DB
server
#-------------------------------------------------------------
<Backend_Socket_Dir> /tmp </Backend_Socket_Dir>
<Receive_Port> 5432 </Receive_Port>
<Recovery_Port> 7779 </Recovery_Port>
<Max_Cluster_Num> 128 </Max_Cluster_Num>
<Use_Connection_Pooling> no </Use_Connection_Pooling>
[postgres ＠ t20030063 postgres]$ pgreplicate -D /usr/local/pgsql/etc -vn
2006-07-26 16:55:48 [5419] DEBUG:PGR_Get_Conf_Data ok
2006-07-26 16:55:48 [5419] DEBUG:LoadBalanceTbl allocate ok
2006-07-26 16:55:48 [5419] DEBUG:PGRset_Conf_Data():CascadeTbl shmget ok
2006-07-26 16:55:48 [5419] DEBUG:PGRset_Conf_Data():CascadeTbl shmat ok
2006-07-26 16:55:48 [5419] DEBUG:PGRset_Conf_Data():CascadeInf shmget ok
2006-07-26 16:55:48 [5419] DEBUG:PGRset_Conf_Data():CascadeInf shmat ok
2006-07-26 16:55:48 [5419] DEBUG:PGRset_Conf_Data():CommitLog shmget ok
2006-07-26 16:55:48 [5419] DEBUG:PGRset_Conf_Data():Commit_Log_Tbl shmat ok
2006-07-26 16:55:48 [5419] DEBUG:PGRset_Conf_Data():RLog Memory Allocation
ok
2006-07-26 16:55:48 [5419] DEBUG:registering
(key,value)=(Host_Name,t199702699.tdc.co.jp)
2006-07-26 16:55:48 [5419] DEBUG:registering hostname t199702699.tdc.co.jp
2006-07-26 16:55:48 [5419] DEBUG:resolved name is 10.20.60.51
2006-07-26 16:55:48 [5419] DEBUG:registering (key,value)=(Port,5432)
2006-07-26 16:55:48 [5419] DEBUG:registering
(key,value)=(Recovery_Port,7779)
2006-07-26 16:55:48 [5419] DEBUG:registering
(key,value)=(Host_Name,t1997026-13.tdc.co.jp)
2006-07-26 16:55:48 [5419] DEBUG:registering hostname t1997026-13.tdc.co.jp
2006-07-26 16:55:48 [5419] DEBUG:resolved name is 10.20.60.55
2006-07-26 16:55:48 [5419] DEBUG:registering (key,value)=(Port,5432)
2006-07-26 16:55:48 [5419] DEBUG:registering
(key,value)=(Recovery_Port,7779)
2006-07-26 16:55:48 [5419] DEBUG:registering
(key,value)=(Host_Name,t20030063.tdc.co.jp)
2006-07-26 16:55:48 [5419] DEBUG:registering
(key,value)=(Recovery_Port,7778)
2006-07-26 16:55:48 [5419] DEBUG:registering
(key,value)=(Replication_Port,8777)
2006-07-26 16:55:48 [5419] DEBUG:registering
(key,value)=(Recovery_Port,7778)
2006-07-26 16:55:48 [5419] DEBUG:registering
(key,value)=(Response_Mode,normal)
2006-07-26 16:55:48 [5419] DEBUG:registering
(key,value)=(Use_Replication_Log,yes)
2006-07-26 16:55:48 [5419] DEBUG:registering (key,value)=(RLOG_Port,8301)
2006-07-26 16:55:48 [5419] DEBUG:PGRset_Conf_Data():HostTbl shmget ok
2006-07-26 16:55:48 [5419] DEBUG:PGRset_Conf_Data():HostTbl shmat ok
2006-07-26 16:55:48 [5419] DEBUG:Use Replication Log. Start PGR_RLog_Main()
2006-07-26 16:55:48 [5421] DEBUG:PGRrecovery_main():PGRrecovery_main bind
port 7778
2006-07-26 16:55:48 [5419] DEBUG:replicate_main():entering replicate_main
2006-07-26 16:55:48 [5419] DEBUG:replicate_main() 8777 port bind OK
2006-07-26 16:55:48 [5419] DEBUG:cmdSts=N
2006-07-26 16:55:48 [5419] DEBUG:rlog=0
2006-07-26 16:55:48 [5419] DEBUG:port=0
2006-07-26 16:55:48 [5419] DEBUG:pid=0
2006-07-26 16:55:48 [5419] DEBUG:from_host=t20030063.tdc.co.jp
2006-07-26 16:55:48 [5419] DEBUG:dbName=template1
2006-07-26 16:55:48 [5419] DEBUG:userName=postgres
2006-07-26 16:55:48 [5419] DEBUG:recieve sec=0
2006-07-26 16:55:48 [5419] DEBUG:recieve usec=0
2006-07-26 16:55:48 [5419] DEBUG:query_size=69
2006-07-26 16:55:48 [5419] DEBUG:request_id=0
2006-07-26 16:55:48 [5419] DEBUG:replicate_id=0
2006-07-26 16:55:48 [5419] DEBUG:query=SELECT
PGR_SYSTEM_COMMAND_FUNCTION(1,'t20030063.tdc.co.jp',8777,7778)
2006-07-26 16:55:48 [5419] DEBUG:PGRreplicate_packet_send():checking host
t199702699.tdc.co.jp for creating threads
2006-07-26 16:55:48 [5419] DEBUG:PGRis_same_host():not same host
2006-07-26 16:55:48 [5419] DEBUG:pgr_createConn():PQsetdbLogin
host[10.20.60.51] port[5432] db[template1] user[postgres]
addr.sun_path[/usr/local/pgsql/etc/.s.PGRLOG.8301]
2006-07-26 16:55:48 [5419] DEBUG:pgr_createConn():Retry. h_errno is
0,reason is 'could not connect to server: Connection refused
Is the server running on host 10.20.60.51 and accepting
TCP/IP connections on port 5432?
'
Replicateion_Log->RLog_Sock_Path[/usr/local/pgsql/etc/.s.PGRLOG.8301]
2006-07-26 16:55:48 [5419] DEBUG:pgr_createConn():Retry. h_errno is
0,reason is 'could not connect to server: Connection refused
Is the server running on host 10.20.60.51 and accepting
TCP/IP connections on port 5432?
'
2006-07-26 16:55:48 [5419] DEBUG:pgr_createConn():Retry. h_errno is
0,reason is 'could not connect to server: Connection refused
Is the server running on host 10.20.60.51 and accepting
TCP/IP connections on port 5432?
'
2006-07-26 16:55:48 [5419] DEBUG:pgr_createConn():Retry. h_errno is
0,reason is 'could not connect to server: Connection refused
Is the server running on host 10.20.60.51 and accepting
TCP/IP connections on port 5432?
'
2006-07-26 16:55:48 [5419] DEBUG:setTransactionTbl(): 5432 ＠ 10.20.60.51 is
not ready
2006-07-26 16:55:48 [5419]
DEBUG:PGRreplicate_packet_send():setTransactionTbl failed
2006-07-26 16:55:48 [5419] DEBUG:PGRreplicate_packet_send():checking host
t1997026-13.tdc.co.jp for creating threads
2006-07-26 16:55:48 [5419] DEBUG:PGRis_same_host():not same host
2006-07-26 16:55:48 [5419] DEBUG:pgr_createConn():PQsetdbLogin
host[10.20.60.55] port[5432] db[template1] user[postgres]
2006-07-26 16:55:48 [5419] DEBUG:pgr_createConn():Retry. h_errno is
0,reason is 'could not connect to server: Connection refused
Is the server running on host 10.20.60.55 and accepting
TCP/IP connections on port 5432?
'
2006-07-26 16:55:48 [5419] DEBUG:pgr_createConn():Retry. h_errno is
0,reason is 'could not connect to server: Connection refused
Is the server running on host 10.20.60.55 and accepting
TCP/IP connections on port 5432?
'
2006-07-26 16:55:48 [5419] DEBUG:pgr_createConn():Retry. h_errno is
0,reason is 'could not connect to server: Connection refused
Is the server running on host 10.20.60.55 and accepting
TCP/IP connections on port 5432?
'
2006-07-26 16:55:48 [5419] DEBUG:pgr_createConn():Retry. h_errno is
0,reason is 'could not connect to server: Connection refused
Is the server running on host 10.20.60.55 and accepting
TCP/IP connections on port 5432?
'
2006-07-26 16:55:48 [5419] DEBUG:setTransactionTbl(): 5432 ＠ 10.20.60.55 is
not ready
2006-07-26 16:55:48 [5419]
DEBUG:PGRreplicate_packet_send():setTransactionTbl failed
2006-07-26 16:55:48 [5419] DEBUG:thread_send_source was not executed
2006-07-26 17:01:06 [5495] DEBUG:PGRread_packet():PG_read_query returns
CREATE TABLE testtab (
id INT,
name VARCHAR(255),
CONSTRAINT test_pk PRIMARY KEY (id)).
2006-07-26 17:01:06 [5495] DEBUG:PGRreturn_result():PGRreturn_result[1]
2006-07-26 17:01:06 [5495] DEBUG:PGRreturn_result():128 send
2006-07-26 17:01:06 [5495] DEBUG:PGRread_packet():PG_read_query returns
CREATE TABLE testtab (
id INT,
name VARCHAR(255),
CONSTRAINT test_pk PRIMARY KEY (id)).
2006-07-26 17:01:06 [5495] DEBUG:PGRdo_replicate():query :: CREATE TABLE
testtab (
id INT,
name VARCHAR(255),
CONSTRAINT test_pk PRIMARY KEY (id))
2006-07-26 17:01:06 [5495] DEBUG:cmdSts=Q
2006-07-26 17:01:06 [5495] DEBUG:cmdType=O
2006-07-26 17:01:06 [5495] DEBUG:rlog=0
2006-07-26 17:01:06 [5495] DEBUG:port=5432
2006-07-26 17:01:06 [5495] DEBUG:pid=13707
2006-07-26 17:01:06 [5495] DEBUG:from_host=127.0.0.1
2006-07-26 17:01:06 [5495] DEBUG:dbName=test
2006-07-26 17:01:06 [5495] DEBUG:userName=postgres
2006-07-26 17:01:06 [5495] DEBUG:recieve sec=1153900866
2006-07-26 17:01:06 [5495] DEBUG:recieve usec=248937
2006-07-26 17:01:06 [5495] DEBUG:query_size=94
2006-07-26 17:01:06 [5495] DEBUG:request_id=1
2006-07-26 17:01:06 [5495] DEBUG:replicate_id=0
2006-07-26 17:01:06 [5495] DEBUG:query=CREATE TABLE testtab (
id INT,
name VARCHAR(255),
CONSTRAINT test_pk PRIMARY KEY (id))
2006-07-26 17:01:06 [5495] DEBUG:sem_lock [1] req
2006-07-26 17:01:06 [5495] DEBUG:sem_lock [1] got it
2006-07-26 17:01:06 [5495] DEBUG:PGRreplicate_packet_send():checking host
t199702699.tdc.co.jp for creating threads
2006-07-26 17:01:06 [5495] DEBUG:pgr_createConn():PQsetdbLogin
host[10.20.60.51] port[5432] db[test] user[postgres]
2006-07-26 17:01:06 [5495] DEBUG:pgr_createConn():PQsetdbLogin ok!!
2006-07-26 17:01:06 [5495] DEBUG:start thread_send_cluster()
2006-07-26 17:01:06 [5495] DEBUG:entering send_replicate_packet_to_server()
2006-07-26 17:01:06 [5495]
DEBUG:send_replicate_packet_to_server():sync_command(SELECT
PGR_SYSTEM_COMMAND_FUNCTION(3,1153900866,248937,0,1,2) )
2006-07-26 17:01:06 [5495] DEBUG:PGRreplicate_packet_send():checking host
t1997026-13.tdc.co.jp for creating threads
2006-07-26 17:01:06 [5495] DEBUG:pgr_createConn():PQsetdbLogin
host[10.20.60.55] port[5432] db[test] user[postgres]
2006-07-26 17:01:06 [5495] DEBUG:send_replicate_packet_to_server()
sync_command returns SYSTEM_COMMAND
2006-07-26 17:01:06 [5495]
DEBUG:send_replicate_packet_to_server():sync_command(SELECT
PGR_SYSTEM_COMMAND_FUNCTION(8,2,0,1) )
2006-07-26 17:01:06 [5495]
DEBUG:send_replicate_packet_to_server():sync_command returns SYSTEM_COMMAND
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'test_pk'
for table 'testtab'
2006-07-26 17:01:06 [5495] DEBUG:pgr_createConn():PQsetdbLogin ok!!
2006-07-26 17:01:06 [5495] DEBUG:start thread_send_cluster()
2006-07-26 17:01:06 [5495] DEBUG:entering send_replicate_packet_to_server()
2006-07-26 17:01:06 [5495]
DEBUG:send_replicate_packet_to_server():sync_command(SELECT
PGR_SYSTEM_COMMAND_FUNCTION(3,1153900866,248937,0,1,2) )
2006-07-26 17:01:06 [5495] DEBUG:send_replicate_packet_to_server()
sync_command returns SYSTEM_COMMAND
2006-07-26 17:01:06 [5495]
DEBUG:send_replicate_packet_to_server():sync_command(SELECT
PGR_SYSTEM_COMMAND_FUNCTION(8,2,0,1) )
2006-07-26 17:01:06 [5495]
DEBUG:send_replicate_packet_to_server():sync_command returns SYSTEM_COMMAND
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'test_pk'
for table 'testtab'
2006-07-26 17:01:06 [5495] DEBUG:send_replicate_packet_to_server():PQexec
send :CREATE TABLE testtab (
id INT,
name VARCHAR(255),
CONSTRAINT test_pk PRIMARY KEY (id))
2006-07-26 17:01:06 [5495] DEBUG:send_replicate_packet_to_server():PQexec
returns :CREATE TABLE
2006-07-26 17:01:06 [5495] DEBUG:thread_send_cluster():return value from
send_replicate_packet_to_server() is 0
2006-07-26 17:01:06 [5495] DEBUG:thread_send_cluster():pthread_exit[0]
2006-07-26 17:01:06 [5495] DEBUG:send_replicate_packet_to_server():PQexec
send :CREATE TABLE testtab (
id INT,
name VARCHAR(255),
CONSTRAINT test_pk PRIMARY KEY (id))
2006-07-26 17:01:06 [5495] DEBUG:send_replicate_packet_to_server():PQexec
returns :CREATE TABLE
2006-07-26 17:01:06 [5495] DEBUG:thread_send_cluster():return value from
send_replicate_packet_to_server() is 0
2006-07-26 17:01:06 [5495] DEBUG:thread_send_cluster():pthread_exit[1]
2006-07-26 17:01:06 [5495] DEBUG:thread_send_source was not executed
2006-07-26 17:01:06 [5495] DEBUG:sem_unlock[1]
2006-07-26 17:01:06 [5495] DEBUG:PGRdo_replicate():PGRreplicate_packet_send
returns 0
[postgres ＠ t20030063 postgres]$ pglb -D /usr/local/pgsql/etc -vn
2006-07-26 16:58:52 [5470]
DEBUG:PGRset_status_on_cluster_tbl():host:t1997026-13.tdc.co.jp port:5432
max:30 use:0 status2
2006-07-26 16:58:52 [5470]
DEBUG:PGRset_status_on_cluster_tbl():host:T199702699.tdc.co.jp port:5432
max:30 use:0 status2
2006-07-26 16:58:52 [5470] DEBUG:init_pglb():Child_Tbl size is[46440]
2006-07-26 16:59:18 [5470] DEBUG:PGRscan_cluster:2 ClusterDB can be used
2006-07-26 16:59:18 [5470] DEBUG:PGRscan_cluster:t1997026-13.tdc.co.jp
[5432],useFlag->2 max->30 use_num->0
2006-07-26 16:59:18 [5476] DEBUG:PGRdo_child():I am 5476
2006-07-26 16:59:18 [5476] DEBUG:do_accept():I am 5476 accept fd 6
2006-07-26 16:59:18 [5476] DEBUG:read_startup_packet():Protocol Major: 2
Minor: 0 database: template1 user: postgres
2006-07-26 16:59:18 [5476] DEBUG:pool_process_query():read kind from
backend pending data Z len: 0 po: 0
2006-07-26 16:59:18 [5476] DEBUG:ProcessFrontendResponse():read kind from
frontend Q(51)
2006-07-26 16:59:18 [5476] DEBUG:pool_read_string: read all from pending
data. po:0 len:0
2006-07-26 16:59:18 [5476] DEBUG:Query(): begin; select
getdatabaseencoding(); commit
2006-07-26 16:59:18 [5476] DEBUG:pool_process_query():read kind from
backend C
2006-07-26 16:59:18 [5476] DEBUG:pool_read_string: read all from pending
data. po:6 len:69
2006-07-26 16:59:18 [5476] DEBUG:CompleteCommandResponse(): string: "BEGIN"
2006-07-26 16:59:18 [5476] DEBUG:pool_process_query():read kind from
backend pending data P len: 68 po: 7
2006-07-26 16:59:18 [5476] DEBUG:pool_read_string: read all from pending
data. po:13 len:62
2006-07-26 16:59:18 [5476] DEBUG:pool_process_query():read kind from
backend pending data T len: 61 po: 14
2006-07-26 16:59:18 [5476] DEBUG:pool_read_string: read all from pending
data. po:36 len:39
2006-07-26 16:59:18 [5476] DEBUG:RowDescription(): field size:64
2006-07-26 16:59:18 [5476] DEBUG:pool_process_query():read kind from
backend pending data D len: 28 po: 47
2006-07-26 16:59:18 [5476] DEBUG:AsciiRow(): len: 6 data: EUC_JP
2006-07-26 16:59:18 [5476] DEBUG:pool_process_query():read kind from
backend pending data C len: 16 po: 59
2006-07-26 16:59:18 [5476] DEBUG:pool_read_string: read all from pending
data. po:66 len:9
2006-07-26 16:59:18 [5476] DEBUG:CompleteCommandResponse(): string:
"SELECT"
2006-07-26 16:59:18 [5476] DEBUG:pool_process_query():read kind from
backend pending data C len: 8 po: 67
2006-07-26 16:59:18 [5476] DEBUG:pool_read_string: read all from pending
data. po:74 len:1
2006-07-26 16:59:18 [5476] DEBUG:CompleteCommandResponse(): string:
"COMMIT"
2006-07-26 16:59:18 [5476] DEBUG:pool_process_query():read kind from
backend pending data Z len: 0 po: 0
2006-07-26 16:59:18 [5476] DEBUG:ProcessFrontendResponse():read kind from
frontend Q(51)
2006-07-26 16:59:18 [5476] DEBUG:pool_read_string: read all from pending
data. po:0 len:0
2006-07-26 16:59:18 [5476] DEBUG:Query(): SELECT d.datname as "Name",
u.usename as "Owner",
pg_catalog.pg_encoding_to_char(d.encoding) as "Encoding"
FROM pg_catalog.pg_database d
LEFT JOIN pg_catalog.pg_user u ON d.datdba = u.usesysid
ORDER BY 1;
2006-07-26 16:59:18 [5476] DEBUG:pool_process_query():read kind from
backend P
2006-07-26 16:59:18 [5476] DEBUG:pool_read_string: read all from pending
data. po:6 len:168
2006-07-26 16:59:18 [5476] DEBUG:pool_process_query():read kind from
backend pending data T len: 167 po: 7
2006-07-26 16:59:18 [5476] DEBUG:pool_read_string: read all from pending
data. po:14 len:160
2006-07-26 16:59:18 [5476] DEBUG:RowDescription(): field size:64
2006-07-26 16:59:18 [5476] DEBUG:pool_read_string: read all from pending
data. po:30 len:144
2006-07-26 16:59:18 [5476] DEBUG:RowDescription(): field size:64
2006-07-26 16:59:18 [5476] DEBUG:pool_read_string: read all from pending
data. po:49 len:125
2006-07-26 16:59:18 [5476] DEBUG:RowDescription(): field size:64
2006-07-26 16:59:18 [5476] DEBUG:pool_process_query():read kind from
backend pending data D len: 114 po: 60
2006-07-26 16:59:18 [5476] DEBUG:AsciiRow(): len: 9 data: template0
2006-07-26 16:59:18 [5476] DEBUG:AsciiRow(): len: 8 data: postgres
2006-07-26 16:59:18 [5476] DEBUG:AsciiRow(): len: 6 data: EUC_JP
2006-07-26 16:59:18 [5476] DEBUG:pool_process_query():read kind from
backend pending data D len: 77 po: 97
2006-07-26 16:59:18 [5476] DEBUG:AsciiRow(): len: 9 data: template1
2006-07-26 16:59:18 [5476] DEBUG:AsciiRow(): len: 8 data: postgres
2006-07-26 16:59:18 [5476] DEBUG:AsciiRow(): len: 6 data: EUC_JP
2006-07-26 16:59:18 [5476] DEBUG:pool_process_query():read kind from
backend pending data D len: 40 po: 134
2006-07-26 16:59:18 [5476] DEBUG:AsciiRow(): len: 4 data: test
2006-07-26 16:59:18 [5476] DEBUG:AsciiRow(): len: 8 data: postgres
2006-07-26 16:59:18 [5476] DEBUG:AsciiRow(): len: 6 data: EUC_JP
2006-07-26 16:59:18 [5476] DEBUG:pool_process_query():read kind from
backend pending data C len: 8 po: 166
2006-07-26 16:59:18 [5476] DEBUG:pool_read_string: read all from pending
data. po:173 len:1
2006-07-26 16:59:18 [5476] DEBUG:CompleteCommandResponse(): string:
"SELECT"
2006-07-26 16:59:18 [5476] DEBUG:pool_process_query():read kind from
backend pending data Z len: 0 po: 0
2006-07-26 16:59:18 [5476] DEBUG:ProcessFrontendResponse():read kind from
frontend X(58)
2006-07-26 16:59:59 [5470] DEBUG:PGRscan_cluster:2 ClusterDB can be used
2006-07-26 16:59:59 [5470] DEBUG:PGRscan_cluster:t1997026-13.tdc.co.jp
[5432],useFlag->2 max->30 use_num->0
2006-07-26 16:59:59 [5484] DEBUG:PGRdo_child():I am 5484
2006-07-26 16:59:59 [5484] DEBUG:do_accept():I am 5484 accept fd 6
2006-07-26 16:59:59 [5484] DEBUG:read_startup_packet():Protocol Major: 2
Minor: 0 database: template1 user: postgres
2006-07-26 16:59:59 [5484] DEBUG:pool_process_query():read kind from
backend pending data Z len: 0 po: 0
2006-07-26 16:59:59 [5484] DEBUG:ProcessFrontendResponse():read kind from
frontend Q(51)
2006-07-26 16:59:59 [5484] DEBUG:pool_read_string: read all from pending
data. po:0 len:0
2006-07-26 16:59:59 [5484] DEBUG:Query(): begin; select
getdatabaseencoding(); commit
2006-07-26 16:59:59 [5484] DEBUG:pool_process_query():read kind from
backend C
2006-07-26 16:59:59 [5484] DEBUG:pool_read_string: read all from pending
data. po:6 len:69
2006-07-26 16:59:59 [5484] DEBUG:CompleteCommandResponse(): string: "BEGIN"
2006-07-26 16:59:59 [5484] DEBUG:pool_process_query():read kind from
backend pending data P len: 68 po: 7
2006-07-26 16:59:59 [5484] DEBUG:pool_read_string: read all from pending
data. po:13 len:62
2006-07-26 16:59:59 [5484] DEBUG:pool_process_query():read kind from
backend pending data T len: 61 po: 14
2006-07-26 16:59:59 [5484] DEBUG:pool_read_string: read all from pending
data. po:36 len:39
2006-07-26 16:59:59 [5484] DEBUG:RowDescription(): field size:64
2006-07-26 16:59:59 [5484] DEBUG:pool_process_query():read kind from
backend pending data D len: 28 po: 47
2006-07-26 16:59:59 [5484] DEBUG:AsciiRow(): len: 6 data: EUC_JP
2006-07-26 16:59:59 [5484] DEBUG:pool_process_query():read kind from
backend pending data C len: 16 po: 59
2006-07-26 16:59:59 [5484] DEBUG:pool_read_string: read all from pending
data. po:66 len:9
2006-07-26 16:59:59 [5484] DEBUG:CompleteCommandResponse(): string:
"SELECT"
2006-07-26 16:59:59 [5484] DEBUG:pool_process_query():read kind from
backend pending data C len: 8 po: 67
2006-07-26 16:59:59 [5484] DEBUG:pool_read_string: read all from pending
data. po:74 len:1
2006-07-26 16:59:59 [5484] DEBUG:CompleteCommandResponse(): string:
"COMMIT"
2006-07-26 16:59:59 [5484] DEBUG:pool_process_query():read kind from
backend pending data Z len: 0 po: 0
2006-07-26 16:59:59 [5484] DEBUG:ProcessFrontendResponse():read kind from
frontend Q(51)
2006-07-26 16:59:59 [5484] DEBUG:pool_read_string: read all from pending
data. po:0 len:0
2006-07-26 16:59:59 [5484] DEBUG:Query(): SELECT d.datname as "Name",
u.usename as "Owner",
pg_catalog.pg_encoding_to_char(d.encoding) as "Encoding"
FROM pg_catalog.pg_database d
LEFT JOIN pg_catalog.pg_user u ON d.datdba = u.usesysid
ORDER BY 1;
2006-07-26 16:59:59 [5484] DEBUG:pool_process_query():read kind from
backend P
2006-07-26 16:59:59 [5484] DEBUG:pool_read_string: read all from pending
data. po:6 len:168
2006-07-26 16:59:59 [5484] DEBUG:pool_process_query():read kind from
backend pending data T len: 167 po: 7
2006-07-26 16:59:59 [5484] DEBUG:pool_read_string: read all from pending
data. po:14 len:160
2006-07-26 16:59:59 [5484] DEBUG:RowDescription(): field size:64
2006-07-26 16:59:59 [5484] DEBUG:pool_read_string: read all from pending
data. po:30 len:144
2006-07-26 16:59:59 [5484] DEBUG:RowDescription(): field size:64
2006-07-26 16:59:59 [5484] DEBUG:pool_read_string: read all from pending
data. po:49 len:125
2006-07-26 16:59:59 [5484] DEBUG:RowDescription(): field size:64
2006-07-26 16:59:59 [5484] DEBUG:pool_process_query():read kind from
backend pending data D len: 114 po: 60
2006-07-26 16:59:59 [5484] DEBUG:AsciiRow(): len: 9 data: template0
2006-07-26 16:59:59 [5484] DEBUG:AsciiRow(): len: 8 data: postgres
2006-07-26 16:59:59 [5484] DEBUG:AsciiRow(): len: 6 data: EUC_JP
2006-07-26 16:59:59 [5484] DEBUG:pool_process_query():read kind from
backend pending data D len: 77 po: 97
2006-07-26 16:59:59 [5484] DEBUG:AsciiRow(): len: 9 data: template1
2006-07-26 16:59:59 [5484] DEBUG:AsciiRow(): len: 8 data: postgres
2006-07-26 16:59:59 [5484] DEBUG:AsciiRow(): len: 6 data: EUC_JP
2006-07-26 16:59:59 [5484] DEBUG:pool_process_query():read kind from
backend pending data D len: 40 po: 134
2006-07-26 16:59:59 [5484] DEBUG:AsciiRow(): len: 4 data: test
2006-07-26 16:59:59 [5484] DEBUG:AsciiRow(): len: 8 data: postgres
2006-07-26 16:59:59 [5484] DEBUG:AsciiRow(): len: 6 data: EUC_JP
2006-07-26 16:59:59 [5484] DEBUG:pool_process_query():read kind from
backend pending data C len: 8 po: 166
2006-07-26 16:59:59 [5484] DEBUG:pool_read_string: read all from pending
data. po:173 len:1
2006-07-26 16:59:59 [5484] DEBUG:CompleteCommandResponse(): string:
"SELECT"
2006-07-26 16:59:59 [5484] DEBUG:pool_process_query():read kind from
backend pending data Z len: 0 po: 0
2006-07-26 16:59:59 [5484] DEBUG:ProcessFrontendResponse():read kind from
frontend X(58)
2006-07-26 17:00:28 [5470] DEBUG:PGRscan_cluster:2 ClusterDB can be used
2006-07-26 17:00:28 [5470] DEBUG:PGRscan_cluster:t1997026-13.tdc.co.jp
[5432],useFlag->2 max->30 use_num->0
2006-07-26 17:00:28 [5489] DEBUG:PGRdo_child():I am 5489
2006-07-26 17:00:28 [5489] DEBUG:do_accept():I am 5489 accept fd 6
2006-07-26 17:00:28 [5489] DEBUG:read_startup_packet():Protocol Major: 2
Minor: 0 database: test user: postgres
2006-07-26 17:00:28 [5489] DEBUG:pool_process_query():read kind from
backend pending data Z len: 0 po: 0
2006-07-26 17:00:28 [5489] DEBUG:ProcessFrontendResponse():read kind from
frontend Q(51)
2006-07-26 17:00:28 [5489] DEBUG:pool_read_string: read all from pending
data. po:0 len:0
2006-07-26 17:00:28 [5489] DEBUG:Query(): begin; select
getdatabaseencoding(); commit
2006-07-26 17:00:28 [5489] DEBUG:pool_process_query():read kind from
backend C
2006-07-26 17:00:28 [5489] DEBUG:pool_read_string: read all from pending
data. po:6 len:69
2006-07-26 17:00:28 [5489] DEBUG:CompleteCommandResponse(): string: "BEGIN"
2006-07-26 17:00:28 [5489] DEBUG:pool_process_query():read kind from
backend pending data P len: 68 po: 7
2006-07-26 17:00:28 [5489] DEBUG:pool_read_string: read all from pending
data. po:13 len:62
2006-07-26 17:00:28 [5489] DEBUG:pool_process_query():read kind from
backend pending data T len: 61 po: 14
2006-07-26 17:00:28 [5489] DEBUG:pool_read_string: read all from pending
data. po:36 len:39
2006-07-26 17:00:28 [5489] DEBUG:RowDescription(): field size:64
2006-07-26 17:00:28 [5489] DEBUG:pool_process_query():read kind from
backend pending data D len: 28 po: 47
2006-07-26 17:00:28 [5489] DEBUG:AsciiRow(): len: 6 data: EUC_JP
2006-07-26 17:00:28 [5489] DEBUG:pool_process_query():read kind from
backend pending data C len: 16 po: 59
2006-07-26 17:00:28 [5489] DEBUG:pool_read_string: read all from pending
data. po:66 len:9
2006-07-26 17:00:28 [5489] DEBUG:CompleteCommandResponse(): string:
"SELECT"
2006-07-26 17:00:28 [5489] DEBUG:pool_process_query():read kind from
backend pending data C len: 8 po: 67
2006-07-26 17:00:28 [5489] DEBUG:pool_read_string: read all from pending
data. po:74 len:1
2006-07-26 17:00:28 [5489] DEBUG:CompleteCommandResponse(): string:
"COMMIT"
2006-07-26 17:00:28 [5489] DEBUG:pool_process_query():read kind from
backend pending data Z len: 0 po: 0
2006-07-26 17:00:28 [5489] DEBUG:ProcessFrontendResponse():read kind from
frontend Q(51)
2006-07-26 17:00:28 [5489] DEBUG:pool_read_string: read all from pending
data. po:0 len:0
2006-07-26 17:00:28 [5489] DEBUG:Query(): BEGIN; SELECT usesuper FROM
pg_catalog.pg_user WHERE usename = 'postgres'; COMMIT
2006-07-26 17:00:29 [5489] DEBUG:pool_process_query():read kind from
backend C
2006-07-26 17:00:29 [5489] DEBUG:pool_read_string: read all from pending
data. po:6 len:53
2006-07-26 17:00:29 [5489] DEBUG:CompleteCommandResponse(): string: "BEGIN"
2006-07-26 17:00:29 [5489] DEBUG:pool_process_query():read kind from
backend pending data P len: 52 po: 7
2006-07-26 17:00:29 [5489] DEBUG:pool_read_string: read all from pending
data. po:13 len:46
2006-07-26 17:00:29 [5489] DEBUG:pool_process_query():read kind from
backend pending data T len: 45 po: 14
2006-07-26 17:00:29 [5489] DEBUG:pool_read_string: read all from pending
data. po:25 len:34
2006-07-26 17:00:29 [5489] DEBUG:RowDescription(): field size:1
2006-07-26 17:00:29 [5489] DEBUG:pool_process_query():read kind from
backend pending data D len: 23 po: 36
2006-07-26 17:00:29 [5489] DEBUG:AsciiRow(): len: 1 data: t
2006-07-26 17:00:29 [5489] DEBUG:pool_process_query():read kind from
backend pending data C len: 16 po: 43
2006-07-26 17:00:29 [5489] DEBUG:pool_read_string: read all from pending
data. po:50 len:9
2006-07-26 17:00:29 [5489] DEBUG:CompleteCommandResponse(): string:
"SELECT"
2006-07-26 17:00:29 [5489] DEBUG:pool_process_query():read kind from
backend pending data C len: 8 po: 51
2006-07-26 17:00:29 [5489] DEBUG:pool_read_string: read all from pending
data. po:58 len:1
2006-07-26 17:00:29 [5489] DEBUG:CompleteCommandResponse(): string:
"COMMIT"
2006-07-26 17:00:29 [5489] DEBUG:pool_process_query():read kind from
backend pending data Z len: 0 po: 0
2006-07-26 17:00:41 [5489] DEBUG:ProcessFrontendResponse():read kind from
frontend Q(51)
2006-07-26 17:00:41 [5489] DEBUG:pool_read_string: read all from pending
data. po:0 len:0
2006-07-26 17:00:41 [5489] DEBUG:Query(): SELECT n.nspname as "Schema",
c.relname as "Name",
CASE c.relkind WHEN 'r' THEN 'table' WHEN 'v' THEN 'view' WHEN 'i' THEN
'index' WHEN 'S' THEN 'sequence' WHEN 's' THEN 'special' END as "Type",
u.usename as "Owner"
FROM pg_catalog.pg_class c
LEFT JOIN pg_catalog.pg_user u ON u.usesysid = c.relowner
LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
WHERE c.relkind IN ('r','v','S','')
AND n.nspname NOT IN ('pg_catalog', 'pg_toast')
AND pg_catalog.pg_table_is_visible(c.oid)
ORDER BY 1,2;
2006-07-26 17:00:41 [5489] DEBUG:pool_process_query():read kind from
backend P
2006-07-26 17:00:41 [5489] DEBUG:pool_read_string: read all from pending
data. po:6 len:75
2006-07-26 17:00:41 [5489] DEBUG:pool_process_query():read kind from
backend pending data T len: 74 po: 7
2006-07-26 17:00:41 [5489] DEBUG:pool_read_string: read all from pending
data. po:16 len:65
2006-07-26 17:00:41 [5489] DEBUG:RowDescription(): field size:64
2006-07-26 17:00:41 [5489] DEBUG:pool_read_string: read all from pending
data. po:31 len:50
2006-07-26 17:00:41 [5489] DEBUG:RowDescription(): field size:64
2006-07-26 17:00:41 [5489] DEBUG:pool_read_string: read all from pending
data. po:46 len:35
2006-07-26 17:00:41 [5489] DEBUG:RowDescription(): field size:65535
2006-07-26 17:00:41 [5489] DEBUG:pool_read_string: read all from pending
data. po:62 len:19
2006-07-26 17:00:41 [5489] DEBUG:RowDescription(): field size:64
2006-07-26 17:00:41 [5489] DEBUG:pool_process_query():read kind from
backend pending data C len: 8 po: 73
2006-07-26 17:00:41 [5489] DEBUG:pool_read_string: read all from pending
data. po:80 len:1
2006-07-26 17:00:41 [5489] DEBUG:CompleteCommandResponse(): string:
"SELECT"
2006-07-26 17:00:41 [5489] DEBUG:pool_process_query():read kind from
backend pending data Z len: 0 po: 0
2006-07-26 17:01:06 [5489] DEBUG:ProcessFrontendResponse():read kind from
frontend Q(51)
2006-07-26 17:01:06 [5489] DEBUG:pool_read_string: read all from pending
data. po:0 len:0
2006-07-26 17:01:06 [5489] DEBUG:Query(): CREATE TABLE testtab (
id INT,
name VARCHAR(255),
CONSTRAINT test_pk PRIMARY KEY (id));
pgcluster メーリングリストの案内