[Pgpool-general] Issue w. PID file and Bind Address

Tue Jun 28 15:36:30 UTC 2011

Tatsuo Ishii <ishii at ...> writes:

> Probably pgpoolAdmin failed to start pgpool-II. 
> 
> > start Pgpool from there I got the error: pgpool.pid not found. 
> 
> Because after successfull start of pgpool-II, the file should be
> created by pgpool-II itself.
> 
> Did you see any error messages in the log files (placed under
> /var/log/pgpool/ if you follow the tutorial).
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese: http://www.sraoss.co.jp
> 

Hi Tatsuo,

Thank you very much for replying. I am sending you the whole log I found under
/var/log/pgpool

2011-06-23 17:11:35 DEBUG: pid 9997: key: listen_addresses
2011-06-23 17:11:35 DEBUG: pid 9997: value: '*' kind: 4
2011-06-23 17:11:35 DEBUG: pid 9997: key: port
2011-06-23 17:11:35 DEBUG: pid 9997: value: 5432 kind: 2
2011-06-23 17:11:35 DEBUG: pid 9997: key: pcp_port
2011-06-23 17:11:35 DEBUG: pid 9997: value: 9898 kind: 2
2011-06-23 17:11:35 DEBUG: pid 9997: key: socket_dir
2011-06-23 17:11:35 DEBUG: pid 9997: value: '/tmp' kind: 4
2011-06-23 17:11:35 DEBUG: pid 9997: key: pcp_socket_dir
2011-06-23 17:11:35 DEBUG: pid 9997: value: '/tmp' kind: 4
2011-06-23 17:11:35 DEBUG: pid 9997: key: backend_socket_dir
2011-06-23 17:11:35 DEBUG: pid 9997: value: '/tmp' kind: 4
2011-06-23 17:11:35 DEBUG: pid 9997: key: pcp_timeout
2011-06-23 17:11:35 DEBUG: pid 9997: value: 10 kind: 2
2011-06-23 17:11:35 DEBUG: pid 9997: key: num_init_children
2011-06-23 17:11:35 DEBUG: pid 9997: value: 32 kind: 2
2011-06-23 17:11:35 DEBUG: pid 9997: key: max_pool
2011-06-23 17:11:35 DEBUG: pid 9997: value: 4 kind: 2
2011-06-23 17:11:35 DEBUG: pid 9997: key: child_life_time
2011-06-23 17:11:35 DEBUG: pid 9997: value: 300 kind: 2
2011-06-23 17:11:35 DEBUG: pid 9997: key: connection_life_time
2011-06-23 17:11:35 DEBUG: pid 9997: value: 0 kind: 2
2011-06-23 17:11:35 DEBUG: pid 9997: key: child_max_connections
2011-06-23 17:11:35 DEBUG: pid 9997: value: 0 kind: 2
2011-06-23 17:11:35 DEBUG: pid 9997: key: client_idle_limit
2011-06-23 17:11:35 DEBUG: pid 9997: value: 0 kind: 2
2011-06-23 17:11:35 DEBUG: pid 9997: key: authentication_timeout
2011-06-23 17:11:35 DEBUG: pid 9997: value: 60 kind: 2
2011-06-23 17:11:35 DEBUG: pid 9997: key: logdir
2011-06-23 17:11:35 DEBUG: pid 9997: value: '/tmp' kind: 4
2011-06-23 17:11:35 DEBUG: pid 9997: key: pid_file_name
2011-06-23 17:11:35 DEBUG: pid 9997: value: '/var/run/pgpool/pgpool.pid' kind: 4
2011-06-23 17:11:35 DEBUG: pid 9997: key: replication_mode
2011-06-23 17:11:35 DEBUG: pid 9997: value: false kind: 1
2011-06-23 17:11:35 DEBUG: pid 9997: key: load_balance_mode
2011-06-23 17:11:35 DEBUG: pid 9997: value: true kind: 1
2011-06-23 17:11:35 DEBUG: pid 9997: key: replication_stop_on_mismatch
2011-06-23 17:11:35 DEBUG: pid 9997: value: false kind: 1
2011-06-23 17:11:35 DEBUG: pid 9997: replication_stop_on_mismatch: 0
2011-06-23 17:11:35 DEBUG: pid 9997: key: failover_if_affected_tuples_mismatch
2011-06-23 17:11:35 DEBUG: pid 9997: value: false kind: 1
2011-06-23 17:11:35 DEBUG: pid 9997: failover_if_affected_tuples_mismatch: 0
2011-06-23 17:11:35 DEBUG: pid 9997: key: replicate_select
2011-06-23 17:11:35 DEBUG: pid 9997: value: false kind: 1
2011-06-23 17:11:35 DEBUG: pid 9997: replicate_select: 0
2011-06-23 17:11:35 DEBUG: pid 9997: key: reset_query_list
2011-06-23 17:11:35 DEBUG: pid 9997: value: 'ABORT; DISCARD ALL' kind: 4
2011-06-23 17:11:35 DEBUG: pid 9997: extract_string_tokens: token: ABORT
2011-06-23 17:11:35 DEBUG: pid 9997: extract_string_tokens: token:  DISCARD ALL
2011-06-23 17:11:35 DEBUG: pid 9997: key: white_function_list
2011-06-23 17:11:35 DEBUG: pid 9997: value: '' kind: 4
2011-06-23 17:11:35 DEBUG: pid 9997: key: black_function_list
2011-06-23 17:11:35 DEBUG: pid 9997: value: 'nextval,setval' kind: 4
2011-06-23 17:11:35 DEBUG: pid 9997: extract_string_tokens: token: nextval
2011-06-23 17:11:35 DEBUG: pid 9997: extract_string_tokens: token: setval
2011-06-23 17:11:35 DEBUG: pid 9997: key: print_timestamp
2011-06-23 17:11:35 DEBUG: pid 9997: value: true kind: 1
2011-06-23 17:11:35 DEBUG: pid 9997: key: master_slave_mode
2011-06-23 17:11:35 DEBUG: pid 9997: value: true kind: 1
2011-06-23 17:11:35 DEBUG: pid 9997: key: master_slave_sub_mode
2011-06-23 17:11:35 DEBUG: pid 9997: value: 'stream' kind: 4
2011-06-23 17:11:35 DEBUG: pid 9997: key: delay_threshold
2011-06-23 17:11:35 DEBUG: pid 9997: value: 10000000 kind: 2
2011-06-23 17:11:35 DEBUG: pid 9997: key: log_standby_delay
2011-06-23 17:11:35 DEBUG: pid 9997: value: 'if_over_threshold' kind: 4
2011-06-23 17:11:35 DEBUG: pid 9997: key: connection_cache
2011-06-23 17:11:35 DEBUG: pid 9997: value: true kind: 1
2011-06-23 17:11:35 DEBUG: pid 9997: key: health_check_timeout
2011-06-23 17:11:35 DEBUG: pid 9997: value: 10 kind: 2
2011-06-23 17:11:35 DEBUG: pid 9997: key: health_check_period
2011-06-23 17:11:35 DEBUG: pid 9997: value: 20 kind: 2
2011-06-23 17:11:35 DEBUG: pid 9997: key: health_check_user
2011-06-23 17:11:35 DEBUG: pid 9997: value: 'postgres' kind: 4
2011-06-23 17:11:35 DEBUG: pid 9997: key: failover_command
2011-06-23 17:11:35 DEBUG: pid 9997: value: '/usr/local/etc/failover.sh %d "%h"
%p %D %m %M "%H" %P' kind: 4
2011-06-23 17:11:35 DEBUG: pid 9997: key: failback_command
2011-06-23 17:11:35 DEBUG: pid 9997: value: '' kind: 4
2011-06-23 17:11:35 DEBUG: pid 9997: key: fail_over_on_backend_error
2011-06-23 17:11:35 DEBUG: pid 9997: value: true kind: 1
2011-06-23 17:11:35 DEBUG: pid 9997: key: insert_lock
2011-06-23 17:11:35 DEBUG: pid 9997: value: false kind: 1
2011-06-23 17:11:35 DEBUG: pid 9997: key: ignore_leading_white_space
2011-06-23 17:11:35 DEBUG: pid 9997: value: true kind: 1
2011-06-23 17:11:35 DEBUG: pid 9997: key: log_statement
2011-06-23 17:11:35 DEBUG: pid 9997: value: false kind: 1
2011-06-23 17:11:35 DEBUG: pid 9997: key: log_per_node_statement
2011-06-23 17:11:35 DEBUG: pid 9997: value: false kind: 1
2011-06-23 17:11:35 DEBUG: pid 9997: key: log_connections
2011-06-23 17:11:35 DEBUG: pid 9997: value: false kind: 1
2011-06-23 17:11:35 DEBUG: pid 9997: key: log_hostname
2011-06-23 17:11:35 DEBUG: pid 9997: value: false kind: 1
2011-06-23 17:11:35 DEBUG: pid 9997: key: parallel_mode
2011-06-23 17:11:35 DEBUG: pid 9997: value: false kind: 1
2011-06-23 17:11:35 DEBUG: pid 9997: key: enable_query_cache
2011-06-23 17:11:35 DEBUG: pid 9997: value: false kind: 1
2011-06-23 17:11:35 DEBUG: pid 9997: key: pgpool2_hostname
2011-06-23 17:11:35 DEBUG: pid 9997: value: '' kind: 4
2011-06-23 17:11:35 DEBUG: pid 9997: key: system_db_hostname
2011-06-23 17:11:35 DEBUG: pid 9997: value: 'localhost' kind: 4
2011-06-23 17:11:35 DEBUG: pid 9997: key: system_db_port
2011-06-23 17:11:35 DEBUG: pid 9997: value: 5432 kind: 2
2011-06-23 17:11:35 DEBUG: pid 9997: key: system_db_dbname
2011-06-23 17:11:35 DEBUG: pid 9997: value: 'pgpool' kind: 4
2011-06-23 17:11:35 DEBUG: pid 9997: key: system_db_schema
2011-06-23 17:11:35 DEBUG: pid 9997: value: 'pgpool_catalog' kind: 4
2011-06-23 17:11:35 DEBUG: pid 9997: key: system_db_user
2011-06-23 17:11:35 DEBUG: pid 9997: value: 'pgpool' kind: 4
2011-06-23 17:11:35 DEBUG: pid 9997: key: system_db_password
2011-06-23 17:11:35 DEBUG: pid 9997: value: '' kind: 4
2011-06-23 17:11:35 DEBUG: pid 9997: key: backend_hostname0
2011-06-23 17:11:35 DEBUG: pid 9997: value: 'osspc17' kind: 4
2011-06-23 17:11:35 DEBUG: pid 9997: key: backend_port0
2011-06-23 17:11:35 DEBUG: pid 9997: value: 5432 kind: 2
2011-06-23 17:11:35 DEBUG: pid 9997: pool_config: port slot number 0 
2011-06-23 17:11:35 DEBUG: pid 9997: key: backend_weight0
2011-06-23 17:11:35 DEBUG: pid 9997: value: 1 kind: 2
2011-06-23 17:11:35 DEBUG: pid 9997: pool_config: weight slot number 0 weight:
1.000000
2011-06-23 17:11:35 DEBUG: pid 9997: key: backend_data_directory0
2011-06-23 17:11:35 DEBUG: pid 9997: value: '/home/postgres/data' kind: 4
2011-06-23 17:11:35 DEBUG: pid 9997: key: backend_hostname1
2011-06-23 17:11:35 DEBUG: pid 9997: value: 'osspc18' kind: 4
2011-06-23 17:11:35 DEBUG: pid 9997: key: backend_port1
2011-06-23 17:11:35 DEBUG: pid 9997: value: 5432 kind: 2
2011-06-23 17:11:35 DEBUG: pid 9997: pool_config: port slot number 1 
2011-06-23 17:11:35 DEBUG: pid 9997: key: backend_weight1
2011-06-23 17:11:35 DEBUG: pid 9997: value: 1 kind: 2
2011-06-23 17:11:35 DEBUG: pid 9997: pool_config: weight slot number 1 weight:
1.000000
2011-06-23 17:11:35 DEBUG: pid 9997: key: backend_data_directory1
2011-06-23 17:11:35 DEBUG: pid 9997: value: '/home/postgres/data' kind: 4
2011-06-23 17:11:35 DEBUG: pid 9997: key: enable_pool_hba
2011-06-23 17:11:35 DEBUG: pid 9997: value: false kind: 1
2011-06-23 17:11:35 DEBUG: pid 9997: key: recovery_user
2011-06-23 17:11:35 DEBUG: pid 9997: value: 'postgres' kind: 4
2011-06-23 17:11:35 DEBUG: pid 9997: key: recovery_password
2011-06-23 17:11:35 DEBUG: pid 9997: value: '' kind: 4
2011-06-23 17:11:35 DEBUG: pid 9997: key: recovery_1st_stage_command
2011-06-23 17:11:35 DEBUG: pid 9997: value: 'basebackup.sh' kind: 4
2011-06-23 17:11:35 DEBUG: pid 9997: key: recovery_2nd_stage_command
2011-06-23 17:11:35 DEBUG: pid 9997: value: '' kind: 4
2011-06-23 17:11:35 DEBUG: pid 9997: key: recovery_timeout
2011-06-23 17:11:35 DEBUG: pid 9997: value: 90 kind: 2
2011-06-23 17:11:35 DEBUG: pid 9997: key: client_idle_limit_in_recovery
2011-06-23 17:11:35 DEBUG: pid 9997: value: 0 kind: 2
2011-06-23 17:11:35 DEBUG: pid 9997: key: lobj_lock_table
2011-06-23 17:11:35 DEBUG: pid 9997: value: '' kind: 4
2011-06-23 17:11:35 DEBUG: pid 9997: key: ssl
2011-06-23 17:11:35 DEBUG: pid 9997: value: false kind: 1
2011-06-23 17:11:35 DEBUG: pid 9997: key: debug_level
2011-06-23 17:11:35 DEBUG: pid 9997: value: 0 kind: 2
2011-06-23 17:11:35 ERROR: pid 9997: bind(0.0.0.0:postgres) failed. reason:
Address already in use
2011-06-23 17:11:35 ERROR: pid 9997: unlink() failed: No such file or directory
2011-06-23 17:11:35 DEBUG: pid 9997: shmem_exit(1)

I can see that at some point, it uses a path  named "/home/postgres/data" which
does not correspond to my local path. That is changed as far as the other nodes
goes, in the Conf file. So I have no idea where that path is coming from.

Also, the .PID file continues to be unaccessible for pgpool. I have to create it
myself, and yet Pgpool is unable to read it sometimes. I can't even stop it from
the console sometimes:

2011-06-28 11:31:34 ERROR: pid 30323: could not read pid file as
/var/run/pgpool/pgpool.pid. reason: Success
2011-06-28 11:31:34 ERROR: pid 30323: could not read pid file
[root at ip-10-72-79-0 pgpool]# pgpool stop
2011-06-28 11:31:44 ERROR: pid 30326: could not read pid file as
/var/run/pgpool/pgpool.pid. reason: Success
2011-06-28 11:31:44 ERROR: pid 30326: could not read pid file

I appreciate your help on this matter. Thanks a lot!