[pgpool-hackers: 4356] Re: [pgpool-committers: 9487] pgpool: Disallowing setting the max_spare_children greater than num_ini
Tatsuo Ishii
ishii at sraoss.co.jp
Sun Jul 23 11:39:23 JST 2023
Hi Usama,
After this commit regression test starts to fail:
testing 012.watchdog_failover_when_quorum_exists...failed.
testing 013.watchdog_failover_require_consensus...failed.
:
:
Attached are logs for the tests.
From: Muhammad Usama <m.usama at gmail.com>
Subject: [pgpool-committers: 9487] pgpool: Disallowing setting the max_spare_children greater than num_ini
Date: Sat, 22 Jul 2023 14:26:28 +0000
Message-ID: <E1qNDYx-002KBf-7l at gothos.postgresql.org>
> Disallowing setting the max_spare_children greater than num_init_children.
>
> Config post-processing stage now throws an error if num_init_children is
> smaller than max_spare_children.
> Commit also adjusts the number of child processes spawned at startup based on
> the configured process management strategy.
> For the Aggressive strategy, max_spare_children number of processes is spawned;
> for the other two strategies, min_spare_children number of children gets
> created at startup.
>
> Branch
> ------
> master
>
> Details
> -------
> https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=37dc683f7f15cbf4502b338937e54b9da0a92efd
>
> Modified Files
> --------------
> src/config/pool_config_variables.c | 7 +++++++
> src/main/pgpool_main.c | 11 ++++++++---
> 2 files changed, 15 insertions(+), 3 deletions(-)
>
-------------- next part --------------
creating leader pgpool and PostgreSQL clusters...PostgreSQL major version: 150
Starting set up in streaming replication mode
creating startall and shutdownall
creating failover script
creating database cluster /home/t-ishii/work/Pgpool-II/current/pgpool2/src/test/regression/tests/012.watchdog_failover_when_quorum_exists/leader/data0...done.
update postgresql.conf
creating pgpool_remote_start
creating basebackup.sh
creating recovery.conf
creating database cluster /home/t-ishii/work/Pgpool-II/current/pgpool2/src/test/regression/tests/012.watchdog_failover_when_quorum_exists/leader/data1...done.
update postgresql.conf
creating pgpool_remote_start
creating basebackup.sh
creating recovery.conf
temporarily start data0 cluster to create extensions
temporarily start pgpool-II to create standby nodes
node_id | hostname | port | status | pg_status | lb_weight | role | pg_role | select_cnt | load_balance_node | replication_delay | replication_state | replication_sync_state | last_status_change
---------+-----------+-------+--------+-----------+-----------+---------+---------+------------+-------------------+-------------------+-------------------+------------------------+---------------------
0 | localhost | 11002 | up | up | 0.500000 | primary | primary | 0 | true | 0 | | | 2023-07-23 10:48:47
1 | localhost | 11003 | down | down | 0.500000 | standby | unknown | 0 | false | 0 | | | 2023-07-23 10:48:46
(2 rows)
recovery node 1...pcp_recovery_node -- Command Successful
done.
creating follow primary script
node_id | hostname | port | status | pg_status | lb_weight | role | pg_role | select_cnt | load_balance_node | replication_delay | replication_state | replication_sync_state | last_status_change
---------+-----------+-------+--------+-----------+-----------+---------+---------+------------+-------------------+-------------------+-------------------+------------------------+---------------------
0 | localhost | 11002 | up | up | 0.500000 | primary | primary | 0 | false | 0 | | | 2023-07-23 10:48:47
1 | localhost | 11003 | up | up | 0.500000 | standby | standby | 0 | true | 0 | | | 2023-07-23 10:48:51
(2 rows)
shutdown all
pgpool-II setting for streaming replication mode is done.
To start the whole system, use /home/t-ishii/work/Pgpool-II/current/pgpool2/src/test/regression/tests/012.watchdog_failover_when_quorum_exists/leader/startall.
To shutdown the whole system, use /home/t-ishii/work/Pgpool-II/current/pgpool2/src/test/regression/tests/012.watchdog_failover_when_quorum_exists/leader/shutdownall.
pcp command user name is "t-ishii", password is "t-ishii".
Each PostgreSQL, pgpool-II and pcp port is as follows:
#1 port is 11002
#2 port is 11003
pgpool port is 11000
pcp port is 11001
The info above is in README.port.
leader setup done.
waiting for server to start....650859 2023-07-23 10:48:52.652 JST LOG: redirecting log output to logging collector process
650859 2023-07-23 10:48:52.652 JST HINT: Future log output will appear in directory "log".
done
server started
waiting for server to start....650871 2023-07-23 10:48:52.781 JST LOG: redirecting log output to logging collector process
650871 2023-07-23 10:48:52.781 JST HINT: Future log output will appear in directory "log".
done
server started
creating standby pgpool...creating standby2 pgpool...Waiting for the pgpool leader...
[check] 1 times
[check] 2 times
[check] 3 times
[check] 4 times
[check] 5 times
[check] 6 times
[check] 7 times
[check] 8 times
[check] 9 times
[check] 10 times
Checking if the Leader rejects the failover because quorum is not present...
[check] 1 times
[check] 2 times
[check] 3 times
[check] 4 times
[check] 5 times
[check] 6 times
[check] 7 times
[check] 8 times
[check] 9 times
[check] 10 times
Waiting for the standby1 to join cluster...
[check] 1 times
[check] 2 times
[check] 3 times
[check] 4 times
[check] 5 times
[check] 6 times
[check] 7 times
[check] 8 times
[check] 9 times
[check] 10 times
Waiting for the standby2 to join cluster...
[check] 1 times
[check] 2 times
[check] 3 times
[check] 4 times
[check] 5 times
[check] 6 times
[check] 7 times
[check] 8 times
[check] 9 times
[check] 10 times
Checking if all Pgpool-II agrees that the failover request is executed
psql: error: connection to server on socket "/tmp/.s.PGSQL.11000" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.11100" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.11200" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
[check] 1 times
psql: error: connection to server on socket "/tmp/.s.PGSQL.11000" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.11100" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.11200" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
[check] 2 times
psql: error: connection to server on socket "/tmp/.s.PGSQL.11000" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.11100" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.11200" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
[check] 3 times
psql: error: connection to server on socket "/tmp/.s.PGSQL.11000" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.11100" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.11200" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
[check] 4 times
psql: error: connection to server on socket "/tmp/.s.PGSQL.11000" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.11100" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.11200" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
[check] 5 times
psql: error: connection to server on socket "/tmp/.s.PGSQL.11000" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.11100" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.11200" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
[check] 6 times
psql: error: connection to server on socket "/tmp/.s.PGSQL.11000" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.11100" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.11200" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
[check] 7 times
psql: error: connection to server on socket "/tmp/.s.PGSQL.11000" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.11100" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.11200" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
[check] 8 times
psql: error: connection to server on socket "/tmp/.s.PGSQL.11000" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.11100" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.11200" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
[check] 9 times
psql: error: connection to server on socket "/tmp/.s.PGSQL.11000" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.11100" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.11200" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
[check] 10 times
2023-07-23 10:50:58.557: main pid 651152: FATAL: invalid configuration, max_spare_children:10 can't be greater than num_init_children:4
2023-07-23 10:50:58.560: main pid 651153: FATAL: invalid configuration, max_spare_children:10 can't be greater than num_init_children:4
2023-07-23 10:50:58.564: main pid 651156: FATAL: invalid configuration, max_spare_children:10 can't be greater than num_init_children:4
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
0 out of 5 successful
-------------- next part --------------
creating leader pgpool and PostgreSQL clusters...PostgreSQL major version: 150
Starting set up in streaming replication mode
creating startall and shutdownall
creating failover script
creating database cluster /home/t-ishii/work/Pgpool-II/current/pgpool2/src/test/regression/tests/013.watchdog_failover_require_consensus/leader/data0...done.
update postgresql.conf
creating pgpool_remote_start
creating basebackup.sh
creating recovery.conf
creating database cluster /home/t-ishii/work/Pgpool-II/current/pgpool2/src/test/regression/tests/013.watchdog_failover_require_consensus/leader/data1...done.
update postgresql.conf
creating pgpool_remote_start
creating basebackup.sh
creating recovery.conf
temporarily start data0 cluster to create extensions
temporarily start pgpool-II to create standby nodes
node_id | hostname | port | status | pg_status | lb_weight | role | pg_role | select_cnt | load_balance_node | replication_delay | replication_state | replication_sync_state | last_status_change
---------+-----------+-------+--------+-----------+-----------+---------+---------+------------+-------------------+-------------------+-------------------+------------------------+---------------------
0 | localhost | 11002 | up | up | 0.500000 | primary | primary | 0 | true | 0 | | | 2023-07-23 10:51:01
1 | localhost | 11003 | down | down | 0.500000 | standby | unknown | 0 | false | 0 | | | 2023-07-23 10:51:00
(2 rows)
recovery node 1...pcp_recovery_node -- Command Successful
done.
creating follow primary script
node_id | hostname | port | status | pg_status | lb_weight | role | pg_role | select_cnt | load_balance_node | replication_delay | replication_state | replication_sync_state | last_status_change
---------+-----------+-------+--------+-----------+-----------+---------+---------+------------+-------------------+-------------------+-------------------+------------------------+---------------------
0 | localhost | 11002 | up | up | 0.500000 | primary | primary | 0 | false | 0 | | | 2023-07-23 10:51:01
1 | localhost | 11003 | up | up | 0.500000 | standby | standby | 0 | true | 0 | | | 2023-07-23 10:51:05
(2 rows)
shutdown all
pgpool-II setting for streaming replication mode is done.
To start the whole system, use /home/t-ishii/work/Pgpool-II/current/pgpool2/src/test/regression/tests/013.watchdog_failover_require_consensus/leader/startall.
To shutdown the whole system, use /home/t-ishii/work/Pgpool-II/current/pgpool2/src/test/regression/tests/013.watchdog_failover_require_consensus/leader/shutdownall.
pcp command user name is "t-ishii", password is "t-ishii".
Each PostgreSQL, pgpool-II and pcp port is as follows:
#1 port is 11002
#2 port is 11003
pgpool port is 11000
pcp port is 11001
The info above is in README.port.
leader setup done.
waiting for server to start....651520 2023-07-23 10:51:06.413 JST LOG: redirecting log output to logging collector process
651520 2023-07-23 10:51:06.413 JST HINT: Future log output will appear in directory "log".
done
server started
waiting for server to start....651533 2023-07-23 10:51:06.543 JST LOG: redirecting log output to logging collector process
651533 2023-07-23 10:51:06.543 JST HINT: Future log output will appear in directory "log".
done
server started
creating standby pgpool...creating standby2 pgpool...Waiting for the pgpool leader...
[check] 1 times
[check] 2 times
[check] 3 times
[check] 4 times
[check] 5 times
[check] 6 times
[check] 7 times
[check] 8 times
[check] 9 times
[check] 10 times
Waiting for the standby1 to join cluster...
[check] 1 times
[check] 2 times
[check] 3 times
[check] 4 times
[check] 5 times
[check] 6 times
[check] 7 times
[check] 8 times
[check] 9 times
[check] 10 times
Waiting for the standby2 to join cluster...
[check] 1 times
[check] 2 times
[check] 3 times
[check] 4 times
[check] 5 times
[check] 6 times
[check] 7 times
[check] 8 times
[check] 9 times
[check] 10 times
Checking if the standby successfully process the failover request...
[check] 1 times
[check] 2 times
[check] 3 times
[check] 4 times
[check] 5 times
[check] 6 times
[check] 7 times
[check] 8 times
[check] 9 times
[check] 10 times
Checking if the Leader receives the failover request and waiting for consensus...
[check] 1 times
[check] 2 times
[check] 3 times
[check] 4 times
[check] 5 times
[check] 6 times
[check] 7 times
[check] 8 times
[check] 9 times
[check] 10 times
Checking if the node is quarantined on standby...
[check] 1 times
[check] 2 times
[check] 3 times
[check] 4 times
[check] 5 times
[check] 6 times
[check] 7 times
[check] 8 times
[check] 9 times
[check] 10 times
Checking if all Pgpool-II agrees that the failover request is executed
psql: error: connection to server on socket "/tmp/.s.PGSQL.11000" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.11100" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.11200" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
[check] 1 times
psql: error: connection to server on socket "/tmp/.s.PGSQL.11000" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.11100" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.11200" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
[check] 2 times
psql: error: connection to server on socket "/tmp/.s.PGSQL.11000" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.11100" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.11200" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
[check] 3 times
psql: error: connection to server on socket "/tmp/.s.PGSQL.11000" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.11100" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.11200" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
[check] 4 times
psql: error: connection to server on socket "/tmp/.s.PGSQL.11000" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.11100" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.11200" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
[check] 5 times
psql: error: connection to server on socket "/tmp/.s.PGSQL.11000" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.11100" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.11200" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
[check] 6 times
psql: error: connection to server on socket "/tmp/.s.PGSQL.11000" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.11100" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.11200" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
[check] 7 times
psql: error: connection to server on socket "/tmp/.s.PGSQL.11000" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.11100" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.11200" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
[check] 8 times
psql: error: connection to server on socket "/tmp/.s.PGSQL.11000" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.11100" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.11200" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
[check] 9 times
psql: error: connection to server on socket "/tmp/.s.PGSQL.11000" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.11100" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.11200" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
[check] 10 times
2023-07-23 10:53:52.419: main pid 651883: FATAL: invalid configuration, max_spare_children:10 can't be greater than num_init_children:4
2023-07-23 10:53:52.432: main pid 651884: FATAL: invalid configuration, max_spare_children:10 can't be greater than num_init_children:4
2023-07-23 10:53:52.446: main pid 651887: FATAL: invalid configuration, max_spare_children:10 can't be greater than num_init_children:4
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
0 out of 7 successful
-------------- next part --------------
mkdir: missing operand
Try 'mkdir --help' for more information.
mkdir: missing operand
Try 'mkdir --help' for more information.
creating leader pgpool and PostgreSQL clusters...PostgreSQL major version: 150
Starting set up in streaming replication mode
creating startall and shutdownall
creating failover script
creating database cluster /home/t-ishii/work/Pgpool-II/current/pgpool2/src/test/regression/tests/014.watchdog_test_quorum_bypass/leader/data0...done.
update postgresql.conf
creating pgpool_remote_start
creating basebackup.sh
creating recovery.conf
creating database cluster /home/t-ishii/work/Pgpool-II/current/pgpool2/src/test/regression/tests/014.watchdog_test_quorum_bypass/leader/data1...done.
update postgresql.conf
creating pgpool_remote_start
creating basebackup.sh
creating recovery.conf
temporarily start data0 cluster to create extensions
temporarily start pgpool-II to create standby nodes
node_id | hostname | port | status | pg_status | lb_weight | role | pg_role | select_cnt | load_balance_node | replication_delay | replication_state | replication_sync_state | last_status_change
---------+-----------+-------+--------+-----------+-----------+---------+---------+------------+-------------------+-------------------+-------------------+------------------------+---------------------
0 | localhost | 11002 | up | up | 0.500000 | primary | primary | 0 | true | 0 | | | 2023-07-23 10:53:55
1 | localhost | 11003 | down | down | 0.500000 | standby | unknown | 0 | false | 0 | | | 2023-07-23 10:53:54
(2 rows)
recovery node 1...pcp_recovery_node -- Command Successful
done.
creating follow primary script
node_id | hostname | port | status | pg_status | lb_weight | role | pg_role | select_cnt | load_balance_node | replication_delay | replication_state | replication_sync_state | last_status_change
---------+-----------+-------+--------+-----------+-----------+---------+---------+------------+-------------------+-------------------+-------------------+------------------------+---------------------
0 | localhost | 11002 | up | up | 0.500000 | primary | primary | 0 | false | 0 | | | 2023-07-23 10:53:55
1 | localhost | 11003 | up | up | 0.500000 | standby | standby | 0 | true | 0 | | | 2023-07-23 10:53:58
(2 rows)
shutdown all
pgpool-II setting for streaming replication mode is done.
To start the whole system, use /home/t-ishii/work/Pgpool-II/current/pgpool2/src/test/regression/tests/014.watchdog_test_quorum_bypass/leader/startall.
To shutdown the whole system, use /home/t-ishii/work/Pgpool-II/current/pgpool2/src/test/regression/tests/014.watchdog_test_quorum_bypass/leader/shutdownall.
pcp command user name is "t-ishii", password is "t-ishii".
Each PostgreSQL, pgpool-II and pcp port is as follows:
#1 port is 11002
#2 port is 11003
pgpool port is 11000
pcp port is 11001
The info above is in README.port.
leader setup done.
waiting for server to start....652250 2023-07-23 10:54:01.345 JST LOG: redirecting log output to logging collector process
652250 2023-07-23 10:54:01.345 JST HINT: Future log output will appear in directory "log".
done
server started
waiting for server to start....652262 2023-07-23 10:54:01.475 JST LOG: redirecting log output to logging collector process
652262 2023-07-23 10:54:01.475 JST HINT: Future log output will appear in directory "log".
done
server started
Waiting for the pgpool leader...
[check] 1 times
[check] 2 times
[check] 3 times
[check] 4 times
[check] 5 times
[check] 6 times
[check] 7 times
[check] 8 times
[check] 9 times
[check] 10 times
ERROR: connection to host "localhost" failed with error "Connection refused"
psql: error: connection to server on socket "/tmp/.s.PGSQL.11000" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
2023-07-23 10:55:02.060: main pid 652438: FATAL: invalid configuration, max_spare_children:10 can't be greater than num_init_children:4
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
0 out of 2 successful
-------------- next part --------------
creating leader pgpool and PostgreSQL clusters...PostgreSQL major version: 150
Starting set up in streaming replication mode
creating startall and shutdownall
creating failover script
creating database cluster /home/t-ishii/work/Pgpool-II/current/pgpool2/src/test/regression/tests/015.watchdog_master_and_backend_fail/leader/data0...done.
update postgresql.conf
creating pgpool_remote_start
creating basebackup.sh
creating recovery.conf
creating database cluster /home/t-ishii/work/Pgpool-II/current/pgpool2/src/test/regression/tests/015.watchdog_master_and_backend_fail/leader/data1...done.
update postgresql.conf
creating pgpool_remote_start
creating basebackup.sh
creating recovery.conf
temporarily start data0 cluster to create extensions
temporarily start pgpool-II to create standby nodes
node_id | hostname | port | status | pg_status | lb_weight | role | pg_role | select_cnt | load_balance_node | replication_delay | replication_state | replication_sync_state | last_status_change
---------+-----------+-------+--------+-----------+-----------+---------+---------+------------+-------------------+-------------------+-------------------+------------------------+---------------------
0 | localhost | 11002 | up | up | 0.500000 | primary | primary | 0 | true | 0 | | | 2023-07-23 10:55:04
1 | localhost | 11003 | down | down | 0.500000 | standby | unknown | 0 | false | 0 | | | 2023-07-23 10:55:03
(2 rows)
recovery node 1...pcp_recovery_node -- Command Successful
done.
creating follow primary script
node_id | hostname | port | status | pg_status | lb_weight | role | pg_role | select_cnt | load_balance_node | replication_delay | replication_state | replication_sync_state | last_status_change
---------+-----------+-------+--------+-----------+-----------+---------+---------+------------+-------------------+-------------------+-------------------+------------------------+---------------------
0 | localhost | 11002 | up | up | 0.500000 | primary | primary | 0 | true | 0 | | | 2023-07-23 10:55:04
1 | localhost | 11003 | up | up | 0.500000 | standby | standby | 0 | false | 0 | | | 2023-07-23 10:55:08
(2 rows)
shutdown all
pgpool-II setting for streaming replication mode is done.
To start the whole system, use /home/t-ishii/work/Pgpool-II/current/pgpool2/src/test/regression/tests/015.watchdog_master_and_backend_fail/leader/startall.
To shutdown the whole system, use /home/t-ishii/work/Pgpool-II/current/pgpool2/src/test/regression/tests/015.watchdog_master_and_backend_fail/leader/shutdownall.
pcp command user name is "t-ishii", password is "t-ishii".
Each PostgreSQL, pgpool-II and pcp port is as follows:
#1 port is 11002
#2 port is 11003
pgpool port is 11000
pcp port is 11001
The info above is in README.port.
leader setup done.
waiting for server to start....652801 2023-07-23 10:55:10.990 JST LOG: redirecting log output to logging collector process
652801 2023-07-23 10:55:10.990 JST HINT: Future log output will appear in directory "log".
done
server started
waiting for server to start....652814 2023-07-23 10:55:11.119 JST LOG: redirecting log output to logging collector process
652814 2023-07-23 10:55:11.119 JST HINT: Future log output will appear in directory "log".
done
server started
creating standby pgpool...creating standby2 pgpool...Waiting for the pgpool leader...
[check] 1 times
[check] 2 times
[check] 3 times
[check] 4 times
[check] 5 times
[check] 6 times
[check] 7 times
[check] 8 times
[check] 9 times
[check] 10 times
Waiting for the standby1 to join cluster...
[check] 1 times
[check] 2 times
[check] 3 times
[check] 4 times
[check] 5 times
[check] 6 times
[check] 7 times
[check] 8 times
[check] 9 times
[check] 10 times
Waiting for the standby2 to join cluster...
[check] 1 times
[check] 2 times
[check] 3 times
[check] 4 times
[check] 5 times
[check] 6 times
[check] 7 times
[check] 8 times
[check] 9 times
[check] 10 times
2023-07-23 10:56:31.631: main pid 652969: FATAL: invalid configuration, max_spare_children:10 can't be greater than num_init_children:4
waiting for server to shut down.... done
server stopped
Waiting for the standby to become new leader...
[check] 1 times
[check] 2 times
[check] 3 times
[check] 4 times
[check] 5 times
[check] 6 times
[check] 7 times
[check] 8 times
[check] 9 times
[check] 10 times
Waiting for the standby to execute failover...
[check] 1 times
[check] 2 times
[check] 3 times
[check] 4 times
[check] 5 times
[check] 6 times
[check] 7 times
[check] 8 times
[check] 9 times
[check] 10 times
Checking if all Pgpool-II agrees that the failover request was executed
psql: error: connection to server on socket "/tmp/.s.PGSQL.11100" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.11200" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
[check] 1 times
psql: error: connection to server on socket "/tmp/.s.PGSQL.11100" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.11200" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
[check] 2 times
psql: error: connection to server on socket "/tmp/.s.PGSQL.11100" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.11200" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
[check] 3 times
psql: error: connection to server on socket "/tmp/.s.PGSQL.11100" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.11200" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
[check] 4 times
psql: error: connection to server on socket "/tmp/.s.PGSQL.11100" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.11200" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
[check] 5 times
psql: error: connection to server on socket "/tmp/.s.PGSQL.11100" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.11200" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
[check] 6 times
psql: error: connection to server on socket "/tmp/.s.PGSQL.11100" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.11200" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
[check] 7 times
psql: error: connection to server on socket "/tmp/.s.PGSQL.11100" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.11200" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
[check] 8 times
psql: error: connection to server on socket "/tmp/.s.PGSQL.11100" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.11200" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
[check] 9 times
psql: error: connection to server on socket "/tmp/.s.PGSQL.11100" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.11200" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
[check] 10 times
2023-07-23 10:57:36.966: main pid 653534: FATAL: invalid configuration, max_spare_children:10 can't be greater than num_init_children:4
2023-07-23 10:57:36.977: main pid 653535: FATAL: invalid configuration, max_spare_children:10 can't be greater than num_init_children:4
2023-07-23 10:57:36.991: main pid 653538: FATAL: invalid configuration, max_spare_children:10 can't be greater than num_init_children:4
waiting for server to shut down.... done
server stopped
pg_ctl: PID file "/home/t-ishii/work/Pgpool-II/current/pgpool2/src/test/regression/tests/015.watchdog_master_and_backend_fail/leader/data1/postmaster.pid" does not exist
Is server running?
0 out of 6 successful
-------------- next part --------------
creating test environment...PostgreSQL major version: 150
Starting set up in streaming replication mode
creating startall and shutdownall
creating failover script
creating database cluster /home/t-ishii/work/Pgpool-II/current/pgpool2/src/test/regression/tests/020.allow_clear_text_frontend_auth/testdir/data0...done.
update postgresql.conf
creating pgpool_remote_start
creating basebackup.sh
creating recovery.conf
creating database cluster /home/t-ishii/work/Pgpool-II/current/pgpool2/src/test/regression/tests/020.allow_clear_text_frontend_auth/testdir/data1...done.
update postgresql.conf
creating pgpool_remote_start
creating basebackup.sh
creating recovery.conf
temporarily start data0 cluster to create extensions
temporarily start pgpool-II to create standby nodes
node_id | hostname | port | status | pg_status | lb_weight | role | pg_role | select_cnt | load_balance_node | replication_delay | replication_state | replication_sync_state | last_status_change
---------+-----------+-------+--------+-----------+-----------+---------+---------+------------+-------------------+-------------------+-------------------+------------------------+---------------------
0 | localhost | 11002 | up | up | 0.500000 | primary | primary | 0 | true | 0 | | | 2023-07-23 11:01:56
1 | localhost | 11003 | down | down | 0.500000 | standby | unknown | 0 | false | 0 | | | 2023-07-23 11:01:55
(2 rows)
recovery node 1...pcp_recovery_node -- Command Successful
done.
creating follow primary script
node_id | hostname | port | status | pg_status | lb_weight | role | pg_role | select_cnt | load_balance_node | replication_delay | replication_state | replication_sync_state | last_status_change
---------+-----------+-------+--------+-----------+-----------+---------+---------+------------+-------------------+-------------------+-------------------+------------------------+---------------------
0 | localhost | 11002 | up | up | 0.500000 | primary | primary | 0 | false | 0 | | | 2023-07-23 11:01:56
1 | localhost | 11003 | up | up | 0.500000 | standby | standby | 0 | true | 0 | | | 2023-07-23 11:01:59
(2 rows)
shutdown all
pgpool-II setting for streaming replication mode is done.
To start the whole system, use /home/t-ishii/work/Pgpool-II/current/pgpool2/src/test/regression/tests/020.allow_clear_text_frontend_auth/testdir/startall.
To shutdown the whole system, use /home/t-ishii/work/Pgpool-II/current/pgpool2/src/test/regression/tests/020.allow_clear_text_frontend_auth/testdir/shutdownall.
pcp command user name is "t-ishii", password is "t-ishii".
Each PostgreSQL, pgpool-II and pcp port is as follows:
#1 port is 11002
#2 port is 11003
pgpool port is 11000
pcp port is 11001
The info above is in README.port.
done.
waiting for server to start....659090 2023-07-23 11:02:01.184 JST LOG: redirecting log output to logging collector process
659090 2023-07-23 11:02:01.184 JST HINT: Future log output will appear in directory "log".
done
server started
waiting for server to start....659103 2023-07-23 11:02:01.299 JST LOG: redirecting log output to logging collector process
659103 2023-07-23 11:02:01.299 JST HINT: Future log output will appear in directory "log".
done
server started
psql: error: connection to server on socket "/tmp/.s.PGSQL.11000" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.11000" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.11000" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.11000" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
scram authentication setup failed
psql: error: connection to server on socket "/tmp/.s.PGSQL.11000" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
md5 authentication setup failed
psql: error: connection to server at "127.0.0.1", port 11000 failed: Connection refused
Is the server running on that host and accepting TCP/IP connections?
scram authentication failed
psql: error: connection to server at "127.0.0.1", port 11000 failed: Connection refused
Is the server running on that host and accepting TCP/IP connections?
md5 authentication failed
Trying wrong passwords now
psql: error: connection to server at "127.0.0.1", port 11000 failed: Connection refused
Is the server running on that host and accepting TCP/IP connections?
wrong password rejected properly for scram auth
psql: error: connection to server at "127.0.0.1", port 11000 failed: Connection refused
Is the server running on that host and accepting TCP/IP connections?
wrong password rejected properly for md5 auth
2023-07-23 11:02:21.581: main pid 659198: FATAL: invalid configuration, max_spare_children:10 can't be greater than num_init_children:1
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
-------------- next part --------------
creating test environment...PostgreSQL major version: 150
Starting set up in streaming replication mode
creating startall and shutdownall
creating failover script
creating database cluster /home/t-ishii/work/Pgpool-II/current/pgpool2/src/test/regression/tests/022.pool_passwd_alternative_auth/testdir/data0...done.
update postgresql.conf
creating pgpool_remote_start
creating basebackup.sh
creating recovery.conf
creating database cluster /home/t-ishii/work/Pgpool-II/current/pgpool2/src/test/regression/tests/022.pool_passwd_alternative_auth/testdir/data1...done.
update postgresql.conf
creating pgpool_remote_start
creating basebackup.sh
creating recovery.conf
temporarily start data0 cluster to create extensions
temporarily start pgpool-II to create standby nodes
node_id | hostname | port | status | pg_status | lb_weight | role | pg_role | select_cnt | load_balance_node | replication_delay | replication_state | replication_sync_state | last_status_change
---------+-----------+-------+--------+-----------+-----------+---------+---------+------------+-------------------+-------------------+-------------------+------------------------+---------------------
0 | localhost | 11002 | up | up | 0.500000 | primary | primary | 0 | true | 0 | | | 2023-07-23 11:02:52
1 | localhost | 11003 | down | down | 0.500000 | standby | unknown | 0 | false | 0 | | | 2023-07-23 11:02:51
(2 rows)
recovery node 1...pcp_recovery_node -- Command Successful
done.
creating follow primary script
node_id | hostname | port | status | pg_status | lb_weight | role | pg_role | select_cnt | load_balance_node | replication_delay | replication_state | replication_sync_state | last_status_change
---------+-----------+-------+--------+-----------+-----------+---------+---------+------------+-------------------+-------------------+-------------------+------------------------+---------------------
0 | localhost | 11002 | up | up | 0.500000 | primary | primary | 0 | false | 0 | | | 2023-07-23 11:02:52
1 | localhost | 11003 | up | up | 0.500000 | standby | standby | 0 | true | 0 | | | 2023-07-23 11:02:56
(2 rows)
shutdown all
pgpool-II setting for streaming replication mode is done.
To start the whole system, use /home/t-ishii/work/Pgpool-II/current/pgpool2/src/test/regression/tests/022.pool_passwd_alternative_auth/testdir/startall.
To shutdown the whole system, use /home/t-ishii/work/Pgpool-II/current/pgpool2/src/test/regression/tests/022.pool_passwd_alternative_auth/testdir/shutdownall.
pcp command user name is "t-ishii", password is "t-ishii".
Each PostgreSQL, pgpool-II and pcp port is as follows:
#1 port is 11002
#2 port is 11003
pgpool port is 11000
pcp port is 11001
The info above is in README.port.
done.
waiting for server to start....660032 2023-07-23 11:02:57.617 JST LOG: redirecting log output to logging collector process
660032 2023-07-23 11:02:57.617 JST HINT: Future log output will appear in directory "log".
done
server started
waiting for server to start....660044 2023-07-23 11:02:57.749 JST LOG: redirecting log output to logging collector process
660044 2023-07-23 11:02:57.749 JST HINT: Future log output will appear in directory "log".
done
server started
psql: error: connection to server on socket "/tmp/.s.PGSQL.11000" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.11000" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.11000" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.11000" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
scram authentication setup failed
psql: error: connection to server on socket "/tmp/.s.PGSQL.11000" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
md5 authentication setup failed
psql: error: connection to server at "127.0.0.1", port 11000 failed: Connection refused
Is the server running on that host and accepting TCP/IP connections?
scram authentication failed
psql: error: connection to server at "127.0.0.1", port 11000 failed: Connection refused
Is the server running on that host and accepting TCP/IP connections?
md5 authentication failed
Trying wrong passwords now
psql: error: connection to server at "127.0.0.1", port 11000 failed: Connection refused
Is the server running on that host and accepting TCP/IP connections?
wrong password rejected properly for scram auth
psql: error: connection to server at "127.0.0.1", port 11000 failed: Connection refused
Is the server running on that host and accepting TCP/IP connections?
wrong password rejected properly for md5 auth
2023-07-23 11:03:18.050: main pid 660138: FATAL: invalid configuration, max_spare_children:10 can't be greater than num_init_children:1
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
-------------- next part --------------
Starting set up
============= setting up pgpool 0 =============
PostgreSQL major version: 150
Starting set up in streaming replication mode
creating startall and shutdownall
creating failover script
creating database cluster /home/t-ishii/work/Pgpool-II/current/pgpool2/src/test/regression/tests/028.watchdog_enable_consensus_with_half_votes/testdir/pgpool0/data0...done.
update postgresql.conf
creating pgpool_remote_start
creating basebackup.sh
creating recovery.conf
creating database cluster /home/t-ishii/work/Pgpool-II/current/pgpool2/src/test/regression/tests/028.watchdog_enable_consensus_with_half_votes/testdir/pgpool0/data1...done.
update postgresql.conf
creating pgpool_remote_start
creating basebackup.sh
creating recovery.conf
temporarily start data0 cluster to create extensions
temporarily start pgpool-II to create standby nodes
node_id | hostname | port | status | pg_status | lb_weight | role | pg_role | select_cnt | load_balance_node | replication_delay | replication_state | replication_sync_state | last_status_change
---------+-----------+-------+--------+-----------+-----------+---------+---------+------------+-------------------+-------------------+-------------------+------------------------+---------------------
0 | localhost | 51000 | up | up | 0.500000 | primary | primary | 0 | true | 0 | | | 2023-07-23 11:05:24
1 | localhost | 51001 | down | down | 0.500000 | standby | unknown | 0 | false | 0 | | | 2023-07-23 11:05:23
(2 rows)
recovery node 1...pcp_recovery_node -- Command Successful
done.
creating follow primary script
node_id | hostname | port | status | pg_status | lb_weight | role | pg_role | select_cnt | load_balance_node | replication_delay | replication_state | replication_sync_state | last_status_change
---------+-----------+-------+--------+-----------+-----------+---------+---------+------------+-------------------+-------------------+-------------------+------------------------+---------------------
0 | localhost | 51000 | up | up | 0.500000 | primary | primary | 0 | true | 0 | | | 2023-07-23 11:05:24
1 | localhost | 51001 | up | up | 0.500000 | standby | standby | 0 | false | 0 | | | 2023-07-23 11:05:28
(2 rows)
shutdown all
pgpool-II setting for streaming replication mode is done.
To start the whole system, use /home/t-ishii/work/Pgpool-II/current/pgpool2/src/test/regression/tests/028.watchdog_enable_consensus_with_half_votes/testdir/pgpool0/startall.
To shutdown the whole system, use /home/t-ishii/work/Pgpool-II/current/pgpool2/src/test/regression/tests/028.watchdog_enable_consensus_with_half_votes/testdir/pgpool0/shutdownall.
pcp command user name is "t-ishii", password is "t-ishii".
Each PostgreSQL, pgpool-II and pcp port is as follows:
#1 port is 51000
#2 port is 51001
pgpool port is 50000
pcp port is 50001
The info above is in README.port.
============= setting up pgpool 1 =============
PostgreSQL major version: 150
Starting set up in streaming replication mode
creating startall and shutdownall
creating failover script
creating follow primary script
shutdown all
pgpool-II setting for streaming replication mode is done.
To start the whole system, use /home/t-ishii/work/Pgpool-II/current/pgpool2/src/test/regression/tests/028.watchdog_enable_consensus_with_half_votes/testdir/pgpool1/startall.
To shutdown the whole system, use /home/t-ishii/work/Pgpool-II/current/pgpool2/src/test/regression/tests/028.watchdog_enable_consensus_with_half_votes/testdir/pgpool1/shutdownall.
pcp command user name is "t-ishii", password is "t-ishii".
Each PostgreSQL, pgpool-II and pcp port is as follows:
#1 port is 51000
#2 port is 51001
pgpool port is 50004
pcp port is 50005
The info above is in README.port.
waiting for server to start....663117 2023-07-23 11:05:29.728 JST LOG: redirecting log output to logging collector process
663117 2023-07-23 11:05:29.728 JST HINT: Future log output will appear in directory "log".
done
server started
waiting for server to start....663129 2023-07-23 11:05:29.862 JST LOG: redirecting log output to logging collector process
663129 2023-07-23 11:05:29.862 JST HINT: Future log output will appear in directory "log".
done
server started
waiting for watchdog node 0 starting up... done.
=== Testing total nodes: 2. enable_consensus_with_half_of_the_votes: off ===
shutdown node pgpool1
2023-07-23 11:05:47.079: main pid 663291: LOG: stop request sent to pgpool (pid: 663144). waiting for termination...
.done.
Quorum does not exist. Test succeeded
2023-07-23 11:05:54.115: main pid 663307: FATAL: could not read pid file
2023-07-23 11:05:54.129: main pid 663310: LOG: stop request sent to pgpool (pid: 663140). waiting for termination...
.done.
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
waiting for server to start....663333 2023-07-23 11:06:00.495 JST LOG: redirecting log output to logging collector process
663333 2023-07-23 11:06:00.495 JST HINT: Future log output will appear in directory "log".
done
server started
waiting for server to start....663345 2023-07-23 11:06:00.605 JST LOG: redirecting log output to logging collector process
663345 2023-07-23 11:06:00.605 JST HINT: Future log output will appear in directory "log".
done
server started
Testing total nodes: 2. enable_consensus_with_half_of_the_votes: on
shutdown node pgpool1
2023-07-23 11:06:18.758: main pid 663506: LOG: stop request sent to pgpool (pid: 663360). waiting for termination...
.done.
Quorum exists. Test succeeded
2023-07-23 11:06:25.798: main pid 663521: FATAL: could not read pid file
2023-07-23 11:06:25.811: main pid 663524: LOG: stop request sent to pgpool (pid: 663356). waiting for termination...
.done.
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
Starting set up
============= setting up pgpool 0 =============
PostgreSQL major version: 150
Starting set up in streaming replication mode
creating startall and shutdownall
creating failover script
creating database cluster /home/t-ishii/work/Pgpool-II/current/pgpool2/src/test/regression/tests/028.watchdog_enable_consensus_with_half_votes/testdir/pgpool0/data0...done.
update postgresql.conf
creating pgpool_remote_start
creating basebackup.sh
creating recovery.conf
creating database cluster /home/t-ishii/work/Pgpool-II/current/pgpool2/src/test/regression/tests/028.watchdog_enable_consensus_with_half_votes/testdir/pgpool0/data1...done.
update postgresql.conf
creating pgpool_remote_start
creating basebackup.sh
creating recovery.conf
temporarily start data0 cluster to create extensions
temporarily start pgpool-II to create standby nodes
node_id | hostname | port | status | pg_status | lb_weight | role | pg_role | select_cnt | load_balance_node | replication_delay | replication_state | replication_sync_state | last_status_change
---------+-----------+-------+--------+-----------+-----------+---------+---------+------------+-------------------+-------------------+-------------------+------------------------+---------------------
0 | localhost | 51000 | up | up | 0.500000 | primary | primary | 0 | true | 0 | | | 2023-07-23 11:06:39
1 | localhost | 51001 | down | down | 0.500000 | standby | unknown | 0 | false | 0 | | | 2023-07-23 11:06:38
(2 rows)
recovery node 1...pcp_recovery_node -- Command Successful
done.
creating follow primary script
node_id | hostname | port | status | pg_status | lb_weight | role | pg_role | select_cnt | load_balance_node | replication_delay | replication_state | replication_sync_state | last_status_change
---------+-----------+-------+--------+-----------+-----------+---------+---------+------------+-------------------+-------------------+-------------------+------------------------+---------------------
0 | localhost | 51000 | up | up | 0.500000 | primary | primary | 0 | false | 0 | | | 2023-07-23 11:06:39
1 | localhost | 51001 | up | up | 0.500000 | standby | standby | 0 | true | 0 | | | 2023-07-23 11:06:43
(2 rows)
shutdown all
pgpool-II setting for streaming replication mode is done.
To start the whole system, use /home/t-ishii/work/Pgpool-II/current/pgpool2/src/test/regression/tests/028.watchdog_enable_consensus_with_half_votes/testdir/pgpool0/startall.
To shutdown the whole system, use /home/t-ishii/work/Pgpool-II/current/pgpool2/src/test/regression/tests/028.watchdog_enable_consensus_with_half_votes/testdir/pgpool0/shutdownall.
pcp command user name is "t-ishii", password is "t-ishii".
Each PostgreSQL, pgpool-II and pcp port is as follows:
#1 port is 51000
#2 port is 51001
pgpool port is 50000
pcp port is 50001
The info above is in README.port.
============= setting up pgpool 1 =============
PostgreSQL major version: 150
Starting set up in streaming replication mode
creating startall and shutdownall
creating failover script
creating follow primary script
shutdown all
pgpool-II setting for streaming replication mode is done.
To start the whole system, use /home/t-ishii/work/Pgpool-II/current/pgpool2/src/test/regression/tests/028.watchdog_enable_consensus_with_half_votes/testdir/pgpool1/startall.
To shutdown the whole system, use /home/t-ishii/work/Pgpool-II/current/pgpool2/src/test/regression/tests/028.watchdog_enable_consensus_with_half_votes/testdir/pgpool1/shutdownall.
pcp command user name is "t-ishii", password is "t-ishii".
Each PostgreSQL, pgpool-II and pcp port is as follows:
#1 port is 51000
#2 port is 51001
pgpool port is 50004
pcp port is 50005
The info above is in README.port.
============= setting up pgpool 2 =============
PostgreSQL major version: 150
Starting set up in streaming replication mode
creating startall and shutdownall
creating failover script
creating follow primary script
shutdown all
pgpool-II setting for streaming replication mode is done.
To start the whole system, use /home/t-ishii/work/Pgpool-II/current/pgpool2/src/test/regression/tests/028.watchdog_enable_consensus_with_half_votes/testdir/pgpool2/startall.
To shutdown the whole system, use /home/t-ishii/work/Pgpool-II/current/pgpool2/src/test/regression/tests/028.watchdog_enable_consensus_with_half_votes/testdir/pgpool2/shutdownall.
pcp command user name is "t-ishii", password is "t-ishii".
Each PostgreSQL, pgpool-II and pcp port is as follows:
#1 port is 51000
#2 port is 51001
pgpool port is 50008
pcp port is 50009
The info above is in README.port.
waiting for server to start....664084 2023-07-23 11:06:45.970 JST LOG: redirecting log output to logging collector process
664084 2023-07-23 11:06:45.970 JST HINT: Future log output will appear in directory "log".
done
server started
waiting for server to start....664096 2023-07-23 11:06:46.101 JST LOG: redirecting log output to logging collector process
664096 2023-07-23 11:06:46.101 JST HINT: Future log output will appear in directory "log".
done
server started
waiting for watchdog node 0 starting up...
-------------- next part --------------
creating test environment...PostgreSQL major version: 150
Starting set up in streaming replication mode
creating startall and shutdownall
creating failover script
creating database cluster /home/t-ishii/work/Pgpool-II/current/pgpool2/src/test/regression/tests/060.memory_leak/testdir/data0...done.
update postgresql.conf
creating pgpool_remote_start
creating basebackup.sh
creating recovery.conf
creating database cluster /home/t-ishii/work/Pgpool-II/current/pgpool2/src/test/regression/tests/060.memory_leak/testdir/data1...done.
update postgresql.conf
creating pgpool_remote_start
creating basebackup.sh
creating recovery.conf
temporarily start data0 cluster to create extensions
temporarily start pgpool-II to create standby nodes
node_id | hostname | port | status | pg_status | lb_weight | role | pg_role | select_cnt | load_balance_node | replication_delay | replication_state | replication_sync_state | last_status_change
---------+-----------+-------+--------+-----------+-----------+---------+---------+------------+-------------------+-------------------+-------------------+------------------------+---------------------
0 | localhost | 11002 | up | up | 0.500000 | primary | primary | 0 | true | 0 | | | 2023-07-23 11:18:27
1 | localhost | 11003 | down | down | 0.500000 | standby | unknown | 0 | false | 0 | | | 2023-07-23 11:18:26
(2 rows)
recovery node 1...pcp_recovery_node -- Command Successful
done.
creating follow primary script
node_id | hostname | port | status | pg_status | lb_weight | role | pg_role | select_cnt | load_balance_node | replication_delay | replication_state | replication_sync_state | last_status_change
---------+-----------+-------+--------+-----------+-----------+---------+---------+------------+-------------------+-------------------+-------------------+------------------------+---------------------
0 | localhost | 11002 | up | up | 0.500000 | primary | primary | 0 | false | 0 | | | 2023-07-23 11:18:27
1 | localhost | 11003 | up | up | 0.500000 | standby | standby | 0 | true | 0 | | | 2023-07-23 11:18:30
(2 rows)
shutdown all
pgpool-II setting for streaming replication mode is done.
To start the whole system, use /home/t-ishii/work/Pgpool-II/current/pgpool2/src/test/regression/tests/060.memory_leak/testdir/startall.
To shutdown the whole system, use /home/t-ishii/work/Pgpool-II/current/pgpool2/src/test/regression/tests/060.memory_leak/testdir/shutdownall.
pcp command user name is "t-ishii", password is "t-ishii".
Each PostgreSQL, pgpool-II and pcp port is as follows:
#1 port is 11002
#2 port is 11003
pgpool port is 11000
pcp port is 11001
The info above is in README.port.
done.
waiting for server to start....676693 2023-07-23 11:18:32.305 JST LOG: redirecting log output to logging collector process
676693 2023-07-23 11:18:32.305 JST HINT: Future log output will appear in directory "log".
done
server started
waiting for server to start....676706 2023-07-23 11:18:32.436 JST LOG: redirecting log output to logging collector process
676706 2023-07-23 11:18:32.436 JST HINT: Future log output will appear in directory "log".
done
server started
pgbench: error: connection to server on socket "/tmp/.s.PGSQL.11000" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
pgbench: error: could not create connection for initialization
pgbench: error: connection to server on socket "/tmp/.s.PGSQL.11000" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
pgbench: error: could not create connection for setup
init_size: VSZ
pgbench: error: connection to server on socket "/tmp/.s.PGSQL.11000" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
pgbench: error: could not create connection for setup
expr: non-integer argument
initial process size: VSZ after size: VSZ delta:
./test.sh: line 54: test: -eq: unary operator expected
memory leak in KB in mode:s
2023-07-23 11:18:33.599: main pid 676740: FATAL: invalid configuration, max_spare_children:10 can't be greater than num_init_children:1
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
-------------- next part --------------
creating test environment...PostgreSQL major version: 150
Starting set up in streaming replication mode
creating startall and shutdownall
creating failover script
creating database cluster /home/t-ishii/work/Pgpool-II/current/pgpool2/src/test/regression/tests/069.memory_leak_extended/testdir/data0...done.
update postgresql.conf
creating pgpool_remote_start
creating basebackup.sh
creating recovery.conf
creating database cluster /home/t-ishii/work/Pgpool-II/current/pgpool2/src/test/regression/tests/069.memory_leak_extended/testdir/data1...done.
update postgresql.conf
creating pgpool_remote_start
creating basebackup.sh
creating recovery.conf
temporarily start data0 cluster to create extensions
temporarily start pgpool-II to create standby nodes
node_id | hostname | port | status | pg_status | lb_weight | role | pg_role | select_cnt | load_balance_node | replication_delay | replication_state | replication_sync_state | last_status_change
---------+-----------+-------+--------+-----------+-----------+---------+---------+------------+-------------------+-------------------+-------------------+------------------------+---------------------
0 | localhost | 11002 | up | up | 0.500000 | primary | primary | 0 | true | 0 | | | 2023-07-23 11:20:21
1 | localhost | 11003 | down | down | 0.500000 | standby | unknown | 0 | false | 0 | | | 2023-07-23 11:20:20
(2 rows)
recovery node 1...pcp_recovery_node -- Command Successful
done.
creating follow primary script
node_id | hostname | port | status | pg_status | lb_weight | role | pg_role | select_cnt | load_balance_node | replication_delay | replication_state | replication_sync_state | last_status_change
---------+-----------+-------+--------+-----------+-----------+---------+---------+------------+-------------------+-------------------+-------------------+------------------------+---------------------
0 | localhost | 11002 | up | up | 0.500000 | primary | primary | 0 | false | 0 | | | 2023-07-23 11:20:21
1 | localhost | 11003 | up | up | 0.500000 | standby | standby | 0 | true | 0 | | | 2023-07-23 11:20:25
(2 rows)
shutdown all
pgpool-II setting for streaming replication mode is done.
To start the whole system, use /home/t-ishii/work/Pgpool-II/current/pgpool2/src/test/regression/tests/069.memory_leak_extended/testdir/startall.
To shutdown the whole system, use /home/t-ishii/work/Pgpool-II/current/pgpool2/src/test/regression/tests/069.memory_leak_extended/testdir/shutdownall.
pcp command user name is "t-ishii", password is "t-ishii".
Each PostgreSQL, pgpool-II and pcp port is as follows:
#1 port is 11002
#2 port is 11003
pgpool port is 11000
pcp port is 11001
The info above is in README.port.
done.
waiting for server to start....681853 2023-07-23 11:20:26.619 JST LOG: redirecting log output to logging collector process
681853 2023-07-23 11:20:26.619 JST HINT: Future log output will appear in directory "log".
done
server started
waiting for server to start....681865 2023-07-23 11:20:26.720 JST LOG: redirecting log output to logging collector process
681865 2023-07-23 11:20:26.720 JST HINT: Future log output will appear in directory "log".
done
server started
pgbench: error: connection to server on socket "/tmp/.s.PGSQL.11000" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
pgbench: error: could not create connection for initialization
pgbench: error: connection to server on socket "/tmp/.s.PGSQL.11000" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
pgbench: error: could not create connection for setup
init_size: VSZ
Starting pgbench in background
Sun Jul 23 11:20:47 JST 2023
pgbench: error: connection to server on socket "/tmp/.s.PGSQL.11000" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
pgbench: error: could not create connection for setup
Sun Jul 23 11:21:16 JST 2023
expr: non-integer argument
initial process size: VSZ after size: VSZ delta:
pgbench done.
Sun Jul 23 11:21:16 JST 2023
./test.sh: line 65: test: -eq: unary operator expected
memory leak in KB in mode:s
2023-07-23 11:21:16.061: main pid 682009: FATAL: invalid configuration, max_spare_children:10 can't be greater than num_init_children:1
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
-------------- next part --------------
creating test environment...PostgreSQL major version: 150
Starting set up in streaming replication mode
creating startall and shutdownall
creating failover script
creating database cluster /home/t-ishii/work/Pgpool-II/current/pgpool2/src/test/regression/tests/070.memory_leak_extended_memqcache/testdir/data0...done.
update postgresql.conf
creating pgpool_remote_start
creating basebackup.sh
creating recovery.conf
creating database cluster /home/t-ishii/work/Pgpool-II/current/pgpool2/src/test/regression/tests/070.memory_leak_extended_memqcache/testdir/data1...done.
update postgresql.conf
creating pgpool_remote_start
creating basebackup.sh
creating recovery.conf
temporarily start data0 cluster to create extensions
temporarily start pgpool-II to create standby nodes
node_id | hostname | port | status | pg_status | lb_weight | role | pg_role | select_cnt | load_balance_node | replication_delay | replication_state | replication_sync_state | last_status_change
---------+-----------+-------+--------+-----------+-----------+---------+---------+------------+-------------------+-------------------+-------------------+------------------------+---------------------
0 | localhost | 11002 | up | up | 0.500000 | primary | primary | 0 | true | 0 | | | 2023-07-23 11:21:19
1 | localhost | 11003 | down | down | 0.500000 | standby | unknown | 0 | false | 0 | | | 2023-07-23 11:21:18
(2 rows)
recovery node 1...pcp_recovery_node -- Command Successful
done.
creating follow primary script
node_id | hostname | port | status | pg_status | lb_weight | role | pg_role | select_cnt | load_balance_node | replication_delay | replication_state | replication_sync_state | last_status_change
---------+-----------+-------+--------+-----------+-----------+---------+---------+------------+-------------------+-------------------+-------------------+------------------------+---------------------
0 | localhost | 11002 | up | up | 0.500000 | primary | primary | 0 | false | 0 | | | 2023-07-23 11:21:19
1 | localhost | 11003 | up | up | 0.500000 | standby | standby | 0 | true | 0 | | | 2023-07-23 11:21:22
(2 rows)
shutdown all
pgpool-II setting for streaming replication mode is done.
To start the whole system, use /home/t-ishii/work/Pgpool-II/current/pgpool2/src/test/regression/tests/070.memory_leak_extended_memqcache/testdir/startall.
To shutdown the whole system, use /home/t-ishii/work/Pgpool-II/current/pgpool2/src/test/regression/tests/070.memory_leak_extended_memqcache/testdir/shutdownall.
pcp command user name is "t-ishii", password is "t-ishii".
Each PostgreSQL, pgpool-II and pcp port is as follows:
#1 port is 11002
#2 port is 11003
pgpool port is 11000
pcp port is 11001
The info above is in README.port.
done.
waiting for server to start....682368 2023-07-23 11:21:24.227 JST LOG: redirecting log output to logging collector process
682368 2023-07-23 11:21:24.227 JST HINT: Future log output will appear in directory "log".
done
server started
waiting for server to start....682380 2023-07-23 11:21:24.327 JST LOG: redirecting log output to logging collector process
682380 2023-07-23 11:21:24.327 JST HINT: Future log output will appear in directory "log".
done
server started
pgbench: error: connection to server on socket "/tmp/.s.PGSQL.11000" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
pgbench: error: could not create connection for initialization
pgbench: error: connection to server on socket "/tmp/.s.PGSQL.11000" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
pgbench: error: could not create connection for setup
init_size: VSZ
pgbench: error: connection to server on socket "/tmp/.s.PGSQL.11000" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
pgbench: error: could not create connection for setup
expr: non-integer argument
initial process size: VSZ after size: VSZ delta:
./test.sh: line 59: test: -eq: unary operator expected
memory leak in KB in mode:s
2023-07-23 11:21:44.650: main pid 682486: FATAL: invalid configuration, max_spare_children:10 can't be greater than num_init_children:1
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
More information about the pgpool-hackers
mailing list