[pgpool-general-jp: 150] Re: pgpoolIIとJDBC protocolVersion2について

[Kenji Yamaguchi]

浅羽さん

お世話になります。
山口です。

ややこしいのですが、状況を説明します。
弊社では今回、２つの環境で試しました。
[環境A]
１．CVSから1.17のpool_process_query.cをダウンロードして置き換えてmake / install
http://www.sraoss.jp/pipermail/pgpool-general-jp/2007-May/000142.html のログ

２．CVSから1.18のpool_process_query.cをダウンロードして置き換えてmake / install
http://www.sraoss.jp/pipermail/pgpool-general-jp/2007-May/000145.html のログ

３．1.1から1.18のパッチをあてた場合
http://www.sraoss.jp/pipermail/pgpool-general-jp/2007-May/000145.html のログ

[環境B]
１．CVSから1.18のpool_process_query.cをダウンロードして置き換えてmake / install
http://www.sraoss.jp/pipermail/pgpool-general-jp/2007-May/000142.html と同様のログ
今回出力されたログもつけておきます。
DriverManager.getConnection("jdbc:postgresql://xxx.xxx.xxx.xxx:9999/hogedb?protocolVersion=2&loglevel=2")
    trying driver[className=org.postgresql.Driver,org.postgresql.Driver ＠ 946d22]
connect jdbc:postgresql://xxx.xxx.xxx.xxx:9999/hogedb?protocolVersion=2&loglevel=2
PostgreSQL 8.1 JDBC3 with SSL (build 409)
Trying to establish a protocol version 2 connection to xxx.xxx.xxx.xxx:9999
 FE=> StartupPacket(user=hogeuser,database=hogedb)
 <=BE AuthenticationOk
 <=BE BackendKeyData(pid=7375,ckey=1179206448)
 <=BE ReadyForQuery
 FE=> Query("set datestyle = 'ISO'; select version(), case when pg_encoding_to_char(1) = 'SQL_ASCII' then 'UNKNOWN' else
getdatabaseencoding() end")
 <=BE CommandStatus(SET)
 <=BE PortalName(blank)
 <=BE RowDescription(2)
 <=BE DataRow
 <=BE CommandStatus(SELECT)
 <=BE ReadyForQuery
Switching to UNICODE client_encoding
 FE=> Query("begin; set autocommit = on; set client_encoding = 'UNICODE'; commit")
 <=BE CommandStatus(BEGIN)
 <=BE CommandStatus(SET)
 <=BE CommandStatus(SET)
 <=BE CommandStatus(COMMIT)
 <=BE ReadyForQuery
Connection encoding (using JVM's nomenclature): UTF-8
    compatible = 8.1
    loglevel = 2
    prepare threshold = 5
getConnection returning driver[className=org.postgresql.Driver,org.postgresql.Driver ＠ 946d22]
getDatabaseProductName PostgresSQL
getDatabaseProductName PostgresSQL
getUserName hogeuser
supportsMixedCaseIdentifiers false
storesUpperCaseIdentifiers false
supportsMixedCaseIdentifiers false
storesUpperCaseIdentifiers false
 FE=> Query("BEGIN;SELECT t.typlen FROM pg_catalog.pg_type t, pg_catalog.pg_namespace n WHERE t.typnamespace=n.oid AND
t.typname='name' AND n.nspname='pg_catalog'")
 <=BE CommandStatus(BEGIN)
 <=BE PortalName(blank)
 <=BE RowDescription(1)
 <=BE DataRow
 <=BE CommandStatus(SELECT)
 <=BE ReadyForQuery
 FE=> Query("SELECT n.nspname,c.relname,a.attname,a.atttypid,a.attnotnull,a.atttypmod,a.attlen,a.attnum,def.adsrc,dsc.description
FROM pg_catalog.pg_namespace n  JOIN pg_catalog.pg_class c ON (c.relnamespace = n.oid)  JOIN pg_catalog.pg_attribute a ON
(a.attrelid=c.oid)  LEFT JOIN pg_catalog.pg_attrdef def ON (a.attrelid=def.adrelid AND a.attnum = def.adnum)  LEFT JOIN
pg_catalog.pg_description dsc ON (c.oid=dsc.objoid AND a.attnum = dsc.objsubid)  LEFT JOIN pg_catalog.pg_class dc ON
(dc.oid=dsc.classoid AND dc.relname='pg_class')  LEFT JOIN pg_catalog.pg_namespace dn ON (dc.relnamespace=dn.oid AND
dn.nspname='pg_catalog')  WHERE a.attnum > 0 AND NOT a.attisdropped  AND n.nspname LIKE 'hogeuser'  AND c.relname LIKE 'usermst'
ORDER BY nspname,relname,attnum ")
 <=BE PortalName(blank)
 <=BE RowDescription(10)
 <=BE CommandStatus(SELECT)
 <=BE ReadyForQuery
 FE=> Query("SELECT n.nspname,c.relname,a.attname,a.atttypid,a.attnotnull,a.atttypmod,a.attlen,a.attnum,def.adsrc,dsc.description
FROM pg_catalog.pg_namespace n  JOIN pg_catalog.pg_class c ON (c.relnamespace = n.oid)  JOIN pg_catalog.pg_attribute a ON
(a.attrelid=c.oid)  LEFT JOIN pg_catalog.pg_attrdef def ON (a.attrelid=def.adrelid AND a.attnum = def.adnum)  LEFT JOIN
pg_catalog.pg_description dsc ON (c.oid=dsc.objoid AND a.attnum = dsc.objsubid)  LEFT JOIN pg_catalog.pg_class dc ON
(dc.oid=dsc.classoid AND dc.relname='pg_class')  LEFT JOIN pg_catalog.pg_namespace dn ON (dc.relnamespace=dn.oid AND
dn.nspname='pg_catalog')  WHERE a.attnum > 0 AND NOT a.attisdropped  AND n.nspname LIKE 'hogeuser'  AND c.relname LIKE 'USERMST'
ORDER BY nspname,relname,attnum ")
 <=BE PortalName(blank)
 <=BE RowDescription(10)
 <=BE CommandStatus(SELECT)
 <=BE ReadyForQuery
 FE=> Query("SELECT n.nspname,c.relname,a.attname,a.atttypid,a.attnotnull,a.atttypmod,a.attlen,a.attnum,def.adsrc,dsc.description
FROM pg_catalog.pg_namespace n  JOIN pg_catalog.pg_class c ON (c.relnamespace = n.oid)  JOIN pg_catalog.pg_attribute a ON
(a.attrelid=c.oid)  LEFT JOIN pg_catalog.pg_attrdef def ON (a.attrelid=def.adrelid AND a.attnum = def.adnum)  LEFT JOIN
pg_catalog.pg_description dsc ON (c.oid=dsc.objoid AND a.attnum = dsc.objsubid)  LEFT JOIN pg_catalog.pg_class dc ON
(dc.oid=dsc.classoid AND dc.relname='pg_class')  LEFT JOIN pg_catalog.pg_namespace dn ON (dc.relnamespace=dn.oid AND
dn.nspname='pg_catalog')  WHERE a.attnum > 0 AND NOT a.attisdropped  AND c.relname LIKE 'usermst'  ORDER BY nspname,relname,attnum
")
 <=BE PortalName(blank)
 <=BE RowDescription(10)
 <=BE DataRow
 <=BE DataRow

-----------------------------------------------------------------

環境Aの３と環境Bの１は同様の作業を行っているのに、
出力されているログが違うので、もしかしたら環境構築上で
不備があるのかもしれませんが、何かお気づきの点はありますでしょうか？
量感京都も、当然の事ながら、通常portとpgpool2の
protocolVersion3は正常に動いております。
（今までの報告は、環境Aでの情報を返信していました）

よろしくお願いします。