[Pgpool-general] stuck with a shmem_exit after the loading of "/usr/local/etc/pool_hba.conf"

Thu Feb 3 09:02:21 UTC 2011

I am getting the following error when I try to run Pgpool. I am trying to
use postgresql 9.0 hot streaming and then load balancing capability of
Pgpool. However, I am stuck with a shmem_exit after the loading
of "/usr/local/etc/pool_hba.conf", as attached below. Please let me know
what could be wrong.

2011-02-03 08:53:20 DEBUG: pid 12138: key: listen_addresses
2011-02-03 08:53:20 DEBUG: pid 12138: value: '*' kind: 4
2011-02-03 08:53:20 DEBUG: pid 12138: key: port
2011-02-03 08:53:20 DEBUG: pid 12138: value: 9999 kind: 2
2011-02-03 08:53:20 DEBUG: pid 12138: key: pcp_port
2011-02-03 08:53:20 DEBUG: pid 12138: value: 9898 kind: 2
2011-02-03 08:53:20 DEBUG: pid 12138: key: socket_dir
2011-02-03 08:53:20 DEBUG: pid 12138: value: '/var/run/postgresql' kind: 4
2011-02-03 08:53:20 DEBUG: pid 12138: key: pcp_socket_dir
2011-02-03 08:53:20 DEBUG: pid 12138: value: '/tmp' kind: 4
2011-02-03 08:53:20 DEBUG: pid 12138: key: backend_socket_dir
2011-02-03 08:53:20 DEBUG: pid 12138: value: '/var/run/postgresql' kind: 4
2011-02-03 08:53:20 DEBUG: pid 12138: key: pcp_timeout
2011-02-03 08:53:20 DEBUG: pid 12138: value: 10 kind: 2
2011-02-03 08:53:20 DEBUG: pid 12138: key: num_init_children
2011-02-03 08:53:20 DEBUG: pid 12138: value: 32 kind: 2
2011-02-03 08:53:20 DEBUG: pid 12138: key: max_pool
2011-02-03 08:53:20 DEBUG: pid 12138: value: 4 kind: 2
2011-02-03 08:53:20 DEBUG: pid 12138: key: child_life_time
2011-02-03 08:53:20 DEBUG: pid 12138: value: 0 kind: 2
2011-02-03 08:53:20 DEBUG: pid 12138: key: connection_life_time
2011-02-03 08:53:20 DEBUG: pid 12138: value: 0 kind: 2
2011-02-03 08:53:20 DEBUG: pid 12138: key: child_max_connections
2011-02-03 08:53:20 DEBUG: pid 12138: value: 0 kind: 2
2011-02-03 08:53:20 DEBUG: pid 12138: key: client_idle_limit
2011-02-03 08:53:20 DEBUG: pid 12138: value: 0 kind: 2
2011-02-03 08:53:20 DEBUG: pid 12138: key: authentication_timeout
2011-02-03 08:53:20 DEBUG: pid 12138: value: 60 kind: 2
2011-02-03 08:53:20 DEBUG: pid 12138: key: logdir
2011-02-03 08:53:20 DEBUG: pid 12138: value: '/var/log/pgpool' kind: 4
2011-02-03 08:53:20 DEBUG: pid 12138: key: pid_file_name
2011-02-03 08:53:20 DEBUG: pid 12138: value: '/var/run/pgpool/pgpool.pid'
kind: 4
2011-02-03 08:53:20 DEBUG: pid 12138: key: replication_mode
2011-02-03 08:53:20 DEBUG: pid 12138: value: true kind: 1
2011-02-03 08:53:20 DEBUG: pid 12138: key: load_balance_mode
2011-02-03 08:53:20 DEBUG: pid 12138: value: true kind: 1
2011-02-03 08:53:20 DEBUG: pid 12138: key: replication_stop_on_mismatch
2011-02-03 08:53:20 DEBUG: pid 12138: value: false kind: 1
2011-02-03 08:53:20 DEBUG: pid 12138: replication_stop_on_mismatch: 0
2011-02-03 08:53:20 DEBUG: pid 12138: key:
failover_if_affected_tuples_mismatch
2011-02-03 08:53:20 DEBUG: pid 12138: value: true kind: 1
2011-02-03 08:53:20 DEBUG: pid 12138: failover_if_affected_tuples_mismatch:
1
2011-02-03 08:53:20 DEBUG: pid 12138: key: replicate_select
2011-02-03 08:53:20 DEBUG: pid 12138: value: false kind: 1
2011-02-03 08:53:20 DEBUG: pid 12138: replicate_select: 0
2011-02-03 08:53:20 DEBUG: pid 12138: key: reset_query_list
2011-02-03 08:53:20 DEBUG: pid 12138: value: 'ABORT;DISCARD ALL' kind: 4
2011-02-03 08:53:20 DEBUG: pid 12138: extract_string_tokens: token: ABORT
2011-02-03 08:53:20 DEBUG: pid 12138: extract_string_tokens: token: DISCARD
ALL
2011-02-03 08:53:20 DEBUG: pid 12138: key: white_function_list
2011-02-03 08:53:20 DEBUG: pid 12138: value: '' kind: 4
2011-02-03 08:53:20 DEBUG: pid 12138: key: black_function_list
2011-02-03 08:53:20 DEBUG: pid 12138: value: 'nextval,setval,foo' kind: 4
2011-02-03 08:53:20 DEBUG: pid 12138: extract_string_tokens: token: nextval
2011-02-03 08:53:20 DEBUG: pid 12138: extract_string_tokens: token: setval
2011-02-03 08:53:20 DEBUG: pid 12138: extract_string_tokens: token: foo
2011-02-03 08:53:20 DEBUG: pid 12138: key: print_timestamp
2011-02-03 08:53:20 DEBUG: pid 12138: value: true kind: 1
2011-02-03 08:53:20 DEBUG: pid 12138: key: master_slave_mode
2011-02-03 08:53:20 DEBUG: pid 12138: value: false kind: 1
2011-02-03 08:53:20 DEBUG: pid 12138: key: master_slave_sub_mode
2011-02-03 08:53:20 DEBUG: pid 12138: value: 'stream' kind: 4
2011-02-03 08:53:20 DEBUG: pid 12138: key: delay_threshold
2011-02-03 08:53:20 DEBUG: pid 12138: value: 100 kind: 2
2011-02-03 08:53:20 DEBUG: pid 12138: key: log_standby_delay
2011-02-03 08:53:20 DEBUG: pid 12138: value: 'if_over_threshold' kind: 4
2011-02-03 08:53:20 DEBUG: pid 12138: key: connection_cache
2011-02-03 08:53:20 DEBUG: pid 12138: value: true kind: 1
2011-02-03 08:53:20 DEBUG: pid 12138: key: health_check_timeout
2011-02-03 08:53:20 DEBUG: pid 12138: value: 10 kind: 2
2011-02-03 08:53:20 DEBUG: pid 12138: key: health_check_period
2011-02-03 08:53:20 DEBUG: pid 12138: value: 10 kind: 2
2011-02-03 08:53:20 DEBUG: pid 12138: key: health_check_user
2011-02-03 08:53:20 DEBUG: pid 12138: value: 'www-data' kind: 4
2011-02-03 08:53:20 DEBUG: pid 12138: key: failover_command
2011-02-03 08:53:20 DEBUG: pid 12138: value: '/usr/local/etc/failover.sh %d
"%h" %p %D %m %M "%H" %P' kind: 4
2011-02-03 08:53:20 DEBUG: pid 12138: key: failback_command
2011-02-03 08:53:20 DEBUG: pid 12138: value: '/bin/rm -f /tmp/trigger_file1'
kind: 4
2011-02-03 08:53:20 DEBUG: pid 12138: key: fail_over_on_backend_error
2011-02-03 08:53:20 DEBUG: pid 12138: value: false kind: 1
2011-02-03 08:53:20 DEBUG: pid 12138: key: insert_lock
2011-02-03 08:53:20 DEBUG: pid 12138: value: true kind: 1
2011-02-03 08:53:20 DEBUG: pid 12138: key: ignore_leading_white_space
2011-02-03 08:53:20 DEBUG: pid 12138: value: false kind: 1
2011-02-03 08:53:20 DEBUG: pid 12138: key: log_statement
2011-02-03 08:53:20 DEBUG: pid 12138: value: true kind: 1
2011-02-03 08:53:20 DEBUG: pid 12138: key: log_per_node_statement
2011-02-03 08:53:20 DEBUG: pid 12138: value: true kind: 1
2011-02-03 08:53:20 DEBUG: pid 12138: key: log_connections
2011-02-03 08:53:20 DEBUG: pid 12138: value: false kind: 1
2011-02-03 08:53:20 DEBUG: pid 12138: key: log_hostname
2011-02-03 08:53:20 DEBUG: pid 12138: value: false kind: 1
2011-02-03 08:53:20 DEBUG: pid 12138: key: parallel_mode
2011-02-03 08:53:20 DEBUG: pid 12138: value: false kind: 1
2011-02-03 08:53:20 DEBUG: pid 12138: key: enable_query_cache
2011-02-03 08:53:20 DEBUG: pid 12138: value: false kind: 1
2011-02-03 08:53:20 DEBUG: pid 12138: key: pgpool2_hostname
2011-02-03 08:53:20 DEBUG: pid 12138: value: '67.23.26.182' kind: 4
2011-02-03 08:53:20 DEBUG: pid 12138: key: system_db_hostname
2011-02-03 08:53:20 DEBUG: pid 12138: value: '67.23.26.182' kind: 4
2011-02-03 08:53:20 DEBUG: pid 12138: key: system_db_port
2011-02-03 08:53:20 DEBUG: pid 12138: value: 5432 kind: 2
2011-02-03 08:53:20 DEBUG: pid 12138: key: system_db_dbname
2011-02-03 08:53:20 DEBUG: pid 12138: value: 'pgpool' kind: 4
2011-02-03 08:53:20 DEBUG: pid 12138: key: system_db_schema
2011-02-03 08:53:20 DEBUG: pid 12138: value: 'pgpool_catalog' kind: 4
2011-02-03 08:53:20 DEBUG: pid 12138: key: system_db_user
2011-02-03 08:53:20 DEBUG: pid 12138: value: 'pgpool' kind: 4
2011-02-03 08:53:20 DEBUG: pid 12138: key: system_db_password
2011-02-03 08:53:20 DEBUG: pid 12138: value: '' kind: 4
2011-02-03 08:53:20 DEBUG: pid 12138: key: enable_pool_hba
2011-02-03 08:53:20 DEBUG: pid 12138: value: true kind: 1
2011-02-03 08:53:20 DEBUG: pid 12138: key: pool_passwd
2011-02-03 08:53:20 DEBUG: pid 12138: value: 'pool_passwd' kind: 4
2011-02-03 08:53:20 DEBUG: pid 12138: key: recovery_user
2011-02-03 08:53:20 DEBUG: pid 12138: value: 'postgres' kind: 4
2011-02-03 08:53:20 DEBUG: pid 12138: key: recovery_password
2011-02-03 08:53:20 DEBUG: pid 12138: value: 'pgpoolAdmin' kind: 4
2011-02-03 08:53:20 DEBUG: pid 12138: key: recovery_1st_stage_command
2011-02-03 08:53:20 DEBUG: pid 12138: value: 'basebackup.sh' kind: 4
2011-02-03 08:53:20 DEBUG: pid 12138: key: recovery_2nd_stage_command
2011-02-03 08:53:20 DEBUG: pid 12138: value: '' kind: 4
2011-02-03 08:53:20 DEBUG: pid 12138: key: recovery_timeout
2011-02-03 08:53:20 DEBUG: pid 12138: value: 60 kind: 2
2011-02-03 08:53:20 DEBUG: pid 12138: key: client_idle_limit_in_recovery
2011-02-03 08:53:20 DEBUG: pid 12138: value: 0 kind: 2
2011-02-03 08:53:20 DEBUG: pid 12138: key: lobj_lock_table
2011-02-03 08:53:20 DEBUG: pid 12138: value: 'pgpool_lobj_lock' kind: 4
2011-02-03 08:53:20 DEBUG: pid 12138: key: ssl
2011-02-03 08:53:20 DEBUG: pid 12138: value: true kind: 1
2011-02-03 08:53:20 DEBUG: pid 12138: key: ssl_key
2011-02-03 08:53:20 DEBUG: pid 12138: value: '/usr/local/etc/server.key'
kind: 4
2011-02-03 08:53:20 DEBUG: pid 12138: key: ssl_cert
2011-02-03 08:53:20 DEBUG: pid 12138: value: '/usr/local/etc/server.crt'
kind: 4
2011-02-03 08:53:20 DEBUG: pid 12138: key: debug_level
2011-02-03 08:53:20 DEBUG: pid 12138: value: 0 kind: 2
2011-02-03 08:53:20 DEBUG: pid 12138: loading "/usr/local/etc/pool_hba.conf"
for client authentication configuration file
2011-02-03 08:53:20 DEBUG: pid 12138: shmem_exit(0)

thanks,
Bharath
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20110203/5f292332/attachment.html>