[pgsql-jp: 38961] Re: pgpool-II 2.0 リリース
skond66 ＠ mail.goo.ne.jp
skond66 ＠ mail.goo.ne.jp
2007年 11月 21日 (水) 15:52:38 JST
ちょっとさきほどとは環境が違いますが、同様に update がうまくいかない時の
ログです。 centos 4.3 postgreSQL 8.1.4
update だけでなく、delete も同様に失敗します。
DB構成は ローカルのDBが1つのみ。ユーザは初期の postgres test DBを使用。
psql test と直接入ると update も普通にできます。psql -p 9999 test だと
失敗します。
＜update の時＞
2007-11-21 15:35:49 DEBUG: pid 12829: read kind from frontend Q(51)
2007-11-21 15:35:49 LOG: pid 12829: statement: update tmp set a = '333';
2007-11-21 15:35:49 DEBUG: pid 12791: reap_handler called
2007-11-21 15:35:49 DEBUG: pid 12791: reap_handler: call wait3
2007-11-21 15:35:49 DEBUG: pid 12791: child 12829 exits with status 11 by signal
11
2007-11-21 15:35:49 DEBUG: pid 12831: I am 12831 accept fd 5
2007-11-21 15:35:49 LOG: pid 12831: connection received: host=[local]
2007-11-21 15:35:49 DEBUG: pid 12831: Protocol Major: 3 Minor: 0 database: test
user: postgres
2007-11-21 15:35:49 DEBUG: pid 12831: new_connection: connecting 0 backend
2007-11-21 15:35:49 DEBUG: pid 12833: I am 12833
2007-11-21 15:35:49 DEBUG: pid 12791: fork a new child pid 12833
2007-11-21 15:35:49 DEBUG: pid 12791: reap_handler: normally exited
2007-11-21 15:35:49 DEBUG: pid 12831: pool_read_message_length: slot: 0 length:
8
2007-11-21 15:35:49 DEBUG: pid 12831: pool_read_message_length2: master slot: 0
length: 25
2007-11-21 15:35:49 DEBUG: pid 12831: 0 th backend: name: client_encoding value:
UTF8
2007-11-21 15:35:49 DEBUG: pid 12831: pool_read_message_length2: master slot: 0
length: 23
2007-11-21 15:35:49 DEBUG: pid 12831: 0 th backend: name: DateStyle value: ISO,
MDY
2007-11-21 15:35:49 DEBUG: pid 12831: pool_read_message_length2: master slot: 0
length: 26
2007-11-21 15:35:49 DEBUG: pid 12831: 0 th backend: name: integer_datetimes valu
e: off
2007-11-21 15:35:49 DEBUG: pid 12831: pool_read_message_length2: master slot: 0
length: 20
2007-11-21 15:35:49 DEBUG: pid 12831: 0 th backend: name: is_superuser value: on
2007-11-21 15:35:49 DEBUG: pid 12831: pool_read_message_length2: master slot: 0
length: 25
2007-11-21 15:35:49 DEBUG: pid 12831: 0 th backend: name: server_encoding value:
UTF8
2007-11-21 15:35:49 DEBUG: pid 12831: pool_read_message_length2: master slot: 0
length: 25
2007-11-21 15:35:49 DEBUG: pid 12831: 0 th backend: name: server_version value:
8.1.4
2007-11-21 15:35:49 DEBUG: pid 12831: pool_read_message_length2: master slot: 0
length: 35
2007-11-21 15:35:49 DEBUG: pid 12831: 0 th backend: name: session_authorizationvalue: postgr
es
2007-11-21 15:35:49 DEBUG: pid 12831: pool_read_message_length2: master slot: 0length: 36
2007-11-21 15:35:49 DEBUG: pid 12831: 0 th backend: name: standard_conforming_strings value:
off
2007-11-21 15:35:49 DEBUG: pid 12831: pool_read_message_length2: master slot: 0length: 19
2007-11-21 15:35:49 DEBUG: pid 12831: 0 th backend: name: TimeZone value: Japan
2007-11-21 15:35:49 DEBUG: pid 12831: pool_read_message_length: slot: 0 length:12
2007-11-21 15:35:49 DEBUG: pid 12831: pool_send_auth_ok: send pid 12834 to frontend
2007-11-21 15:35:49 DEBUG: pid 12831: select_load_balancing_node: selected backend id is 0
2007-11-21 15:35:49 DEBUG: pid 12831: read_kind_from_backend: read kind from 0 th backend Z
NUM_BACKENDS: 1
2007-11-21 15:35:49 DEBUG: pid 12831: pool_process_query: kind from backend: Z
2007-11-21 15:35:49 DEBUG: pid 12831: pool_read_message_length: slot: 0 length:
＜起動時＞
[etc]# pgpool -n -d
2007-11-21 15:35:02 DEBUG: pid 12791: key: listen_addresses
2007-11-21 15:35:02 DEBUG: pid 12791: value: 'localhost' kind: 4
2007-11-21 15:35:02 DEBUG: pid 12791: key: port
2007-11-21 15:35:02 DEBUG: pid 12791: value: 9999 kind: 2
2007-11-21 15:35:02 DEBUG: pid 12791: key: pcp_port
2007-11-21 15:35:02 DEBUG: pid 12791: value: 9898 kind: 2
2007-11-21 15:35:02 DEBUG: pid 12791: key: socket_dir
2007-11-21 15:35:02 DEBUG: pid 12791: value: '/tmp' kind: 4
2007-11-21 15:35:02 DEBUG: pid 12791: key: pcp_socket_dir
2007-11-21 15:35:02 DEBUG: pid 12791: value: '/tmp' kind: 4
2007-11-21 15:35:02 DEBUG: pid 12791: key: backend_socket_dir
2007-11-21 15:35:02 DEBUG: pid 12791: value: '/tmp' kind: 4
2007-11-21 15:35:02 DEBUG: pid 12791: key: pcp_timeout
2007-11-21 15:35:02 DEBUG: pid 12791: value: 10 kind: 2
2007-11-21 15:35:02 DEBUG: pid 12791: key: num_init_children
2007-11-21 15:35:02 DEBUG: pid 12791: value: 32 kind: 2
2007-11-21 15:35:02 DEBUG: pid 12791: key: max_pool
2007-11-21 15:35:02 DEBUG: pid 12791: value: 4 kind: 2
2007-11-21 15:35:02 DEBUG: pid 12791: key: child_life_time
2007-11-21 15:35:02 DEBUG: pid 12791: value: 300 kind: 2
2007-11-21 15:35:02 DEBUG: pid 12791: key: connection_life_time
2007-11-21 15:35:02 DEBUG: pid 12791: value: 0 kind: 2
2007-11-21 15:35:02 DEBUG: pid 12791: key: child_max_connections
2007-11-21 15:35:02 DEBUG: pid 12791: value: 0 kind: 2
2007-11-21 15:35:02 DEBUG: pid 12791: key: client_idle_limit
2007-11-21 15:35:02 DEBUG: pid 12791: value: 0 kind: 2
2007-11-21 15:35:02 DEBUG: pid 12791: key: authentication_timeout
2007-11-21 15:35:02 DEBUG: pid 12791: value: 60 kind: 2
2007-11-21 15:35:02 DEBUG: pid 12791: key: logdir
2007-11-21 15:35:02 DEBUG: pid 12791: value: '/tmp' kind: 4
2007-11-21 15:35:02 DEBUG: pid 12791: key: replication_mode
2007-11-21 15:35:02 DEBUG: pid 12791: value: true kind: 1
2007-11-21 15:35:02 DEBUG: pid 12791: key: replication_timeout
2007-11-21 15:35:02 DEBUG: pid 12791: value: 5000 kind: 2
2007-11-21 15:35:02 DEBUG: pid 12791: key: load_balance_mode
2007-11-21 15:35:02 DEBUG: pid 12791: value: true kind: 1
2007-11-21 15:35:02 DEBUG: pid 12791: key: replication_stop_on_mismatch
2007-11-21 15:35:02 DEBUG: pid 12791: value: false kind: 1
2007-11-21 15:35:02 DEBUG: pid 12791: replication_stop_on_mismatch: 0
2007-11-21 15:35:02 DEBUG: pid 12791: key: replicate_select
2007-11-21 15:35:02 DEBUG: pid 12791: value: true kind: 1
2007-11-21 15:35:02 DEBUG: pid 12791: key: reset_query_list
2007-11-21 15:35:02 DEBUG: pid 12791: value: 'ABORT; RESET ALL; SET SESSION AUTH
ORIZATION DEFAULT' kind: 4
2007-11-21 15:35:02 DEBUG: pid 12791: extract_string_tokens: token: ABORT
2007-11-21 15:35:02 DEBUG: pid 12791: extract_string_tokens: token: RESET ALL
2007-11-21 15:35:02 DEBUG: pid 12791: extract_string_tokens: token: SET SESSION
AUTHORIZATION DEFAULT
2007-11-21 15:35:02 DEBUG: pid 12791: key: print_timestamp
2007-11-21 15:35:02 DEBUG: pid 12791: value: true kind: 1
2007-11-21 15:35:02 DEBUG: pid 12791: key: master_slave_mode
2007-11-21 15:35:02 DEBUG: pid 12791: value: false kind: 1
2007-11-21 15:35:02 DEBUG: pid 12791: key: connection_cache
2007-11-21 15:35:02 DEBUG: pid 12791: value: true kind: 1
2007-11-21 15:35:02 DEBUG: pid 12791: key: health_check_timeout
2007-11-21 15:35:02 DEBUG: pid 12791: value: 20 kind: 2
2007-11-21 15:35:02 DEBUG: pid 12791: key: health_check_period
2007-11-21 15:35:02 DEBUG: pid 12791: value: 0 kind: 2
2007-11-21 15:35:02 DEBUG: pid 12791: key: health_check_user
2007-11-21 15:35:02 DEBUG: pid 12791: value: 'nobody' kind: 4
2007-11-21 15:35:02 DEBUG: pid 12791: key: failover_command
2007-11-21 15:35:02 DEBUG: pid 12791: value: '' kind: 4
2007-11-21 15:35:02 DEBUG: pid 12791: key: failback_command
2007-11-21 15:35:02 DEBUG: pid 12791: value: '' kind: 4
2007-11-21 15:35:02 DEBUG: pid 12791: key: insert_lock
2007-11-21 15:35:02 DEBUG: pid 12791: value: false kind: 1
2007-11-21 15:35:02 DEBUG: pid 12791: key: ignore_leading_white_space
2007-11-21 15:35:02 DEBUG: pid 12791: value: true kind: 1
2007-11-21 15:35:02 DEBUG: pid 12791: key: log_statement
2007-11-21 15:35:02 DEBUG: pid 12791: value: true kind: 1
2007-11-21 15:35:02 DEBUG: pid 12791: key: log_connections
2007-11-21 15:35:02 DEBUG: pid 12791: value: true kind: 1
2007-11-21 15:35:02 DEBUG: pid 12791: key: log_hostname
2007-11-21 15:35:02 DEBUG: pid 12791: value: false kind: 1
2007-11-21 15:35:02 DEBUG: pid 12791: key: parallel_mode
2007-11-21 15:35:02 DEBUG: pid 12791: value: false kind: 1
2007-11-21 15:35:02 DEBUG: pid 12791: key: enable_query_cache
2007-11-21 15:35:02 DEBUG: pid 12791: value: false kind: 1
2007-11-21 15:35:02 DEBUG: pid 12791: key: pgpool2_hostname
2007-11-21 15:35:02 DEBUG: pid 12791: value: '' kind: 4
2007-11-21 15:35:02 DEBUG: pid 12791: key: system_db_hostname
2007-11-21 15:35:02 DEBUG: pid 12791: value: 'localhost' kind: 4
2007-11-21 15:35:02 DEBUG: pid 12791: key: system_db_port
2007-11-21 15:35:02 DEBUG: pid 12791: value: 5432 kind: 2
2007-11-21 15:35:02 DEBUG: pid 12791: key: system_db_dbname
2007-11-21 15:35:02 DEBUG: pid 12791: value: 'pgpool' kind: 4
2007-11-21 15:35:02 DEBUG: pid 12791: key: system_db_schema
2007-11-21 15:35:02 DEBUG: pid 12791: value: 'pgpool_catalog' kind: 4
2007-11-21 15:35:02 DEBUG: pid 12791: key: system_db_user
2007-11-21 15:35:02 DEBUG: pid 12791: value: 'pgpool' kind: 4
2007-11-21 15:35:02 DEBUG: pid 12791: key: system_db_password
2007-11-21 15:35:02 DEBUG: pid 12791: value: '' kind: 4
2007-11-21 15:35:02 DEBUG: pid 12791: key: backend_hostname0
2007-11-21 15:35:02 DEBUG: pid 12791: value: 'localhost' kind: 4
2007-11-21 15:35:02 DEBUG: pid 12791: key: backend_port0
2007-11-21 15:35:02 DEBUG: pid 12791: value: 5432 kind: 2
2007-11-21 15:35:02 DEBUG: pid 12791: pool_config: port slot number 0
2007-11-21 15:35:02 DEBUG: pid 12791: key: backend_weight0
2007-11-21 15:35:02 DEBUG: pid 12791: value: 1 kind: 2
2007-11-21 15:35:02 DEBUG: pid 12791: pool_config: weight slot number 0 weight:
1.000000
2007-11-21 15:35:02 DEBUG: pid 12791: key: backend_data_directory0
2007-11-21 15:35:02 DEBUG: pid 12791: value: '/data' kind: 4
2007-11-21 15:35:02 DEBUG: pid 12791: key: enable_pool_hba
2007-11-21 15:35:02 DEBUG: pid 12791: value: false kind: 1
2007-11-21 15:35:02 DEBUG: pid 12791: key: recovery_user
2007-11-21 15:35:02 DEBUG: pid 12791: value: 'nobody' kind: 4
2007-11-21 15:35:02 DEBUG: pid 12791: key: recovery_password
2007-11-21 15:35:02 DEBUG: pid 12791: value: '' kind: 4
2007-11-21 15:35:02 DEBUG: pid 12791: key: recovery_1st_stage_command
2007-11-21 15:35:02 DEBUG: pid 12791: value: '' kind: 4
2007-11-21 15:35:02 DEBUG: pid 12791: key: recovery_2nd_stage_command
2007-11-21 15:35:02 DEBUG: pid 12791: value: '' kind: 4
2007-11-21 15:35:02 DEBUG: pid 12791: num_backends: 1 num_backends: 1 total_weig
ht: 1.000000
2007-11-21 15:35:02 DEBUG: pid 12791: backend 0 weight: 2147483647.000000
2007-11-21 15:35:02 DEBUG: pid 12792: I am 12792
2007-11-21 15:35:02 DEBUG: pid 12793: I am 12793
2007-11-21 15:35:02 DEBUG: pid 12794: I am 12794
2007-11-21 15:35:02 DEBUG: pid 12795: I am 12795
2007-11-21 15:35:02 DEBUG: pid 12797: I am 12797
2007-11-21 15:35:02 DEBUG: pid 12798: I am 12798
2007-11-21 15:35:02 DEBUG: pid 12799: I am 12799
2007-11-21 15:35:02 DEBUG: pid 12800: I am 12800
2007-11-21 15:35:02 DEBUG: pid 12801: I am 12801
2007-11-21 15:35:02 DEBUG: pid 12802: I am 12802
2007-11-21 15:35:02 DEBUG: pid 12796: I am 12796
2007-11-21 15:35:02 DEBUG: pid 12804: I am 12804
2007-11-21 15:35:02 DEBUG: pid 12805: I am 12805
2007-11-21 15:35:02 DEBUG: pid 12806: I am 12806
2007-11-21 15:35:02 DEBUG: pid 12807: I am 12807
2007-11-21 15:35:02 DEBUG: pid 12808: I am 12808
2007-11-21 15:35:02 DEBUG: pid 12809: I am 12809
2007-11-21 15:35:02 DEBUG: pid 12803: I am 12803
2007-11-21 15:35:02 DEBUG: pid 12810: I am 12810
2007-11-21 15:35:02 DEBUG: pid 12811: I am 12811
2007-11-21 15:35:02 DEBUG: pid 12812: I am 12812
2007-11-21 15:35:02 DEBUG: pid 12813: I am 12813
2007-11-21 15:35:02 DEBUG: pid 12814: I am 12814
2007-11-21 15:35:02 DEBUG: pid 12815: I am 12815
2007-11-21 15:35:02 DEBUG: pid 12816: I am 12816
2007-11-21 15:35:02 DEBUG: pid 12817: I am 12817
2007-11-21 15:35:02 DEBUG: pid 12818: I am 12818
2007-11-21 15:35:02 DEBUG: pid 12819: I am 12819
2007-11-21 15:35:02 DEBUG: pid 12820: I am 12820
2007-11-21 15:35:02 DEBUG: pid 12821: I am 12821
2007-11-21 15:35:02 DEBUG: pid 12822: I am 12822
2007-11-21 15:35:02 LOG: pid 12791: pgpool successfully started
2007-11-21 15:35:02 DEBUG: pid 12824: I am PCP 12824
2007-11-21 15:35:02 DEBUG: pid 12823: I am 12823
2007-11-21 15:35:07 DEBUG: pid 12823: I am 12823 accept fd 0
2007-11-21 15:35:07 LOG: pid 12823: connection received: host=[local]
2007-11-21 15:35:07 DEBUG: pid 12823: Protocol Major: 3 Minor: 0 database: test
user: postgres
2007-11-21 15:35:07 DEBUG: pid 12823: new_connection: connecting 0 backend
2007-11-21 15:35:07 DEBUG: pid 12823: pool_read_message_length: slot: 0 length:
8
2007-11-21 15:35:07 DEBUG: pid 12823: pool_read_message_length2: master slot: 0
length: 25
2007-11-21 15:35:07 DEBUG: pid 12823: 0 th backend: name: client_encoding value:
UTF8
2007-11-21 15:35:07 DEBUG: pid 12823: pool_read_message_length2: master slot: 0
length: 23
2007-11-21 15:35:07 DEBUG: pid 12823: 0 th backend: name: DateStyle value: ISO,
MDY
2007-11-21 15:35:07 DEBUG: pid 12823: pool_read_message_length2: master slot: 0
length: 26
2007-11-21 15:35:07 DEBUG: pid 12823: 0 th backend: name: integer_datetimes valu
e: off
2007-11-21 15:35:07 DEBUG: pid 12823: pool_read_message_length2: master slot: 0
length: 20
2007-11-21 15:35:07 DEBUG: pid 12823: 0 th backend: name: is_superuser value: on
2007-11-21 15:35:07 DEBUG: pid 12823: pool_read_message_length2: master slot: 0
length: 25
2007-11-21 15:35:07 DEBUG: pid 12823: 0 th backend: name: server_encoding value:
UTF8
2007-11-21 15:35:07 DEBUG: pid 12823: pool_read_message_length2: master slot: 0
length: 25
2007-11-21 15:35:07 DEBUG: pid 12823: 0 th backend: name: server_version value:
8.1.4
2007-11-21 15:35:07 DEBUG: pid 12823: pool_read_message_length2: master slot: 0
length: 35
2007-11-21 15:35:07 DEBUG: pid 12823: 0 th backend: name: session_authorization
value: postgres
2007-11-21 15:35:07 DEBUG: pid 12823: pool_read_message_length2: master slot: 0
length: 36
2007-11-21 15:35:07 DEBUG: pid 12823: 0 th backend: name: standard_conforming_st
rings value: off
2007-11-21 15:35:07 DEBUG: pid 12823: pool_read_message_length2: master slot: 0
length: 19
2007-11-21 15:35:07 DEBUG: pid 12823: 0 th backend: name: TimeZone value: Japan
2007-11-21 15:35:07 DEBUG: pid 12823: pool_read_message_length: slot: 0 length:
12
2007-11-21 15:35:07 DEBUG: pid 12823: pool_send_auth_ok: send pid 12828 to front
end
2007-11-21 15:35:07 DEBUG: pid 12823: select_load_balancing_node: selected backe
nd id is 0
2007-11-21 15:35:07 DEBUG: pid 12823: read_kind_from_backend: read kind from 0 t
h backend Z NUM_BACKENDS: 1
2007-11-21 15:35:07 DEBUG: pid 12823: pool_process_query: kind from backend: Z
2007-11-21 15:35:07 DEBUG: pid 12823: pool_read_message_length: slot: 0 length:
5
2007-11-21 15:35:07 DEBUG: pid 12823: ReadyForQuery: message length: 5
2007-11-21 15:35:07 DEBUG: pid 12823: ReadyForQuery: transaction state: I
20
<insert の時＞
2007-11-21 15:50:05 DEBUG: pid 12851: read kind from frontend Q(51)
2007-11-21 15:50:05 LOG: pid 12851: statement: insert into tmp VALUES ('999',4);
2007-11-21 15:50:05 DEBUG: pid 12851: do_command: Query: BEGIN
2007-11-21 15:50:05 DEBUG: pid 12851: command tag: BEGIN
2007-11-21 15:50:05 DEBUG: pid 12851: ReadyForQuery: transaction state: T
2007-11-21 15:50:05 DEBUG: pid 12851: waiting for backend 0 completing the query
2007-11-21 15:50:05 DEBUG: pid 12851: read_kind_from_backend: read kind from 0 th backend C
NUM_BACKENDS: 1
2007-11-21 15:50:05 DEBUG: pid 12851: pool_process_query: kind from backend: C
2007-11-21 15:50:05 DEBUG: pid 12851: read_kind_from_backend: read kind from 0 th backend Z
NUM_BACKENDS: 1
2007-11-21 15:50:05 DEBUG: pid 12851: pool_process_query: kind from backend: Z
2007-11-21 15:50:05 DEBUG: pid 12851: pool_read_message_length: slot: 0 length: 5
2007-11-21 15:50:05 DEBUG: pid 12851: ReadyForQuery: message length: 5
2007-11-21 15:50:05 DEBUG: pid 12851: ReadyForQuery: transaction state: T
2007-11-21 15:50:05 DEBUG: pid 12851: do_command: Query: COMMIT
2007-11-21 15:50:05 DEBUG: pid 12851: command tag: COMMIT
2007-11-21 15:50:05 DEBUG: pid 12851: pool_read_message_length: slot: 0 length: 5
2007-11-21 15:50:05 DEBUG: pid 12851: ReadyForQuery: message length: 5
2007-11-21 15:50:05 DEBUG: pid 12851: ReadyForQuery: transaction state: I
よろしくお願いいたします。
pgsql-jp メーリングリストの案内