[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-admin
Subject: [ADMIN] Pgpool Issue-
From: DM <dm.aeqa () gmail ! com>
Date: 2009-02-26 20:02:03
Message-ID: eae6a62a0902261202l390a63d8x3dc503f0287c5070 () mail ! gmail ! com
[Download RAW message or body]
Hi All,
I have installed Postgres 8.3.3 and Pgpool 2.2RC2 on two machines and* Both
*servers have the identical copy of the database running.
I have started postgres server on both machines and I have started pgpool on
both machines.
But for some reasons i am not able to connect to database through pgpool.
psql -U postgres -p 9999
*Pgpool logs for the first machine shows*
2009-02-25 18:00:31 LOG: pid 30544: pgpool successfully started
2009-02-25 18:04:27 LOG: pid 30555: connection received: host=[local]
2009-02-25 18:04:27 ERROR: pid 30555: pool_read_kind: kind does not match
between master(82) slot[1] (69)
2009-02-26 10:56:19 ERROR: pid 30544: connect_inet_domain_socket: connect()
failed: Connection refused
2009-02-26 10:56:19 ERROR: pid 30544: health check failed. 1 th host
fdbr-res0002 at port 5432 is down
2009-02-26 10:56:19 LOG: pid 30544: set 1 th backend down status
2009-02-26 10:56:19 LOG: pid 30544: starting degeneration. shutdown host
fdbr-res0002(5432)
2009-02-26 10:56:19 LOG: pid 30544: failover_handler: set new master node:
0
2009-02-26 10:56:19 LOG: pid 30544: failover done. shutdown host
fdbr-res0002(5432)
pid file found. is another pgpool(30544) is running?
2009-02-26 10:58:03 ERROR: pid 30544: connect_inet_domain_socket: connect()
failed: Connection refused
2009-02-26 10:58:03 ERROR: pid 30544: health check failed. 0 th host
localhost at port 5432 is down
2009-02-26 10:58:03 LOG: pid 30544: set 0 th backend down status
2009-02-26 10:58:03 LOG: pid 30544: starting degeneration. shutdown host
localhost(5432)
2009-02-26 10:58:03 ERROR: pid 30544: failover_handler: no valid DB node
found
2009-02-26 10:58:03 LOG: pid 30544: failover_handler: set new master node:
2
2009-02-26 10:58:03 LOG: pid 30544: failover done. shutdown host
localhost(5432)
pid file found. is another pgpool(30544) is running?
2009-02-26 11:44:11 LOG: pid 7900: Cannot accept() new connection. all
backends are down
2009-02-26 11:45:59 LOG: pid 21707: Cannot accept() new connection. all
backends are down
2009-02-26 11:46:25 LOG: pid 30544: received fast shutdown request
stop request sent to pgpool. waiting for termination....done.
I can connect to individual database using
"psql -U postgres -p 5432" --> fdbr-res0001
"psql -U postgres -p 5432" --> fdbr-res0002
Here is the configuration of Pgpool.conf file, both machines have the same
identical configuration file with only backend_hostname1 = 'fdbr-res0002'
difference
listen_addresses = '*'
port = 9999
pcp_port = 9898
socket_dir = '/tmp'
pcp_socket_dir = '/tmp'
backend_socket_dir = '/tmp'
pcp_timeout = 10
num_init_children = 64
max_pool = 10
child_life_time = 300
connection_life_time = 0
child_max_connections = 0
client_idle_limit = 0
authentication_timeout = 60
logdir = '/usr/pgpool-II/2.2RC2/log'
pid_file_name = '/usr/pgpool-II/2.2RC2/etc/pgpool.pid'
replication_mode = true
load_balance_mode = true
replication_stop_on_mismatch = false
replicate_select = false
reset_query_list = 'ABORT; RESET ALL; SET SESSION AUTHORIZATION DEFAULT'
print_timestamp = true
master_slave_mode = false
connection_cache = true
health_check_timeout = 20
health_check_period = 1
health_check_user = 'postgres'
failover_command = ''
failback_command = ''
insert_lock = false
ignore_leading_white_space = true
log_statement = true
log_connections = true
log_hostname = true
parallel_mode = false
enable_query_cache = false
#pgpool2_hostname = 'fdbr-res0002'
pgpool2_hostname = ''
system_db_hostname = 'localhost'
system_db_port = 5432
system_db_dbname = 'pgpool'
system_db_schema = 'pgpool_catalog'
system_db_user = 'pgpool'
system_db_password = ''
backend_hostname0 = 'localhost'
backend_port0 = 5432
backend_weight0 = 1
backend_data_directory0 = '/mnt/data/pns/pgsql8.3.6'
backend_hostname1 = 'fdbr-res0002'
backend_port1 = 5432
backend_weight1 = 1
backend_data_directory1 = '/mnt/data/pns/pgsql8.3.6'
enable_pool_hba = true
recovery_user = 'postgres'
recovery_password = ''
recovery_1st_stage_command = ''
recovery_2nd_stage_command = ''
recovery_timeout = 90
client_idle_limit_in_recovery = 0
Any solution would be greatly appreciated
Thanks
Deepak Murthy
[Attachment #3 (text/html)]
Hi All,<br><br>I have installed Postgres 8.3.3 and Pgpool 2.2RC2 on two machines \
and<i> Both </i>servers have the identical copy of the database running. <br>I have \
started postgres server on both machines and I have started pgpool on both \
machines.<br> <br>But for some reasons i am not able to connect to database through \
pgpool.<br>psql -U postgres -p 9999<br><br><b>Pgpool logs for the first machine \
shows</b><br><br>2009-02-25 18:00:31 LOG: pid 30544: pgpool successfully \
started<br> 2009-02-25 18:04:27 LOG: pid 30555: connection received: \
host=[local]<br>2009-02-25 18:04:27 ERROR: pid 30555: pool_read_kind: kind does not \
match between master(82) slot[1] (69)<br>2009-02-26 10:56:19 ERROR: pid 30544: \
connect_inet_domain_socket: connect() failed: Connection refused<br> 2009-02-26 \
10:56:19 ERROR: pid 30544: health check failed. 1 th host fdbr-res0002 at port 5432 \
is down<br>2009-02-26 10:56:19 LOG: pid 30544: set 1 th backend down \
status<br>2009-02-26 10:56:19 LOG: pid 30544: starting degeneration. shutdown host \
fdbr-res0002(5432)<br> 2009-02-26 10:56:19 LOG: pid 30544: failover_handler: set \
new master node: 0<br>2009-02-26 10:56:19 LOG: pid 30544: failover done. shutdown \
host fdbr-res0002(5432)<br>pid file found. is another pgpool(30544) is running?<br> \
2009-02-26 10:58:03 ERROR: pid 30544: connect_inet_domain_socket: connect() failed: \
Connection refused<br>2009-02-26 10:58:03 ERROR: pid 30544: health check failed. 0 th \
host localhost at port 5432 is down<br>2009-02-26 10:58:03 LOG: pid 30544: set 0 th \
backend down status<br> 2009-02-26 10:58:03 LOG: pid 30544: starting degeneration. \
shutdown host localhost(5432)<br>2009-02-26 10:58:03 ERROR: pid 30544: \
failover_handler: no valid DB node found<br>2009-02-26 10:58:03 LOG: pid 30544: \
failover_handler: set new master node: 2<br> 2009-02-26 10:58:03 LOG: pid 30544: \
failover done. shutdown host localhost(5432)<br>pid file found. is another \
pgpool(30544) is running?<br>2009-02-26 11:44:11 LOG: pid 7900: Cannot accept() new \
connection. all backends are down<br> 2009-02-26 11:45:59 LOG: pid 21707: Cannot \
accept() new connection. all backends are down<br>2009-02-26 11:46:25 LOG: pid \
30544: received fast shutdown request<br>stop request sent to pgpool. waiting for \
termination....done.<br> <br><br>I can connect to individual database using \
<br>"psql -U postgres -p 5432" --> fdbr-res0001<br>"psql -U \
postgres -p 5432" --> fdbr-res0002<br><br>Here is the configuration of \
Pgpool.conf file, both machines have the same identical configuration file with only \
backend_hostname1 = 'fdbr-res0002' difference<br> <br>listen_addresses = \
'*'<br>port = 9999<br>pcp_port = 9898<br>socket_dir = \
'/tmp'<br>pcp_socket_dir = '/tmp'<br>backend_socket_dir = \
'/tmp'<br>pcp_timeout = 10<br>num_init_children = 64<br> max_pool = \
10<br>child_life_time = 300<br>connection_life_time = 0<br>child_max_connections = \
0<br>client_idle_limit = 0<br>authentication_timeout = 60<br>logdir = \
'/usr/pgpool-II/2.2RC2/log'<br>pid_file_name = \
'/usr/pgpool-II/2.2RC2/etc/pgpool.pid'<br> replication_mode = \
true<br>load_balance_mode = true<br>replication_stop_on_mismatch = \
false<br>replicate_select = false<br>reset_query_list = 'ABORT; RESET ALL; SET \
SESSION AUTHORIZATION DEFAULT'<br>print_timestamp = true<br> master_slave_mode = \
false<br>connection_cache = true<br>health_check_timeout = 20<br>health_check_period \
= 1<br>health_check_user = 'postgres'<br>failover_command = \
''<br>failback_command = ''<br>insert_lock = false<br> \
ignore_leading_white_space = true<br>log_statement = true <br>log_connections = true \
<br>log_hostname = true <br>parallel_mode = false<br>enable_query_cache = \
false<br>#pgpool2_hostname = 'fdbr-res0002'<br>pgpool2_hostname = \
''<br> system_db_hostname = 'localhost'<br>system_db_port = \
5432<br>system_db_dbname = 'pgpool'<br>system_db_schema = \
'pgpool_catalog'<br>system_db_user = 'pgpool'<br>system_db_password = \
''<br> <br>backend_hostname0 = 'localhost'<br>backend_port0 = \
5432<br>backend_weight0 = 1<br>backend_data_directory0 = \
'/mnt/data/pns/pgsql8.3.6'<br><br>backend_hostname1 = \
'fdbr-res0002'<br>backend_port1 = 5432<br> backend_weight1 = \
1<br>backend_data_directory1 = \
'/mnt/data/pns/pgsql8.3.6'<br><br>enable_pool_hba = true<br>recovery_user = \
'postgres'<br>recovery_password = ''<br>recovery_1st_stage_command = \
''<br> recovery_2nd_stage_command = ''<br>recovery_timeout = \
90<br>client_idle_limit_in_recovery = 0<br><br><br>Any solution would be greatly \
appreciated<br><br>Thanks<br>Deepak Murthy<br><br>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic