[pgsql-jp: 33677] Re: pgpool の接続が増え続けます

[Imono Kazuo]

どこからご入用かわかりませんので適当なところから最後まで以下に
添付いたしました。これはＣＳＥを起動後、ＤＢに接続し、それを切断
した時のものです。
よろしくお願いいたします。

DEBUG: pid 12772: pool_read_string: read all from pending data. po:0 len:0
DEBUG: pid 12772: Query: SELECT a.attname FROM pg_class c,pg_attribute a
WHERE c.oid=a.attrelid AND c.relname='pg_trigger' AND a.attname =
'tgisconstraint'
DEBUG: pid 12772: read kind from backend P
DEBUG: pid 12772: pool_read_string: read all from pending data. po:6 len:50
DEBUG: pid 12772: read kind from backend pending data T len: 49 po: 7
DEBUG: pid 12772: pool_read_string: read all from pending data. po:17 len:39
DEBUG: pid 12772: RowDescription: field size:64
DEBUG: pid 12772: read kind from backend pending data D len: 28 po: 28
DEBUG: pid 12772: AsciiRow: len:14 data: tgisconstrain
DEBUG: pid 12772: read kind from backend pending data C len: 8 po: 48
DEBUG: pid 12772: pool_read_string: read all from pending data. po:55 len:1
DEBUG: pid 12772: Complete Command Response: string: "SELECT"
DEBUG: pid 12772: read kind from backend pending data Z len: 0 po: 0
DEBUG: pid 12773: read kind from frontend Q(51)
DEBUG: pid 12773: pool_read_string: read all from pending data. po:0 len:0
DEBUG: pid 12773: Query: SET CLIENT_ENCODING TO SJIS
DEBUG: pid 12773: read kind from backend C
DEBUG: pid 12773: pool_read_string: read all from pending data. po:4 len:1
DEBUG: pid 12773: Complete Command Response: string: "SET"
DEBUG: pid 12773: read kind from backend pending data Z len: 0 po: 0
DEBUG: pid 12772: read kind from frontend Q(51)
DEBUG: pid 12772: pool_read_string: read all from pending data. po:0 len:0
DEBUG: pid 12772: Query: SET CLIENT_ENCODING TO SJIS
DEBUG: pid 12772: read kind from backend C
DEBUG: pid 12772: pool_read_string: read all from pending data. po:4 len:1
DEBUG: pid 12772: Complete Command Response: string: "SET"
DEBUG: pid 12772: read kind from backend pending data Z len: 0 po: 0
DEBUG: pid 12771: I am 12771 accept fd 6
DEBUG: pid 12771: Protocol Major: 1234 Minor: 5678 database:  user:
DEBUG: pid 12771: Cancel request received
DEBUG: pid 12771: connecting postmaster Unix domain socket:
/tmp/.s.PGSQL.5433
DEBUG: pid 12771: connected to postmaster Unix domain socket:
/tmp/.s.PGSQL.5433 fd: 7
DEBUG: pid 12773: read kind from frontend X(58)
DEBUG: pid 12773: Query: ABORT
DEBUG: pid 12771: I am 12771 accept fd 6
DEBUG: pid 12771: Protocol Major: 1234 Minor: 5678 database:  user:
DEBUG: pid 12771: Cancel request received
DEBUG: pid 12771: connecting postmaster Unix domain socket:
/tmp/.s.PGSQL.5433
DEBUG: pid 12771: connected to postmaster Unix domain socket:
/tmp/.s.PGSQL.5433 fd: 7
DEBUG: pid 12772: read kind from frontend X(58)
DEBUG: pid 12772: Query: ABORT

----- Original Message ----- 
From: "Tatsuo Ishii" <t-ishii ＠ sra.co.jp>
To: <pgsql-jp ＠ ml.postgresql.jp>
Sent: Thursday, July 15, 2004 12:28 PM
Subject: [pgsql-jp: 33674] Re: pgpool の接続が増え続けます


> 石井です．
>
> > ＣＳＥは常に２つ接続を使うようです。pgpool 抜きでそうなります。
> > また、pgpool は replication_mode = false のまま使用しています。
> > やはり libpq.dll では pgpool が使えないのでしょうか。pgpool の
> > 新機能に期待していたのですが...
>
> そうですか．では，-d -n オプションを付けてpgpoolを起動し，CSE or 他の
> アプリから接続を切断したときのログを見せていただけますか？
> --
> Tatsuo Ishii
>