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

Tue Jun 28 15:49:11 UTC 2011

You need to replace "osspc17" and "osspc18" part at least in
pgpool.conf unless you set PostgreSQL servers's hostnanmes exactly
same as in the tutorial.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> 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!
> 
> _______________________________________________
> Pgpool-general mailing list
> Pgpool-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-general