[pgpool-general-jp: 808] Re: pgpool-II 3.0 でのnextval でエラー
松山大樹
t.matsuyama ＠ wowcom.co.jp
2010年 9月 27日 (月) 12:50:21 JST
松山です。
これでよろしいでしょうか。
------------------------------------------------------------------
2010-09-27 12:48:23 DEBUG: pid 23099: key: listen_addresses
2010-09-27 12:48:23 DEBUG: pid 23099: value: '*' kind: 4
2010-09-27 12:48:23 DEBUG: pid 23099: key: port
2010-09-27 12:48:23 DEBUG: pid 23099: value: 9999 kind: 2
2010-09-27 12:48:23 DEBUG: pid 23099: key: pcp_port
2010-09-27 12:48:23 DEBUG: pid 23099: value: 9898 kind: 2
2010-09-27 12:48:23 DEBUG: pid 23099: key: socket_dir
2010-09-27 12:48:23 DEBUG: pid 23099: value: '/tmp' kind: 4
2010-09-27 12:48:23 DEBUG: pid 23099: key: pcp_socket_dir
2010-09-27 12:48:23 DEBUG: pid 23099: value: '/tmp' kind: 4
2010-09-27 12:48:23 DEBUG: pid 23099: key: backend_socket_dir
2010-09-27 12:48:23 DEBUG: pid 23099: value: '/tmp' kind: 4
2010-09-27 12:48:23 DEBUG: pid 23099: key: pcp_timeout
2010-09-27 12:48:23 DEBUG: pid 23099: value: 10 kind: 2
2010-09-27 12:48:23 DEBUG: pid 23099: key: num_init_children
2010-09-27 12:48:23 DEBUG: pid 23099: value: 32 kind: 2
2010-09-27 12:48:23 DEBUG: pid 23099: key: max_pool
2010-09-27 12:48:23 DEBUG: pid 23099: value: 4 kind: 2
2010-09-27 12:48:23 DEBUG: pid 23099: key: child_life_time
2010-09-27 12:48:23 DEBUG: pid 23099: value: 300 kind: 2
2010-09-27 12:48:23 DEBUG: pid 23099: key: connection_life_time
2010-09-27 12:48:23 DEBUG: pid 23099: value: 0 kind: 2
2010-09-27 12:48:23 DEBUG: pid 23099: key: child_max_connections
2010-09-27 12:48:23 DEBUG: pid 23099: value: 0 kind: 2
2010-09-27 12:48:23 DEBUG: pid 23099: key: client_idle_limit
2010-09-27 12:48:23 DEBUG: pid 23099: value: 0 kind: 2
2010-09-27 12:48:23 DEBUG: pid 23099: key: authentication_timeout
2010-09-27 12:48:23 DEBUG: pid 23099: value: 60 kind: 2
2010-09-27 12:48:23 DEBUG: pid 23099: key: logdir
2010-09-27 12:48:23 DEBUG: pid 23099: value: '/usr/local/pgpool2/logs'
kind: 4
2010-09-27 12:48:23 DEBUG: pid 23099: key: pid_file_name
2010-09-27 12:48:23 DEBUG: pid 23099: value:
'/usr/local/pgpool2/etc/pgpool.pid' kind: 4
2010-09-27 12:48:23 DEBUG: pid 23099: key: replication_mode
2010-09-27 12:48:23 DEBUG: pid 23099: value: true kind: 1
2010-09-27 12:48:23 DEBUG: pid 23099: key: load_balance_mode
2010-09-27 12:48:23 DEBUG: pid 23099: value: true kind: 1
2010-09-27 12:48:23 DEBUG: pid 23099: key: replication_stop_on_mismatch
2010-09-27 12:48:23 DEBUG: pid 23099: value: false kind: 1
2010-09-27 12:48:23 DEBUG: pid 23099: replication_stop_on_mismatch: 0
2010-09-27 12:48:23 DEBUG: pid 23099: key:
failover_if_affected_tuples_mismatch
2010-09-27 12:48:23 DEBUG: pid 23099: value: false kind: 1
2010-09-27 12:48:23 DEBUG: pid 23099:
failover_if_affected_tuples_mismatch: 0
2010-09-27 12:48:23 DEBUG: pid 23099: key: replicate_select
2010-09-27 12:48:23 DEBUG: pid 23099: value: false kind: 1
2010-09-27 12:48:23 DEBUG: pid 23099: replicate_select: 0
2010-09-27 12:48:23 DEBUG: pid 23099: key: reset_query_list
2010-09-27 12:48:23 DEBUG: pid 23099: value: 'ABORT; DISCARD ALL' kind: 4
2010-09-27 12:48:23 DEBUG: pid 23099: extract_string_tokens: token: ABORT
2010-09-27 12:48:23 DEBUG: pid 23099: extract_string_tokens: token:
DISCARD ALL
2010-09-27 12:48:23 DEBUG: pid 23099: key: white_function_list
2010-09-27 12:48:23 DEBUG: pid 23099: value: '' kind: 4
2010-09-27 12:48:23 DEBUG: pid 23099: key: black_function_list
2010-09-27 12:48:23 DEBUG: pid 23099: value: 'nextval,setval' kind: 4
2010-09-27 12:48:23 DEBUG: pid 23099: extract_string_tokens: token: nextval
2010-09-27 12:48:23 DEBUG: pid 23099: extract_string_tokens: token: setval
2010-09-27 12:48:23 DEBUG: pid 23099: key: print_timestamp
2010-09-27 12:48:23 DEBUG: pid 23099: value: true kind: 1
2010-09-27 12:48:23 DEBUG: pid 23099: key: master_slave_mode
2010-09-27 12:48:23 DEBUG: pid 23099: value: false kind: 1
2010-09-27 12:48:23 DEBUG: pid 23099: key: master_slave_sub_mode
2010-09-27 12:48:23 DEBUG: pid 23099: value: 'slony' kind: 4
2010-09-27 12:48:23 DEBUG: pid 23099: key: delay_threshold
2010-09-27 12:48:23 DEBUG: pid 23099: value: 0 kind: 2
2010-09-27 12:48:23 DEBUG: pid 23099: key: log_standby_delay
2010-09-27 12:48:23 DEBUG: pid 23099: value: 'none' kind: 4
2010-09-27 12:48:23 DEBUG: pid 23099: key: connection_cache
2010-09-27 12:48:23 DEBUG: pid 23099: value: true kind: 1
2010-09-27 12:48:23 DEBUG: pid 23099: key: health_check_timeout
2010-09-27 12:48:23 DEBUG: pid 23099: value: 20 kind: 2
2010-09-27 12:48:23 DEBUG: pid 23099: key: health_check_period
2010-09-27 12:48:23 DEBUG: pid 23099: value: 0 kind: 2
2010-09-27 12:48:23 DEBUG: pid 23099: key: health_check_user
2010-09-27 12:48:23 DEBUG: pid 23099: value: 'nobody' kind: 4
2010-09-27 12:48:23 DEBUG: pid 23099: key: failover_command
2010-09-27 12:48:23 DEBUG: pid 23099: value: '' kind: 4
2010-09-27 12:48:23 DEBUG: pid 23099: key: failback_command
2010-09-27 12:48:23 DEBUG: pid 23099: value: '' kind: 4
2010-09-27 12:48:23 DEBUG: pid 23099: key: fail_over_on_backend_error
2010-09-27 12:48:23 DEBUG: pid 23099: value: true kind: 1
2010-09-27 12:48:23 DEBUG: pid 23099: key: insert_lock
2010-09-27 12:48:23 DEBUG: pid 23099: value: true kind: 1
2010-09-27 12:48:23 DEBUG: pid 23099: key: ignore_leading_white_space
2010-09-27 12:48:23 DEBUG: pid 23099: value: true kind: 1
2010-09-27 12:48:23 DEBUG: pid 23099: key: log_statement
2010-09-27 12:48:23 DEBUG: pid 23099: value: true kind: 1
2010-09-27 12:48:23 DEBUG: pid 23099: key: log_per_node_statement
2010-09-27 12:48:23 DEBUG: pid 23099: value: true kind: 1
2010-09-27 12:48:23 DEBUG: pid 23099: key: log_connections
2010-09-27 12:48:23 DEBUG: pid 23099: value: true kind: 1
2010-09-27 12:48:23 DEBUG: pid 23099: key: log_hostname
2010-09-27 12:48:23 DEBUG: pid 23099: value: true kind: 1
2010-09-27 12:48:23 DEBUG: pid 23099: key: parallel_mode
2010-09-27 12:48:23 DEBUG: pid 23099: value: false kind: 1
2010-09-27 12:48:23 DEBUG: pid 23099: key: enable_query_cache
2010-09-27 12:48:23 DEBUG: pid 23099: value: false kind: 1
2010-09-27 12:48:23 DEBUG: pid 23099: key: pgpool2_hostname
2010-09-27 12:48:23 DEBUG: pid 23099: value: '' kind: 4
2010-09-27 12:48:23 DEBUG: pid 23099: key: system_db_hostname
2010-09-27 12:48:23 DEBUG: pid 23099: value: 'localhost' kind: 4
2010-09-27 12:48:23 DEBUG: pid 23099: key: system_db_port
2010-09-27 12:48:23 DEBUG: pid 23099: value: 5432 kind: 2
2010-09-27 12:48:23 DEBUG: pid 23099: key: system_db_dbname
2010-09-27 12:48:23 DEBUG: pid 23099: value: 'pgpool' kind: 4
2010-09-27 12:48:23 DEBUG: pid 23099: key: system_db_schema
2010-09-27 12:48:23 DEBUG: pid 23099: value: 'pgpool_catalog' kind: 4
2010-09-27 12:48:23 DEBUG: pid 23099: key: system_db_user
2010-09-27 12:48:23 DEBUG: pid 23099: value: 'pgpool' kind: 4
2010-09-27 12:48:23 DEBUG: pid 23099: key: system_db_password
2010-09-27 12:48:23 DEBUG: pid 23099: value: '' kind: 4
2010-09-27 12:48:23 DEBUG: pid 23099: key: backend_hostname0
2010-09-27 12:48:23 DEBUG: pid 23099: value: 'localhost' kind: 4
2010-09-27 12:48:23 DEBUG: pid 23099: key: backend_port0
2010-09-27 12:48:23 DEBUG: pid 23099: value: 5432 kind: 2
2010-09-27 12:48:23 DEBUG: pid 23099: pool_config: port slot number 0
2010-09-27 12:48:23 DEBUG: pid 23099: key: backend_weight0
2010-09-27 12:48:23 DEBUG: pid 23099: value: 1 kind: 2
2010-09-27 12:48:23 DEBUG: pid 23099: pool_config: weight slot number 0
weight: 1.000000
2010-09-27 12:48:23 DEBUG: pid 23099: key: backend_data_directory0
2010-09-27 12:48:23 DEBUG: pid 23099: value: '/usr/local/pgsql/data' kind: 4
2010-09-27 12:48:23 DEBUG: pid 23099: key: enable_pool_hba
2010-09-27 12:48:23 DEBUG: pid 23099: value: false kind: 1
2010-09-27 12:48:23 DEBUG: pid 23099: key: recovery_user
2010-09-27 12:48:23 DEBUG: pid 23099: value: 'nobody' kind: 4
2010-09-27 12:48:23 DEBUG: pid 23099: key: recovery_password
2010-09-27 12:48:23 DEBUG: pid 23099: value: '' kind: 4
2010-09-27 12:48:23 DEBUG: pid 23099: key: recovery_1st_stage_command
2010-09-27 12:48:23 DEBUG: pid 23099: value: '' kind: 4
2010-09-27 12:48:23 DEBUG: pid 23099: key: recovery_2nd_stage_command
2010-09-27 12:48:23 DEBUG: pid 23099: value: '' kind: 4
2010-09-27 12:48:23 DEBUG: pid 23099: key: recovery_timeout
2010-09-27 12:48:23 DEBUG: pid 23099: value: 90 kind: 2
2010-09-27 12:48:23 DEBUG: pid 23099: key: client_idle_limit_in_recovery
2010-09-27 12:48:23 DEBUG: pid 23099: value: 0 kind: 2
2010-09-27 12:48:23 DEBUG: pid 23099: key: lobj_lock_table
2010-09-27 12:48:23 DEBUG: pid 23099: value: '' kind: 4
2010-09-27 12:48:23 DEBUG: pid 23099: key: ssl
2010-09-27 12:48:23 DEBUG: pid 23099: value: false kind: 1
2010-09-27 12:48:23 DEBUG: pid 23099: key: debug_level
2010-09-27 12:48:23 DEBUG: pid 23099: value: 1 kind: 2
2010-09-27 12:48:23 DEBUG: pid 23099: num_backends: 1 total_weight: 1.000000
2010-09-27 12:48:23 DEBUG: pid 23099: backend 0 weight: 2147483647.000000
2010-09-27 12:48:23 DEBUG: pid 23099: shmem_exit(0)
---------------------------------------------------------------------
> 北川です。
>
> On Fri, 24 Sep 2010 12:02:41 +0900
> 松山大樹<t.matsuyama ＠ wowcom.co.jp> wrote:
>
>> 松山と申します。
>>
>> pgpool-II 3.0 をレプリケーションモードで試してみているのですが、
>> トランザクション制御下で、nextval('xxxxxxxxx') を実行すると、
>> 次のようなエラーになってしまいます。
>>
>> An I/O error occured while sending to the backend.
>>
>> 発行しているSQLは、
>> select nextval('xxxxxxxxx')
>> ですが、この結果自体は正常に取得できています。
>> その後で、コミットしようとして失敗しています。
>>
>> pgpool-II 2.3.2.2 では、正常に取得もコミットも完了していたのですが。
>> 考えられる原因は何でしょうか？
>
> おそらく、JDBC などで利用されている拡張プロトコルを処理する部分の
> バグと思われます。
>
> ただいま調査していますが、よろしければ障害発生時の pgpool-II の
> デバッグログを送って頂けると助かります。
>
> よろしくお願いいたします。
>
pgpool-general-jp メーリングリストの案内