[pgpool-general-jp: 297] Re: pgpool-II パラレルモード select と order by でエラー
Yoshiharu Mori
y-mori ＠ sraoss.co.jp
2007年 11月 26日 (月) 20:44:58 JST
浅野様
お世話になっております。
盛です。
> pgpool-II パラレルクエリモード使用で select文 を order by句 と組み合わせて
>
>
> 発行すると、エラーが発生します。
>
> テーブルに設定した文字数の範囲内の文字列が入っているにも関わらず、
> 文字列がオーバーしているかのようなエラーが表示されます。
> （例:character varying(100)なら80文字の文字列）
>
> どなたか対処法をご存知の方が見えましたら、
> お教え願いたいと思います。
恐らく、systemDBとデータが入っているDBのencodingが異なるのでは
ないでしょうか。
例えばsystemDBがEUC_JPで作成されており、データが入っているDBがUTF-8の
場合など。
>
>
> [エラーの状況]
> ・発行するＳＱＬ
> select * from shop_data where shop_area_number='1' order by r_datetime
> desc limit 5 offset 0;
>
> ・発生したエラー
> Query failed: ERROR: value too long for type character varying(100)
>
> ・一見すると単に文字数がオーバーしているだけだと思われたが、
> フィールドに入っている文字は80文字ほど(日本語)で、オーバーはしていない。
>
>
>
> ・あるフィールド（shop_caption1 ※下記参照）に最も多く文字列が入っていたので、
> 文字数を60文字くらいに減らしたらエラーは出なくなった。
>
> ・別のフィールド（[shop_estimate] character varying(50) ）には35文字程度いたが、これもエラーの原因となっていた。
> 文字数を60文字くらいに減らしたらエラーは出なくなった。
>
> ・試しに order by句をはずして 「select * from shop_data」 だけを発行すると、このエラーは出なくなった。
>
> ・またPostgreSQL単体で動かしてみたところ、エラーは出なくなった。
>
>
> ------------------------------------------------
> [環境]
> OS： Cent OS 4.4
> Apache： httpd-2.0.52
> PHP： 4.4.5
> pgpool-II： 1.3
> PostgreSQL 8.2.5
>
> （※PostgreSQL 8.1.4、pgpool-II-1.2.1のバージョンで試しても同じエラーが出ました。）
>
> ------------------------------------------------
> [pgpoolシステムDB テーブル]
> insert into pgpool_catalog.dist_def values(
> 'shop_db',
> 'public',
> 'shop_data',
> 'shop_data_id',
> ARRAY['shop_data_id','shop_commu_id','shop_area_number','shop_cooking_number','shop_notice','shop_check','shop_point1','shop_point2','shop_point3','shop_explain1','shop_explain2','shop_caption1','shop_caption2','shop_caption3','shop_caption4','shop_address','shop_access','shop_map','shop_tel','shop_fax','shop_business_hours','shop_regular_holiday','shop_estimate','shop_seat','shop_maximum','shop_parking_lot','shop_card','shop_service','shop_web_site','shop_mail_address','image_filename1','image_filename2','image_filename3','image_filename4','image_filename5','image_filename6','image_width1','image_height1','image_width2','image_height2','image_width3','image_height3','image_width4','image_height4','image_width5','image_height5','image_width6','image_height6','r_datetime'],
> ARRAY['integer','integer','smallint','smallint','character
> varying(50)','text','smallint','smallint','smallint','text','text','character
> varying(100)','character varying(100)','character varying(100)','character
> varying(100)','text','text','text','character varying(50)','character
> varying(50)','text','character varying(100)','character
> varying(50)','text','character varying(50)','character
> varying(50)','text','text','text','character
> varying(100)','text','text','text','text','text','text','smallint','smallint','smallint','smallint','smallint','smallint','smallint','smallint','smallint','smallint','smallint','smallint','timestamp
> without time zone'],
> 'pgpool_catalog.dist_def_shop_data')
>
> ------------------------------------------------
> [分割ファンクション]
> CREATE OR REPLACE FUNCTION pgpool_catalog.dist_def_shop_data(val ANYELEMENT)
> RETURNS INTEGER AS $$
> SELECT CASE WHEN $1 > 0 then 1
> END $$ LANGUAGE SQL;
>
> ------------------------------------------------
> [テーブル]
> shop_data_id | integer | not null
> shop_commu_id | integer | not null default 0
> shop_area_number | smallint | not null default 0
> shop_cooking_number | smallint | not null default 0
> shop_notice | character varying(50) | not null
> shop_check | text | not null
> shop_point1 | smallint | not null default 0
> shop_point2 | smallint | not null default 0
> shop_point3 | smallint | not null default 0
> shop_explain1 | text | not null
> shop_explain2 | text | not null
> shop_caption1 | character varying(100) | not null
> shop_caption2 | character varying(100) | not null
> shop_caption3 | character varying(100) | not null
> shop_caption4 | character varying(100) | not null
> shop_address | text | not null
> shop_access | text | not null
> shop_map | text | not null
> shop_tel | character varying(50) | not null
> shop_fax | character varying(50) | not null
> shop_business_hours | text | not null
> shop_regular_holiday | character varying(100) | not null
> shop_estimate | character varying(50) | not null
> shop_seat | text | not null
> shop_maximum | character varying(50) | not null
> shop_parking_lot | character varying(50) | not null
> shop_card | text | not null
> shop_service | text | not null
> shop_web_site | text | not null
> shop_mail_address | character varying(100) | not null
> image_filename1 | text | not null
> image_filename2 | text | not null
> image_filename3 | text | not null
> image_filename4 | text | not null
> image_filename5 | text | not null
> image_filename6 | text | not null
> image_width1 | smallint | not null default 0
> image_height1 | smallint | not null default 0
> image_width2 | smallint | not null default 0
> image_height2 | smallint | not null default 0
> image_width3 | smallint | not null default 0
> image_height3 | smallint | not null default 0
> image_width4 | smallint | not null default 0
> image_height4 | smallint | not null default 0
> image_width5 | smallint | not null default 0
> image_height5 | smallint | not null default 0
> image_width6 | smallint | not null default 0
> image_height6 | smallint | not null default 0
> r_datetime | timestamp without time zone | not null default now()
>
> ------------------------------------------------
> [PostgreSQL エラーが発生した付近のログ]
>
> 2007-11-22 15:15:02 JST idleLOCATION: exec_simple_query, postgres.c:811
> 2007-11-22 15:15:02 JST SETLOG: 00000: duration: 0.615 ms
> 2007-11-22 15:15:02 JST SETLOCATION: exec_simple_query, postgres.c:1009
> 2007-11-22 15:20:01 JST idleLOG: 00000: statement: SELECT "*" FROM
> "shop_commu_admin_confirm" WHERE ("r_datetime"<'2007-11-19 15:20:01' )
> 2007-11-22 15:20:01 JST idleLOCATION: exec_simple_query, postgres.c:811
> 2007-11-22 15:20:01 JST SELECTLOG: 00000: duration: 5.663 ms
> 2007-11-22 15:20:01 JST SELECTLOCATION: exec_simple_query, postgres.c:1009
> 2007-11-22 15:20:01 JST idleLOG: 00000: statement: RESET ALL
> 2007-11-22 15:20:01 JST idleLOCATION: exec_simple_query, postgres.c:811
> 2007-11-22 15:20:01 JST RESETLOG: 00000: duration: 0.520 ms
> 2007-11-22 15:20:01 JST RESETLOCATION: exec_simple_query, postgres.c:1009
> 2007-11-22 15:20:01 JST idleLOG: 00000: statement: SET SESSION
> AUTHORIZATION DEFAULT
> 2007-11-22 15:20:01 JST idleLOCATION: exec_simple_query, postgres.c:811
> 2007-11-22 15:20:01 JST SETLOG: 00000: duration: 0.581 ms
> 2007-11-22 15:20:01 JST SETLOCATION: exec_simple_query, postgres.c:1009
> 2007-11-22 15:49:34 JST idleLOG: 00000: statement: RESET ALL
> 2007-11-22 15:49:34 JST idleLOCATION: exec_simple_query, postgres.c:811
> 2007-11-22 15:49:34 JST RESETLOG: 00000: duration: 0.759 ms
> 2007-11-22 15:49:34 JST RESETLOCATION: exec_simple_query, postgres.c:1009
> 2007-11-22 15:49:34 JST idleLOG: 00000: statement: SET SESSION
> AUTHORIZATION DEFAULT
> 2007-11-22 15:49:34 JST idleLOCATION: exec_simple_query, postgres.c:811
> 2007-11-22 15:49:34 JST SETLOG: 00000: duration: 0.775 ms
> 2007-11-22 15:49:34 JST SETLOCATION: exec_simple_query, postgres.c:1009
> 2007-11-22 15:51:45 JST idleLOG: 00000: statement: select * from shop_data
> 2007-11-22 15:51:45 JST idleLOCATION: exec_simple_query, postgres.c:811
> 2007-11-22 15:51:45 JST SELECTLOG: 00000: duration: 71.649 ms
> 2007-11-22 15:51:45 JST SELECTLOCATION: exec_simple_query, postgres.c:1009
> 2007-11-22 15:51:45 JST idleLOG: 00000: statement: RESET ALL
> 2007-11-22 15:51:45 JST idleLOCATION: exec_simple_query, postgres.c:811
> 2007-11-22 15:51:45 JST RESETLOG: 00000: duration: 0.574 ms
> 2007-11-22 15:51:45 JST RESETLOCATION: exec_simple_query, postgres.c:1009
> 2007-11-22 15:51:45 JST idleLOG: 00000: statement: RESET ALL
> 2007-11-22 15:51:45 JST idleLOCATION: exec_simple_query, postgres.c:811
> 2007-11-22 15:51:45 JST RESETLOG: 00000: duration: 0.523 ms
> 2007-11-22 15:51:45 JST RESETLOCATION: exec_simple_query, postgres.c:1009
> 2007-11-22 15:51:45 JST idleLOG: 00000: statement: SET SESSION
> AUTHORIZATION DEFAULT
> 2007-11-22 15:51:45 JST idleLOCATION: exec_simple_query, postgres.c:811
> 2007-11-22 15:51:45 JST SETLOG: 00000: duration: 0.562 ms
> 2007-11-22 15:51:45 JST SETLOCATION: exec_simple_query, postgres.c:1009
> 2007-11-22 15:51:45 JST idleLOG: 00000: statement: SET SESSION
> AUTHORIZATION DEFAULT
> 2007-11-22 15:51:45 JST idleLOCATION: exec_simple_query, postgres.c:811
> 2007-11-22 15:51:45 JST SETLOG: 00000: duration: 0.588 ms
> 2007-11-22 15:51:45 JST SETLOCATION: exec_simple_query, postgres.c:1009
> 2007-11-22 15:53:07 JST idleLOG: 00000: statement: select * from shop_data
> WHERE shop_area_number ='1'
> 2007-11-22 15:53:07 JST idleLOCATION: exec_simple_query, postgres.c:811
> 2007-11-22 15:53:07 JST SELECTLOG: 00000: duration: 15.463 ms
> 2007-11-22 15:53:07 JST SELECTLOCATION: exec_simple_query, postgres.c:1009
> 2007-11-22 15:53:07 JST idleLOG: 00000: statement: RESET ALL
> 2007-11-22 15:53:07 JST idleLOCATION: exec_simple_query, postgres.c:811
> 2007-11-22 15:53:07 JST RESETLOG: 00000: duration: 0.447 ms
> 2007-11-22 15:53:07 JST RESETLOCATION: exec_simple_query, postgres.c:1009
> 2007-11-22 15:53:07 JST idleLOG: 00000: statement: SET SESSION
> AUTHORIZATION DEFAULT
> 2007-11-22 15:53:07 JST idleLOCATION: exec_simple_query, postgres.c:811
> 2007-11-22 15:53:07 JST SETLOG: 00000: duration: 0.449 ms
> 2007-11-22 15:53:07 JST SETLOCATION: exec_simple_query, postgres.c:1009
> 2007-11-22 15:53:07 JST idleLOG: 00000: statement: select * from shop_data
> 2007-11-22 15:53:07 JST idleLOCATION: exec_simple_query, postgres.c:811
> 2007-11-22 15:53:07 JST SELECTLOG: 00000: duration: 6.608 ms
> 2007-11-22 15:53:07 JST SELECTLOCATION: exec_simple_query, postgres.c:1009
> 2007-11-22 15:53:07 JST idleLOG: 00000: statement: select * from shop_data
> WHERE shop_area_number ='1'
> 2007-11-22 15:53:07 JST idleLOCATION: exec_simple_query, postgres.c:811
> 2007-11-22 15:53:07 JST SELECTLOG: 00000: duration: 1.956 ms
> 2007-11-22 15:53:07 JST SELECTLOCATION: exec_simple_query, postgres.c:1009
> 2007-11-22 15:53:07 JST idleLOG: 00000: statement: RESET ALL
> 2007-11-22 15:53:07 JST idleLOCATION: exec_simple_query, postgres.c:811
> 2007-11-22 15:53:07 JST RESETLOG: 00000: duration: 0.384 ms
> 2007-11-22 15:53:07 JST RESETLOCATION: exec_simple_query, postgres.c:1009
> 2007-11-22 15:53:07 JST idleLOG: 00000: statement: SET SESSION
> AUTHORIZATION DEFAULT
> 2007-11-22 15:53:07 JST idleLOCATION: exec_simple_query, postgres.c:811
> 2007-11-22 15:53:07 JST SETLOG: 00000: duration: 0.461 ms
> 2007-11-22 15:53:07 JST SETLOCATION: exec_simple_query, postgres.c:1009
> 2007-11-22 15:53:07 JST idleLOG: 00000: statement: RESET ALL
> 2007-11-22 15:53:07 JST idleLOCATION: exec_simple_query, postgres.c:811
> 2007-11-22 15:53:07 JST RESETLOG: 00000: duration: 0.557 ms
> 2007-11-22 15:53:07 JST RESETLOCATION: exec_simple_query, postgres.c:1009
> 2007-11-22 15:53:07 JST idleLOG: 00000: statement: SET SESSION
> AUTHORIZATION DEFAULT
> 2007-11-22 15:53:07 JST idleLOCATION: exec_simple_query, postgres.c:811
> 2007-11-22 15:53:07 JST SETLOG: 00000: duration: 0.555 ms
> 2007-11-22 15:53:07 JST SETLOCATION: exec_simple_query, postgres.c:1009
> 2007-11-22 15:53:07 JST idleLOG: 00000: statement: RESET ALL
> 2007-11-22 15:53:07 JST idleLOCATION: exec_simple_query, postgres.c:811
> 2007-11-22 15:53:07 JST RESETLOG: 00000: duration: 0.660 ms
> 2007-11-22 15:53:07 JST RESETLOCATION: exec_simple_query, postgres.c:1009
> 2007-11-22 15:53:07 JST idleLOG: 00000: statement: SET SESSION
> AUTHORIZATION DEFAULT
> 2007-11-22 15:53:07 JST idleLOCATION: exec_simple_query, postgres.c:811
> 2007-11-22 15:53:07 JST SETLOG: 00000: duration: 0.603 ms
> 2007-11-22 15:53:07 JST SETLOCATION: exec_simple_query, postgres.c:1009
>
>
> ------------------------------------------------
> [pgpool-II エラーが発生した付近のログ]
>
> 2007-11-22 15:53:07 DEBUG: pid 8737: pool_read_message_length2: master slot:
> 0 length: 19
> 2007-11-22 15:53:07 DEBUG: pid 8737: pool_read_message_length2: master slot:
> 1 length: 19
> 2007-11-22 15:53:07 DEBUG: pid 8737: pool_read_message_length2: master slot:
> 2 length: 19
> 2007-11-22 15:53:07 DEBUG: pid 8737: 0 th backend: name: TimeZone value:
> Japan
> 2007-11-22 15:53:07 DEBUG: pid 8737: 1 th backend: name: TimeZone value:
> Japan
> 2007-11-22 15:53:07 DEBUG: pid 8737: 2 th backend: name: TimeZone value:
> Japan
> 2007-11-22 15:53:07 DEBUG: pid 8737: pool_read_message_length: slot: 0
> length: 12
> 2007-11-22 15:53:07 DEBUG: pid 8737: pool_read_message_length: slot: 1
> length: 12
> 2007-11-22 15:53:07 DEBUG: pid 8737: pool_read_message_length: slot: 2
> length: 12
> 2007-11-22 15:53:07 DEBUG: pid 8737: pool_send_auth_ok: send pid 8940 to
> frontend
> 2007-11-22 15:53:07 DEBUG: pid 8737: select_load_balancing_node: selected
> backend id is 0
> 2007-11-22 15:53:07 DEBUG: pid 8737: read_kind_from_backend: read kind from
> 0 th backend Z NUM_BACKENDS: 3
> 2007-11-22 15:53:07 DEBUG: pid 8737: read_kind_from_backend: read kind from
> 1 th backend Z NUM_BACKENDS: 3
> 2007-11-22 15:53:07 DEBUG: pid 8737: read_kind_from_backend: read kind from
> 2 th backend Z NUM_BACKENDS: 3
> 2007-11-22 15:53:07 DEBUG: pid 8737: pool_process_query: kind from backend:
> Z
> 2007-11-22 15:53:07 DEBUG: pid 8737: pool_read_message_length: slot: 0
> length: 5
> 2007-11-22 15:53:07 DEBUG: pid 8737: pool_read_message_length: slot: 1
> length: 5
> 2007-11-22 15:53:07 DEBUG: pid 8737: pool_read_message_length: slot: 2
> length: 5
> 2007-11-22 15:53:07 DEBUG: pid 8737: ReadyForQuery: message length: 5
> 2007-11-22 15:53:07 DEBUG: pid 8737: ReadyForQuery: transaction state: I
> 2007-11-22 15:53:07 DEBUG: pid 8737: pool_process_query: num_fds: 13
> 2007-11-22 15:53:07 DEBUG: pid 8737: read kind from frontend Q(51)
> 2007-11-22 15:53:07 DEBUG: pid 8737: statement2: SELECT
> pool_parallel("select * from shop_data")
> 2007-11-22 15:53:07 DEBUG: pid 8737: pool_parallel_query: 0 th FD_SET: 10
> 2007-11-22 15:53:07 DEBUG: pid 8737: pool_parallel_query: 1 th FD_SET: 11
> 2007-11-22 15:53:07 DEBUG: pid 8737: pool_parallel_query: 2 th FD_SET: 12
> 2007-11-22 15:53:07 DEBUG: pid 8737: pool_parallel_query: num_fds: 13
> 2007-11-22 15:53:07 DEBUG: pid 8737: read_kind_from_one_backend: read kind
> from 2 th backend T
> 2007-11-22 15:53:07 DEBUG: pid 8737: pool_parallel_exec: kind from backend:
> T
> 2007-11-22 15:53:07 DEBUG: pid 8737: pool_parallel_exec: dummy from backend:
> C
> 2007-11-22 15:53:07 DEBUG: pid 8737: pool_parallel_query: 0 th FD_SET: 10
> 2007-11-22 15:53:07 DEBUG: pid 8737: pool_parallel_query: 1 th FD_SET: 11
> 2007-11-22 15:53:07 DEBUG: pid 8737: pool_parallel_query: num_fds: 13
> 2007-11-22 15:53:07 DEBUG: pid 8737: read_kind_from_one_backend: read kind
> from 0 th backend T
> 2007-11-22 15:53:07 DEBUG: pid 8737: pool_parallel_exec: dummy kind from
> backend: T
> 2007-11-22 15:53:07 DEBUG: pid 8737: pool_parallel_exec: dummy from backend:
> C
> 2007-11-22 15:53:07 DEBUG: pid 8737: pool_parallel_query: 1 th FD_SET: 11
> 2007-11-22 15:53:07 DEBUG: pid 8737: pool_parallel_query: num_fds: 13
> 2007-11-22 15:53:07 DEBUG: pid 8737: read_kind_from_one_backend: read kind
> from 1 th backend T
> 2007-11-22 15:53:07 DEBUG: pid 8737: pool_parallel_exec: dummy kind from
> backend: T
> 2007-11-22 15:53:07 DEBUG: pid 8737: pool_parallel_exec: kind from backend:
> D
> 2007-11-22 15:53:07 DEBUG: pid 8737: pool_parallel_exec: kind from backend:
> D
> 2007-11-22 15:53:07 DEBUG: pid 8737: pool_parallel_exec: kind from backend:
> C
> 2007-11-22 15:53:07 DEBUG: pid 8737: read_kind_from_backend: read kind from
> 0 th backend Z NUM_BACKENDS: 3
> 2007-11-22 15:53:07 DEBUG: pid 8737: read_kind_from_backend: read kind from
> 1 th backend Z NUM_BACKENDS: 3
> 2007-11-22 15:53:07 DEBUG: pid 8737: read_kind_from_backend: read kind from
> 2 th backend Z NUM_BACKENDS: 3
> 2007-11-22 15:53:07 DEBUG: pid 8737: pool_process_query: kind from backend:
> Z
> 2007-11-22 15:53:07 DEBUG: pid 8737: pool_read_message_length: slot: 0
> length: 5
> 2007-11-22 15:53:07 DEBUG: pid 8737: pool_read_message_length: slot: 1
> length: 5
> 2007-11-22 15:53:07 DEBUG: pid 8737: pool_read_message_length: slot: 2
> length: 5
> 2007-11-22 15:53:07 DEBUG: pid 8737: ReadyForQuery: message length: 5
> 2007-11-22 15:53:07 DEBUG: pid 8737: ReadyForQuery: transaction state: I
> 2007-11-22 15:53:07 DEBUG: pid 8737: pool_process_query: num_fds: 13
> 2007-11-22 15:53:07 DEBUG: pid 8758: pool_rewrite_stmt: XXX message_code 7
> 2007-11-22 15:53:07 DEBUG: pid 8758: pool_rewrite_stmt: XXX rule 704
> 2007-11-22 15:53:07 DEBUG: pid 8758: pool_process_query: num_fds: 13
> 2007-11-22 15:53:07 DEBUG: pid 8758: read kind from frontend Q(51)
> 2007-11-22 15:53:07 DEBUG: pid 8758: statement2: select * from shop_data
> where shop_area_number='1' order by r_datetime desc limit 5 offset 0
> 2007-11-22 15:53:07 DEBUG: pid 8758: OneNode_do_command: Query: SELECT *
> FROM dblink('host=localhost dbname=shop_db port=9999
> user=shop_db_admin','SELECT pool_parallel("select * from shop_data WHERE
> shop_area_number =''1''")') AS shop_data(shop_data_id integer,shop_commu_id
> integer,shop_area_number smallint,shop_cooking_number smallint,shop_notice
> character varying(50),shop_check text,shop_point1 smallint,shop_point2
> smallint,shop_point3 smallint,shop_explain1 text,shop_explain2
> text,shop_caption1 character varying(100),shop_caption2 character
> varying(100),shop_caption3 character varying(100),shop_caption4 character
> varying(100),shop_address text,shop_access text,shop_map text,shop_tel
> character varying(50),shop_fax character varying(50),shop_business_hours
> text,shop_regular_holiday character varying(100),shop_estimate character
> varying(50),shop_seat text,shop_maximum character
> varying(50),shop_parking_lot character varying(50),shop_card
> text,shop_service text,shop_web_site text,shop_mail_address character
> varying(100),image_filename1 text,image_filename2 text,image_filename3
> text,image_filename4 text,image_filename5 text,image_filename6
> text,image_width1 smallint,image_height1 smallint,image_width2
> smallint,image_height2 smallint,image_width3 smallint,image_height3
> smallint,image_width4 smallint,image_height4 smallint,image_width5
> smallint,image_height5 smallint,image_width6 smallint,image_height6
> smallint,r_datetime timestamp without time zone) ORDER BY r_datetime DESC
> OFFSET 0 LIMIT 5
> 2007-11-22 15:53:07 DEBUG: pid 8737: read kind from frontend X(58)
> 2007-11-22 15:53:07 DEBUG: pid 8737: statement2: RESET ALL
> 2007-11-22 15:53:07 DEBUG: pid 8737: pool_rewrite_stmt: XXX rule 743
> 2007-11-22 15:53:07 DEBUG: pid 8737: waiting for backend 0 completing the
> query
> 2007-11-22 15:53:07 DEBUG: pid 8761: I am 8761 accept fd 9
> 2007-11-22 15:53:07 DEBUG: pid 8761: Protocol Major: 3 Minor: 0 database:
> shop_db user: shop_db_admin
> 2007-11-22 15:53:07 DEBUG: pid 8761: pool_send_auth_ok: send pid 8888 to
> frontend
> 2007-11-22 15:53:07 DEBUG: pid 8761: select_load_balancing_node: selected
> backend id is 2
> 2007-11-22 15:53:07 DEBUG: pid 8761: pool_process_query: num_fds: 13
> 2007-11-22 15:53:07 DEBUG: pid 8761: read kind from frontend Q(51)
> 2007-11-22 15:53:07 DEBUG: pid 8761: statement2: SELECT
> pool_parallel("select * from shop_data WHERE shop_area_number ='1'")
> 2007-11-22 15:53:07 DEBUG: pid 8761: pool_parallel_query: 0 th FD_SET: 10
> 2007-11-22 15:53:07 DEBUG: pid 8761: pool_parallel_query: 1 th FD_SET: 11
> 2007-11-22 15:53:07 DEBUG: pid 8761: pool_parallel_query: 2 th FD_SET: 12
> 2007-11-22 15:53:07 DEBUG: pid 8761: pool_parallel_query: num_fds: 13
> 2007-11-22 15:53:07 DEBUG: pid 8761: read_kind_from_one_backend: read kind
> from 0 th backend T
> 2007-11-22 15:53:07 DEBUG: pid 8761: pool_parallel_exec: kind from backend:
> T
> 2007-11-22 15:53:07 DEBUG: pid 8761: pool_parallel_exec: dummy from backend:
> C
> 2007-11-22 15:53:07 DEBUG: pid 8761: read_kind_from_one_backend: read kind
> from 2 th backend T
> 2007-11-22 15:53:07 DEBUG: pid 8761: pool_parallel_exec: dummy kind from
> backend: T
> 2007-11-22 15:53:07 DEBUG: pid 8761: pool_parallel_exec: dummy from backend:
> C
> 2007-11-22 15:53:07 DEBUG: pid 8761: pool_parallel_query: 1 th FD_SET: 11
> 2007-11-22 15:53:07 DEBUG: pid 8761: pool_parallel_query: num_fds: 13
> 2007-11-22 15:53:07 DEBUG: pid 8761: read_kind_from_one_backend: read kind
> from 1 th backend T
> 2007-11-22 15:53:07 DEBUG: pid 8761: pool_parallel_exec: dummy kind from
> backend: T
> 2007-11-22 15:53:07 DEBUG: pid 8761: pool_parallel_exec: kind from backend:
> D
> 2007-11-22 15:53:07 DEBUG: pid 8761: pool_parallel_exec: kind from backend:
> C
> 2007-11-22 15:53:07 DEBUG: pid 8761: read_kind_from_backend: read kind from
> 0 th backend Z NUM_BACKENDS: 3
> 2007-11-22 15:53:07 DEBUG: pid 8761: read_kind_from_backend: read kind from
> 1 th backend Z NUM_BACKENDS: 3
> 2007-11-22 15:53:07 DEBUG: pid 8761: read_kind_from_backend: read kind from
> 2 th backend Z NUM_BACKENDS: 3
> 2007-11-22 15:53:07 DEBUG: pid 8761: pool_process_query: kind from backend:
> Z
> 2007-11-22 15:53:07 DEBUG: pid 8761: pool_read_message_length: slot: 0
> length: 5
> 2007-11-22 15:53:07 DEBUG: pid 8761: pool_read_message_length: slot: 1
> length: 5
> 2007-11-22 15:53:07 DEBUG: pid 8761: pool_read_message_length: slot: 2
> length: 5
> 2007-11-22 15:53:07 DEBUG: pid 8761: ReadyForQuery: message length: 5
> 2007-11-22 15:53:07 DEBUG: pid 8761: ReadyForQuery: transaction state: I
> 2007-11-22 15:53:07 DEBUG: pid 8761: pool_process_query: num_fds: 13
> 2007-11-22 15:53:07 DEBUG: pid 8761: read kind from frontend X(58)
> 2007-11-22 15:53:07 DEBUG: pid 8761: statement2: RESET ALL
> 2007-11-22 15:53:07 DEBUG: pid 8761: pool_rewrite_stmt: XXX rule 743
> 2007-11-22 15:53:07 DEBUG: pid 8761: waiting for backend 0 completing the
> query
> 2007-11-22 15:53:07 DEBUG: pid 8761: waiting for backend 1 completing the
> query
> 2007-11-22 15:53:07 DEBUG: pid 8758: pool_rewrite_stmt: XXX message_code 7
> 2007-11-22 15:53:07 DEBUG: pid 8758: pool_rewrite_stmt: XXX rule 704
> 2007-11-22 15:53:07 DEBUG: pid 8758: pool_process_query: num_fds: 13
> 2007-11-22 15:53:07 DEBUG: pid 8758: read kind from frontend X(58)
> 2007-11-22 15:53:07 DEBUG: pid 8758: statement2: RESET ALL
> 2007-11-22 15:53:07 DEBUG: pid 8758: pool_rewrite_stmt: XXX rule 743
> 2007-11-22 15:53:07 DEBUG: pid 8758: waiting for backend 0 completing the
> query
> 2007-11-22 15:53:07 DEBUG: pid 8761: waiting for backend 2 completing the
> query
> 2007-11-22 15:53:07 DEBUG: pid 8761: read_kind_from_backend: read kind from
> 0 th backend C NUM_BACKENDS: 3
> 2007-11-22 15:53:07 DEBUG: pid 8761: read_kind_from_backend: read kind from
> 1 th backend C NUM_BACKENDS: 3
> 2007-11-22 15:53:07 DEBUG: pid 8761: read_kind_from_backend: read kind from
> 2 th backend C NUM_BACKENDS: 3
> 2007-11-22 15:53:07 DEBUG: pid 8761: pool_process_query: kind from backend:
> C
> 2007-11-22 15:53:07 DEBUG: pid 8761: read_kind_from_backend: read kind from
> 0 th backend Z NUM_BACKENDS: 3
> 2007-11-22 15:53:07 DEBUG: pid 8761: read_kind_from_backend: read kind from
> 1 th backend Z NUM_BACKENDS: 3
> 2007-11-22 15:53:07 DEBUG: pid 8761: read_kind_from_backend: read kind from
> 2 th backend Z NUM_BACKENDS: 3
> 2007-11-22 15:53:07 DEBUG: pid 8761: pool_process_query: kind from backend:
> Z
> 2007-11-22 15:53:07 DEBUG: pid 8761: pool_read_message_length: slot: 0
> length: 5
> 2007-11-22 15:53:07 DEBUG: pid 8761: pool_read_message_length: slot: 1
> length: 5
> 2007-11-22 15:53:07 DEBUG: pid 8761: pool_read_message_length: slot: 2
> length: 5
> 2007-11-22 15:53:07 DEBUG: pid 8761: ReadyForQuery: message length: 5
> 2007-11-22 15:53:07 DEBUG: pid 8761: ReadyForQuery: transaction state: I
> 2007-11-22 15:53:07 DEBUG: pid 8761: statement2: SET SESSION AUTHORIZATION
> DEFAULT
> 2007-11-22 15:53:07 DEBUG: pid 8761: pool_rewrite_stmt: XXX rule 741
> 2007-11-22 15:53:07 DEBUG: pid 8761: waiting for backend 0 completing the
> query
> 2007-11-22 15:53:07 DEBUG: pid 8758: waiting for backend 1 completing the
> query
> 2007-11-22 15:53:07 DEBUG: pid 8761: waiting for backend 1 completing the
> query
> 2007-11-22 15:53:07 DEBUG: pid 8761: waiting for backend 2 completing the
> query
> 2007-11-22 15:53:07 DEBUG: pid 8761: read_kind_from_backend: read kind from
> 0 th backend S NUM_BACKENDS: 3
> 2007-11-22 15:53:07 DEBUG: pid 8761: read_kind_from_backend: read kind from
> 1 th backend S NUM_BACKENDS: 3
> 2007-11-22 15:53:07 DEBUG: pid 8761: read_kind_from_backend: read kind from
> 2 th backend S NUM_BACKENDS: 3
> 2007-11-22 15:53:07 DEBUG: pid 8761: pool_process_query: kind from backend:
> S
> 2007-11-22 15:53:07 DEBUG: pid 8761: pool_read_message_length2: master slot:
> 0 length: 21
> 2007-11-22 15:53:07 DEBUG: pid 8761: pool_read_message_length2: master slot:
> 1 length: 21
> 2007-11-22 15:53:07 DEBUG: pid 8761: pool_read_message_length2: master slot:
> 2 length: 21
> 2007-11-22 15:53:07 DEBUG: pid 8761: 0 th backend: name: is_superuser value:
> off
> 2007-11-22 15:53:07 DEBUG: pid 8761: 1 th backend: name: is_superuser value:
> off
> 2007-11-22 15:53:07 DEBUG: pid 8761: 2 th backend: name: is_superuser value:
> off
> 2007-11-22 15:53:07 DEBUG: pid 8761: read_kind_from_backend: read kind from
> 0 th backend S NUM_BACKENDS: 3
> 2007-11-22 15:53:07 DEBUG: pid 8761: read_kind_from_backend: read kind from
> 1 th backend S NUM_BACKENDS: 3
> 2007-11-22 15:53:07 DEBUG: pid 8761: read_kind_from_backend: read kind from
> 2 th backend S NUM_BACKENDS: 3
> 2007-11-22 15:53:07 DEBUG: pid 8761: pool_process_query: kind from backend:
> S
> 2007-11-22 15:53:07 DEBUG: pid 8761: pool_read_message_length2: master slot:
> 0 length: 32
> 2007-11-22 15:53:07 DEBUG: pid 8761: pool_read_message_length2: master slot:
> 1 length: 32
> 2007-11-22 15:53:07 DEBUG: pid 8761: pool_read_message_length2: master slot:
> 2 length: 32
> 2007-11-22 15:53:07 DEBUG: pid 8761: 0 th backend: name:
> session_authorization value: shop_db_admin
> 2007-11-22 15:53:07 DEBUG: pid 8761: 1 th backend: name:
> session_authorization value: shop_db_admin
> 2007-11-22 15:53:07 DEBUG: pid 8761: 2 th backend: name:
> session_authorization value: shop_db_admin
> 2007-11-22 15:53:07 DEBUG: pid 8761: read_kind_from_backend: read kind from
> 0 th backend C NUM_BACKENDS: 3
> 2007-11-22 15:53:07 DEBUG: pid 8761: read_kind_from_backend: read kind from
> 1 th backend C NUM_BACKENDS: 3
> 2007-11-22 15:53:07 DEBUG: pid 8761: read_kind_from_backend: read kind from
> 2 th backend C NUM_BACKENDS: 3
> 2007-11-22 15:53:07 DEBUG: pid 8761: pool_process_query: kind from backend:
> C
> 2007-11-22 15:53:07 DEBUG: pid 8761: read_kind_from_backend: read kind from
> 0 th backend Z NUM_BACKENDS: 3
> 2007-11-22 15:53:07 DEBUG: pid 8761: read_kind_from_backend: read kind from
> 1 th backend Z NUM_BACKENDS: 3
> 2007-11-22 15:53:07 DEBUG: pid 8761: read_kind_from_backend: read kind from
> 2 th backend Z NUM_BACKENDS: 3
> 2007-11-22 15:53:07 DEBUG: pid 8761: pool_process_query: kind from backend:
> Z
> 2007-11-22 15:53:07 DEBUG: pid 8761: pool_read_message_length: slot: 0
> length: 5
> 2007-11-22 15:53:07 DEBUG: pid 8761: pool_read_message_length: slot: 1
> length: 5
> 2007-11-22 15:53:07 DEBUG: pid 8761: pool_read_message_length: slot: 2
> length: 5
> 2007-11-22 15:53:07 DEBUG: pid 8761: ReadyForQuery: message length: 5
> 2007-11-22 15:53:07 DEBUG: pid 8761: ReadyForQuery: transaction state: I
> 2007-11-22 15:53:07 DEBUG: pid 8761: pool_connection_pool_timer: set close
> time 1195714387
> 2007-11-22 15:53:07 DEBUG: pid 8758: waiting for backend 2 completing the
> query
> 2007-11-22 15:53:07 DEBUG: pid 8758: read_kind_from_backend: read kind from
> 0 th backend C NUM_BACKENDS: 3
> 2007-11-22 15:53:07 DEBUG: pid 8758: read_kind_from_backend: read kind from
> 1 th backend C NUM_BACKENDS: 3
> 2007-11-22 15:53:07 DEBUG: pid 8758: read_kind_from_backend: read kind from
> 2 th backend C NUM_BACKENDS: 3
> 2007-11-22 15:53:07 DEBUG: pid 8758: pool_process_query: kind from backend:
> C
> 2007-11-22 15:53:07 DEBUG: pid 8758: read_kind_from_backend: read kind from
> 0 th backend Z NUM_BACKENDS: 3
> 2007-11-22 15:53:07 DEBUG: pid 8758: read_kind_from_backend: read kind from
> 1 th backend Z NUM_BACKENDS: 3
> 2007-11-22 15:53:07 DEBUG: pid 8758: read_kind_from_backend: read kind from
> 2 th backend Z NUM_BACKENDS: 3
> 2007-11-22 15:53:07 DEBUG: pid 8758: pool_process_query: kind from backend:
> Z
> 2007-11-22 15:53:07 DEBUG: pid 8758: pool_read_message_length: slot: 0
> length: 5
> 2007-11-22 15:53:07 DEBUG: pid 8758: pool_read_message_length: slot: 1
> length: 5
> 2007-11-22 15:53:07 DEBUG: pid 8758: pool_read_message_length: slot: 2
> length: 5
> 2007-11-22 15:53:07 DEBUG: pid 8758: ReadyForQuery: message length: 5
> 2007-11-22 15:53:07 DEBUG: pid 8758: ReadyForQuery: transaction state: I
> 2007-11-22 15:53:07 DEBUG: pid 8758: statement2: SET SESSION AUTHORIZATION
> DEFAULT
> 2007-11-22 15:53:07 DEBUG: pid 8758: pool_rewrite_stmt: XXX rule 741
> 2007-11-22 15:53:07 DEBUG: pid 8758: waiting for backend 0 completing the
> query
> 2007-11-22 15:53:07 DEBUG: pid 8758: waiting for backend 1 completing the
> query
> 2007-11-22 15:53:07 DEBUG: pid 8758: waiting for backend 2 completing the
> query
> 2007-11-22 15:53:07 DEBUG: pid 8758: read_kind_from_backend: read kind from
> 0 th backend S NUM_BACKENDS: 3
> 2007-11-22 15:53:07 DEBUG: pid 8758: read_kind_from_backend: read kind from
> 1 th backend S NUM_BACKENDS: 3
> 2007-11-22 15:53:07 DEBUG: pid 8758: read_kind_from_backend: read kind from
> 2 th backend S NUM_BACKENDS: 3
> 2007-11-22 15:53:07 DEBUG: pid 8758: pool_process_query: kind from backend:
> S
> 2007-11-22 15:53:07 DEBUG: pid 8758: pool_read_message_length2: master slot:
> 0 length: 21
> 2007-11-22 15:53:07 DEBUG: pid 8758: pool_read_message_length2: master slot:
> 1 length: 21
> 2007-11-22 15:53:07 DEBUG: pid 8758: pool_read_message_length2: master slot:
> 2 length: 21
> 2007-11-22 15:53:07 DEBUG: pid 8758: 0 th backend: name: is_superuser value:
> off
> 2007-11-22 15:53:07 DEBUG: pid 8758: 1 th backend: name: is_superuser value:
> off
> 2007-11-22 15:53:07 DEBUG: pid 8758: 2 th backend: name: is_superuser value:
> off
> 2007-11-22 15:53:07 DEBUG: pid 8758: read_kind_from_backend: read kind from
> 0 th backend S NUM_BACKENDS: 3
> 2007-11-22 15:53:07 DEBUG: pid 8758: read_kind_from_backend: read kind from
> 1 th backend S NUM_BACKENDS: 3
> 2007-11-22 15:53:07 DEBUG: pid 8758: read_kind_from_backend: read kind from
> 2 th backend S NUM_BACKENDS: 3
> 2007-11-22 15:53:07 DEBUG: pid 8758: pool_process_query: kind from backend:
> S
> 2007-11-22 15:53:07 DEBUG: pid 8758: pool_read_message_length2: master slot:
> 0 length: 32
> 2007-11-22 15:53:07 DEBUG: pid 8758: pool_read_message_length2: master slot:
> 1 length: 32
> 2007-11-22 15:53:07 DEBUG: pid 8758: pool_read_message_length2: master slot:
> 2 length: 32
> 2007-11-22 15:53:07 DEBUG: pid 8758: 0 th backend: name:
> session_authorization value: shop_db_admin
> 2007-11-22 15:53:07 DEBUG: pid 8758: 1 th backend: name:
> session_authorization value: shop_db_admin
> 2007-11-22 15:53:07 DEBUG: pid 8758: 2 th backend: name:
> session_authorization value: shop_db_admin
> 2007-11-22 15:53:07 DEBUG: pid 8758: read_kind_from_backend: read kind from
> 0 th backend C NUM_BACKENDS: 3
> 2007-11-22 15:53:07 DEBUG: pid 8758: read_kind_from_backend: read kind from
> 1 th backend C NUM_BACKENDS: 3
> 2007-11-22 15:53:07 DEBUG: pid 8758: read_kind_from_backend: read kind from
> 2 th backend C NUM_BACKENDS: 3
> 2007-11-22 15:53:07 DEBUG: pid 8758: pool_process_query: kind from backend:
> C
> 2007-11-22 15:53:07 DEBUG: pid 8758: read_kind_from_backend: read kind from
> 0 th backend Z NUM_BACKENDS: 3
> 2007-11-22 15:53:07 DEBUG: pid 8758: read_kind_from_backend: read kind from
> 1 th backend Z NUM_BACKENDS: 3
> 2007-11-22 15:53:07 DEBUG: pid 8758: read_kind_from_backend: read kind from
> 2 th backend Z NUM_BACKENDS: 3
> 2007-11-22 15:53:07 DEBUG: pid 8758: pool_process_query: kind from backend:
> Z
> 2007-11-22 15:53:07 DEBUG: pid 8758: pool_read_message_length: slot: 0
> length: 5
> 2007-11-22 15:53:07 DEBUG: pid 8758: pool_read_message_length: slot: 1
> length: 5
> 2007-11-22 15:53:07 DEBUG: pid 8758: pool_read_message_length: slot: 2
> length: 5
> 2007-11-22 15:53:07 DEBUG: pid 8758: ReadyForQuery: message length: 5
> 2007-11-22 15:53:07 DEBUG: pid 8758: ReadyForQuery: transaction state: I
> 2007-11-22 15:53:07 DEBUG: pid 8758: pool_connection_pool_timer: set close
> time 1195714387
> 2007-11-22 15:53:07 DEBUG: pid 8737: waiting for backend 1 completing the
> query
> 2007-11-22 15:53:07 DEBUG: pid 8737: waiting for backend 2 completing the
> query
> 2007-11-22 15:53:07 DEBUG: pid 8737: read_kind_from_backend: read kind from
> 0 th backend C NUM_BACKENDS: 3
> 2007-11-22 15:53:07 DEBUG: pid 8737: read_kind_from_backend: read kind from
> 1 th backend C NUM_BACKENDS: 3
> 2007-11-22 15:53:07 DEBUG: pid 8737: read_kind_from_backend: read kind from
> 2 th backend C NUM_BACKENDS: 3
> 2007-11-22 15:53:07 DEBUG: pid 8737: pool_process_query: kind from backend:
> C
> 2007-11-22 15:53:07 DEBUG: pid 8737: read_kind_from_backend: read kind from
> 0 th backend Z NUM_BACKENDS: 3
> 2007-11-22 15:53:07 DEBUG: pid 8737: read_kind_from_backend: read kind from
> 1 th backend Z NUM_BACKENDS: 3
> 2007-11-22 15:53:07 DEBUG: pid 8737: read_kind_from_backend: read kind from
> 2 th backend Z NUM_BACKENDS: 3
> 2007-11-22 15:53:07 DEBUG: pid 8737: pool_process_query: kind from backend:
> Z
> 2007-11-22 15:53:07 DEBUG: pid 8737: pool_read_message_length: slot: 0
> length: 5
> 2007-11-22 15:53:07 DEBUG: pid 8737: pool_read_message_length: slot: 1
> length: 5
> 2007-11-22 15:53:07 DEBUG: pid 8737: pool_read_message_length: slot: 2
> length: 5
> 2007-11-22 15:53:07 DEBUG: pid 8737: ReadyForQuery: message length: 5
> 2007-11-22 15:53:07 DEBUG: pid 8737: ReadyForQuery: transaction state: I
> 2007-11-22 15:53:07 DEBUG: pid 8737: statement2: SET SESSION AUTHORIZATION
> DEFAULT
> 2007-11-22 15:53:07 DEBUG: pid 8737: pool_rewrite_stmt: XXX rule 741
> 2007-11-22 15:53:07 DEBUG: pid 8737: waiting for backend 0 completing the
> query
> 2007-11-22 15:53:07 DEBUG: pid 8737: waiting for backend 1 completing the
> query
> 2007-11-22 15:53:07 DEBUG: pid 8737: waiting for backend 2 completing the
> query
> 2007-11-22 15:53:07 DEBUG: pid 8737: read_kind_from_backend: read kind from
> 0 th backend S NUM_BACKENDS: 3
> 2007-11-22 15:53:07 DEBUG: pid 8737: read_kind_from_backend: read kind from
> 1 th backend S NUM_BACKENDS: 3
> 2007-11-22 15:53:07 DEBUG: pid 8737: read_kind_from_backend: read kind from
> 2 th backend S NUM_BACKENDS: 3
> 2007-11-22 15:53:07 DEBUG: pid 8737: pool_process_query: kind from backend:
> S
> 2007-11-22 15:53:07 DEBUG: pid 8737: pool_read_message_length2: master slot:
> 0 length: 21
> 2007-11-22 15:53:07 DEBUG: pid 8737: pool_read_message_length2: master slot:
> 1 length: 21
> 2007-11-22 15:53:07 DEBUG: pid 8737: pool_read_message_length2: master slot:
> 2 length: 21
> 2007-11-22 15:53:07 DEBUG: pid 8737: 0 th backend: name: is_superuser value:
> off
> 2007-11-22 15:53:07 DEBUG: pid 8737: 1 th backend: name: is_superuser value:
> off
> 2007-11-22 15:53:07 DEBUG: pid 8737: 2 th backend: name: is_superuser value:
> off
> 2007-11-22 15:53:07 DEBUG: pid 8737: read_kind_from_backend: read kind from
> 0 th backend S NUM_BACKENDS: 3
> 2007-11-22 15:53:07 DEBUG: pid 8737: read_kind_from_backend: read kind from
> 1 th backend S NUM_BACKENDS: 3
> 2007-11-22 15:53:07 DEBUG: pid 8737: read_kind_from_backend: read kind from
> 2 th backend S NUM_BACKENDS: 3
> 2007-11-22 15:53:07 DEBUG: pid 8737: pool_process_query: kind from backend:
> S
> 2007-11-22 15:53:07 DEBUG: pid 8737: pool_read_message_length2: master slot:
> 0 length: 32
> 2007-11-22 15:53:07 DEBUG: pid 8737: pool_read_message_length2: master slot:
> 1 length: 32
> 2007-11-22 15:53:07 DEBUG: pid 8737: pool_read_message_length2: master slot:
> 2 length: 32
> 2007-11-22 15:53:07 DEBUG: pid 8737: 0 th backend: name:
> session_authorization value: shop_db_admin
> 2007-11-22 15:53:07 DEBUG: pid 8737: 1 th backend: name:
> session_authorization value: shop_db_admin
> 2007-11-22 15:53:07 DEBUG: pid 8737: 2 th backend: name:
> session_authorization value: shop_db_admin
> 2007-11-22 15:53:07 DEBUG: pid 8737: read_kind_from_backend: read kind from
> 0 th backend C NUM_BACKENDS: 3
> 2007-11-22 15:53:07 DEBUG: pid 8737: read_kind_from_backend: read kind from
> 1 th backend C NUM_BACKENDS: 3
> 2007-11-22 15:53:07 DEBUG: pid 8737: read_kind_from_backend: read kind from
> 2 th backend C NUM_BACKENDS: 3
> 2007-11-22 15:53:07 DEBUG: pid 8737: pool_process_query: kind from backend:
> C
> 2007-11-22 15:53:07 DEBUG: pid 8737: read_kind_from_backend: read kind from
> 0 th backend Z NUM_BACKENDS: 3
> 2007-11-22 15:53:07 DEBUG: pid 8737: read_kind_from_backend: read kind from
> 1 th backend Z NUM_BACKENDS: 3
> 2007-11-22 15:53:07 DEBUG: pid 8737: read_kind_from_backend: read kind from
> 2 th backend Z NUM_BACKENDS: 3
> 2007-11-22 15:53:07 DEBUG: pid 8737: pool_process_query: kind from backend:
> Z
> 2007-11-22 15:53:07 DEBUG: pid 8737: pool_read_message_length: slot: 0
> length: 5
> 2007-11-22 15:53:07 DEBUG: pid 8737: pool_read_message_length: slot: 1
> length: 5
> 2007-11-22 15:53:07 DEBUG: pid 8737: pool_read_message_length: slot: 2
> length: 5
> 2007-11-22 15:53:07 DEBUG: pid 8737: ReadyForQuery: message length: 5
> 2007-11-22 15:53:07 DEBUG: pid 8737: ReadyForQuery: transaction state: I
> 2007-11-22 15:53:07 DEBUG: pid 8737: pool_connection_pool_timer: set close
> time 1195714387
>
> ------------------
> 浅野
>
> asano ＠ engm.com
>
>
> _______________________________________________
> pgpool-general-jp mailing list
> pgpool-general-jp ＠ sraoss.jp
> http://www.sraoss.jp/mailman/listinfo/pgpool-general-jp
>
--
SRA OSS, Inc. 日本支社
Yoshiharu Mori <y-mori ＠ sraoss.co.jp>
http://www.sraoss.co.jp/
pgpool-general-jp メーリングリストの案内