[pgsql-jp: 36361] pgpool264 で接続エラー

[ASP森山 和宏]

moriyamaと申します

pgpoolのサイトに2.6.4が上がっていたので試してみたところ、
CSEで接続をしようとすると４回に１回しか接続できなくなりました。

接続失敗時CSEに表示されるエラーメッセージは下記になります。

connectDB() -- expected authentication request

接続が正常に出来た場合は、普通にDB内のデータにもアクセスできます。

2.6.3ではこのような現象は発生しませんでした。

なにかDBコネクション系で大きく変更があったのでしょうか。

テスト環境：
OS：RedHatES3
DB：PostgreSQL8.0.3
PGPOOL：2.6.4

DBとPGPOOLは１台のサーバで稼動させています。
PGPOOLの設定は2.6.3、2.6.4でまったく同じ設定にしています。

下記はコネクション失敗時のログです
2005-11-10 19:12:06 DEBUG: pid 28733: I am 28733 accept fd 6
2005-11-10 19:12:06 DEBUG: pid 28733: Protocol Major: 1234 Minor: 5678 
database:  user:
2005-11-10 19:12:06 DEBUG: pid 28733: Cancel request received
2005-11-10 19:12:06 DEBUG: pid 28733: connecting postmaster Unix domain 
socket: /tmp/.s.PGSQL.5532
2005-11-10 19:12:06 DEBUG: pid 28733: connected to postmaster Unix domain 
socket: /tmp/.s.PGSQL.5532 fd: 8
2005-11-10 19:12:06 DEBUG: pid 28732: read kind from frontend X(58)
2005-11-10 19:12:06 DEBUG: pid 28732: Query: ABORT
2005-11-10 19:12:06 DEBUG: pid 28732: read kind from frontend ^@(00)
2005-11-10 19:12:06 ERROR: pid 28732: ProcessFrontendResponse: unknown 
message type ^@(00)
2005-11-10 19:12:06 DEBUG: pid 28732: I am 28732 accept fd 6
2005-11-10 19:12:06 DEBUG: pid 28732: Protocol Major: 1234 Minor: 5678 
database:  user:
2005-11-10 19:12:06 DEBUG: pid 28732: Cancel request received
2005-11-10 19:12:06 DEBUG: pid 28732: connecting postmaster Unix domain 
socket: /tmp/.s.PGSQL.5532
2005-11-10 19:12:06 DEBUG: pid 28732: connected to postmaster Unix domain 
socket: /tmp/.s.PGSQL.5532 fd: 7
2005-11-10 19:12:06 DEBUG: pid 28731: read kind from frontend X(58)
2005-11-10 19:12:06 DEBUG: pid 28731: Query: ABORT
2005-11-10 19:12:06 DEBUG: pid 28731: read kind from frontend ^@(00)
2005-11-10 19:12:06 ERROR: pid 28731: ProcessFrontendResponse: unknown 
message type ^@(00)
2005-11-10 19:12:10 DEBUG: pid 28731: I am 28731 accept fd 6
2005-11-10 19:12:10 DEBUG: pid 28731: Protocol Major: 2 Minor: 0 database: 
dotdb5 user: postgres
2005-11-10 19:12:10 DEBUG: pid 28731: connecting postmaster Unix domain 
socket: /tmp/.s.PGSQL.5532
2005-11-10 19:12:10 DEBUG: pid 28731: connected to postmaster Unix domain 
socket: /tmp/.s.PGSQL.5532 fd: 7
2005-11-10 19:12:10 DEBUG: pid 28731: read kind from backend pending data Z 
len: 0 po: 0
2005-11-10 19:12:10 DEBUG: pid 28731: pool_process_query: kind from backend: 
Z
2005-11-10 19:12:10 ERROR: pid 28731: ProcessFrontendResponse: failed to 
read kind from frontend. fronend abnormally exited
2005-11-10 19:12:10 DEBUG: pid 28731: Query: ABORT
2005-11-10 19:12:10 DEBUG: pid 28731: read kind from backend N
2005-11-10 19:12:10 DEBUG: pid 28731: pool_process_query: kind from backend: 
N
2005-11-10 19:12:10 DEBUG: pid 28731: pool_read_string: read all from 
pending data. po:0 len:0
2005-11-10 19:12:10 DEBUG: pid 28731: read kind from backend C
2005-11-10 19:12:10 DEBUG: pid 28731: pool_process_query: kind from backend: 
C
2005-11-10 19:12:10 DEBUG: pid 28731: pool_read_string: read all from 
pending data. po:9 len:1
2005-11-10 19:12:10 DEBUG: pid 28731: Complete Command Response: string: 
"ROLLBACK"
2005-11-10 19:12:10 DEBUG: pid 28731: read kind from backend pending data Z 
len: 0 po: 0
2005-11-10 19:12:10 DEBUG: pid 28731: pool_process_query: kind from backend: 
Z
2005-11-10 19:12:10 DEBUG: pid 28731: Query:  RESET ALL
2005-11-10 19:12:10 DEBUG: pid 28731: read kind from backend C
2005-11-10 19:12:10 DEBUG: pid 28731: pool_process_query: kind from backend: 
C
2005-11-10 19:12:10 DEBUG: pid 28731: pool_read_string: read all from 
pending data. po:6 len:1
2005-11-10 19:12:10 DEBUG: pid 28731: Complete Command Response: string: 
"RESET"
2005-11-10 19:12:10 DEBUG: pid 28731: read kind from backend pending data Z 
len: 0 po: 0
2005-11-10 19:12:10 DEBUG: pid 28731: pool_process_query: kind from backend: 
Z
2005-11-10 19:12:10 DEBUG: pid 28731: Query:  SET SESSION AUTHORIZATION 
DEFAULT
2005-11-10 19:12:10 DEBUG: pid 28731: read kind from backend C
2005-11-10 19:12:10 DEBUG: pid 28731: pool_process_query: kind from backend: 
C
2005-11-10 19:12:10 DEBUG: pid 28731: pool_read_string: read all from 
pending data. po:4 len:1
2005-11-10 19:12:10 DEBUG: pid 28731: Complete Command Response: string: 
"SET"
2005-11-10 19:12:10 DEBUG: pid 28731: read kind from backend pending data Z 
len: 0 po: 0
2005-11-10 19:12:10 DEBUG: pid 28731: pool_process_query: kind from backend: 
Z
2005-11-10 19:12:10 DEBUG: pid 28731: pool_connection_pool_timer: set close 
time 1131617530

以上、よろしくお願い致します