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

Thu Feb 3 09:10:15 UTC 2011

That is the correct output. I think, pgpool must be running fine. Did you check 
your processes after this? What options do you give while starting pgpool? Use 
"pgpool -d -D -f pgpool.conf". 

________________________________
From: Bharath Keshav <bharath.keshav at gmail.com>
To: pgpool-general at pgfoundry.org
Sent: Thu, February 3, 2011 2:32:21 PM
Subject: [Pgpool-general] stuck with a shmem_exit after the loading of 
"/usr/local/etc/pool_hba.conf"

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/eba8d285/attachment-0001.html>