[pgpool-general-jp: 1254] Re: UPDATE後にキャッシュ削除されない
佐藤慎
s_sato ＠ eltex.co.jp
2014年 1月 24日 (金) 17:04:24 JST
$B ＠ P0fMM(B
$B$*@$OC$K$J$C$F$*$j$^$9!#:4F#$G$9!#(B
$B0J2<$O(Bconf$B$H%m%0$K$J$j$^$9!#(B
[pgpool.conf]
listen_addresses = '*'
port = 9999
socket_dir = '/tmp'
pcp_port = 9898
pcp_socket_dir = '/tmp'
backend_hostname0 = 'xs2-sms-db1'
backend_port0 = 5432
backend_weight0 = 1
backend_data_directory0 = '/opt/pgsql'
backend_flag0 = 'ALLOW_TO_FAILOVER'
backend_hostname1 = 'xs2-sms-db2'
backend_port1 = 5432
backend_weight1 = 3
backend_data_directory1 = '/opt/pgsql'
backend_flag1 = 'ALLOW_TO_FAILOVER'
enable_pool_hba = off
pool_passwd = 'pool_passwd'
authentication_timeout = 60
ssl = off
num_init_children = 128
max_pool = 1
child_life_time = 300
child_max_connections = 0
connection_life_time = 0
client_idle_limit = 0
log_destination = 'stderr'
print_timestamp = on
log_connections = off
log_hostname = off
log_statement = on
log_per_node_statement = on
log_standby_delay = 'if_over_threshold'
syslog_facility = 'LOCAL0'
syslog_ident = 'pgpool'
debug_level = 0
pid_file_name = '/var/run/pgpool/pgpool.pid'
logdir = '/tmp'
connection_cache = on
reset_query_list = 'ABORT; DISCARD ALL'
replication_mode = off
replicate_select = off
insert_lock = off
lobj_lock_table = ''
replication_stop_on_mismatch = off
failover_if_affected_tuples_mismatch = off
load_balance_mode = on
ignore_leading_white_space = on
white_function_list = ''
black_function_list = 'currval,lastval,nextval,setval'
master_slave_mode = on
master_slave_sub_mode = 'stream'
sr_check_period = 10
sr_check_user = 'postgres'
sr_check_password = '******'
delay_threshold = 100
follow_master_command = '/unyo/shell/bin/follow_master.sh %h %d %H %P'
parallel_mode = off
pgpool2_hostname = ''
health_check_period = 5
health_check_timeout = 20
health_check_user = 'postgres'
health_check_password = '******'
health_check_max_retries = 1
health_check_retry_delay = 5
failover_command = '/unyo/shell/bin/failover.sh %d "%h" %p %D %m %M "%H" %P
%r %R'
failback_command = ''
fail_over_on_backend_error = on
recovery_user = 'nobody'
recovery_password = ''
recovery_1st_stage_command = ''
recovery_2nd_stage_command = ''
recovery_timeout = 90
client_idle_limit_in_recovery = 0
use_watchdog = on
trusted_servers = ''
delegate_IP = '172.18.253.150'
wd_hostname = 'xs2-sms-pg1'
wd_port = 9000
wd_interval = 10
ping_path = '/bin'
ifconfig_path = '/sbin'
if_up_cmd = 'ifconfig eth1:0 inet $_IP_$ netmask 255.255.255.128'
if_down_cmd = 'ifconfig eth1:0 down'
arping_path = '/usr/sbin' # arping command path
arping_cmd = 'arping -U $_IP_$ -w 1'
wd_life_point = 3
wd_lifecheck_query = 'SELECT 1'
other_pgpool_hostname0 = 'xs2-sms-pg2'
other_pgpool_port0 = 9999
other_wd_port0 = 9000
relcache_expire = 0
relcache_size = 256
check_temp_table = on
memory_cache_enabled = on
memqcache_method = 'shmem'
memqcache_memcached_host = 'localhost'
memqcache_memcached_port = 11211
memqcache_total_size = 67108864
memqcache_max_num_cache = 1000000
memqcache_expire = 3600
memqcache_auto_cache_invalidation = on
memqcache_maxcache = 409600
memqcache_cache_block_size = 1048576
memqcache_oiddir = '/var/log/pgpool/oiddir'
white_memqcache_table_list = ''
black_memqcache_table_list = ''
[pgpool$B%G%P%C%/%m%0(B]
2014-01-23 14:56:31 DEBUG: pid 613: send_to_where: 0 query: UPDATE
t_work_flow SET company_no = $1 , action_code = $2 , work_status = $3 ,
totalization_data = $4 , target_action_code = $5 , admin_user_no = $6 ,
confirm_user_no1 = $7 , modify_date = $8 , modify_person_id = $9 ,
modify_ipaddress = $10 , modify_user_agent = $11 , confirm_date1 = $12
WHERE work_flow_no = $13 AND (del_flg <> $14 OR del_flg IS NULL)
2014-01-23 14:56:31 DEBUG: pid 613: Parse: waiting for master completing
the query
2014-01-23 14:56:31 LOG: pid 613: DB node id: 0 backend pid: 5317
statement: Parse: UPDATE t_work_flow SET company_no = $1 , action_code =
$2 , work_status = $3 , totalization_data = $4 , target_action_code = $5
, admin_user_no = $6 , confirm_user_no1 = $7 , modify_date = $8 ,
modify_person_id = $9 , modify_ipaddress = $10 , modify_user_agent = $11
, confirm_date1 = $12 WHERE work_flow_no = $13 AND (del_flg <> $14 OR
del_flg IS NULL)
2014-01-23 14:56:31 DEBUG: pid 613: wait_for_query_response: waiting for
backend 0 completing the query
2014-01-23 14:56:31 DEBUG: pid 613: detect_error: kind: 1
2014-01-23 14:56:31 DEBUG: pid 613: pool_unset_skip_reading_from_backends:
done
2014-01-23 14:56:31 DEBUG: pid 613: read_kind_from_one_backend: read kind
from 0 th backend 1
2014-01-23 14:56:31 DEBUG: pid 613: read_kind_from_backend: kind: 1 from 0
th backend
2014-01-23 14:56:31 DEBUG: pid 613: read_kind_from_backend: read kind from
0 th backend 1 NUM_BACKENDS: 2
2014-01-23 14:56:31 DEBUG: pid 613: ProcessBackendResponse: kind from
backend: 1
2014-01-23 14:56:31 DEBUG: pid 613: pool_add_sent_message: prepared
statement "" already exists
2014-01-23 14:56:31 DEBUG: pid 613: can_query_context_destroy: query
context 0x1d4c1e0 is still used. query: SELECT t_work_flow.company_no AS
T1_C1,t_work_flow.shop_no AS T1_C2,t_work_flow.work_flow_no AS
T1_C3,t_work_flow.work_code AS T1_C4,t_work_flow.action_code AS
T1_C5,t_work_flow.work_status AS T1_C6,t_work_flow.target_url AS
T1_C7,t_work_flow.totalization_data AS T1_C8,t_work_flow.target_action_code
AS T1_C9,t_work_flow.admin_user_no AS T1_C10,t_work_flow.request_user_no AS
T1_C11,t_work_flow.confirm_user_no1 AS T1_C12,t_work_flow.confirm_user_no2
AS T1_C13,t_work_flow.confirm_user_no3 AS
T1_C14,t_work_flow.confirm_user_no4 AS T1_C15,t_work_flow.confirm_user_no5
AS T1_C16,t_work_flow.confirm_user_no6 AS
T1_C17,t_work_flow.confirm_user_no7 AS T1_C18,t_work_flow.confirm_user_no8
AS T1_C19,t_work_flow.approve_user_no AS T1_C20,t_work_flow.yobi_string1 AS
T1_C21,t_work_flow.yobi_string2 AS T1_C22,t_work_flow.yobi_string3 AS
T1_C23,t_work_flow.yobi_string4 AS T1_C24,t_work_flow.yobi_string5 AS
T1_C25,t_work_flow.yobi_num1 AS T1_C26,t_work_flow.yobi_num2 AS
T1_C27,t_work_flow.yobi_num3 AS T1_C28,t_work_flow.yobi_num4 AS
T1_C29,t_work_flow.yobi_num5 AS T1_C30,t_work_flow.yobi_time1 AS
T1_C31,t_work_flow.yobi_time2 AS T1_C32,t_work_flow.yobi_time3 AS
T1_C33,t_work_flow.yobi_time4 AS T1_C34,t_work_flow.yobi_time5 AS
T1_C35,t_work_flow.del_flg AS T1_C36,t_work_flow.del_date AS
T1_C37,t_work_flow.del_person_id AS T1_C38,t_work_flow.del_ipaddress AS
T1_C39,t_work_flow.del_user_agent AS T1_C40,t_work_flow.add_date AS
T1_C41,t_work_flow.add_person_id AS T1_C42,t_work_flow.add_ipaddress AS
T1_C43,t_work_flow.add_user_agent AS T1_C44,t_work_flow.modify_date AS
T1_C45,t_work_flow.modify_person_id AS T1_C46,t_work_flow.modify_ipaddress
AS T1_C47,t_work_flow.modify_user_agent AS T1_C48,t_work_flow.request_date
AS T1_C49,t_work_flow.confirm_date1 AS T1_C50,t_work_flow.confirm_date2 AS
T1_C51,t_work_flow.confirm_date3 AS T1_C52,t_work_flow.confirm_date4 AS
T1_C53,t_work_flow.confirm_date5 AS T1_C54,t_work_flow.confirm_date6 AS
T1_C55,t_work_flow.confirm_date7 AS T1_C56,t_work_flow.confirm_date8 AS
T1_C57,t_work_flow.approve_date AS T1_C58 FROM t_work_flow WHERE
work_flow_no = $1 AND (t_work_flow.del_flg<> $2 OR t_work_flow.del_flg IS
NULL)
2014-01-23 14:56:31 DEBUG: pid 613: can_query_context_destroy: query
context 0x1d4c1e0 is still used. query: SELECT t_work_flow.company_no AS
T1_C1,t_work_flow.shop_no AS T1_C2,t_work_flow.work_flow_no AS
T1_C3,t_work_flow.work_code AS T1_C4,t_work_flow.action_code AS
T1_C5,t_work_flow.work_status AS T1_C6,t_work_flow.target_url AS
T1_C7,t_work_flow.totalization_data AS T1_C8,t_work_flow.target_action_code
AS T1_C9,t_work_flow.admin_user_no AS T1_C10,t_work_flow.request_user_no AS
T1_C11,t_work_flow.confirm_user_no1 AS T1_C12,t_work_flow.confirm_user_no2
AS T1_C13,t_work_flow.confirm_user_no3 AS
T1_C14,t_work_flow.confirm_user_no4 AS T1_C15,t_work_flow.confirm_user_no5
AS T1_C16,t_work_flow.confirm_user_no6 AS
T1_C17,t_work_flow.confirm_user_no7 AS T1_C18,t_work_flow.confirm_user_no8
AS T1_C19,t_work_flow.approve_user_no AS T1_C20,t_work_flow.yobi_string1 AS
T1_C21,t_work_flow.yobi_string2 AS T1_C22,t_work_flow.yobi_string3 AS
T1_C23,t_work_flow.yobi_string4 AS T1_C24,t_work_flow.yobi_string5 AS
T1_C25,t_work_flow.yobi_num1 AS T1_C26,t_work_flow.yobi_num2 AS
T1_C27,t_work_flow.yobi_num3 AS T1_C28,t_work_flow.yobi_num4 AS
T1_C29,t_work_flow.yobi_num5 AS T1_C30,t_work_flow.yobi_time1 AS
T1_C31,t_work_flow.yobi_time2 AS T1_C32,t_work_flow.yobi_time3 AS
T1_C33,t_work_flow.yobi_time4 AS T1_C34,t_work_flow.yobi_time5 AS
T1_C35,t_work_flow.del_flg AS T1_C36,t_work_flow.del_date AS
T1_C37,t_work_flow.del_person_id AS T1_C38,t_work_flow.del_ipaddress AS
T1_C39,t_work_flow.del_user_agent AS T1_C40,t_work_flow.add_date AS
T1_C41,t_work_flow.add_person_id AS T1_C42,t_work_flow.add_ipaddress AS
T1_C43,t_work_flow.add_user_agent AS T1_C44,t_work_flow.modify_date AS
T1_C45,t_work_flow.modify_person_id AS T1_C46,t_work_flow.modify_ipaddress
AS T1_C47,t_work_flow.modify_user_agent AS T1_C48,t_work_flow.request_date
AS T1_C49,t_work_flow.confirm_date1 AS T1_C50,t_work_flow.confirm_date2 AS
T1_C51,t_work_flow.confirm_date3 AS T1_C52,t_work_flow.confirm_date4 AS
T1_C53,t_work_flow.confirm_date5 AS T1_C54,t_work_flow.confirm_date6 AS
T1_C55,t_work_flow.confirm_date7 AS T1_C56,t_work_flow.confirm_date8 AS
T1_C57,t_work_flow.approve_date AS T1_C58 FROM t_work_flow WHERE
work_flow_no = $1 AND (t_work_flow.del_flg<> $2 OR t_work_flow.del_flg IS
NULL)
2014-01-23 14:56:31 DEBUG: pid 613: can_query_context_destroy: query
context 0x1d4c1e0 is still used for 2 times.
2014-01-23 14:56:31 DEBUG: pid 613: pool_set_command_success: done
2014-01-23 14:56:31 DEBUG: pid 613: pool_unset_query_in_progress: done
2014-01-23 14:56:31 DEBUG: pid 613: ProcessFrontendResponse: kind from
frontend B(42)
2014-01-23 14:56:31 DEBUG: pid 613:
pool_unset_doing_extended_query_message: done
2014-01-23 14:56:31 DEBUG: pid 613: pool_set_doing_extended_query_message:
done
2014-01-23 14:56:31 DEBUG: pid 613: pool_set_query_in_progress: done
2014-01-23 14:56:31 DEBUG: pid 613: Bind: waiting for master completing the
query
2014-01-23 14:56:31 LOG: pid 613: DB node id: 0 backend pid: 5317
statement: B message
2014-01-23 14:56:31 DEBUG: pid 613: wait_for_query_response: waiting for
backend 0 completing the query
2014-01-23 14:56:31 DEBUG: pid 613: read_kind_from_one_backend: read kind
from 0 th backend 2
2014-01-23 14:56:31 DEBUG: pid 613: read_kind_from_backend: kind: 2 from 0
th backend
2014-01-23 14:56:31 DEBUG: pid 613: read_kind_from_backend: read kind from
0 th backend 2 NUM_BACKENDS: 2
2014-01-23 14:56:31 DEBUG: pid 613: ProcessBackendResponse: kind from
backend: 2
2014-01-23 14:56:31 DEBUG: pid 613: pool_add_sent_message: portal ""
already exists
2014-01-23 14:56:31 DEBUG: pid 613: can_query_context_destroy: query
context 0x1d4c1e0 is still used. query: SELECT t_work_flow.company_no AS
T1_C1,t_work_flow.shop_no AS T1_C2,t_work_flow.work_flow_no AS
T1_C3,t_work_flow.work_code AS T1_C4,t_work_flow.action_code AS
T1_C5,t_work_flow.work_status AS T1_C6,t_work_flow.target_url AS
T1_C7,t_work_flow.totalization_data AS T1_C8,t_work_flow.target_action_code
AS T1_C9,t_work_flow.admin_user_no AS T1_C10,t_work_flow.request_user_no AS
T1_C11,t_work_flow.confirm_user_no1 AS T1_C12,t_work_flow.confirm_user_no2
AS T1_C13,t_work_flow.confirm_user_no3 AS
T1_C14,t_work_flow.confirm_user_no4 AS T1_C15,t_work_flow.confirm_user_no5
AS T1_C16,t_work_flow.confirm_user_no6 AS
T1_C17,t_work_flow.confirm_user_no7 AS T1_C18,t_work_flow.confirm_user_no8
AS T1_C19,t_work_flow.approve_user_no AS T1_C20,t_work_flow.yobi_string1 AS
T1_C21,t_work_flow.yobi_string2 AS T1_C22,t_work_flow.yobi_string3 AS
T1_C23,t_work_flow.yobi_string4 AS T1_C24,t_work_flow.yobi_string5 AS
T1_C25,t_work_flow.yobi_num1 AS T1_C26,t_work_flow.yobi_num2 AS
T1_C27,t_work_flow.yobi_num3 AS T1_C28,t_work_flow.yobi_num4 AS
T1_C29,t_work_flow.yobi_num5 AS T1_C30,t_work_flow.yobi_time1 AS
T1_C31,t_work_flow.yobi_time2 AS T1_C32,t_work_flow.yobi_time3 AS
T1_C33,t_work_flow.yobi_time4 AS T1_C34,t_work_flow.yobi_time5 AS
T1_C35,t_work_flow.del_flg AS T1_C36,t_work_flow.del_date AS
T1_C37,t_work_flow.del_person_id AS T1_C38,t_work_flow.del_ipaddress AS
T1_C39,t_work_flow.del_user_agent AS T1_C40,t_work_flow.add_date AS
T1_C41,t_work_flow.add_person_id AS T1_C42,t_work_flow.add_ipaddress AS
T1_C43,t_work_flow.add_user_agent AS T1_C44,t_work_flow.modify_date AS
T1_C45,t_work_flow.modify_person_id AS T1_C46,t_work_flow.modify_ipaddress
AS T1_C47,t_work_flow.modify_user_agent AS T1_C48,t_work_flow.request_date
AS T1_C49,t_work_flow.confirm_date1 AS T1_C50,t_work_flow.confirm_date2 AS
T1_C51,t_work_flow.confirm_date3 AS T1_C52,t_work_flow.confirm_date4 AS
T1_C53,t_work_flow.confirm_date5 AS T1_C54,t_work_flow.confirm_date6 AS
T1_C55,t_work_flow.confirm_date7 AS T1_C56,t_work_flow.confirm_date8 AS
T1_C57,t_work_flow.approve_date AS T1_C58 FROM t_work_flow WHERE
work_flow_no = $1 AND (t_work_flow.del_flg<> $2 OR t_work_flow.del_flg IS
NULL)
2014-01-23 14:56:31 DEBUG: pid 613: pool_unset_query_in_progress: done
2014-01-23 14:56:31 DEBUG: pid 613: pool_set_query_in_progress: done
2014-01-23 14:56:31 DEBUG: pid 613: pool_set_command_success: done
2014-01-23 14:56:31 DEBUG: pid 613: pool_unset_query_in_progress: done
2014-01-23 14:56:31 DEBUG: pid 613: ProcessFrontendResponse: kind from
frontend D(44)
2014-01-23 14:56:31 DEBUG: pid 613:
pool_unset_doing_extended_query_message: done
2014-01-23 14:56:31 DEBUG: pid 613: pool_set_doing_extended_query_message:
done
2014-01-23 14:56:31 DEBUG: pid 613: pool_set_query_in_progress: done
2014-01-23 14:56:31 DEBUG: pid 613: Describe: waiting for master completing
the query
2014-01-23 14:56:31 LOG: pid 613: DB node id: 0 backend pid: 5317
statement: D message
2014-01-23 14:56:31 DEBUG: pid 613: wait_for_query_response: waiting for
backend 0 completing the query
2014-01-23 14:56:31 DEBUG: pid 613: read_kind_from_one_backend: read kind
from 0 th backend n
2014-01-23 14:56:31 DEBUG: pid 613: read_kind_from_backend: kind: n from 0
th backend
2014-01-23 14:56:31 DEBUG: pid 613: read_kind_from_backend: read kind from
0 th backend n NUM_BACKENDS: 2
2014-01-23 14:56:31 DEBUG: pid 613: ProcessBackendResponse: kind from
backend: n
2014-01-23 14:56:31 DEBUG: pid 613: pool_unset_query_in_progress: done
2014-01-23 14:56:31 DEBUG: pid 613: ProcessFrontendResponse: kind from
frontend E(45)
2014-01-23 14:56:31 DEBUG: pid 613:
pool_unset_doing_extended_query_message: done
2014-01-23 14:56:31 DEBUG: pid 613: pool_set_doing_extended_query_message:
done
2014-01-23 14:56:31 DEBUG: pid 613: pool_set_query_in_progress: done
2014-01-23 14:56:31 DEBUG: pid 613: Execute: portal name <>
2014-01-23 14:56:31 DEBUG: pid 613: Execute: query string = < UPDATE
t_work_flow SET company_no = $1 , action_code = $2 , work_status = $3 ,
totalization_data = $4 , target_action_code = $5 , admin_user_no = $6 ,
confirm_user_no1 = $7 , modify_date = $8 , modify_person_id = $9 ,
modify_ipaddress = $10 , modify_user_agent = $11 , confirm_date1 = $12
WHERE work_flow_no = $13 AND (del_flg <> $14 OR del_flg IS NULL) >
2014-01-23 14:56:31 LOG: pid 613: DB node id: 0 backend pid: 5317
statement: Execute: UPDATE t_work_flow SET company_no = $1 , action_code
= $2 , work_status = $3 , totalization_data = $4 , target_action_code =
$5 , admin_user_no = $6 , confirm_user_no1 = $7 , modify_date = $8 ,
modify_person_id = $9 , modify_ipaddress = $10 , modify_user_agent = $11
, confirm_date1 = $12 WHERE work_flow_no = $13 AND (del_flg <> $14 OR
del_flg IS NULL)
2014-01-23 14:56:31 DEBUG: pid 613: wait_for_query_response: waiting for
backend 0 completing the query
2014-01-23 14:56:31 DEBUG: pid 613: read_kind_from_one_backend: read kind
from 0 th backend C
2014-01-23 14:56:31 DEBUG: pid 613: read_kind_from_backend: kind: C from 0
th backend
2014-01-23 14:56:31 DEBUG: pid 613: read_kind_from_backend: read kind from
0 th backend C NUM_BACKENDS: 2
2014-01-23 14:56:31 DEBUG: pid 613: ProcessBackendResponse: kind from
backend: C
2014-01-23 14:56:31 DEBUG: pid 613: pool_set_command_success: done
2014-01-23 14:56:31 DEBUG: pid 613: pool_unset_query_in_progress: done
2014-01-23 14:56:31 DEBUG: pid 613: ProcessFrontendResponse: kind from
frontend S(53)
2014-01-23 14:56:31 DEBUG: pid 613:
pool_unset_doing_extended_query_message: done
2014-01-23 14:56:31 DEBUG: pid 613: pool_set_doing_extended_query_message:
done
2014-01-23 14:56:31 DEBUG: pid 613: pool_set_query_in_progress: done
2014-01-23 14:56:31 DEBUG: pid 613: read_kind_from_one_backend: read kind
from 0 th backend Z
2014-01-23 14:56:31 DEBUG: pid 613: read_kind_from_backend: kind: Z from 0
th backend
2014-01-23 14:56:31 DEBUG: pid 613: read_kind_from_backend: read kind from
0 th backend Z NUM_BACKENDS: 2
2014-01-23 14:56:31 DEBUG: pid 613: ProcessBackendResponse: kind from
backend: Z
2014-01-23 14:56:31 DEBUG: pid 613: pool_read_message_length: slot: 0
length: 5
2014-01-23 14:56:31 DEBUG: pid 613: ReadyForQuery: transaction state:T
2014-01-23 14:56:31 DEBUG: pid 613: pool_set_writing_transaction: done
2014-01-23 14:56:31 DEBUG: pid 613: pool_unset_query_in_progress: done
2014-01-23 14:56:31 DEBUG: pid 613: ProcessBackendResponse: Ready For Query
2014-01-23 14:56:31 DEBUG: pid 613: ProcessFrontendResponse: kind from
frontend P(50)
2014-01-23 14:56:31 DEBUG: pid 613:
pool_unset_doing_extended_query_message: done
2014-01-23 14:56:31 DEBUG: pid 613: pool_set_doing_extended_query_message:
done
2014-01-23 14:56:31 DEBUG: pid 613: pool_set_query_in_progress: done
2014-01-23 14:56:31 DEBUG: pid 613: Parse: statement name <>
2014-01-23 14:56:31 DEBUG: pid 613: pool_set_query_in_progress: done
2014-01-23 14:56:31 DEBUG: pid 613: pool_has_insertinto_or_locking_clause:
returns 0
2014-01-23 14:56:31 DEBUG: pid 613: pool_has_non_immutable_function_call: 0
2014-01-23 14:56:31 DEBUG: pid 613: temp_table_walker: relname: t_work_flow
2014-01-23 14:56:31 DEBUG: pid 613: system_catalog_walker: relname:
t_work_flow
2014-01-23 14:56:31 DEBUG: pid 613: make_table_name_from_rangevar:
tablename:t_work_flow
2014-01-23 14:56:31 DEBUG: pid 613: view_walker: relname: t_work_flow
2014-01-23 14:56:31 DEBUG: pid 613: make_table_name_from_rangevar:
tablename:t_work_flow
2014-01-23 14:56:31 DEBUG: pid 613: unlogged_table_walker: relname:
t_work_flow
2014-01-23 14:56:31 DEBUG: pid 613: pool_has_insertinto_or_locking_clause:
returns 0
2014-01-23 14:56:31 DEBUG: pid 613: send_to_where: 2 query: SELECT
t_work_flow.company_no AS T1_C1,t_work_flow.shop_no AS
T1_C2,t_work_flow.work_flow_no AS T1_C3,t_work_flow.work_code AS
T1_C4,t_work_flow.action_code AS T1_C5,t_work_flow.work_status AS
T1_C6,t_work_flow.target_url AS T1_C7,t_work_flow.totalization_data AS
T1_C8,t_work_flow.target_action_code AS T1_C9,t_work_flow.admin_user_no AS
T1_C10,t_work_flow.request_user_no AS T1_C11,t_work_flow.confirm_user_no1
AS T1_C12,t_work_flow.confirm_user_no2 AS
T1_C13,t_work_flow.confirm_user_no3 AS T1_C14,t_work_flow.confirm_user_no4
AS T1_C15,t_work_flow.confirm_user_no5 AS
T1_C16,t_work_flow.confirm_user_no6 AS T1_C17,t_work_flow.confirm_user_no7
AS T1_C18,t_work_flow.confirm_user_no8 AS
T1_C19,t_work_flow.approve_user_no AS T1_C20,t_work_flow.yobi_string1 AS
T1_C21,t_work_flow.yobi_string2 AS T1_C22,t_work_flow.yobi_string3 AS
T1_C23,t_work_flow.yobi_string4 AS T1_C24,t_work_flow.yobi_string5 AS
T1_C25,t_work_flow.yobi_num1 AS T1_C26,t_work_flow.yobi_num2 AS
T1_C27,t_work_flow.yobi_num3 AS T1_C28,t_work_flow.yobi_num4 AS
T1_C29,t_work_flow.yobi_num5 AS T1_C30,t_work_flow.yobi_time1 AS
T1_C31,t_work_flow.yobi_time2 AS T1_C32,t_work_flow.yobi_time3 AS
T1_C33,t_work_flow.yobi_time4 AS T1_C34,t_work_flow.yobi_time5 AS
T1_C35,t_work_flow.del_flg AS T1_C36,t_work_flow.del_date AS
T1_C37,t_work_flow.del_person_id AS T1_C38,t_work_flow.del_ipaddress AS
T1_C39,t_work_flow.del_user_agent AS T1_C40,t_work_flow.add_date AS
T1_C41,t_work_flow.add_person_id AS T1_C42,t_work_flow.add_ipaddress AS
T1_C43,t_work_flow.add_user_agent AS T1_C44,t_work_flow.modify_date AS
T1_C45,t_work_flow.modify_person_id AS T1_C46,t_work_flow.modify_ipaddress
AS T1_C47,t_work_flow.modify_user_agent AS T1_C48,t_work_flow.request_date
AS T1_C49,t_work_flow.confirm_date1 AS T1_C50,t_work_flow.confirm_date2 AS
T1_C51,t_work_flow.confirm_date3 AS T1_C52,t_work_flow.confirm_date4 AS
T1_C53,t_work_flow.confirm_date5 AS T1_C54,t_work_flow.confirm_date6 AS
T1_C55,t_work_flow.confirm_date7 AS T1_C56,t_work_flow.confirm_date8 AS
T1_C57,t_work_flow.approve_date AS T1_C58 FROM t_work_flow WHERE
work_flow_no = $1 AND (t_work_flow.del_flg<> $2 OR t_work_flow.del_flg IS
NULL)
2014-01-23 14:56:31 DEBUG: pid 613: Parse: waiting for master completing
the query
2014-01-23 14:56:31 LOG: pid 613: DB node id: 0 backend pid: 5317
statement: Parse: SELECT t_work_flow.company_no AS
T1_C1,t_work_flow.shop_no AS T1_C2,t_work_flow.work_flow_no AS
T1_C3,t_work_flow.work_code AS T1_C4,t_work_flow.action_code AS
T1_C5,t_work_flow.work_status AS T1_C6,t_work_flow.target_url AS
T1_C7,t_work_flow.totalization_data AS T1_C8,t_work_flow.target_action_code
AS T1_C9,t_work_flow.admin_user_no AS T1_C10,t_work_flow.request_user_no AS
T1_C11,t_work_flow.confirm_user_no1 AS T1_C12,t_work_flow.confirm_user_no2
AS T1_C13,t_work_flow.confirm_user_no3 AS
T1_C14,t_work_flow.confirm_user_no4 AS T1_C15,t_work_flow.confirm_user_no5
AS T1_C16,t_work_flow.confirm_user_no6 AS
T1_C17,t_work_flow.confirm_user_no7 AS T1_C18,t_work_flow.confirm_user_no8
AS T1_C19,t_work_flow.approve_user_no AS T1_C20,t_work_flow.yobi_string1 AS
T1_C21,t_work_flow.yobi_string2 AS T1_C22,t_work_flow.yobi_string3 AS
T1_C23,t_work_flow.yobi_string4 AS T1_C24,t_work_flow.yobi_string5 AS
T1_C25,t_work_flow.yobi_num1 AS T1_C26,t_work_flow.yobi_num2 AS T1_C27,t_
2014-01-23 14:56:31 DEBUG: pid 613: wait_for_query_response: waiting for
backend 0 completing the query
2014-01-23 14:56:31 DEBUG: pid 613: detect_error: kind: 1
2014-01-23 14:56:31 DEBUG: pid 613: read_kind_from_one_backend: read kind
from 0 th backend 1
2014-01-23 14:56:31 DEBUG: pid 613: read_kind_from_backend: kind: 1 from 0
th backend
2014-01-23 14:56:31 DEBUG: pid 613: read_kind_from_backend: read kind from
0 th backend 1 NUM_BACKENDS: 2
2014-01-23 14:56:31 DEBUG: pid 613: ProcessBackendResponse: kind from
backend: 1
2014-01-23 14:56:31 DEBUG: pid 613: pool_add_sent_message: prepared
statement "" already exists
2014-01-23 14:56:31 DEBUG: pid 613: can_query_context_destroy: query
context 0x1b2be60 is still used. query: UPDATE t_work_flow SET company_no =
$1 , action_code = $2 , work_status = $3 , totalization_data = $4 ,
target_action_code = $5 , admin_user_no = $6 , confirm_user_no1 = $7 ,
modify_date = $8 , modify_person_id = $9 , modify_ipaddress = $10 ,
modify_user_agent = $11 , confirm_date1 = $12 WHERE work_flow_no = $13
AND (del_flg <> $14 OR del_flg IS NULL)
2014-01-23 14:56:31 DEBUG: pid 613: can_query_context_destroy: query
context 0x1b2be60 is still used. query: UPDATE t_work_flow SET company_no =
$1 , action_code = $2 , work_status = $3 , totalization_data = $4 ,
target_action_code = $5 , admin_user_no = $6 , confirm_user_no1 = $7 ,
modify_date = $8 , modify_person_id = $9 , modify_ipaddress = $10 ,
modify_user_agent = $11 , confirm_date1 = $12 WHERE work_flow_no = $13
AND (del_flg <> $14 OR del_flg IS NULL)
2014-01-23 14:56:31 DEBUG: pid 613: can_query_context_destroy: query
context 0x1b2be60 is still used for 2 times.
2014-01-23 14:56:31 DEBUG: pid 613: pool_add_buffer: realloc old size:0 new
size:8192
2014-01-23 14:56:31 DEBUG: pid 613: pool_add_buffer: len:1, total:1
bufsize:8192
2014-01-23 14:56:31 DEBUG: pid 613: pool_add_buffer: len:4, total:5
bufsize:8192
2014-01-23 14:56:31 DEBUG: pid 613: pool_set_command_success: done
2014-01-23 14:56:31 DEBUG: pid 613: pool_unset_query_in_progress: done
2014-01-23 14:56:31 DEBUG: pid 613: ProcessFrontendResponse: kind from
frontend B(42)
2014-01-23 14:56:31 DEBUG: pid 613:
pool_unset_doing_extended_query_message: done
2014-01-23 14:56:31 DEBUG: pid 613: pool_set_doing_extended_query_message:
done
2014-01-23 14:56:31 DEBUG: pid 613: pool_set_query_in_progress: done
2014-01-23 14:56:31 DEBUG: pid 613: pool_has_insertinto_or_locking_clause:
returns 0
2014-01-23 14:56:31 DEBUG: pid 613: send_to_where: 2 query: SELECT
t_work_flow.company_no AS T1_C1,t_work_flow.shop_no AS
T1_C2,t_work_flow.work_flow_no AS T1_C3,t_work_flow.work_code AS
T1_C4,t_work_flow.action_code AS T1_C5,t_work_flow.work_status AS
T1_C6,t_work_flow.target_url AS T1_C7,t_work_flow.totalization_data AS
T1_C8,t_work_flow.target_action_code AS T1_C9,t_work_flow.admin_user_no AS
T1_C10,t_work_flow.request_user_no AS T1_C11,t_work_flow.confirm_user_no1
AS T1_C12,t_work_flow.confirm_user_no2 AS
T1_C13,t_work_flow.confirm_user_no3 AS T1_C14,t_work_flow.confirm_user_no4
AS T1_C15,t_work_flow.confirm_user_no5 AS
T1_C16,t_work_flow.confirm_user_no6 AS T1_C17,t_work_flow.confirm_user_no7
AS T1_C18,t_work_flow.confirm_user_no8 AS
T1_C19,t_work_flow.approve_user_no AS T1_C20,t_work_flow.yobi_string1 AS
T1_C21,t_work_flow.yobi_string2 AS T1_C22,t_work_flow.yobi_string3 AS
T1_C23,t_work_flow.yobi_string4 AS T1_C24,t_work_flow.yobi_string5 AS
T1_C25,t_work_flow.yobi_num1 AS T1_C26,t_work_flow.yobi_num2 AS
T1_C27,t_work_flow.yobi_num3 AS T1_C28,t_work_flow.yobi_num4 AS
T1_C29,t_work_flow.yobi_num5 AS T1_C30,t_work_flow.yobi_time1 AS
T1_C31,t_work_flow.yobi_time2 AS T1_C32,t_work_flow.yobi_time3 AS
T1_C33,t_work_flow.yobi_time4 AS T1_C34,t_work_flow.yobi_time5 AS
T1_C35,t_work_flow.del_flg AS T1_C36,t_work_flow.del_date AS
T1_C37,t_work_flow.del_person_id AS T1_C38,t_work_flow.del_ipaddress AS
T1_C39,t_work_flow.del_user_agent AS T1_C40,t_work_flow.add_date AS
T1_C41,t_work_flow.add_person_id AS T1_C42,t_work_flow.add_ipaddress AS
T1_C43,t_work_flow.add_user_agent AS T1_C44,t_work_flow.modify_date AS
T1_C45,t_work_flow.modify_person_id AS T1_C46,t_work_flow.modify_ipaddress
AS T1_C47,t_work_flow.modify_user_agent AS T1_C48,t_work_flow.request_date
AS T1_C49,t_work_flow.confirm_date1 AS T1_C50,t_work_flow.confirm_date2 AS
T1_C51,t_work_flow.confirm_date3 AS T1_C52,t_work_flow.confirm_date4 AS
T1_C53,t_work_flow.confirm_date5 AS T1_C54,t_work_flow.confirm_date6 AS
T1_C55,t_work_flow.confirm_date7 AS T1_C56,t_work_flow.confirm_date8 AS
T1_C57,t_work_flow.approve_date AS T1_C58 FROM t_work_flow WHERE
work_flow_no = $1 AND (t_work_flow.del_flg<> $2 OR t_work_flow.del_flg IS
NULL)
2014-01-23 14:56:31 DEBUG: pid 613: Bind: waiting for master completing the
query
2014-01-23 14:56:31 LOG: pid 613: DB node id: 0 backend pid: 5317
statement: B message
2014-01-23 14:56:31 DEBUG: pid 613: wait_for_query_response: waiting for
backend 0 completing the query
2014-01-23 14:56:31 DEBUG: pid 613: read_kind_from_one_backend: read kind
from 0 th backend 2
2014-01-23 14:56:31 DEBUG: pid 613: read_kind_from_backend: kind: 2 from 0
th backend
2014-01-23 14:56:31 DEBUG: pid 613: read_kind_from_backend: read kind from
0 th backend 2 NUM_BACKENDS: 2
2014-01-23 14:56:31 DEBUG: pid 613: ProcessBackendResponse: kind from
backend: 2
2014-01-23 14:56:31 DEBUG: pid 613: pool_add_sent_message: portal ""
already exists
2014-01-23 14:56:31 DEBUG: pid 613: can_query_context_destroy: query
context 0x1b2be60 is still used. query: UPDATE t_work_flow SET company_no =
$1 , action_code = $2 , work_status = $3 , totalization_data = $4 ,
target_action_code = $5 , admin_user_no = $6 , confirm_user_no1 = $7 ,
modify_date = $8 , modify_person_id = $9 , modify_ipaddress = $10 ,
modify_user_agent = $11 , confirm_date1 = $12 WHERE work_flow_no = $13
AND (del_flg <> $14 OR del_flg IS NULL)
2014-01-23 14:56:31 DEBUG: pid 613: pool_unset_query_in_progress: done
2014-01-23 14:56:31 DEBUG: pid 613: pool_set_query_in_progress: done
2014-01-23 14:56:31 DEBUG: pid 613: pool_add_buffer: len:1, total:6
bufsize:8192
2014-01-23 14:56:31 DEBUG: pid 613: pool_add_buffer: len:4, total:10
bufsize:8192
2014-01-23 14:56:31 DEBUG: pid 613: pool_set_command_success: done
2014-01-23 14:56:31 DEBUG: pid 613: pool_unset_query_in_progress: done
2014-01-23 14:56:31 DEBUG: pid 613: ProcessFrontendResponse: kind from
frontend D(44)
2014-01-23 14:56:31 DEBUG: pid 613:
pool_unset_doing_extended_query_message: done
2014-01-23 14:56:31 DEBUG: pid 613: pool_set_doing_extended_query_message:
done
2014-01-23 14:56:31 DEBUG: pid 613: pool_set_query_in_progress: done
2014-01-23 14:56:31 DEBUG: pid 613: Describe: waiting for master completing
the query
2014-01-23 14:56:31 LOG: pid 613: DB node id: 0 backend pid: 5317
statement: D message
2014-01-23 14:56:31 DEBUG: pid 613: wait_for_query_response: waiting for
backend 0 completing the query
2014-01-23 14:56:31 DEBUG: pid 613: read_kind_from_one_backend: read kind
from 0 th backend T
2014-01-23 14:56:31 DEBUG: pid 613: read_kind_from_backend: kind: T from 0
th backend
2014-01-23 14:56:31 DEBUG: pid 613: read_kind_from_backend: read kind from
0 th backend T NUM_BACKENDS: 2
2014-01-23 14:56:31 DEBUG: pid 613: ProcessBackendResponse: kind from
backend: T
2014-01-23 14:56:31 DEBUG: pid 613: pool_add_buffer: len:1, total:11
bufsize:8192
2014-01-23 14:56:31 DEBUG: pid 613: pool_add_buffer: len:4, total:15
bufsize:8192
2014-01-23 14:56:31 DEBUG: pid 613: pool_add_buffer: len:1443, total:1458
bufsize:8192
2014-01-23 14:56:31 DEBUG: pid 613: pool_unset_query_in_progress: done
2014-01-23 14:56:31 DEBUG: pid 613: ProcessFrontendResponse: kind from
frontend E(45)
2014-01-23 14:56:31 DEBUG: pid 613:
pool_unset_doing_extended_query_message: done
2014-01-23 14:56:31 DEBUG: pid 613: pool_set_doing_extended_query_message:
done
2014-01-23 14:56:31 DEBUG: pid 613: pool_set_query_in_progress: done
2014-01-23 14:56:31 DEBUG: pid 613: Execute: portal name <>
2014-01-23 14:56:31 DEBUG: pid 613: Execute: query string = <SELECT
t_work_flow.company_no AS T1_C1,t_work_flow.shop_no AS
T1_C2,t_work_flow.work_flow_no AS T1_C3,t_work_flow.work_code AS
T1_C4,t_work_flow.action_code AS T1_C5,t_work_flow.work_status AS
T1_C6,t_work_flow.target_url AS T1_C7,t_work_flow.totalization_data AS
T1_C8,t_work_flow.target_action_code AS T1_C9,t_work_flow.admin_user_no AS
T1_C10,t_work_flow.request_user_no AS T1_C11,t_work_flow.confirm_user_no1
AS T1_C12,t_work_flow.confirm_user_no2 AS
T1_C13,t_work_flow.confirm_user_no3 AS T1_C14,t_work_flow.confirm_user_no4
AS T1_C15,t_work_flow.confirm_user_no5 AS
T1_C16,t_work_flow.confirm_user_no6 AS T1_C17,t_work_flow.confirm_user_no7
AS T1_C18,t_work_flow.confirm_user_no8 AS
T1_C19,t_work_flow.approve_user_no AS T1_C20,t_work_flow.yobi_string1 AS
T1_C21,t_work_flow.yobi_string2 AS T1_C22,t_work_flow.yobi_string3 AS
T1_C23,t_work_flow.yobi_string4 AS T1_C24,t_work_flow.yobi_string5 AS
T1_C25,t_work_flow.yobi_num1 AS T1_C26,t_work_flow.yobi_num2 AS
T1_C27,t_work_flow.yobi_num3 AS T1_C28,t_work_flow.yobi_num4 AS
T1_C29,t_work_flow.yobi_num5 AS T1_C30,t_work_flow.yobi_time1 AS
T1_C31,t_work_flow.yobi_time2 AS T1_C32,t_work_flow.yobi_time3 AS
T1_C33,t_work_flow.yobi_time4 AS T1_C34,t_work_flow.yobi_time5 AS
T1_C35,t_work_flow.del_flg AS T1_C36,t_work_flow.del_date AS
T1_C37,t_work_flow.del_person_id AS T1_C38,t_work_flow.del_ipaddress AS
T1_C39,t_work_flow.del_user_agent AS T1_C40,t_work_flow.add_date AS
T1_C41,t_work_flow.add_person_id AS T1_C42,t_work_flow.add_ipaddress AS
T1_C43,t_work_flow.add_user_agent AS T1_C44,t_work_flow.modify_date AS
T1_C45,t_work_flow.modify_person_id AS T1_C46,t_work_flow.modify_ipaddress
AS T1_C47,t_work_flow.modify_user_agent AS T1_C48,t_work_flow.request_date
AS T1_C49,t_work_flow.confirm_date1 AS T1_C50,t_work_flow.confirm_date2 AS
T1_C51,t_work_flow.confirm_date3 AS T1_C52,t_work_flow.confirm_date4 AS
T1_C53,t_work_flow.confirm_date5 AS T1_C54,t_work_flow.confirm_date6 AS
T1_C55,t_work_flow.confirm_date7 AS T1_C56,t_work_flow.confirm_date8 AS
T1_C57,t_work_flow.approve_date AS T1_C58 FROM t_work_flow WHERE
work_flow_no = $1 AND (t_work_flow.del_flg<> $2 OR t_work_flow.del_flg IS
NULL) >
2014-01-23 14:56:31 DEBUG: pid 613: encode_key: username xspuser
2014-01-23 14:56:31 DEBUG: pid 613: encode_key: database_name xspdb
2014-01-23 14:56:31 DEBUG: pid 613: encode_key: query SELECT
t_work_flow.company_no AS T1_C1,t_work_flow.shop_no AS
T1_C2,t_work_flow.work_flow_no AS T1_C3,t_work_flow.work_code AS
T1_C4,t_work_flow.action_code AS T1_C5,t_work_flow.work_status AS
T1_C6,t_work_flow.target_url AS T1_C7,t_work_flow.totalization_data AS
T1_C8,t_work_flow.target_action_code AS T1_C9,t_work_flow.admin_user_no AS
T1_C10,t_work_flow.request_user_no AS T1_C11,t_work_flow.confirm_user_no1
AS T1_C12,t_work_flow.confirm_user_no2 AS
T1_C13,t_work_flow.confirm_user_no3 AS T1_C14,t_work_flow.confirm_user_no4
AS T1_C15,t_work_flow.confirm_user_no5 AS
T1_C16,t_work_flow.confirm_user_no6 AS T1_C17,t_work_flow.confirm_user_no7
AS T1_C18,t_work_flow.confirm_user_no8 AS
T1_C19,t_work_flow.approve_user_no AS T1_C20,t_work_flow.yobi_string1 AS
T1_C21,t_work_flow.yobi_string2 AS T1_C22,t_work_flow.yobi_string3 AS
T1_C23,t_work_flow.yobi_string4 AS T1_C24,t_work_flow.yobi_string5 AS
T1_C25,t_work_flow.yobi_num1 AS T1_C26,t_work_flow.yobi_num2 AS
T1_C27,t_work_flow.yobi_num3 AS T1_C28,t_work_flow.yobi_num4 AS
T1_C29,t_work_flow.yobi_num5 AS T1_C30,t_work_flow.yobi_time1 AS
T1_C31,t_work_flow.yobi_time2 AS T1_C32,t_work_flow.yobi_time3 AS
T1_C33,t_work_flow.yobi_time4 AS T1_C34,t_work_flow.yobi_time5 AS
T1_C35,t_work_flow.del_flg AS T1_C36,t_work_flow.del_date AS
T1_C37,t_work_flow.del_person_id AS T1_C38,t_work_flow.del_ipaddress AS
T1_C39,t_work_flow.del_user_agent AS T1_C40,t_work_flow.add_date AS
T1_C41,t_work_flow.add_person_id AS T1_C42,t_work_flow.add_ipaddress AS
T1_C43,t_work_flow.add_user_agent AS T1_C44,t_work_flow.modify_date AS
T1_C45,t_work_flow.modify_person_id AS T1_C46,t_work_flow.modify_ipaddress
AS T1_C47,t_work_flow.modify_user_agent AS T1_C48,t_work_flow.request_date
AS T1_C49,t_work_flow.confirm_date1 AS T1_C50,t_work_flow.confirm_date2 AS
T1_C51,t_work_flow.confirm_date3 AS T1_C52,t_work_flow.confirm_date4 AS
T1_C53,t_work_flow.confirm_date5 AS T1_C54,t_work_flow.confirm_date6 AS
T1_C55,t_work_flow.confirm_date7 AS T1_C56,t_work_flow.confirm_date8 AS
T1_C57,t_work_flow.approve_date AS T1_C58 FROM t_work_flow WHERE
work_flow_no = $1 AND (t_work_flow.del_flg<> $2 OR t_work_flow.del_flg IS
NULL) 0000000000020000000336333300000001310000
2014-01-23 14:56:31 DEBUG: pid 613: encode_key: `xspuserSELECT
t_work_flow.company_no AS T1_C1,t_work_flow.shop_no AS
T1_C2,t_work_flow.work_flow_no AS T1_C3,t_work_flow.work_code AS
T1_C4,t_work_flow.action_code AS T1_C5,t_work_flow.work_status AS
T1_C6,t_work_flow.target_url AS T1_C7,t_work_flow.totalization_data AS
T1_C8,t_work_flow.target_action_code AS T1_C9,t_work_flow.admin_user_no AS
T1_C10,t_work_flow.request_user_no AS T1_C11,t_work_flow.confirm_user_no1
AS T1_C12,t_work_flow.confirm_user_no2 AS
T1_C13,t_work_flow.confirm_user_no3 AS T1_C14,t_work_flow.confirm_user_no4
AS T1_C15,t_work_flow.confirm_user_no5 AS
T1_C16,t_work_flow.confirm_user_no6 AS T1_C17,t_work_flow.confirm_user_no7
AS T1_C18,t_work_flow.confirm_user_no8 AS
T1_C19,t_work_flow.approve_user_no AS T1_C20,t_work_flow.yobi_string1 AS
T1_C21,t_work_flow.yobi_string2 AS T1_C22,t_work_flow.yobi_string3 AS
T1_C23,t_work_flow.yobi_string4 AS T1_C24,t_work_flow.yobi_string5 AS
T1_C25,t_work_flow.yobi_num1 AS T1_C26,t_work_flow.yobi_num2 AS
T1_C27,t_work_flow.yobi_num3 AS T1_C28,t_work_flow.yobi_num4 AS
T1_C29,t_work_flow.yobi_num5 AS T1_C30,t_work_flow.yobi_time1 AS
T1_C31,t_work_flow.yobi_time2 AS T1_C32,t_work_flow.yobi_time3 AS
T1_C33,t_work_flow.yobi_time4 AS T1_C34,t_work_flow.yobi_time5 AS
T1_C35,t_work_flow.del_flg AS T1_C36,t_work_flow.del_date AS
T1_C37,t_work_flow.del_person_id AS T1_C38,t_work_flow.del_ipaddress AS
T1_C39,t_work_flow.del_user_agent AS T1_C40,t_work_flow.add_date AS
T1_C41,t_work_flow.add_person_id AS T1_C42,t_work_flow.add_ipaddress AS
T1_C43,t_work_flow.add_user_agent AS T1_C44,t_work_flow.modify_date AS
T1_C45,t_work_flow.modify_person_id AS T1_C46,t_work_flow.modify_ipaddress
AS T1_C47,t_work_flow.modify_user_agent AS T1_C48,t_work_flow.request_date
AS T1_C49,t_work_flow.confirm_date1 AS T1_C50,t_work_flow.confirm_date2 AS
T1_C51,t_work_flow.confirm_date3 AS T1_C52,t_work_flow.confirm_date4 AS
T1_C53,t_work_flow.confirm_date5 AS T1_C54,t_work_flow.confirm_date6 AS
T1_C55,t_work_flow.confirm_date7 AS T1_C56,t_work_flow.confirm_date8 AS
T1_C57,t_work_flow.approve_date AS T1_C58 FROM t_work_flow WHERE
work_flow_no = $1 AND (t_work_flow.del_flg<> $2 OR t_work_flow.del_flg IS
NULL) 0000000000020000000336333300000001310000xspdb' ->
`e5455205c36a11c2249b964547032887'
2014-01-23 14:56:31 DEBUG: pid 613: pool_fetch_cache: search key
==e5455205c36a11c2249b964547032887==
2014-01-23 14:56:31 DEBUG: pid 613: pool_fetch_cache: query=SELECT
t_work_flow.company_no AS T1_C1,t_work_flow.shop_no AS
T1_C2,t_work_flow.work_flow_no AS T1_C3,t_work_flow.work_code AS
T1_C4,t_work_flow.action_code AS T1_C5,t_work_flow.work_status AS
T1_C6,t_work_flow.target_url AS T1_C7,t_work_flow.totalization_data AS
T1_C8,t_work_flow.target_action_code AS T1_C9,t_work_flow.admin_user_no AS
T1_C10,t_work_flow.request_user_no AS T1_C11,t_work_flow.confirm_user_no1
AS T1_C12,t_work_flow.confirm_user_no2 AS
T1_C13,t_work_flow.confirm_user_no3 AS T1_C14,t_work_flow.confirm_user_no4
AS T1_C15,t_work_flow.confirm_user_no5 AS
T1_C16,t_work_flow.confirm_user_no6 AS T1_C17,t_work_flow.confirm_user_no7
AS T1_C18,t_work_flow.confirm_user_no8 AS
T1_C19,t_work_flow.approve_user_no AS T1_C20,t_work_flow.yobi_string1 AS
T1_C21,t_work_flow.yobi_string2 AS T1_C22,t_work_flow.yobi_string3 AS
T1_C23,t_work_flow.yobi_string4 AS T1_C24,t_work_flow.yobi_string5 AS
T1_C25,t_work_flow.yobi_num1 AS T1_C26,t_work_flow.yobi_num2 AS
T1_C27,t_work_flow.yobi_num3 AS T1_C28,t_work_flow.yobi_num4 AS
T1_C29,t_work_flow.yobi_num5 AS T1_C30,t_work_flow.yobi_time1 AS
T1_C31,t_work_flow.yobi_time2 AS T1_C32,t_work_flow.yobi_time3 AS
T1_C33,t_work_flow.yobi_time4 AS T1_C34,t_work_flow.yobi_time5 AS
T1_C35,t_work_flow.del_flg AS T1_C36,t_work_flow.del_date AS
T1_C37,t_work_flow.del_person_id AS T1_C38,t_work_flow.del_ipaddress AS
T1_C39,t_work_flow.del_user_agent AS T1_C40,t_work_flow.add_date AS
T1_C41,t_work_flow.add_person_id AS T1_C42,t_work_flow.add_ipaddress AS
T1_C43,t_work_flow.add_user_agent AS T1_C44,t_work_flow.modify_date AS
T1_C45,t_work_flow.modify_person_id AS T1_C46,t_work_flow.modify_ipaddress
AS T1_C47,t_work_flow.modify_user_agent AS T1_C48,t_work_flow.request_date
AS T1_C49,t_work_flow.confirm_date1 AS T1_C50,t_work_flow.confirm_date2 AS
T1_C51,t_work_flow.confirm_date3 AS T1_C52,t_work_flow.confirm_date4 AS
T1_C53,t_work_flow.confirm_date5 AS T1_C54,t_work_flow.confirm_date6 AS
T1_C55,t_work_flow.confirm_date7 AS T1_C56,t_work_flow.confirm_date8 AS
T1_C57,t_work_flow.approve_date AS T1_C58 FROM t_work_flow WHERE
work_flow_no = $1 AND (t_work_flow.del_flg<> $2 OR t_work_flow.del_flg IS
NULL) 0000000000020000000336333300000001310000 len:2175
2014-01-23 14:56:31 DEBUG: pid 613: send_cached_messages: D len: 702
2014-01-23 14:56:31 DEBUG: pid 613: send_message: kind=D, len=702,
data=0x1da6077
2014-01-23 14:56:31 DEBUG: pid 613: send_cached_messages: C len: 13
2014-01-23 14:56:31 DEBUG: pid 613: send_message: kind=C, len=13,
data=0x1da6336
2014-01-23 14:56:31 DEBUG: pid 613: pool_fetch_from_memory_cache: expecting
sync: S
2014-01-23 14:56:31 DEBUG: pid 613: send_message: kind=Z, len=5,
data=0x7fff8e381bff
2014-01-23 14:56:31 LOG: pid 613: query result fetched from cache.
statement: SELECT t_work_flow.company_no AS T1_C1,t_work_flow.shop_no AS
T1_C2,t_work_flow.work_flow_no AS T1_C3,t_work_flow.work_code AS
T1_C4,t_work_flow.action_code AS T1_C5,t_work_flow.work_status AS
T1_C6,t_work_flow.target_url AS T1_C7,t_work_flow.totalization_data AS
T1_C8,t_work_flow.target_action_code AS T1_C9,t_work_flow.admin_user_no AS
T1_C10,t_work_flow.request_user_no AS T1_C11,t_work_flow.confirm_user_no1
AS T1_C12,t_work_flow.confirm_user_no2 AS
T1_C13,t_work_flow.confirm_user_no3 AS T1_C14,t_work_flow.confirm_user_no4
AS T1_C15,t_work_flow.confirm_user_no5 AS
T1_C16,t_work_flow.confirm_user_no6 AS T1_C17,t_work_flow.confirm_user_no7
AS T1_C18,t_work_flow.confirm_user_no8 AS
T1_C19,t_work_flow.approve_user_no AS T1_C20,t_work_flow.yobi_string1 AS
T1_C21,t_work_flow.yobi_string2 AS T1_C22,t_work_flow.yobi_string3 AS
T1_C23,t_work_flow.yobi_string4 AS T1_C24,t_work_flow.yobi_string5 AS
T1_C25,t_work_flow.yobi_num1 AS T1_C26,t_work_flow.yobi_num2 AS
T1_C27,t_work_flow.yobi_num3 AS T1_C28,t_work_flow.yobi_num4 AS
T1_C29,t_work_flow.yobi_num5 AS T1_C30,t_work_flow.yobi_time1 AS
T1_C31,t_work_flow.yobi_time2 AS T1_C32,t_work_flow.yobi_time3 AS
T1_C33,t_work_flow.yobi_time4 AS T1_C34,t_work_flow.yobi_time5 AS
T1_C35,t_work_flow.del_flg AS T1_C36,t_work_flow.del_date AS
T1_C37,t_work_flow.del_person_id AS T1_C38,t_work_flow.del_ipaddress AS
T1_C39,t_work_flow.del_user_agent AS T1_C40,t_work_flow.add_date AS
T1_C41,t_work_flow.add_person_id AS T1_C42,t_work_flow.add_ipaddress AS
T1_C43,t_work_flow.add_user_agent AS T1_C44,t_work_flow.modify_date AS
T1_C45,t_work_flow.modify_person_id AS T1_C46,t_work_flow.modify_ipaddress
AS T1_C47,t_work_flow.modify_user_agent AS T1_C48,t_work_flow.request_date
AS T1_C49,t_work_flow.confirm_date1 AS T1_C50,t_work_flow.confirm_date2 AS
T1_C51,t_work_flow.confirm_date3 AS T1_C52,t_work_flow.confirm_date4 AS
T1_C53,t_work_flow.confirm_date5 AS T1_C54,t_work_flow.confirm_date6 AS
T1_C55,t_work_flow.confirm_date7 AS T1_C56,t_work_flow.confirm_date8 AS
T1_C57,t_work_flow.approve_date AS T1_C58 FROM t_work_flow WHERE
work_flow_no = $1 AND (t_work_flow.del_flg<> $2 OR t_work_flow.del_flg IS
NULL) 0000000000020000000336333300000001310000
2014-01-23 14:56:31 DEBUG: pid 613: pool_fetch_from_memory_cache: a query
result found in the query cache, SELECT t_work_flow.company_no AS
T1_C1,t_work_flow.shop_no AS T1_C2,t_work_flow.work_flow_no AS
T1_C3,t_work_flow.work_code AS T1_C4,t_work_flow.action_code AS
T1_C5,t_work_flow.work_status AS T1_C6,t_work_flow.target_url AS
T1_C7,t_work_flow.totalization_data AS T1_C8,t_work_flow.target_action_code
AS T1_C9,t_work_flow.admin_user_no AS T1_C10,t_work_flow.request_user_no AS
T1_C11,t_work_flow.confirm_user_no1 AS T1_C12,t_work_flow.confirm_user_no2
AS T1_C13,t_work_flow.confirm_user_no3 AS
T1_C14,t_work_flow.confirm_user_no4 AS T1_C15,t_work_flow.confirm_user_no5
AS T1_C16,t_work_flow.confirm_user_no6 AS
T1_C17,t_work_flow.confirm_user_no7 AS T1_C18,t_work_flow.confirm_user_no8
AS T1_C19,t_work_flow.approve_user_no AS T1_C20,t_work_flow.yobi_string1 AS
T1_C21,t_work_flow.yobi_string2 AS T1_C22,t_work_flow.yobi_string3 AS
T1_C23,t_work_flow.yobi_string4 AS T1_C24,t_work_flow.yobi_string5 AS
T1_C25,t_work_flow.yobi_num1 AS T1_C26,t_work_flow.yobi_num2 AS
T1_C27,t_work_flow.yobi_num3 AS T1_C28,t_work_flow.yobi_num4 AS
T1_C29,t_work_flow.yobi_num5 AS T1_C30,t_work_flow.yobi_time1 AS
T1_C31,t_work_flow.yobi_time2 AS T1_C32,t_work_flow.yobi_time3 AS
T1_C33,t_work_flow.yobi_time4 AS T1_C34,t_work_flow.yobi_time5 AS
T1_C35,t_work_flow.del_flg AS T1_C36,t_work_flow.del_date AS
T1_C37,t_work_flow.del_person_id AS T1_C38,t_work_flow.del_ipaddress AS
T1_C39,t_work_flow.del_user_agent AS T1_C40,t_work_flow.add_date AS
T1_C41,t_work_flow.add_person_id AS T1_C42,t_work_flow.add_ipaddress AS
T1_C43,t_work_flow.add_user_agent AS T1_C44,t_work_flow.modify_date AS
T1_C45,t_work_flow.modify_person_id AS T1_C46,t_work_flow.modify_ipaddress
AS T1_C47,t_work_flow.modify_user_agent AS T1_C48,t_work_flow.request_date
AS T1_C49,t_work_flow.confirm_date1 AS T1_C50,t_work_flow.confirm_date2 AS
T1_C51,t_work_flow.confirm_date3 AS T1_C52,t_work_flow.confirm_date4 AS
T1_C53,t_work_flow.confirm_date5 AS T1_C54,t_work_flow.confirm_date6 AS
T1_C55,t_work_flow.confirm_date7 AS T1_C56,t_work_flow.confirm_date8 AS
T1_C57,t_work_flow.approve_date AS T1_C58 FROM t_work_flow WHERE
work_flow_no = $1 AND (t_work_flow.del_flg<> $2 OR t_work_flow.del_flg IS
NULL) 0000000000020000000336333300000001310000
$B0J>e$K$J$j$^$9!#(B
$B$h$m$7$/$*4j$$$$$?$7$^$9!#(B
2014/1/23 Tatsuo Ishii <ishii ＠ sraoss.co.jp>
> $B$3$s$P$s$O!#@P0f$G$9!#(B
>
> pgpool.conf$B$r8+$;$F$$$?$@$1$^$9$+!)(B
>
> $B$"$H!"%m%0$N3F9T$,ESCf$G ＠ Z$l$F$$$k$h$&$G$9$,!"40A4$J$b$N$r8+$;$F$$$?$@(B
> $B$1$^$9$+!)(B
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese: http://www.sraoss.co.jp
>
> > $B$*@$OC$K$J$C$F$*$j$^$9!#:4F#$H?=$7$^$9!#(B
> >
> > pgpool3.3.2$B$N%*%s%a%b%j%/%(%j%-%c%C%7%e$K$D$$$F$N<ALd$G$9!#(B
> > $B%/%(%j%-%c%C%7%eM-8z$+L58z$+$G(BSELECT$B7k2L$,0c$C$F$7$^$&$H$$$&LdBj$,=P$F$*$j$^$9!#(B
> >
> > SELECT$B!"(BUPDATE$B!"(BSELECT$B$N=g$K%"%W%j%1!<%7%g%s$NCf$G<B9T$7$F$$$^$9!#(B
> > $B:G8e$N(BSELECT$B$G$O!"(BUPDATE$B8e$N7k2L$,JV$k$N$, ＠ 5$7$$$N$G$9$,!"(B
> > $B%/%(%j%-%c%C%7%eM-8z$K$7$?>l9g0J2<$N$h$&$JF0$-$K$J$j!"(B
> > $B-!$H-#$GF1$87k2L$,JV$C$F$-$F$7$^$C$F$$$^$9!#(B
> >
> > $B-!(B SELECT $B!&!&!&%-%c%C%7%e:n ＠ .(B
> > $B-"(B UPDATE $B!&!&!&%-%c%C%7%e$,$J$<$+:o=|$5$l$J$$(B
> > $B-#(B SELECT $B!&!&!&%-%c%C%7%e$+$i7k2L$,JV$C$F$7$^$&(B
> > $B-$(B COMMIT
> >
> >
> > $B0J2<$N$$$:$l$N>l9g$O!"@5>o$J7k2L$,JV$C$F$-$^$9!#(B
> > $B%/%(%j%-%c%C%7%e$rL58z$K$7$?>l9g(B
> > psql$B$+$i@\B3$7$F(BSQL$B$rN.$7$?>l9g(B
> > /*NO QUERY CACHE*/$B!W%3%a%s%H$rIU$1$?>l9g(B
> >
> >
> > pgpool$B$N;EMM>e$N@)Ls$K0z$C$+$+$C$F$$$k$+IT6q9g$@$H;W$$$^$9!#(B
> > $B2?$+$7$i$N>pJs$rD:$1$^$9$H9,$$$G$9!#(B
> > $BLdBjH/@8$7$?:]$N(Bpgpool$B$N%m%0$rKvHx$K$D$1$^$7$?$,!"(BUPDATE$B8e$K%-%c%C%7%e$,:o=|$5$l$F$$$J$$$N$,5$$K$J$j$^$9!#(B
> >
> >
> > $B0J2<$K3F<o>pJs$r5-:\$5$;$FD:$-$^$9!#(B
> >
> > [$B3F<o4D6-(B]
> > pgpool-II 3.3.2
> > PostgreSQL 9.2.4
> > Web$B%5!<%P!<(B Apache 2.2.23
> > Tomcat Version 7.0.29
> > JDBC$B%I%i%$%P!<(B postgresql-9.1-902.jdbc4.jar
> > Java 1.7.0_05-b06
> >
> > [pgpool$B%G%P%C%/%m%0(B]
> >
> ----------------------------------------------------------------------------------------------------------------------------------
> > 2014-01-23 14:56:31 DEBUG: pid 613: send_to_where: 0 query: UPDATE
> > t_work_flow SET company_no = $1 , action_code = $2 , work_st
> > 2014-01-23 14:56:31 DEBUG: pid 613: Parse: waiting for master
> > completing the query
> > 2014-01-23 14:56:31 LOG: pid 613: DB node id: 0 backend pid: 5317
> > statement: Parse: UPDATE t_work_flow SET company_no = $1 , a
> > 2014-01-23 14:56:31 DEBUG: pid 613: wait_for_query_response: waiting
> > for backend 0 completing the query
> > 2014-01-23 14:56:31 DEBUG: pid 613: detect_error: kind: 1
> > 2014-01-23 14:56:31 DEBUG: pid 613:
> pool_unset_skip_reading_from_backends: done
> > 2014-01-23 14:56:31 DEBUG: pid 613: read_kind_from_one_backend: read
> > kind from 0 th backend 1
> > 2014-01-23 14:56:31 DEBUG: pid 613: read_kind_from_backend: kind: 1
> > from 0 th backend
> > 2014-01-23 14:56:31 DEBUG: pid 613: read_kind_from_backend: read kind
> > from 0 th backend 1 NUM_BACKENDS: 2
> > 2014-01-23 14:56:31 DEBUG: pid 613: ProcessBackendResponse: kind from
> backend: 1
> > 2014-01-23 14:56:31 DEBUG: pid 613: pool_add_sent_message: prepared
> > statement "" already exists
> > 2014-01-23 14:56:31 DEBUG: pid 613: can_query_context_destroy: query
> > context 0x1d4c1e0 is still used. query: SELECT t_work_flow.co
> > 2014-01-23 14:56:31 DEBUG: pid 613: can_query_context_destroy: query
> > context 0x1d4c1e0 is still used. query: SELECT t_work_flow.co
> > 2014-01-23 14:56:31 DEBUG: pid 613: can_query_context_destroy: query
> > context 0x1d4c1e0 is still used for 2 times.
> > 2014-01-23 14:56:31 DEBUG: pid 613: pool_set_command_success: done
> > 2014-01-23 14:56:31 DEBUG: pid 613: pool_unset_query_in_progress: done
> > 2014-01-23 14:56:31 DEBUG: pid 613: ProcessFrontendResponse: kind from
> > frontend B(42)
> > 2014-01-23 14:56:31 DEBUG: pid 613:
> > pool_unset_doing_extended_query_message: done
> > 2014-01-23 14:56:31 DEBUG: pid 613:
> pool_set_doing_extended_query_message: done
> > 2014-01-23 14:56:31 DEBUG: pid 613: pool_set_query_in_progress: done
> > 2014-01-23 14:56:31 DEBUG: pid 613: Bind: waiting for master
> > completing the query
> > 2014-01-23 14:56:31 LOG: pid 613: DB node id: 0 backend pid: 5317
> > statement: B message
> > 2014-01-23 14:56:31 DEBUG: pid 613: wait_for_query_response: waiting
> > for backend 0 completing the query
> > 2014-01-23 14:56:31 DEBUG: pid 613: read_kind_from_one_backend: read
> > kind from 0 th backend 2
> > 2014-01-23 14:56:31 DEBUG: pid 613: read_kind_from_backend: kind: 2
> > from 0 th backend
> > 2014-01-23 14:56:31 DEBUG: pid 613: read_kind_from_backend: read kind
> > from 0 th backend 2 NUM_BACKENDS: 2
> > 2014-01-23 14:56:31 DEBUG: pid 613: ProcessBackendResponse: kind from
> backend: 2
> > 2014-01-23 14:56:31 DEBUG: pid 613: pool_add_sent_message: portal ""
> > already exists
> > 2014-01-23 14:56:31 DEBUG: pid 613: can_query_context_destroy: query
> > context 0x1d4c1e0 is still used. query: SELECT t_work_flow.co
> > 2014-01-23 14:56:31 DEBUG: pid 613: pool_unset_query_in_progress: done
> > 2014-01-23 14:56:31 DEBUG: pid 613: pool_set_query_in_progress: done
> > 2014-01-23 14:56:31 DEBUG: pid 613: pool_set_command_success: done
> > 2014-01-23 14:56:31 DEBUG: pid 613: pool_unset_query_in_progress: done
> > 2014-01-23 14:56:31 DEBUG: pid 613: ProcessFrontendResponse: kind from
> > frontend D(44)
> > 2014-01-23 14:56:31 DEBUG: pid 613:
> > pool_unset_doing_extended_query_message: done
> > 2014-01-23 14:56:31 DEBUG: pid 613:
> pool_set_doing_extended_query_message: done
> > 2014-01-23 14:56:31 DEBUG: pid 613: pool_set_query_in_progress: done
> > 2014-01-23 14:56:31 DEBUG: pid 613: Describe: waiting for master
> > completing the query
> > 2014-01-23 14:56:31 LOG: pid 613: DB node id: 0 backend pid: 5317
> > statement: D message
> > 2014-01-23 14:56:31 DEBUG: pid 613: wait_for_query_response: waiting
> > for backend 0 completing the query
> > 2014-01-23 14:56:31 DEBUG: pid 613: read_kind_from_one_backend: read
> > kind from 0 th backend n
> > 2014-01-23 14:56:31 DEBUG: pid 613: read_kind_from_backend: kind: n
> > from 0 th backend
> > 2014-01-23 14:56:31 DEBUG: pid 613: read_kind_from_backend: read kind
> > from 0 th backend n NUM_BACKENDS: 2
> > 2014-01-23 14:56:31 DEBUG: pid 613: ProcessBackendResponse: kind from
> backend: n
> > 2014-01-23 14:56:31 DEBUG: pid 613: pool_unset_query_in_progress: done
> > 2014-01-23 14:56:31 DEBUG: pid 613: ProcessFrontendResponse: kind from
> > frontend E(45)
> > 2014-01-23 14:56:31 DEBUG: pid 613:
> > pool_unset_doing_extended_query_message: done
> > 2014-01-23 14:56:31 DEBUG: pid 613:
> pool_set_doing_extended_query_message: done
> > 2014-01-23 14:56:31 DEBUG: pid 613: pool_set_query_in_progress: done
> > 2014-01-23 14:56:31 DEBUG: pid 613: Execute: portal name <>
> > 2014-01-23 14:56:31 DEBUG: pid 613: Execute: query string = < UPDATE
> > t_work_flow SET company_no = $1 , action_code = $2 , work_s
> > 2014-01-23 14:56:31 LOG: pid 613: DB node id: 0 backend pid: 5317
> > statement: Execute: UPDATE t_work_flow SET company_no = $1 ,
> > 2014-01-23 14:56:31 DEBUG: pid 613: wait_for_query_response: waiting
> > for backend 0 completing the query
> > 2014-01-23 14:56:31 DEBUG: pid 613: read_kind_from_one_backend: read
> > kind from 0 th backend C
> > 2014-01-23 14:56:31 DEBUG: pid 613: read_kind_from_backend: kind: C
> > from 0 th backend
> > 2014-01-23 14:56:31 DEBUG: pid 613: read_kind_from_backend: read kind
> > from 0 th backend C NUM_BACKENDS: 2
> > 2014-01-23 14:56:31 DEBUG: pid 613: ProcessBackendResponse: kind from
> backend: C
> > 2014-01-23 14:56:31 DEBUG: pid 613: pool_set_command_success: done
> > 2014-01-23 14:56:31 DEBUG: pid 613: pool_unset_query_in_progress: done
> > 2014-01-23 14:56:31 DEBUG: pid 613: ProcessFrontendResponse: kind from
> > frontend S(53)
> > 2014-01-23 14:56:31 DEBUG: pid 613:
> > pool_unset_doing_extended_query_message: done
> > 2014-01-23 14:56:31 DEBUG: pid 613:
> pool_set_doing_extended_query_message: done
> > 2014-01-23 14:56:31 DEBUG: pid 613: pool_set_query_in_progress: done
> > 2014-01-23 14:56:31 DEBUG: pid 613: read_kind_from_one_backend: read
> > kind from 0 th backend Z
> > 2014-01-23 14:56:31 DEBUG: pid 613: read_kind_from_backend: kind: Z
> > from 0 th backend
> > 2014-01-23 14:56:31 DEBUG: pid 613: read_kind_from_backend: read kind
> > from 0 th backend Z NUM_BACKENDS: 2
> > 2014-01-23 14:56:31 DEBUG: pid 613: ProcessBackendResponse: kind from
> backend: Z
> > 2014-01-23 14:56:31 DEBUG: pid 613: pool_read_message_length: slot: 0
> length: 5
> > 2014-01-23 14:56:31 DEBUG: pid 613: ReadyForQuery: transaction state:T
> > 2014-01-23 14:56:31 DEBUG: pid 613: pool_set_writing_transaction: done
> > 2014-01-23 14:56:31 DEBUG: pid 613: pool_unset_query_in_progress: done
> > 2014-01-23 14:56:31 DEBUG: pid 613: ProcessBackendResponse: Ready For
> Query
> > 2014-01-23 14:56:31 DEBUG: pid 613: ProcessFrontendResponse: kind from
> > frontend P(50)
> > 2014-01-23 14:56:31 DEBUG: pid 613:
> > pool_unset_doing_extended_query_message: done
> > 2014-01-23 14:56:31 DEBUG: pid 613:
> pool_set_doing_extended_query_message: done
> > 2014-01-23 14:56:31 DEBUG: pid 613: pool_set_query_in_progress: done
> > 2014-01-23 14:56:31 DEBUG: pid 613: Parse: statement name <>
> > 2014-01-23 14:56:31 DEBUG: pid 613: pool_set_query_in_progress: done
> > 2014-01-23 14:56:31 DEBUG: pid 613:
> > pool_has_insertinto_or_locking_clause: returns 0
> > 2014-01-23 14:56:31 DEBUG: pid 613:
> pool_has_non_immutable_function_call: 0
> > 2014-01-23 14:56:31 DEBUG: pid 613: temp_table_walker: relname:
> t_work_flow
> > 2014-01-23 14:56:31 DEBUG: pid 613: system_catalog_walker: relname:
> t_work_flow
> > 2014-01-23 14:56:31 DEBUG: pid 613: make_table_name_from_rangevar:
> > tablename:t_work_flow
> > 2014-01-23 14:56:31 DEBUG: pid 613: view_walker: relname: t_work_flow
> > 2014-01-23 14:56:31 DEBUG: pid 613: make_table_name_from_rangevar:
> > tablename:t_work_flow
> > 2014-01-23 14:56:31 DEBUG: pid 613: unlogged_table_walker: relname:
> t_work_flow
> > 2014-01-23 14:56:31 DEBUG: pid 613:
> > pool_has_insertinto_or_locking_clause: returns 0
> > 2014-01-23 14:56:31 DEBUG: pid 613: send_to_where: 2 query: SELECT
> > t_work_flow.company_no AS T1_C1,t_work_flow.shop_no AS T1_C2,t_
> > 2014-01-23 14:56:31 DEBUG: pid 613: Parse: waiting for master
> > completing the query
> > 2014-01-23 14:56:31 LOG: pid 613: DB node id: 0 backend pid: 5317
> > statement: Parse: SELECT t_work_flow.company_no AS T1_C1,t_wor
> > 2014-01-23 14:56:31 DEBUG: pid 613: wait_for_query_response: waiting
> > for backend 0 completing the query
> > 2014-01-23 14:56:31 DEBUG: pid 613: detect_error: kind: 1
> > 2014-01-23 14:56:31 DEBUG: pid 613: read_kind_from_one_backend: read
> > kind from 0 th backend 1
> > 2014-01-23 14:56:31 DEBUG: pid 613: read_kind_from_backend: kind: 1
> > from 0 th backend
> > 2014-01-23 14:56:31 DEBUG: pid 613: read_kind_from_backend: read kind
> > from 0 th backend 1 NUM_BACKENDS: 2
> > 2014-01-23 14:56:31 DEBUG: pid 613: ProcessBackendResponse: kind from
> backend: 1
> > 2014-01-23 14:56:31 DEBUG: pid 613: pool_add_sent_message: prepared
> > statement "" already exists
> > 2014-01-23 14:56:31 DEBUG: pid 613: can_query_context_destroy: query
> > context 0x1b2be60 is still used. query: UPDATE t_work_flow SE
> > 2014-01-23 14:56:31 DEBUG: pid 613: can_query_context_destroy: query
> > context 0x1b2be60 is still used. query: UPDATE t_work_flow SE
> > 2014-01-23 14:56:31 DEBUG: pid 613: can_query_context_destroy: query
> > context 0x1b2be60 is still used for 2 times.
> > 2014-01-23 14:56:31 DEBUG: pid 613: pool_add_buffer: realloc old
> > size:0 new size:8192
> > 2014-01-23 14:56:31 DEBUG: pid 613: pool_add_buffer: len:1, total:1
> bufsize:8192
> > 2014-01-23 14:56:31 DEBUG: pid 613: pool_add_buffer: len:4, total:5
> bufsize:8192
> > 2014-01-23 14:56:31 DEBUG: pid 613: pool_set_command_success: done
> > 2014-01-23 14:56:31 DEBUG: pid 613: pool_unset_query_in_progress: done
> > 2014-01-23 14:56:31 DEBUG: pid 613: ProcessFrontendResponse: kind from
> > frontend B(42)
> > 2014-01-23 14:56:31 DEBUG: pid 613:
> > pool_unset_doing_extended_query_message: done
> > 2014-01-23 14:56:31 DEBUG: pid 613:
> pool_set_doing_extended_query_message: done
> > 2014-01-23 14:56:31 DEBUG: pid 613: pool_set_query_in_progress: done
> > 2014-01-23 14:56:31 DEBUG: pid 613:
> > pool_has_insertinto_or_locking_clause: returns 0
> > 2014-01-23 14:56:31 DEBUG: pid 613: send_to_where: 2 query: SELECT
> > t_work_flow.company_no AS T1_C1,t_work_flow.shop_no AS T1_C2,t_
> > 2014-01-23 14:56:31 DEBUG: pid 613: Bind: waiting for master
> > completing the query
> > 2014-01-23 14:56:31 LOG: pid 613: DB node id: 0 backend pid: 5317
> > statement: B message
> > 2014-01-23 14:56:31 DEBUG: pid 613: wait_for_query_response: waiting
> > for backend 0 completing the query
> > 2014-01-23 14:56:31 DEBUG: pid 613: read_kind_from_one_backend: read
> > kind from 0 th backend 2
> > 2014-01-23 14:56:31 DEBUG: pid 613: read_kind_from_backend: kind: 2
> > from 0 th backend
> > 2014-01-23 14:56:31 DEBUG: pid 613: read_kind_from_backend: read kind
> > from 0 th backend 2 NUM_BACKENDS: 2
> > 2014-01-23 14:56:31 DEBUG: pid 613: ProcessBackendResponse: kind from
> backend: 2
> > 2014-01-23 14:56:31 DEBUG: pid 613: pool_add_sent_message: portal ""
> > already exists
> > 2014-01-23 14:56:31 DEBUG: pid 613: can_query_context_destroy: query
> > context 0x1b2be60 is still used. query: UPDATE t_work_flow SE
> > 2014-01-23 14:56:31 DEBUG: pid 613: pool_unset_query_in_progress: done
> > 2014-01-23 14:56:31 DEBUG: pid 613: pool_set_query_in_progress: done
> > 2014-01-23 14:56:31 DEBUG: pid 613: pool_add_buffer: len:1, total:6
> bufsize:8192
> > 2014-01-23 14:56:31 DEBUG: pid 613: pool_add_buffer: len:4, total:10
> > bufsize:8192
> > 2014-01-23 14:56:31 DEBUG: pid 613: pool_set_command_success: done
> > 2014-01-23 14:56:31 DEBUG: pid 613: pool_unset_query_in_progress: done
> > 2014-01-23 14:56:31 DEBUG: pid 613: ProcessFrontendResponse: kind from
> > frontend D(44)
> > 2014-01-23 14:56:31 DEBUG: pid 613:
> > pool_unset_doing_extended_query_message: done
> > 2014-01-23 14:56:31 DEBUG: pid 613:
> pool_set_doing_extended_query_message: done
> > 2014-01-23 14:56:31 DEBUG: pid 613: pool_set_query_in_progress: done
> > 2014-01-23 14:56:31 DEBUG: pid 613: Describe: waiting for master
> > completing the query
> > 2014-01-23 14:56:31 LOG: pid 613: DB node id: 0 backend pid: 5317
> > statement: D message
> > 2014-01-23 14:56:31 DEBUG: pid 613: wait_for_query_response: waiting
> > for backend 0 completing the query
> > 2014-01-23 14:56:31 DEBUG: pid 613: read_kind_from_one_backend: read
> > kind from 0 th backend T
> > 2014-01-23 14:56:31 DEBUG: pid 613: read_kind_from_backend: kind: T
> > from 0 th backend
> > 2014-01-23 14:56:31 DEBUG: pid 613: read_kind_from_backend: read kind
> > from 0 th backend T NUM_BACKENDS: 2
> > 2014-01-23 14:56:31 DEBUG: pid 613: ProcessBackendResponse: kind from
> backend: T
> > 2014-01-23 14:56:31 DEBUG: pid 613: pool_add_buffer: len:1, total:11
> > bufsize:8192
> > 2014-01-23 14:56:31 DEBUG: pid 613: pool_add_buffer: len:4, total:15
> > bufsize:8192
> > 2014-01-23 14:56:31 DEBUG: pid 613: pool_add_buffer: len:1443,
> > total:1458 bufsize:8192
> > 2014-01-23 14:56:31 DEBUG: pid 613: pool_unset_query_in_progress: done
> > 2014-01-23 14:56:31 DEBUG: pid 613: ProcessFrontendResponse: kind from
> > frontend E(45)
> > 2014-01-23 14:56:31 DEBUG: pid 613:
> > pool_unset_doing_extended_query_message: done
> > 2014-01-23 14:56:31 DEBUG: pid 613:
> pool_set_doing_extended_query_message: done
> > 2014-01-23 14:56:31 DEBUG: pid 613: pool_set_query_in_progress: done
> > 2014-01-23 14:56:31 DEBUG: pid 613: Execute: portal name <>
> > 2014-01-23 14:56:31 DEBUG: pid 613: Execute: query string = SELECT
> > t_work_flow.company_no AS T1_C1,t_work_flow.shop_no AS T1_C2,t
> > 2014-01-23 14:56:31 DEBUG: pid 613: encode_key: username xspuser
> > 2014-01-23 14:56:31 DEBUG: pid 613: encode_key: database_name xspdb
> > 2014-01-23 14:56:31 DEBUG: pid 613: encode_key: query SELECT
> > t_work_flow.company_no AS T1_C1,t_work_flow.shop_no AS T1_C2,t_work_f
> > 2014-01-23 14:56:31 DEBUG: pid 613: encode_key: `xspuserSELECT
> > t_work_flow.company_no AS T1_C1,t_work_flow.shop_no AS T1_C2,t_work
> > 2014-01-23 14:56:31 DEBUG: pid 613: pool_fetch_cache: search key
> > ==e5455205c36a11c2249b964547032887==
> > 2014-01-23 14:56:31 DEBUG: pid 613: pool_fetch_cache: query=SELECT
> > t_work_flow.company_no AS T1_C1,t_work_flow.shop_no AS T1_C2,t_
> > 2014-01-23 14:56:31 DEBUG: pid 613: send_cached_messages: D len: 702
> > 2014-01-23 14:56:31 DEBUG: pid 613: send_message: kind=D, len=702,
> > data=0x1da6077
> > 2014-01-23 14:56:31 DEBUG: pid 613: send_cached_messages: C len: 13
> > 2014-01-23 14:56:31 DEBUG: pid 613: send_message: kind=C, len=13,
> data=0x1da6336
> > 2014-01-23 14:56:31 DEBUG: pid 613: pool_fetch_from_memory_cache:
> > expecting sync: S
> > 2014-01-23 14:56:31 DEBUG: pid 613: send_message: kind=Z, len=5,
> > data=0x7fff8e381bff
> > 2014-01-23 14:56:31 LOG: pid 613: query result fetched from cache.
> > statement: SELECT t_work_flow.company_no AS T1_C1,t_work_flow
> > 2014-01-23 14:56:31 DEBUG: pid 613: pool_fetch_from_memory_cache: a
> > query result found in the query cache, SELECT t_work_flow.comp
> >
> ----------------------------------------------------------------------------------------------------------------------------------
> >
> > $B$h$m$7$/$*4j$$$$$?$7$^$9!#(B
> >
> > --
> > $B!=!=!=!=!=!=!=!=!=!=!=!=!=!=!=!=!=!=!=!=!=!=!=!=!=(B
> > $B:4F#(B $B?5(B
> > $B3t<02q<R%(%k%F%C%/%9(B
> > $B%7%9%F%`%^%M!<%8%a%s%H%5!<%S%9It(B
> > $B")(B240-0005 $B2#IM;TJ]EZ%vC+6h?@8MD.(B134
> > $B2#IM%S%8%M%9%Q!<%/(B $B%$!<%9%H%?%o!<(B14$B3,(B
> > $BEEOC!'(B045-332-7865 Fax$B!'(B045-332-6644
> > URL $B!'(Bhttp://www.eltex.co.jp/
> > facebook$B!'(Bhttp://www.facebook.com/ELTEXinc
> > $B!=!=!=!=!=!=!=!=!=!=!=!=!=!=!=!=!=!=(B(c)ELTEX, Inc.
>
--
$B!=!=!=!=!=!=!=!=!=!=!=!=!=!=!=!=!=!=!=!=!=!=!=!=!=(B
$B:4F#(B $B?5(B
$B3t<02q<R%(%k%F%C%/%9(B
$B%7%9%F%`%^%M!<%8%a%s%H%5!<%S%9It(B
$B")(B240-0005 $B2#IM;TJ]EZ%vC+6h?@8MD.(B134
$B2#IM%S%8%M%9%Q!<%/(B $B%$!<%9%H%?%o!<(B14$B3,(B
$BEEOC!'(B045-332-7865 Fax$B!'(B045-332-6644
URL $B!'(Bhttp://www.eltex.co.jp/
facebook$B!'(Bhttp://www.facebook.com/ELTEXinc
$B!=!=!=!=!=!=!=!=!=!=!=!=!=!=!=!=!=!=(B(c)ELTEX, Inc.
-------------- next part --------------
HTML$B$NE:IU%U%!%$%k$rJ]4I$7$^$7$?(B...
URL: <http://www.sraoss.jp/pipermail/pgpool-general-jp/attachments/20140124/663be722/attachment-0001.html>
pgpool-general-jp メーリングリストの案内