[Pgpool-general] Is master / slave mode working ?

Fri Nov 11 23:35:01 GMT 2005

Hi,

I have tried to use pgpool in master / slave mode, without success.
Starting with both databases alive, when the slave database is being
shutdown, pgpool failover from the master to the slave !

Here are the logs corresponding to that funny situation.
The configuration is enclosed in the first lines of the log.

Am i missing something ??

------------------

2005-11-12 00:20:12 DEBUG: pid 30123: key: listen_addresses
2005-11-12 00:20:12 DEBUG: pid 30123: value: '127.0.0.1' kind: 4
2005-11-12 00:20:12 DEBUG: pid 30123: key: port
2005-11-12 00:20:12 DEBUG: pid 30123: value: 5432 kind: 2
2005-11-12 00:20:12 DEBUG: pid 30123: key: socket_dir
2005-11-12 00:20:12 DEBUG: pid 30123: value: '/tmp' kind: 4
2005-11-12 00:20:12 DEBUG: pid 30123: key: backend_host_name
2005-11-12 00:20:12 DEBUG: pid 30123: value: 'DBSERVER1' kind: 4
2005-11-12 00:20:12 DEBUG: pid 30123: :DBSERVER1:
2005-11-12 00:20:12 DEBUG: pid 30123: key: backend_port
2005-11-12 00:20:12 DEBUG: pid 30123: value: 5432 kind: 2
2005-11-12 00:20:12 DEBUG: pid 30123: key: backend_socket_dir
2005-11-12 00:20:12 DEBUG: pid 30123: value: '/tmp' kind: 4
2005-11-12 00:20:12 DEBUG: pid 30123: key: secondary_backend_host_name
2005-11-12 00:20:12 DEBUG: pid 30123: value: 'DBSERVER2' kind: 4
2005-11-12 00:20:12 DEBUG: pid 30123: :DBSERVER2:
2005-11-12 00:20:12 DEBUG: pid 30123: key: secondary_backend_port
2005-11-12 00:20:12 DEBUG: pid 30123: value: 5432 kind: 2
2005-11-12 00:20:12 DEBUG: pid 30123: key: num_init_children
2005-11-12 00:20:12 DEBUG: pid 30123: value: 16 kind: 2
2005-11-12 00:20:12 DEBUG: pid 30123: key: max_pool
2005-11-12 00:20:12 DEBUG: pid 30123: value: 5 kind: 2
2005-11-12 00:20:12 DEBUG: pid 30123: key: child_life_time
2005-11-12 00:20:12 DEBUG: pid 30123: value: 300 kind: 2
2005-11-12 00:20:12 DEBUG: pid 30123: key: connection_life_time
2005-11-12 00:20:12 DEBUG: pid 30123: value: 0 kind: 2
2005-11-12 00:20:12 DEBUG: pid 30123: key: logdir
2005-11-12 00:20:12 DEBUG: pid 30123: value: '/tmp' kind: 4
2005-11-12 00:20:12 DEBUG: pid 30123: key: replication_mode
2005-11-12 00:20:12 DEBUG: pid 30123: value: false kind: 1
2005-11-12 00:20:12 DEBUG: pid 30123: key: replication_strict
2005-11-12 00:20:12 DEBUG: pid 30123: value: true kind: 1
2005-11-12 00:20:12 DEBUG: pid 30123: key: replication_timeout
2005-11-12 00:20:12 DEBUG: pid 30123: value: 5000 kind: 2
2005-11-12 00:20:12 DEBUG: pid 30123: key: load_balance_mode
2005-11-12 00:20:12 DEBUG: pid 30123: value: true kind: 1
2005-11-12 00:20:12 DEBUG: pid 30123: key: weight_master
2005-11-12 00:20:12 DEBUG: pid 30123: value: 0.5 kind: 3
2005-11-12 00:20:12 DEBUG: pid 30123: weight_master: 0.500000
2005-11-12 00:20:12 DEBUG: pid 30123: key: weight_secondary
2005-11-12 00:20:12 DEBUG: pid 30123: value: 0.5 kind: 3
2005-11-12 00:20:12 DEBUG: pid 30123: weight_secondary: 0.500000
2005-11-12 00:20:12 DEBUG: pid 30123: key: replication_stop_on_mismatch
2005-11-12 00:20:12 DEBUG: pid 30123: value: false kind: 1
2005-11-12 00:20:12 DEBUG: pid 30123: replication_stop_on_mismatch: 0
2005-11-12 00:20:12 DEBUG: pid 30123: key: reset_query_list
2005-11-12 00:20:12 DEBUG: pid 30123: value: 'ABORT; RESET ALL; SET
SESSION AUTHORIZATION DEFAULT' kind: 4
2005-11-12 00:20:12 DEBUG: pid 30123: extract_string_tokens: token: ABORT
2005-11-12 00:20:12 DEBUG: pid 30123: extract_string_tokens: token:
RESET ALL
2005-11-12 00:20:12 DEBUG: pid 30123: extract_string_tokens: token:  SET
SESSION AUTHORIZATION DEFAULT
2005-11-12 00:20:12 DEBUG: pid 30123: key: print_timestamp
2005-11-12 00:20:12 DEBUG: pid 30123: value: true kind: 1
2005-11-12 00:20:12 DEBUG: pid 30123: key: master_slave_mode
2005-11-12 00:20:12 DEBUG: pid 30123: value: true kind: 1
2005-11-12 00:20:12 DEBUG: pid 30123: key: connection_cache
2005-11-12 00:20:12 DEBUG: pid 30123: value: true kind: 1
2005-11-12 00:20:12 DEBUG: pid 30123: key: health_check_timeout
2005-11-12 00:20:12 DEBUG: pid 30123: value: 5 kind: 2
2005-11-12 00:20:12 DEBUG: pid 30123: key: health_check_period
2005-11-12 00:20:12 DEBUG: pid 30123: value: 5 kind: 2
2005-11-12 00:20:12 DEBUG: pid 30123: key: health_check_user
2005-11-12 00:20:12 DEBUG: pid 30123: value: 'CMS_front' kind: 4
2005-11-12 00:20:12 DEBUG: pid 30123: weight: 1073741823
2005-11-12 00:20:12 DEBUG: pid 30124: I am 30124
2005-11-12 00:20:12 DEBUG: pid 30125: I am 30125
2005-11-12 00:20:12 DEBUG: pid 30126: I am 30126
2005-11-12 00:20:12 DEBUG: pid 30127: I am 30127
2005-11-12 00:20:12 DEBUG: pid 30128: I am 30128
2005-11-12 00:20:12 DEBUG: pid 30129: I am 30129
2005-11-12 00:20:12 DEBUG: pid 30130: I am 30130
2005-11-12 00:20:12 DEBUG: pid 30131: I am 30131
2005-11-12 00:20:12 DEBUG: pid 30132: I am 30132
2005-11-12 00:20:12 DEBUG: pid 30133: I am 30133
2005-11-12 00:20:12 DEBUG: pid 30134: I am 30134
2005-11-12 00:20:12 DEBUG: pid 30135: I am 30135
2005-11-12 00:20:12 DEBUG: pid 30136: I am 30136
2005-11-12 00:20:12 DEBUG: pid 30137: I am 30137
2005-11-12 00:20:12 DEBUG: pid 30138: I am 30138
2005-11-12 00:20:12 DEBUG: pid 30139: I am 30139
2005-11-12 00:20:12 LOG:   pid 30123: pgpool successfully started
2005-11-12 00:20:12 LOG:   pid 30123: starting health checking
2005-11-12 00:20:17 LOG:   pid 30123: starting health checking
2005-11-12 00:20:22 LOG:   pid 30123: starting health checking
2005-11-12 00:20:27 LOG:   pid 30123: starting health checking
2005-11-12 00:20:27 ERROR: pid 30123: connect_inet_domain_socket:
connect() failed: Connection refused
2005-11-12 00:20:27 ERROR: pid 30123: health check failed. secondary
DBSERVER2 at port 5432 is down
2005-11-12 00:20:27 DEBUG: pid 30123: failover_handler called
2005-11-12 00:20:27 LOG:   pid 30123: starting failover from
DBSERVER1(5432) to DBSERVER2(5432)
2005-11-12 00:20:27 DEBUG: pid 30123: kill 30124
2005-11-12 00:20:27 DEBUG: pid 30123: kill 30125
2005-11-12 00:20:27 DEBUG: pid 30123: kill 30126
2005-11-12 00:20:27 DEBUG: pid 30123: kill 30127
2005-11-12 00:20:27 DEBUG: pid 30123: kill 30128
2005-11-12 00:20:27 DEBUG: pid 30123: kill 30129
2005-11-12 00:20:27 DEBUG: pid 30123: kill 30130
2005-11-12 00:20:27 DEBUG: pid 30123: kill 30131
2005-11-12 00:20:27 DEBUG: pid 30123: kill 30132
2005-11-12 00:20:27 DEBUG: pid 30123: kill 30133
2005-11-12 00:20:27 DEBUG: pid 30123: kill 30134
2005-11-12 00:20:27 DEBUG: pid 30123: kill 30135
2005-11-12 00:20:27 DEBUG: pid 30123: kill 30136
2005-11-12 00:20:27 DEBUG: pid 30123: kill 30137
2005-11-12 00:20:27 DEBUG: pid 30123: kill 30138
2005-11-12 00:20:27 DEBUG: pid 30130: child receives shutdown request
signal 3
2005-11-12 00:20:27 DEBUG: pid 30134: child receives shutdown request
signal 3
2005-11-12 00:20:27 DEBUG: pid 30131: child receives shutdown request
signal 3
2005-11-12 00:20:27 DEBUG: pid 30135: child receives shutdown request
signal 3
2005-11-12 00:20:27 DEBUG: pid 30126: child receives shutdown request
signal 3
2005-11-12 00:20:27 DEBUG: pid 30136: child receives shutdown request
signal 3
2005-11-12 00:20:27 DEBUG: pid 30132: child receives shutdown request
signal 3
2005-11-12 00:20:27 DEBUG: pid 30137: child receives shutdown request
signal 3
2005-11-12 00:20:27 DEBUG: pid 30133: child receives shutdown request
signal 3
2005-11-12 00:20:27 DEBUG: pid 30138: child receives shutdown request
signal 3
2005-11-12 00:20:27 DEBUG: pid 30124: child receives shutdown request
signal 3
2005-11-12 00:20:27 DEBUG: pid 30139: child receives shutdown request
signal 3
2005-11-12 00:20:27 DEBUG: pid 30127: child receives shutdown request
signal 3
2005-11-12 00:20:27 DEBUG: pid 30123: kill 30139
2005-11-12 00:20:27 DEBUG: pid 30129: child receives shutdown request
signal 3
2005-11-12 00:20:27 DEBUG: pid 30128: child receives shutdown request
signal 3
2005-11-12 00:20:27 DEBUG: pid 30125: child receives shutdown request
signal 3
2005-11-12 00:20:27 DEBUG: pid 30141: I am 30141
2005-11-12 00:20:27 DEBUG: pid 30142: I am 30142
2005-11-12 00:20:27 DEBUG: pid 30143: I am 30143
2005-11-12 00:20:27 DEBUG: pid 30144: I am 30144
2005-11-12 00:20:27 DEBUG: pid 30145: I am 30145
2005-11-12 00:20:27 DEBUG: pid 30146: I am 30146
2005-11-12 00:20:27 DEBUG: pid 30147: I am 30147
2005-11-12 00:20:27 DEBUG: pid 30148: I am 30148
2005-11-12 00:20:27 DEBUG: pid 30149: I am 30149
2005-11-12 00:20:27 DEBUG: pid 30150: I am 30150
2005-11-12 00:20:27 DEBUG: pid 30151: I am 30151
2005-11-12 00:20:27 DEBUG: pid 30152: I am 30152
2005-11-12 00:20:27 DEBUG: pid 30153: I am 30153
2005-11-12 00:20:27 DEBUG: pid 30154: I am 30154
2005-11-12 00:20:27 DEBUG: pid 30155: I am 30155
2005-11-12 00:20:27 DEBUG: pid 30156: I am 30156
2005-11-12 00:20:27 LOG:   pid 30123: failover from DBSERVER1(5432) to
DBSERVER2(5432) done.
2005-11-12 00:20:27 DEBUG: pid 30123: reap_handler called
2005-11-12 00:20:32 LOG:   pid 30123: starting health checking
2005-11-12 00:20:32 ERROR: pid 30123: connect_inet_domain_socket:
connect() failed: Connection refused
2005-11-12 00:20:32 ERROR: pid 30123: health check failed. master
DBSERVER2 at port 5432 is down
2005-11-12 00:20:32 DEBUG: pid 30123: failover_handler called
2005-11-12 00:20:32 LOG:   pid 30123: starting failover from
DBSERVER2(5432) to DBSERVER2(5432)

...