Tatsuo Ishii <ishii@...> 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@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 [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
