[pgpool-general-jp: 33] Re: JDBCからpgpool-IIを経由してのpostgreSQL接続について

[高橋 浩之]

高橋です。

本日提供頂いたパッチを試した所、うまく動きました。
ご対応いただきありがとうございました。

ご参考までに成功時のログを添付いたします。


----postgreSQLのログ----

2006-11-15 15:29:42 JST myhost postgres[10937]: [1-1] LOG:  00000: statement: PREPARE <unnamed> AS SELECT * FROM test
2006-11-15 15:29:42 JST myhost postgres[10937]: [2-1] LOCATION:  exec_parse_message, postgres.c:1153
2006-11-15 15:29:42 JST myhost postgres[10937]: [3-1] LOG:  00000: statement: <BIND> 
2006-11-15 15:29:42 JST myhost postgres[10937]: [4-1] LOCATION:  exec_bind_message, postgres.c:1454
2006-11-15 15:29:42 JST myhost postgres[10937]: [5-1] LOG:  00000: statement: EXECUTE <unnamed>  [PREPARE:  SELECT * FROM test]
2006-11-15 15:29:42 JST myhost postgres[10937]: [6-1] LOCATION:  exec_execute_message, postgres.c:1720
2006-11-15 15:29:42 JST myhost postgres[10937]: [7-1] LOG:  00000: duration: 31.782 ms
2006-11-15 15:29:42 JST myhost postgres[10937]: [8-1] LOCATION:  exec_execute_message, postgres.c:1816
2006-11-15 15:29:42 JST myhost postgres[10937]: [9-1] LOG:  00000: statement:  RESET ALL
2006-11-15 15:29:42 JST myhost postgres[10937]: [10-1] LOCATION:  log_after_parse, postgres.c:605
2006-11-15 15:29:42 JST myhost postgres[10937]: [11-1] LOG:  00000: duration: 0.333 ms
2006-11-15 15:29:42 JST myhost postgres[10937]: [12-1] LOCATION:  exec_simple_query, postgres.c:1090
2006-11-15 15:29:42 JST myhost postgres[10937]: [13-1] LOG:  00000: statement:  SET SESSION AUTHORIZATION DEFAULT
2006-11-15 15:29:42 JST myhost postgres[10937]: [14-1] LOCATION:  log_after_parse, postgres.c:605
2006-11-15 15:29:42 JST myhost postgres[10937]: [15-1] LOG:  00000: duration: 0.203 ms
2006-11-15 15:29:42 JST myhost postgres[10937]: [16-1] LOCATION:  exec_simple_query, postgres.c:1090

----postgreSQLのログ ここまで----


----pgpool-IIのログ----

2006-11-15 15:29:41 DEBUG: pid 10836: I am 10836 accept fd 5
2006-11-15 15:29:41 DEBUG: pid 10836: Protocol Major: 3 Minor: 0 database: test user: postgres
2006-11-15 15:29:41 DEBUG: pid 10836: new_connection: connecting 0 backend
2006-11-15 15:29:42 DEBUG: pid 10836: pool_read_message_length: slot: 0 length: 8
2006-11-15 15:29:42 DEBUG: pid 10836: pool_read_message_length2: master slot: 0 length: 28
2006-11-15 15:29:42 DEBUG: pid 10836: 0 th backend: name: client_encoding value: UNICODE
2006-11-15 15:29:42 DEBUG: pid 10836: pool_read_message_length2: master slot: 0 length: 23
2006-11-15 15:29:42 DEBUG: pid 10836: 0 th backend: name: DateStyle value: ISO, MDY
2006-11-15 15:29:42 DEBUG: pid 10836: pool_read_message_length2: master slot: 0 length: 26
2006-11-15 15:29:42 DEBUG: pid 10836: 0 th backend: name: integer_datetimes value: off
2006-11-15 15:29:42 DEBUG: pid 10836: pool_read_message_length2: master slot: 0 length: 20
2006-11-15 15:29:42 DEBUG: pid 10836: 0 th backend: name: is_superuser value: on
2006-11-15 15:29:42 DEBUG: pid 10836: pool_read_message_length2: master slot: 0 length: 25
2006-11-15 15:29:42 DEBUG: pid 10836: 0 th backend: name: server_encoding value: UTF8
2006-11-15 15:29:42 DEBUG: pid 10836: pool_read_message_length2: master slot: 0 length: 25
2006-11-15 15:29:42 DEBUG: pid 10836: 0 th backend: name: server_version value: 8.1.4
2006-11-15 15:29:42 DEBUG: pid 10836: pool_read_message_length2: master slot: 0 length: 35
2006-11-15 15:29:42 DEBUG: pid 10836: 0 th backend: name: session_authorization value: postgres
2006-11-15 15:29:42 DEBUG: pid 10836: pool_read_message_length2: master slot: 0 length: 36
2006-11-15 15:29:42 DEBUG: pid 10836: 0 th backend: name: standard_conforming_strings value: off
2006-11-15 15:29:42 DEBUG: pid 10836: pool_read_message_length2: master slot: 0 length: 19
2006-11-15 15:29:42 DEBUG: pid 10836: 0 th backend: name: TimeZone value: Japan
2006-11-15 15:29:42 DEBUG: pid 10836: pool_read_message_length: slot: 0 length: 12
2006-11-15 15:29:42 DEBUG: pid 10836: pool_send_auth_ok: send pid 10937 to frontend
2006-11-15 15:29:42 DEBUG: pid 10836: read_kind_from_backend: read kind from 0 th backend Z NUM_BACKENDS: 1
2006-11-15 15:29:42 DEBUG: pid 10836: pool_process_query: kind from backend: Z
2006-11-15 15:29:42 DEBUG: pid 10836: pool_read_message_length: slot: 0 length: 5
2006-11-15 15:29:42 DEBUG: pid 10836: ReadyForQuery: message length: 5
2006-11-15 15:29:42 DEBUG: pid 10836: ReadyForQuery: transaction state: I
2006-11-15 15:29:42 DEBUG: pid 10836: pool_process_query: num_fds: 7
2006-11-15 15:29:42 DEBUG: pid 10836: read kind from frontend P(50)
2006-11-15 15:29:42 DEBUG: pid 10836: read kind from frontend B(42)
2006-11-15 15:29:42 DEBUG: pid 10836: read kind from frontend D(44)
2006-11-15 15:29:42 DEBUG: pid 10836: read kind from frontend E(45)
2006-11-15 15:29:42 DEBUG: pid 10836: Execute: portal name <>
2006-11-15 15:29:42 DEBUG: pid 10836: read kind from frontend S(53)
2006-11-15 15:29:42 DEBUG: pid 10836: read_kind_from_backend: read kind from 0 th backend N NUM_BACKENDS: 1
2006-11-15 15:29:42 DEBUG: pid 10836: pool_process_query: kind from backend: N
2006-11-15 15:29:42 DEBUG: pid 10836: pool_process_query: num_fds: 7
2006-11-15 15:29:42 DEBUG: pid 10836: read_kind_from_backend: read kind from 0 th backend Z NUM_BACKENDS: 1
2006-11-15 15:29:42 DEBUG: pid 10836: pool_process_query: kind from backend: Z
2006-11-15 15:29:42 DEBUG: pid 10836: pool_read_message_length: slot: 0 length: 5
2006-11-15 15:29:42 DEBUG: pid 10836: ReadyForQuery: message length: 5
2006-11-15 15:29:42 DEBUG: pid 10836: ReadyForQuery: transaction state: I
2006-11-15 15:29:42 DEBUG: pid 10836: pool_process_query: num_fds: 7
2006-11-15 15:29:42 DEBUG: pid 10836: read kind from frontend X(58)
2006-11-15 15:29:42 LOG:   pid 10836: statement:  RESET ALL
2006-11-15 15:29:42 DEBUG: pid 10836: waiting for backend 0 completing the query
2006-11-15 15:29:42 DEBUG: pid 10836: pool_process_query: num_fds: 7
2006-11-15 15:29:42 DEBUG: pid 10836: read_kind_from_backend: read kind from 0 th backend N NUM_BACKENDS: 1
2006-11-15 15:29:42 DEBUG: pid 10836: pool_process_query: kind from backend: N
2006-11-15 15:29:42 DEBUG: pid 10836: pool_process_query: num_fds: 7
2006-11-15 15:29:42 DEBUG: pid 10836: read_kind_from_backend: read kind from 0 th backend C NUM_BACKENDS: 1
2006-11-15 15:29:42 DEBUG: pid 10836: pool_process_query: kind from backend: C
2006-11-15 15:29:42 DEBUG: pid 10836: read_kind_from_backend: read kind from 0 th backend N NUM_BACKENDS: 1
2006-11-15 15:29:42 DEBUG: pid 10836: pool_process_query: kind from backend: N
2006-11-15 15:29:42 DEBUG: pid 10836: pool_process_query: num_fds: 7
2006-11-15 15:29:42 DEBUG: pid 10836: read_kind_from_backend: read kind from 0 th backend Z NUM_BACKENDS: 1
2006-11-15 15:29:42 DEBUG: pid 10836: pool_process_query: kind from backend: Z
2006-11-15 15:29:42 DEBUG: pid 10836: pool_read_message_length: slot: 0 length: 5
2006-11-15 15:29:42 DEBUG: pid 10836: ReadyForQuery: message length: 5
2006-11-15 15:29:42 DEBUG: pid 10836: ReadyForQuery: transaction state: I
2006-11-15 15:29:42 LOG:   pid 10836: statement:  SET SESSION AUTHORIZATION DEFAULT
2006-11-15 15:29:42 DEBUG: pid 10836: waiting for backend 0 completing the query
2006-11-15 15:29:42 DEBUG: pid 10836: pool_process_query: num_fds: 7
2006-11-15 15:29:42 DEBUG: pid 10836: read_kind_from_backend: read kind from 0 th backend N NUM_BACKENDS: 1
2006-11-15 15:29:42 DEBUG: pid 10836: pool_process_query: kind from backend: N
2006-11-15 15:29:42 DEBUG: pid 10836: pool_process_query: num_fds: 7
2006-11-15 15:29:42 DEBUG: pid 10836: read_kind_from_backend: read kind from 0 th backend S NUM_BACKENDS: 1
2006-11-15 15:29:42 DEBUG: pid 10836: pool_process_query: kind from backend: S
2006-11-15 15:29:42 DEBUG: pid 10836: pool_read_message_length2: master slot: 0 length: 20
2006-11-15 15:29:42 DEBUG: pid 10836: 0 th backend: name: is_superuser value: on
2006-11-15 15:29:42 DEBUG: pid 10836: read_kind_from_backend: read kind from 0 th backend S NUM_BACKENDS: 1
2006-11-15 15:29:42 DEBUG: pid 10836: pool_process_query: kind from backend: S
2006-11-15 15:29:42 DEBUG: pid 10836: pool_read_message_length2: master slot: 0 length: 35
2006-11-15 15:29:42 DEBUG: pid 10836: 0 th backend: name: session_authorization value: postgres
2006-11-15 15:29:42 DEBUG: pid 10836: read_kind_from_backend: read kind from 0 th backend C NUM_BACKENDS: 1
2006-11-15 15:29:42 DEBUG: pid 10836: pool_process_query: kind from backend: C
2006-11-15 15:29:42 DEBUG: pid 10836: read_kind_from_backend: read kind from 0 th backend N NUM_BACKENDS: 1
2006-11-15 15:29:42 DEBUG: pid 10836: pool_process_query: kind from backend: N
2006-11-15 15:29:42 DEBUG: pid 10836: pool_process_query: num_fds: 7
2006-11-15 15:29:42 DEBUG: pid 10836: read_kind_from_backend: read kind from 0 th backend Z NUM_BACKENDS: 1
2006-11-15 15:29:42 DEBUG: pid 10836: pool_process_query: kind from backend: Z
2006-11-15 15:29:42 DEBUG: pid 10836: pool_read_message_length: slot: 0 length: 5
2006-11-15 15:29:42 DEBUG: pid 10836: ReadyForQuery: message length: 5
2006-11-15 15:29:42 DEBUG: pid 10836: ReadyForQuery: transaction state: I
2006-11-15 15:29:42 DEBUG: pid 10836: pool_connection_pool_timer: set close time 1163572182

----pgpool-IIのログ ここまで----